Using Integrated label invoice paper with Ebay

With integrated label invoice paper you can print a standard invoice with removable customer address labels to attach to the customer's order. If you use the 2 label integrated label invoice paper the invoice address and delivery (or return) address are printed onto separate labels. 

This solution works with Ebay's Selling Manager Basic & Pro and Microsoft Word 95, 97, 2000, 2002, 2003 and 2007

You can buy Integrated Label Invoice Paper from http://www.integratedlabels.co.uk, prices start at £8.99 (+ VAT) including free delivery.

There is a free 14 day trial of the software at the following link:


http://www.integratedlabels.co.uk/download/IL_Invoicing.exe

An example of a sale made using Ebay and a modified template is shown below:

How to print your Ebay Invoices onto Integrated Label Invoice Paper

Note: If you list your items with Turbo Lister, Ebay directly or other listing software (e.g. Spoonfeeder) you should use the free Selling Manager software to download your orders to the PC. If you are using Selling Manager Pro you should following the instructions from step 1. If you haven't already signed up to Selling Manager Pro or Selling Manager you can sign up using the following link:

http://pages.ebay.co.uk/selling_manager/

1. Run the installation. This, by default, installs into C:\IntegratedLabels.

2. Select the items that you want to print the invoices for using Selling Manager and press the Download button. If using a popup blocker hold down the Ctrl key.


3. When the File Download dialog appears press the Save button.

4. Save the file into C:\Downloads (or your chosen to download files from the internet).




5. Run IntegratedLabels.co.uk Invoicing. This can be run from the Start menu or desktop (if chosen when installing the software). The default location for the Ebay items file is set to C:\Downloads. This can be changed to any other location. However, you should keep the processed location to be C:\IntegratedLabels.

Press the Process items button. This shows details about the items being processed.




6. Open the installed Word document. This is installed, by default into, C:\IntegratedLabels.



Change any details on the page. Leave all fields with << >> around them. These link to the order information. If you use the double label integrated label invoice paper you can use the top left label for a return address or other item processing information.

When you are ready to print the invoices for the items you Mail Merge the order details.

Microsoft Word 95, 97, 2000

Microsoft Word 2002, 2003

Microsoft Word 2007

Microsoft Word 95, 97, 2000

Select the Mail Merge, this described below:


This will show the Mail Merge Helper. The Main document (1) and Data source (2) will already be setup with the correct details. You simply need to click on the Merge button (3). This is shown below:




NOTE: The Main document and Data source will automatically be set (and different) for each order type.


You can now print the invoices out. Change the Merge to to Printer. You can then click on the Merge button.

If you want to see all the merged information before printing leave the Merge to option as New document. This will create a single Word document for you to see the invoices before printing (and make any manual amendments if required).

This is now complete. Save your document and repeat the merge process when you receive new orders.

Microsoft Word 2002, 2003

Select the Mail Merge Wizard, this described below:


This will show the Mail Merge Wizard on the right hand side of the window. Press Next to select Letters as the documents to make. Then press Next again to use the current document.

You are now asked to select the recipients to create the invoices for. If the required file (The file will be SalesHistory.csv for Ebay, AmazonMP.csv for Amazon Marketplace, AmazonSC.csv for Amazon SellerCentral, PlayTrade.csv for PlayTrade and EBid.csv for Ebid) is shown select this file otherwise click on Browse and find the required file (in C:\Integratedlabels). Once selected you are asked to confirm the orders to create invoices for, press OK.

NOTE: If Word displays the My Data Sources folder you can create short cut to C:\IntegratedLabels in this folder (to select your orders file more quickly). When you open a Word document (in the My Documents folder) select the My Data Sources folder and right click and select Create shortcut menu item. Then enter the short cut value as C:\Integratedlabels.




Select Next at the bottom right hand corner of the window to start the merge. Then click Next to preview the merge.




Finally select Next to complete the merge.




Select Print to print out all the invoices.


This is now complete. Save your document and repeat the merge process when you receive new orders.


Microsoft Word 2007

Click on the Mailings tab at the top of main window (to the right of Home).


Click on the Select Recipients option and select the Use Existing List menu option. This is shown below:




Select the processed orders file. This will be in C:\Integratedlabels. The file will be SalesHistory.csv for Ebay, AmazonMP.csv for Amazon Marketplace, AmazonSC.csv for Amazon SellerCentral, PlayTrade.csv for PlayTrade and EBid.csv for Ebid. Once selected click on Open.



NOTE: If Word displays the My Data Sources folder you can create short cut to C:\IntegratedLabels in this folder (to select your orders file more quickly). When you open a Word document (in the My Documents folder) select the My Data Sources folder and right click and select Create shortcut menu item. Then enter the short cut value as C:\Integratedlabels.

When the File Conversion dialog is displayed press OK. This is shown below:




If required, you can now see the invoices before printing by clicking on the Preview Results button, shown below:




Once you are happy with the invoices you can print them by clicking on the Finish and Merge button and selecting the Print Documents menu option, shown below:

You should then save the document, shown below:


The next time that you open the Word document you will be asked to confirm where to get the order information from. Click on Yes.



You then simply need to select the Mailings tab and click on Finish and Merge to print out the invoices.