This facility enables orders to be placed via uploading a pre-prepared spreadsheet or text file. Once loaded, you can checkout or save as a Buying list in the normal way.
Currently, the file formats supported are csv, or txt.
The file, if prepared with Excel for example, should contain only two columns of information: the item number in the first column A, and the Quantity required in the second column B.
Once populated, save your file as CSV (comma delimited) (*.csv) . The CSV (comma delimited) version of the file looks like this:
Multiple Order Quantity (MOQ)
MOQ’s are validated during the upload. In our example shown above are two highlighted items: 36-006B has an MOQ of 3, therefore 5 is not a valid multiple. Only multiples of 3 will pass validation, for example 3, 6 or 9. Item 34-630B has an MOQ of 2 therefore the quantity of 4 will pass validation as 4 is a multiple of 2. Only validated items are loaded into the cart.
How to use
Click My Cart from the menu.
Click the Upload from spreadsheet button – an uploader will appear:
Click the Browse button to select your prepared file from your computer:
The selected file name is now shown.
If you wish to replace any existing items in the current Cart with the contents of the sheet selected, tick the “box to replace the content of the cart” above. Then click the Upload button
Invalid product codes
After uploading the sheet an Upload Report will show how many lines were successfully imported and how many failed the validation, with those that failed being shown in a table below. In our example the item 36-006B with a Quantity of 5 failed due to the quantity required being incompatible with the MOQ. Attempting to use codes that do not match the database of products will also fail validation. This report can be printed for reference.
You may upload another sheet if you wish to add to this cart, or when done click the Cancel or Close button on the uploader. The lines will be placed into the cart.
The cart is now ready to go to the Checkout or saved as a Buying list for use later.
