User:
 
Current Invoice
Total $0.00

What to do?     go back     


How do you create your own order file?


 
The system requires you to be logged in through your customer id, and have a pre-formatted text file accessible to your PC.
 
This text file must follow the data separation rules below.
The first line of the file contains the header information with each data field separated by commas.
Each subsequent line contains an individual order item, again with each data field separated by commas.
 
FIRST LINE:       SUBSEQUENT LINES: 
1) Delivery Name(1-30 chars) 1) UPC/EAN/ISBN-10 or Supplier Code(0-13 chars)
2) Deliv.Address 1(0-30 chars) 2) Quantity(0-5 digits)
3) Deliv.Address 2(0-30 chars) 3) Comment(0-40 chars)
4) Deliv.Address 3(0-25 chars)   
5) Pcode(0-4 chars)   
6) Order Reference(0-20 chars)   
7) No of Order Lines(1-5 digits)   
For example, this text file:
YOUR TOP SHOP,43 SMITH STREET,SYDNEY,,2000,1245637,19
9781868525799,3,
WOW003,12,
OM006,6,
9781581342772,1,
1031,23,
GP13,34,
BMF013,22,
9781581341720,1,
PR013,21,
BPH002,4,
KMW001,1,Pack this one well
WR006,1,
WR004,1,
OM005,1,
WT004,1,
OM003,1,
,,2 copies HC of You Are Mine
,,Send well packed please
,,Add 10 Newsletters

 

 

If error messages occur, please check the following:

  1. The Header record must be the first record on the file (i.e. no blank lines are to precede it). It must then be followed by the details records with no intervening blank lines.
  2. There must be no embedded commas or quote marks in the name and address of the header record, nor in the product code or comment field of the details records.
  3. The maximum field sizes must not be exceeded. Pay particular attention to trailing spaces in the comment field.
  4. If a product code is present, the quantity cannot have a null value.