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
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 |
|||||
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 |