Adding Products by Use of a Template

Adding Products by Use of a Template

  • Click on Inventory then Products.
  • Click on the upload icon highlighted on the top right side as shown below :
  •  On the page that appears, click on the CSV sample link to download a CSV template which you will then populate your products with.

  • The CSV template has the following fields as shown below :

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 :

  • Production – product type in which raw materials are processed into finished goods.
  • Service – product type in which no physical goods are transferred from the seller to the buyer.
  • Stockable – This is a tangible product.

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. 

  • - VAT set at 16%.
  • - CLevy which applies for restaurants and is set at 2%.

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.

  • From the information above, you can then fill the CSV template.
  • Save your CSV file at a suitable location on your computer.

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 :

  • Click on Inventory then Products.
  • On the Products page, click on the upload icon highlighted below in the top-right:

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:

 

  • Click on the “Drop a CSV file” field.
  • Select your CSV template from the location you saved it in. This will then be inserted into the upload panel.
  • Click Import Products to upload your CSV template.

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.

 

    • Related Articles

    • Adding Products by Use of a Template

      Click on Inventory then Products. Click on the upload icon highlighted on the top right side as shown below :  On the page that appears, click on the CSV sample link to download a CSV template which you will then populate your products with. The CSV ...
    • Adding products with serials using a CSV

      Xoko now accommodates not only barcode/SKUs but also serial numbers. This means, adding of products with IMEs to your back office will no longer be an issue in your business. This is new feature ensures that this is achieved in a simple and easy ...
    • Managing Stock by Use of Approvals

      Using approvals means one user initiates requests and another one approves. This is done when managing stock i.e. receiving, adjusting, transferring, and managing stock. To begin with, ensure the approval is set under settings. Use the link below ...
    • Bulk Receiving of Stock

      Xoko now allows you to receive stock in bulk by use of a CSV file thus reducing time taken in stock management. To achieve this, here are steps to follow. 1. Login  to Backoffice with appropriate account 2. On the sidebar, select Inventory then click ...
    • Transfer of stock

      Xoko allows you to transfer stock from one branch to another. Here is the information you require to get started. 1. Access inventory and select manage 2. Use the dropdown under manage inventory and select transfer stock 3. Enter the required ...