Click on material db menu, then select import csv file (a text format file). If your product list is Microsoft Excel file, you may save that Excel file as csv format (in Excel, Save As, then select csv format).

 

 

Steps to Import Product List from a CSV File:

·        Click on import csv file, navigate the directory and select the csv file (as depicted below). One csv file should contain one product type (such as Carpet, etc), if your product file contains multiple product types, break into separate csv files by product type.

·        Upon importing, click on “Match Fields“ button to sync the imported file fields with those of the program database. The most important field is Style Code. Match as many fields as possible, leave the unmatched field blank. For Type Code and Category Code, you may match the ones in the sample database to have the items imported under the same categories.

 

 

 

 

 If in csv file there is Unit or UOM column, make sure the unit labels in there matches the ones used in the program database (such as SY, SF; if not, convert them into SY or SF and save into the csv file to ensure accurate importing).