Using Integrated label invoice paper with Amazon

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 Amazon's Seller Central or Marketplace Pro-merchant and Microsoft Word 95, 97, 2000, 2002, 2003, 2007, 2010, 2013, 2016. When you install the software you are asked where you sell yout products on Amazon and the appropriate template is installed.

You can buy Integrated Label Invoice Paper from

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



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

How to print

Retrieving the orders from Amazon

Seller Central
Marketplace

Downloading orders from Amazon SellerCentral

1. Login to Amazon Seller Central (at https://sellercentral-europe.amazon.com) and go to the Orders tab. Then select the Advanced Features option (just below the tab).

2. Click on Download Orders File (shown below).

3. Click on Request Report and select the required orders (from the required date range).

4. When the reports have been created (normally within 10 minutes) click on the file and save this into the following location:

C:\Downloads\Orders.txt

Marketplace Pro Merchant (subscription required)

Login to Amazon Marketplace (at https://www.amazon.co.uk) and click on Your Account at the top of the screen. Then click on Your Marketplace Seller Account link, shown below:

2. Under the Manage Your Orders options you should select Order Reports. If you do not have this option then you do not have an Amazon Pro Merchant account. To use this software you will need to sign up for a Pro Merchant account (currently £25 per month). Under the Settings options click on Seller Account Information. There is an Upgrade button at the bottom of the Seller Account Information page (under the Selling Plan options).

3. Under Request an Order Report, select the number of days to retrieve orders for and click on Request Report. The orders report will then be generated. This can take from a few seconds to an hour. Click on the Refresh button until your new report appears. When this appears click on the Download button to retrieve the order information.

NOTE: You can also setup automatically created reports to pickup each day. To do this click on the Edit button under the Scheduled Order Report Settings.

4. Click on Save and enter the file to C:\Downloads. In this example, the file is saved as:


C:\Downloads\X2LP2OBAFEQSER.txt

Processing and printing the orders

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.

Open the Word document for the required site (e.g. Ebay).

NOTE: The Word templates are 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, 2010, 2013,2016

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, 2010, 2013,2016

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. If the Create shortcut menu option is not available you can make it available by clicking on the New Source... button, then click Cancel. You can then right click and the menu option will appear (this is a bug in MS Word).

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.