Hello all, currently I send packages out with an invoice in a Doc Enclosed Wallet. I want to move onto using a sticky label and emailing the invoice to my customer. I understand there are companies that will do this but I want to be able to do this myself.

How do I export Customers information from ebay Paypal?

I think I can manage the data through excel from there.

Would you recommend using a Dymo printer or Mail Merge from here?

What is the best way to then invoice the customer via email?

I sell several different items and have sales ranging from 5-30 per day.

regards Matthew

I highly suggest you use www.aimcosfotware.co.uk and just use your normal printer tp print the labels. This is BY FAR the easiest solution. It may cost a little bit but try the free trial. Many TWF members have and have gone on to buy it and they would never try anything else.

http://www.micomonline.co.uk/search....t=QL-560VPZ&go

i use this and its fantastic. hook up to your PC use excel for multiple order print

USB so no messing around just install driver, plug and go with any pc.

Originally Posted by uhafmail

I highly suggest you use www.aimcosfotware.co.uk and just use your normal printer tp print the labels. This is BY FAR the easiest solution. It may cost a little bit but try the free trial. Many TWF members have and have gone on to buy it and they would never try anything else.

Very very good software that is!

For shipping labels I strongly recommend Dymo 400 or any other Dymo thermal label. With 3rd party, compatible labels, it's really great, high quality and cost effective way to print shipping labels.

__________________

Looking for Products to Sell on eBay? (53k+ and counting)

Originally Posted by skill4style

Hello all, currently I send packages out with an invoice in a Doc Enclosed Wallet. I want to move onto using a sticky label and emailing the invoice to my customer. I understand there are companies that will do this but I want to be able to do this myself.

How do I export Customers information from ebay Paypal?

I think I can manage the data through excel from there.

Would you recommend using a Dymo printer or Mail Merge from here?

What is the best way to then invoice the customer via email?

I sell several different items and have sales ranging from 5-30 per day.

regards Matthew

I would download your sales data as a text file, import it into excel tab seperated. Then do a mail merge in word, using the insert merge field option linked to the exel file. Choose the create labels option and then either cusom set the borders or buy avery compatible labels

So it would look like

<buyername>
<address line 1>
<address line 2>
<address line 3>


on each label.


Alternatively you can do what we do which is create an integrated packing sheet, invoice and address label.


So we do a merge as letter, rather than label and use an A4 sheet with single integrated label

then on the none label part we have


Dear <buyename>

thank you for your purchase of <productname> from us

here is your VAT receipt


Company Name
Company VAT Number
Company Address


<quantity purchase X <productname> <purchaseprice>
<shipping level> <shippingprice>



. Total <totalprice>


Thank you for shipping with us
.



. Web address



On the label part we have the address merged as on the label example above.

All in on then you have a picking sheet, VAT receipt and shipping label.

What and how do I extrapolate this data from PAypal or eBay?

you can download a sales file from ebay.

go to myebay/sold/awaiting postage
and then tick all the ones you want to download, if you manage your what needs posting properly you should just be able to tick select all.

Ok cool I'll have a look into that. I'll let you know what I come up with but yes the idea of an invoice combined with a sticky postage label sounds great. I think thats how alot of big online retailers send items. Will have to research into sizes and costs etc. The system you use goes through each one automatically? Is it some sort of Macro you use?

no need for a macro. Your excel will have title fields in line 1 and then each sale on a line underneath.

Word in mail merge will automatically create a new page / label for each entry