Import Products

Import Products:

Steps:

  1. Go to Products -> Import Products
  2. Download the template file.
  3. Fill all the information as per the displayed columns name & instructions. Don’t remove the heading from template file.
  4. Import the file

Instructions

Follow the instructions carefully before importing the file.
The columns of the file should be in the following order.

Column NumberColumn NameInstruction
1Product Name (Required)Name of the product
2Brand (Optional)Name of the brand
(If not found a new brand with the given name will be created)
3Unit (Required)Name of the unit
4Category (Optional)Name of the Category
(If not found new category with the given name will be created)
5Sub-category (Optional)Name of the Sub-Category
(If not found new sub-category with the given name under the
parent Category will be created)
6SKU (Optional)Product SKU. If blank an SKU will be automatically generated
7Barcode Type (Optional, Default: C128)Barcode Type for the product.
Currently supported: C128, C39, EAN-13, EAN-8, UPC-A, UPC-E, ITF-14
8Manage Stock? (Required)Enable or disable stock management
1 = Yes
0 = No
9Alert quantity (Optional)Alert quantity
10Expires in (Optional)Product expiry period (Only in numbers)
11Expiry Period Unit (Optional)Unit for the expiry period
Available Options: days, months
12Applicable Tax (Optional)Name of the Tax Rate

If the purchase Price (Excluding Tax) is not the same as
Purchase Price (Including Tax)
then you must supply the tax rate name.
13Selling Price Tax Type (Required)Selling Price Tax Type
Available Options: inclusive, exclusive
14Product Type (Required)Product Type
Available Options: single, variable
15Variation Name (Required if product type is variable)Name of the variation (Ex: Size, Color, etc )
16Variation Values (Required if product type is variable)Values for the variation separated with ‘|’
(Ex: Red|Blue|Green)
17Purchase Price (Including Tax)
(Required if Purchase Price Excluding Tax is not given)
Purchase Price (Including Tax) (Only in numbers)

For variable products ‘|’ separated values with
the same order as Variation Values
(Ex: 84|85|88)
18Purchase Price (Excluding Tax)
(Required if Purchase Price Including Tax is not given)
Purchase Price (Excluding Tax) (Only in numbers)

For variable products ‘|’ separated values with
the same order as Variation Values
(Ex: 84|85|88)
19Profit Margin % (Optional)Profit Margin (Only in numbers)
If blank default profit margin for the
the business will be used
20Selling Price (Optional)Selling Price (Only in numbers)
If blank selling price will be calculated
with the given Purchase Price
and Applicable Tax
21Opening Stock (Optional)Opening Stock (Only in numbers)

For variable products separate stock quantities with ‘|’
(Ex: 100|150|200)
22Opening stock location (Optional)
If blank first business location will be used
Name of the business location
23Expiry Date (Optional)Stock Expiry Date
Format: mm-dd-yyyy; Ex: 11-25-2018
24Enable Product description, IMEI or Serial Number (Optional, Default: 0)1 = Yes
0 = No
25Weight (Optional)Optional
26Rack (Optional)Rack details are separated by ‘|’ for different business locations serially.
(Ex: R1|R5|R12)
27Row (Optional)Row details separated by ‘|’ for different business locations serially.
(Ex: ROW1|ROW2|ROW3)
28Position (Optional)Position details separated by ‘|’ for different business locations serially.
(Ex: POS1|POS2|POS3)
29Image (Optional)Image name with extension.
(Image name must be uploaded to the server public/uploads/img )
30Product Description (Optional)
31Custom Field1 (Optional)
32Custom Field2 (Optional)
33Custom Field3 (Optional)
34Custom Field4 (Optional)
35Not for selling (Optional)1 = Yes
0 = No
36Product locations (Optional)Comma-separated string of business location names where the product will be available

Common Errors:

  1. Error: UNIT not found
    Solution: Make sure the unit you provided in excel file is already present in the system. Go to  Products -> Units, add the unit & import the file again.

Not well-defined error:

Many times it can show some not well-defined errors like “non-numeric value encounter” or others

In this case, the best way is to split your import into multiple files.

For example, if you’re importing fil with 500 products, divide it into 2 files of 250 each and import it.

Powered by BetterDocs