Updating Stock Items Using Data Imports
Overview
Updating Stock items using the Import Tool
Specification
This can be done using the inbuilt data import tool in [System Setup | Data Imports].
There is only one mandatory column as detailed below plus as many columns as you wish to update.
A sample file that updates the stock value and country of manufacture for stock item 773W can be found attached to this article.
- STOCK_CODE - This field is mandatory and is what your system will use to identify existing products.
- Any columns you wish to update.
- A list of the available fields that can be updated is here, Stock Data Import Map
Notes/Caveats
If you require a list of all the stock codes on your system, this can be generated using the process below.
- Go to [Reports | Adhoc Reports].
- In the popup window select System - Products.
- This will produce a CSV file of all the stock items on your system.