Difference between revisions of "Data Import/Import Inventory"

Revision as of 14:31, 2 July 2015

To Import Inventory

The Import Inventory function allows you to import serial numbers to store against the serialised product and store them in the product inventory. The serial numbers must be loaded via a .CSV file that is imported and processed to load all the serial numbers against the serialised product.

Product Inventory Import File Format The product inventory import file must in .CSV format, with a column heading row containing the field names as specified below:

Field |Description

PRODUCT_ID |The product ID of the serialised product in the system

SERIAL_NUMBER |The serial number to store in the product inventory

SELL_BEFORE_DATE|The expiry date for the item, Used with SIMS

COST_PRICE|Ex Tax Cost Price - For Future use

1. On the Product Inventory page, click the Import Inventory button. The Import Product Inventory page will appear.
2. Upload the product inventory import file. Click the Browse button. The File Upload window will appear. Navigate to and select the required file, and then click Open.
3. Click the Import to Inventory button. The system will load the serial numbers from the product inventory import file.