Uploading Products
Only text files should be uploaded. Tab-separated (TSV), Comma-separated (CSV) and a few variants are supported. Excel files should be saved as tab separated files before uploading.
The first line should contain the field names, which are listed below, with brief explanations:
- stock_code is the unique stock code or product code, or part number you use.
- name is a short descriptive name or title your product is known as
- EAN is the European Article Number (the barcode number)
- qty_avail is the number of products available to promise, ie. excluding products already allocated to sales orders.
- qty_held is the number of products already allocated or being held for existing orders
- order_qty_min is the minimum number of products which can be purchased at a time. It might be the packet size.1
- order_qty_step is the multiples of products which must be purchased beyond the minimum quantity1
- price is the regular wholesale price
- rrp is the recommended retail price
- special is the reduced wholesale price, this selling price is automatically chosen when it's value is lower than 'price'
- cost is the cost of the item to you, the supplier. May be omitted.
- image is the file name of the image associated with the product
- description is a textual description of the product. May include any extra details you desire. Presently must be a single line (no paragraphs) but words will wrap when displayed
- category is the name of the category or major-group which this product will be listed under
- subcategory is the name of the subcategory or minor-group which this product will be listed under
- custom 1-4 up to four custom fields may be included.
1 For example, if products are sold in packets of 10, then use order_qty_min=10 and order_qty_step=10. But if a customer can purchase any number from 10 upwards (eg. 11, 12, etc) then order_qty_min=10 and order_qty_step=1. Put another way, order_qty_step is the minimum additional number of items which can be purchased after the order_qty_min has been satisfied.
All fields may only be a single line of text (currenlty due to import format limitations). Some variation on field names is permitted, so avoid custom field names similar to those listed above.
The four custom fields can be named anything (the first four unrecognised field names will be accepted as custom fields), though they will currently be shown as "custom" in the iPhone app.