To create products and virtual kits in bulk, you need to use the CSV template. When you do not edit the template correctly, you will receive errors at the time of import. Further ahead in this article, you will learn how to troubleshoot these errors.

Error

How to resolve

Failed: SKU is missing; the field cannot be blank. Make sure to add the SKU and then upload the CSV again.

Do not leave the SKU field blank in the CSV.

Failed: SKU is a duplicate in the CSV. Make sure it is unique for the product.

Do not use the same SKU for multiple products.

Failed: EAN is a duplicate in the CSV. Make sure it is unique for the product.

Do not use the same EAN for multiple products.

Failed: UPC is a duplicate in the CSV. Make sure it is unique for the product.

Do not use the same UPC for multiple products.

Failed: GTIN is a duplicate in the CSV. Make sure it is unique for the product.

Do not use the same GTIN for multiple products.

Failed: Alias is a duplicate in the CSV. Make sure it is unique for the product.

Do not use an existing alias again for multiple products.

Failed: Vertical is missing; the field cannot be blank. Make sure to add the vertical and then upload the CSV again.

Do not leave the vertical field blank in the CSV.

Failed: The selected brand is inactive in the workspace. Change the status to active or use the brand name, which is under active status. Refer to the article add and edit a brand to learn more.

The selected brand should be active in the workspace.

Failed: Brand is missing; the field cannot be blank. Make sure to add it and then upload the CSV again.

Do not leave the brand field blank in the CSV.

Failed: The title cannot be greater than 100 characters. Make sure you are not exceeding the character limitations before uploading the CSV.

Do not exceed 100 characters in the product title.

Failed: The title is missing; the field cannot be blank. Make sure to add it and then upload the CSV again.

Do not leave the title field blank in the CSV.

Failed: Image URL is missing; the field cannot be blank. Make sure to add the Image URL and then upload the CSV again.

Do not leave the image URL field blank in the CSV.

Failed: Image URL cannot be greater than 250 characters. Make sure it does not exceed the limit and then upload the CSV again.

Do not exceed 250 characters in the image URL.

Failed: Image URL contains space in between. Replace space with %20 in the image URL. Refer to the article troubleshooting CSV template errors to learn more.

Replace any space in the image URL by %20.

Failed: Image URL must start with https://. Refer to the article product image requirement to learn more.

The URL must start with https://.

Failed: The M.R.P. is missing; the field cannot be blank. Make sure to add it and then upload the CSV again.

Do not leave the M.R.P. field blank in the CSV.

Failed: The M.R.P. is inappropriate. Make sure it is numeric only.

The M.R.P. should be numeric only.

Failed: The M.R.P. cannot be less than the unit price.

The M.R.P. should not be less than the unit price.

Failed: The M.R.P. cannot be negative.

The M.R.P. should not have a negative value.

Failed: The unit price cannot be negative.

The unit price should not have a negative value.

Failed: The unit price is missing; the field cannot be blank. Make sure it is added and then upload the CSV again.

Do not leave the unit price field blank in the CSV.

Failed: The unit price is inappropriate. Make sure it is numeric only.

The unit price should be numeric only.

Failed: The tax code value is incorrect. You can select the tax code from predefined values only.

The tax code should be a predefined value from the list.

-ESBGST1: if tax applicable is 5% or 12%

-ESBGST2: if tax applicable is 12% 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%

Failed: The Tax code is missing; the field cannot be blank. Make sure to add it and then upload the CSV again.

Do not leave the tax code field blank in the CSV.

Failed: Weight is missing; the field cannot be blank. Make sure to add it and then upload the CSV again.

Do not leave the weight field blank in the CSV.

Failed: Weight cannot be negative.

The weight should not have a negative value.

Failed: The weight is inappropriate. Make sure it is numeric only.

The weight should be numeric only.

Failed: The unit of weight is incorrect. Make sure the unit is g and then upload the CSV again.

The weight unit should be g only.

Failed: Length is missing; the field cannot be blank. Make sure to add it and then upload the CSV again.

Do not leave the length field blank in the CSV.

Failed: Length cannot be negative.

The length should not have a negative value.

Failed: Length is inappropriate. Make sure it is in numeric only.

The length should be numeric only.

Failed: Width is missing; the field cannot be blank. Make sure to add it and then upload the CSV again.

Do not leave the width field blank in the CSV.

Failed: Width cannot be negative.

The width should not have a negative value.

Failed: Width is inappropriate. Make sure it is in numeric only.

The width should be numeric only.

Failed: Height is missing; the field cannot be blank. Make sure to add it and then upload the CSV again.

Do not leave the height field blank in the CSV.

Failed: Height cannot be negative.

The height should not have a negative value.

Failed: Height is inappropriate. Make sure it is in numeric only.

The height should be numeric only.

Failed: The unit of dimensions is incorrect. Make sure the unit is cm and then upload the CSV again.

The dimensions unit should be cm only.

Failed: The custom field does not exist. Make sure the custom field is added to the workspace and assigned to the products. Refer to the article creating custom fields to learn more.

The custom field should be added to the workspace and should be assigned to the product.

Failed: The custom field value is invalid. Make sure the value matches the custom field type. Refer to the article creating custom fields to learn more.

The custom field value should match the field type that was set at the time of creating the custom field.

Failed: Component is missing; the field cannot be blank. Make sure to add the component and then upload the CSV again.

Do not leave the component field blank in the CSV.

Failed: You cannot add a component with the same SKU in multiple columns. Make sure to add the component only once and along with the correct quantity and then upload the CSV again.

A component should be added only once in the template and the correct quantity of the component that is to be included in the virtual kit should be specified in the respective column.

Failed: One of the components of the virtual kit is in draft or is invalid. Make sure the product you are adding as the component is active.

The components should be active in the workspace.

Failed: Quantity is missing; the field cannot be blank. Make sure the quantity is at least greater than or equal to 1 and then upload the CSV again.

Do not leave the quantity field blank in the CSV.

Failed: EAN cannot be different for one virtual kit (SKU).

The EAN entered should be the same for all the components of the virtual kit.

Failed: UPC cannot be different for one virtual kit (SKU).

The UPC entered should be the same for all the components of the virtual kit.

Failed: GTIN cannot be different for one virtual kit (SKU).

The GTIN entered should be of the virtual kit and not of the component.

Failed: Aliases cannot be different for one virtual kit (SKU).

The aliases entered should be of the virtual kit and not of the component.

Failed: The M.R.P. cannot be different for one virtual kit (SKU).

The M.R.P. entered should be of the virtual kit and not of the component.

Failed: HSN Code cannot be different for one virtual kit (SKU).

The HSN code entered should be of the virtual kit and not of the component.

Failed: The Tax Code cannot be different for one virtual kit (SKU).

The tax code entered should be of the virtual kit and not of the component.

Did this answer your question?