Importing Products


  • stockcode: Stock Code should not be empty. It should not already exist.

  • description: Stock description should not have any special characters (&"/'$#%?{}!*;:). It should not contain more than 25 characters

  • categoryname: Category Name as displayed in the software. ie the category should already exist.

  • units: Units should exist already. Check Below for list of Units.

  • itemtype: Itemtype should be Assemble, Manufactured, Purchased, Wage/Service charge

  • taxcatgory: Tax Category Name should be Exempt, Freight, Luxury Items, Taxable supply

  • materialcost: Material cost should be in number format without any comma. Default value is Zero. Example 9999.99

  • salesprice: Sales Price should be number format without any comma. Default value is Zero. Example 9999.99

  • barcode: Barcode is optional.

  • eoq: Economic Order Quantity should be number format without any comma. Default value is Zero.Example 9999.99

  • serialized: Serialized is should be 'YES' or 'NO'. If products have serial number then Batch Controlled should be 'Yes'

  • controlled: Batch Controlled is should be 'YES' or 'NO'.Batch Control should be 'Yes' if the product have serial number.

  • Units List:

Units options

each, meters, kgs, litres, length, Kilometers, centimeters, yards, gallon, inch, mile, minute, hour, day, gram, Kilogram, pound, box, batch, case, crate, US liquid gallon, US liquid quart, US liquid pint, US legal cup, fluid ounce, US tablespoon, US teaspoon, Cubic meter, Milliliter, Imperial gallon, imp. quart, Imperial pint, Imperial cup, Imperial tables, Imperial teaspoon, Cubic foot, Cubic foot, tonne, Milligram, Microgram, Imperial ton, US ton, Stone, Millimetre, Micrometres, Nanometre, Mile, Yard, Foot, Nautical mile.


Sample import format