Product Code: Mandatory. Enter text or numeric or alphanumeric value to help you easily identify your product, product SKU. For example, if your product is M&M’s Peanut, code can be MM-PEA; for Coca Cola 12 oz cans code can be Coke and so on. If you don’t have your own coding convention, you can just use sequential numbers for the Product Code field: 1,2,3, etc.
Product Name: Mandatory. Enter the full name of the product, for example Coca Cola 12 oz cans.
Product Type: Mandatory. Enter as text the product type. Value that you enter here can be one of the 4 system predefined types: Beverage, Food, Hot drink and Ingredient or your custom product type. If the specified product type does not exist, the system will automatically create it. More info about Product Types.
Units per Case: Optional, number. Enter the number of bottles / cans per case for drinks or number of items in box for Snacks for example. This number is used when you create your Purchase records.
Reorder Point: Optional, number. Enter what is the stock level at which you should consider replenishing this product. When the quantity in the warehouse drops below the reorder point, the product will be displayed in the Inventory to Reorder report. Enter the Reorder Point in single units.
Initial Stock: Optional, number. Enter the quantity available in the warehouse. Value should be in single units (single bottle, single can, single snack).
Unit Cost: Optional, number. The price of the product per single unit at which you buy from supplier. This is the price for the initial quantity.
Barcode: Optional. Enter product’s barcode.
Save the file on your computer.
Go to Inventory section and in Inventory Command bar select button
System will open Import Products from Excel window: