Branch_ID - This is the number that corresponds to your branch as listed. To get your Branch ID, click Inventory then Outlets to give you a list of all outlets. The number that corresponds to a outlet is the Branch ID as highlighted below :
Supplier_ID - This is the number that corresponds to your supplier as listed. To get your suppler ID, click Inventory then Suppliers to give you a list of all suppliers as shown below. The number that corresponds to a supplier is the supplier ID as highlighted below :
Category_ID – This is the number that corresponds your category as listed. To get your category ID, click on Inventory then Categories to give you a list of all product categories as shown below. The number that corresponds to a category is the category ID as highlighted below :
SKU - A stock keeping unit (SKU) is a product and service identification code for a product, often represented by a bar code that is unique for each item in inventory. Please note that this should be unique for each variant.
Batch_No - a batch number is like a group id which given to a specific production output and is used to differentiate the products. Please note that products in the same category bear the same batch number. For instance if you sell Xoko Milk it could be packed in 250ml, 500ml and 1L. The different packets are independent products in the inventory but they share the same batch number.
Product Type - There are 3 product types :
Please select the product type that corresponds with your product(s).
Product – This is the name of the product.
Variant - A variant refers to the variations of a product such as size or colour. For instance, 250ml, 500ml, 1L, blue, red etc.
Quantity – this is the amount or number of the product.
Cost Price - This is the price at which you bought a product or the cost of production of your product exclusive of tax.
Retail Price - This is the price at which you are selling your product inclusive of tax.
Margin - This is the profit margin.
Branch - This is the outlet you'd like to upload the stock in.
Supplier - This is the name of the supplier of your product.
Tax –There are two forms of tax enabled by default i.e.
You can change tax types from back-office settings for tax. Please select the tax that applies for your store. If none of the tax types apply, do not select any.
Note : Do not change the column titles in the CSV template and ensure to save your template in the CSV format.
Proceed to upload the populated CSV template by :
You will then be redirected to the product upload page. Please note to select the correct branch that you are uploading your stock as shown below:
Once you are done, you can then look at the products by clicking on Inventory then Products. This will then give you a list of all products uploaded.