Definition
If a user has multiple inventory items to enter, they can import Inventory by simply downloading the CSV template and uploading the modified template.
By clicking Export Supplier action button, Q6 will download the Supplier list automatically in CSV format.
Steps on how to Import Inventory
1.Go to Inventory > Inventory List;
2.Click on Action > Import Inventory;
3.Download Inventory Template CSV file;
4.Fill the required information without changing the headings, and save as CSV file format;
5.Then upload the completed Inventory Template CSV file;
6.Click Import.
Import Inventory Fields Explained
.png)
1.Browse: User may click Browse to upload the completed Inventory Template.
2.Import: Once the template has been uploaded, Import function will be activated, and it's just one click away to batch import Inventory List for up to 1000 inventory items.
3.Close: Clicking Close will take you back to the Inventory List.
4.Exit: Clicking Exit will take you back to the Dashboard.
Tips on Import Inventory
1.Do not change the column headings in the template file.
2.All the columns marked with * are compulsory columns, which should not be left blank.
3.We recommend to run a test import of 3-4 Items before importing a large list.
4.A maximum of 1000 Inventories can be imported at a time.
5.If an item already exists in Q6 with the same Inventory Name, this Item will be ignored and wont be imported in the system!
6.Make sure your Account Name, Tax Code, Supplier, Category Name already exists in Q6 before you do importing Inventories.
7.All numbers input should not be negative numbers.
|