Product – Product Import or Inventory – Product Import (when using expanded inventory)
This menu option allows you to create an Excel.xlsx file containing multiple products. This file can then be imported to create or update product resources.
The Product Import Update Template.xlsx file is available with the required layout of the information to be created/updated by logging into www.asicomp.com. Under documents you will find it in General Knowledge called Product Import Update Template.
The file contains multiple worksheets(tabs) containing all the information related to each expander within a product resource such as General Information, Vendors/Costs, Additional Charges (including Artwork and Instructions), Matrix information, Product Instructions, User Defined Fields, and Notes.
Additional worksheets contain information related to various Add Ons such as Inventory, Ecommerce, Manifest, and Points. These worksheets include the information within the product resource expanders for Stock Location, Program Pricing/Web Categories/Suggested Products and Shipment Export information.
Note: When working with the Product Import Update Template.xlsx, these worksheets must remain in the file, even if you do not have any of these Add Ons installed.
The last worksheet in the spreadsheet contains Field Mappings.
This menu option allows you to create an Excel.xlsx file containing multiple products. This file can then be imported to create or update product resources.
The Product Import Update Template.xlsx file is available with the required layout of the information to be created/updated by logging into www.asicomp.com. Under documents you will find it in General Knowledge called Product Import Update Template.
The file contains multiple worksheets(tabs) containing all the information related to each expander within a product resource such as General Information, Vendors/Costs, Additional Charges (including Artwork and Instructions), Matrix information, Product Instructions, User Defined Fields, and Notes.
Additional worksheets contain information related to various Add Ons such as Inventory, Ecommerce, Manifest, and Points. These worksheets include the information within the product resource expanders for Stock Location, Program Pricing/Web Categories/Suggested Products and Shipment Export information.
Note: When working with the Product Import Update Template.xlsx, these worksheets must remain in the file, even if you do not have any of these Add Ons installed.
The last worksheet in the spreadsheet contains Field Mappings.
- This explains the information contained on all the worksheets by column and row.
- Contains the type of data needed for each column.
- Information on the results if some fields are left blank.
The Product Import option is located under Inventory – Product – Product Import.
Select to Import Products or Update Products.