Using Integrated label paper with PlayTrade
With integrated label 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 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 and 2007
NOTE: You must have a ProTrader (monthly subscription) account to use
this software.
You can buy Integrated Label Paper from http://www.integratedlabels.co.uk, prices start at £8.99 (+ VAT) including free delivery.
An example of a sale made using PlayTrade and a modified template is shown below:
How to print your PlayTrade Invoices
1. Run the
installation. This, by default, installs 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 label 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
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.