Difference between revisions of "Data Import/Import Inventory"
(Created page with '==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 ser…') |
|||
| Line 4: | Line 4: | ||
Product Inventory Import File Format | 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: | The product inventory import file must in .CSV format, with a column heading row containing the field names as specified below: | ||
| − | Field Description | + | |
| + | ||Field ||Description | ||
||PRODUCT_ID ||The product ID of the serialised product in the system | ||PRODUCT_ID ||The product ID of the serialised product in the system | ||
||SERIAL_NUMBER ||The serial number to store in the product inventory | ||SERIAL_NUMBER ||The serial number to store in the product inventory | ||
Revision as of 20:39, 11 April 2013
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 ||OWNING_ACCOUNT_ID ||Your account number within the system. This can be located at the very bottom, right hand corner of all pages in the system
- On the Product Inventory page, click the Import Inventory button. The Import Product Inventory page will appear.
- 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.
- Click the Import to Inventory button. The system will load the serial numbers from the product inventory import file.
