You can import products and virtual kits in bulk using the respective CSV templates. In this article, you will learn how to prepare these templates for import.

Preparing the CSV for product

Follow the steps below to prepare the CSV correctly for upload.

  • Navigate to the sidebar and select Inventory >All products >Import

  • Select Create new or update existing products >Product

  • Download the product template.

Eshopbox will skip any row starting with a semi-colon “;”.

In this template, you will come across the following attributes.

Product template attributes

Attribute

Description

SKU

SKU (Stock Keeping Unit) is a unique identifier for the product. It is a mandatory field.

Product Group Code

Product Group Code is an identifier used to group products with multiple variants. It is an optional field.

EAN

EAN (European Article Number) is a unique identifier for the product. It is an optional field.

UPC

UPC (Universal Product Code) is a unique identifier for the product. It is an optional field.

GTIN

GTIN (Global Trade Item Number) is a unique identifier for the product. It is an optional field.

Aliases

You can add other aliases (unique identifiers) for a product. It is an optional field.

Vertical

It is the category to which the product belongs. It is an optional field. You can only enter the vertical mapped with the brand.

Brand

It is the brand of the product. It is an optional field. You can map one brand with a product. Make sure the brand is created and active.

Title

It is a short description of your product. It is a mandatory field.

Image URL

The URL of an image representing the product. The URL has to start with https://. It is a mandatory field. To add the product images, you need to generate image links. Learn to create links for your product images.

Fragile

A product is fragile if it cannot survive a 4-foot drop without being damaged. Enter Yes or No as per the product specification. It is an optional field.

Dangerous

A product that needs special precautions when handled. Enter Yes or No as per the product specification. It is an optional field.

A battery or contains one

Any product that contains, or is, a battery. Enter Yes or No as per the product specification. It is an optional field.

Media

Books, CDs, DVDs and other media may qualify. Enter Yes or No as per the product specification. It is an optional field.

M.R.P.

It is the maximum retail price of the product that is assigned by its manufacturer for selling in India.

Unit price

It is the cost price of the product.

Tax code

It is required to calculate the tax amount when the product is invoiced. You can select the tax code from the following pre-defined values.
-ESBGST1: if tax applicable is 5% or 12% -ESBGST2: if tax applicable is 5% or 18%
-ESBGST3: if tax applicable is 0%
-ESBGST4: if tax applicable is 0%
-ESBGST5: if tax applicable is 18%
-ESBGST7: if tax applicable is 5%
-ESBGST9: if tax applicable is 12%
-ESBGST10: if tax applicable is 3%
-ESBGST12: if tax applicable is 28%

HSN code

It is used for the classification of goods systematically and logically and was developed by the World Customs Organization (WCO). It is a mandatory field and should be mentioned in the invoice.

Weight

Weight of the product in kg. It should be numeric with up to 2 decimal points. It is a mandatory field required to calculate storage as well as shipping charges.

Weight unit

It is the unit for the weight of the product. Should be kg only.

Length

Length of the product. It should be numeric with up to 2 decimal points. It is a mandatory field required to calculate storage as well as shipping charges.

Width

Width of the product. It should be numeric with up to 2 decimal points. It is a mandatory field required to calculate storage as well as shipping charges.

Height

Height of the product. It should be numeric with up to 2 decimal points. It is a mandatory field required to calculate storage as well as shipping charges.

Dimensions unit

It is the unit for the dimensions (LXBXH) of the product. Should be cm only.

Custom field

A custom field can store information unique to your business. Custom fields with multiple values must be added in the same cell separated by a semicolon “;”.

  • Fill in the product details under each field in the template header.

  • Save the template as CSV. Your products are now ready for import.

Preparing the CSV for virtual kit

  • Navigate to the sidebar and select Inventory >All products >Import

  • Select Create new or update existing products >Virtual kit

  • Download the virtual kit template.

  • Fill in the details of the virtual kits in it. In this template, you will come across the following attributes.

Virtual kit template attributes

Attributes

Description

Component

It is the SKU that you want to add in a virtual kit as a component. It is a mandatory field. Use separate rows to add multiple components in a virtual kit.

Quantity

It is the number of items of the SKU that you want to add to a virtual kit.

SKU

SKU (Stock Keeping Unit) is a unique identifier for the virtual kit. It is a mandatory field. SKU should be the same in case you are creating a virtual kit for multiple components.

Product Group Code

Product Group Code is an identifier used to group multiple virtual kits. It is an optional field.

EAN

EAN (European Article Number) is a unique identifier for the virtual kit. It is an optional field.

GTIN

GTIN (Global Trade Item Number) is a unique identifier for the virtual kit. It is an optional field.

UPC

UPC (Universal Product Code) is a unique identifier for the virtual kit. It is an optional field.

Aliases

You can add other aliases (unique identifiers) for a virtual kit. It is an optional field.

Title

It is a short description of your virtual kit. It is a mandatory field. The title should be the same in case you are creating a virtual kit for multiple components.

M.R.P.

It is the maximum retail price of the virtual kit that is assigned by its manufacturer for selling in India. It is a mandatory field. M.R.P should be the same in case you are creating a virtual kit for multiple components.

Tax code

It is required for calculating the applicable tax. It is a mandatory field.
You can select the tax code from the following pre-defined values.
-ESBGST1: if tax applicable is 5% or 12% -ESBGST2: if tax applicable is 5% or 18%
-ESBGST3: if tax applicable is 0%
-ESBGST4: if tax applicable is 0%
-ESBGST5: if tax applicable is 18%
-ESBGST7: if tax applicable is 5%
-ESBGST9: if tax applicable is 12%
-ESBGST10: if tax applicable is 3%
-ESBGST12: if tax applicable is 28%

HSN code

It is used for the classification of goods systematically and logically and was developed by the World Customs Organization (WCO). It is a mandatory field and should be mentioned in the invoice. HSN code should be the same in case you are creating a virtual kit for multiple components. It is a mandatory field.

Custom field

A custom field can store information unique to your business. Custom fields with multiple values must be added in the same cell separated by a semicolon “;”.

  • Save the template as CSV. Your virtual kits are now ready for import.


Note

  • Eshopbox recommends you use Google Sheets to work with your templates. After you've made the changes to the template, make sure to download the file as a CSV.

  • When you edit this template, make sure to remove all the sample data in it.

  • Special characters don't always work correctly when the CSV templates are exported, edited with another spreadsheet program and then imported back into Eshopbox.

  • The product and virtual kit templates cannot exceed the max file size limit of 5MB. If your product template is larger than the limit, you'll have to import the product details in multiple CSVs.

  • In custom fields, you need to enter the details as per the field type defined for it. For instance, if you've created a custom field with a single select option, you can only enter one pre-defined value against the custom field. Learn how to create a custom field.

  • To view the status of your imports, you can navigate to Sidebar and select
    Files >Imports. Learn how to troubleshoot CSV template errors.

Did this answer your question?