Product Importer - Quick Add

In addition to the file content rules outlined here the Quick Add import file has the following requirements:

 

1.The file must contain the column names in the first row of the file.

2.The file must contain a value for the StockCode column.

3.the column names have to be named to match the quick add grid columns, any other column names will be ignored during the import procedure, valid column names are:
 
StockCode
SupplierPartNumber
Description
Price
Location
Category
CommodityCode
TaxCode
SalesNomCode
UnitOfSale
ItemType
Supplier
PurchaseNomCode
ReOrderLevel
ReOrderQty
Department
Weight
 

 

The following sample shows a basic import file contents:

 

StockCode

Description

Price

TEST1

Test Product 1

£1.00

TEST2

Test Product 2

£2.00

 

When the above data is imported 2 new rows will be added to the Quick Add grid, as there are only 3 column being imported from the file the columns not defined in the file will take on the default values as per the default value fields.