Using Integrated label invoice paper with Play.com

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 Play.com's PlayTrade ProTrader account and Microsoft Word 95, 97, 2000, 2002, 2003, 2007, 2010, 2013,2016

NOTE: You must have a ProTrader (monthly subscription) account to use this software.

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 PlayTrade and a modified template is shown below:

How to print your PlayTrade Integrated Label Invoices

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

2. Login into your acccount at www.play.com and click on the Reports option on the left hand side (shown below):


3. Select the Orders (choose time period) report, shown above. Click on the Submit report request button. After a few minutes the report will have been created and you can click on the Report link in the Downloads column. You are then prompted with the following dialog. You should click Save and save the file (DownloadReport_aspx.txt) to a location on your PC, for example, C:\Downloads.



NOTE
: If you have problems saving the file you should click on Open. When the file is displayed in your browser select all the text (Control Key and A) and then Copying the text into notepad (Press the Windows key and R and then type Notepad and press enter) and save the file to the correct location.

4. 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 PlayTrade 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.

Decide if you want to prinout invoices for cancelled, pending and refunded orders and then 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 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.


Mole End Group of Companies
www.mole-end.biz
www.1stoporders.co.uk
www.integratedlabels.co.uk
www.invoicepaper.co.uk
www.baypaper.co.uk
Products, plugins and utilities for Actinic Desktop and SellerDeck All your orders, from all your systems, all together in one simple-to-use application Integrated label invoice paper and free software packages and templates. Print your invoice and labels at the same time Print Amazon Despatch Notes with a peel out label with the customer's details on directly from Amazon Print Ebay Invoices with a peel out label with the customer's details on directly from Ebay