corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Software to turn .csv file into an invoice in excel or word


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Software to turn .csv file into an invoice in excel or word
Dan
Premium Member

Avatar

Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
8th Apr 10 at 17:12   View Garage View User's Profile U2U Member Reply With Quote
Evening all.

I need a piece of software, or code to turn my ebay sale .csv file into an invoice, but i need to be able to use integrated label paper with it, does it exist?

Is it easy enough to make an excel sheet that will print how i want it to, if i just have to copy/paste certain data in?

What other options do i have?



Adult GiftsClick here to vist us
oceansoul
Member
Registered: 19th Jun 06
Location: Sunbury, Surrey
User status: Offline
8th Apr 10 at 17:15   View User's Profile U2U Member Reply With Quote
I though Excel could open CSV?
Dan
Premium Member

Avatar

Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
8th Apr 10 at 17:18   View Garage View User's Profile U2U Member Reply With Quote
It can, but the .csv ebay downloads is just full of data.

I need something to turn this data into an invoice, with bits in the right places etc

Adult GiftsClick here to vist us
Dan
Premium Member

Avatar

Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
8th Apr 10 at 17:25   View Garage View User's Profile U2U Member Reply With Quote
TBH

All i really need is to make a template maybe in word, where i can open it up, copy and paste or fill in:

buyers address
Item name
Quantity
Price
Postage price + service used
Total price
Date

The paper i have has the integrated label about 3 inchs from bottom, so i want to have a standard note with a note to the buyer about our site and a discount code for it.

Is word the best way to do this?

Adult GiftsClick here to vist us
Deadude
Member
Registered: 30th Jun 07
Location: Spondon, Derby
User status: Offline
8th Apr 10 at 18:39   View User's Profile U2U Member Reply With Quote
i assume in excel you just get a list of all your sales? if so a Vlookup would probably do the job you would just enter the ebay sales number and it would fill in the rest of the details providing you make some sort of a template for the invoice up.
Dan
Premium Member

Avatar

Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
8th Apr 10 at 18:55   View Garage View User's Profile U2U Member Reply With Quote
Ive just knocked up a basic invoice in works.

I just have to make sure everytime that no extra lines get added, or ill put it all out of line. Unless i can fix this can i?

Adult GiftsClick here to vist us
ed
Member
Registered: 10th Sep 03
User status: Offline
8th Apr 10 at 19:54   View User's Profile U2U Member Reply With Quote
You can't format a CSV file because all it contains is data.

If you can make you invoices in html then you can use an API called DOMPDF. This basically turns HTML into a PDF document via PHP:

http://www.digitaljunkies.ca/dompdf/
ed
Member
Registered: 10th Sep 03
User status: Offline
8th Apr 10 at 19:54   View User's Profile U2U Member Reply With Quote
It's nigh on impossible to make excel or word files online too. PDF is the way to do it.
Dan
Premium Member

Avatar

Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
8th Apr 10 at 20:49   View Garage View User's Profile U2U Member Reply With Quote
Well i managed to find a program to convert the .csv to a .xls file.

I think i could then use mail merge to make something.

Havent really got the inspiration to learn how to make that atm, so ill just stick to the word template i made, which i can just copy/paste into.

Cheers anyway

Adult GiftsClick here to vist us
John
Member
Registered: 30th Jun 03
User status: Offline
8th Apr 10 at 22:59   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by ed
You can't format a CSV file because all it contains is data.

If you can make you invoices in html then you can use an API called DOMPDF. This basically turns HTML into a PDF document via PHP:

http://www.digitaljunkies.ca/dompdf/


Or just have a template and import the data, which is easier.

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
money making scheme Drew General Chat 520 13866
9th Apr 09 at 16:51
by Mark Prydderch		  
Excel question (quick) Ojc General Chat 12 907
30th Sep 04 at 20:18
by Sam		  
Excel help and making my life easier Melville Geek Day 9 978
26th Oct 06 at 14:17
by Melville		  
Send Bulk Emails in outlook express Doldy Geek Day 8 313
1st Sep 08 at 18:44
by Doldy		  
OpenOffice - opinons? deano87 Geek Day 26 1612
16th Sep 08 at 21:28
by deano87		  

Corsa Sport » Message Board » Off Day » Geek Day » Software to turn .csv file into an invoice in excel or word 29 database queries in 0.0096211 seconds