Follow

Things to consider while editing an Import CSV file

While editing your Import CSV file please pay attention to the cases listed below to be able to run a successful importing process.

Please bu sure about the CSV file format. It must have the same format with Shopio's sample files.

The first line of your CSV file must have the field headers described below. You can change the order of the Fields (Ex: Sample CSV comes in an order like Handle, Title, SKU, etc. You can change this order like Title, SKU, Handle, etc.) but you can't change the Field Names, you can't add or delete Fields.

Handle

* Can't be more than 255 characters.
* Blank handle field gives an error if used with option name or option value.
* To use handle field with option name or option value, there must be an already filled line with the same handle name without option fields.
- Error Mesaage: "Parent product not found with given handle"

Title

* If the line isn't for a variant, title field can't be blank.
* If the line isn't for a variant, title name can't be more than 255 characters.

Brand

* If the line isn't for a variant, brand name can't be more than 255 characters.

Option name 1-2-3

* Option name can't be more than 128 characters.
* If option value x filled, option name x field can't be blank.
- Error Message: "Option Name x is required"


Option Value 1-2-3

* Option value can't be more than 128 characters.
* If option name x is filled, option value x field can't be blank.

Category

* If the line isn't for a variant, category name can't be more than 255 characters.

Tax Group

* If the line isn't for a variant, tax group name can't be more than 255 characters.

Weight

* Weight value must be a number. (can be blank)
* Weight value can't be less than 0 and greater than or equal to 999999.

Price

* Price field can't be blank
* Price value must be a number.
* Price value can't be less than 0.
* If the price value is a decimal, must be used with dot. Decimal prices with comma turn with an error.

SKU

* SKU can't be more than 255 characters.

Stock Tracking

* Stock Tracking field can't be blank.
* Stock Tracking field can only be 1 or 0. Otherwise turns with an error.

Stock Amount

* If stock tracking field is 1, stock amount field can't be blank.
Error Message: "Stock Amount is required when Stock Tracking is 1"
* Stock amount value must be a number.
* Stock amount value can't be less than 0 and greater than or equal to 1000000.

Description

* If the line isn't for a variant, description can't be more than 65000 characters.

Image 1-2-3-4

* Image URL's can't have more than 2048 characters.
* Image URL must be taken from a valid website.
* Variants can only have 1 image. That means, if the line is for a variant system considers only image 1 field and ignores other image fields. (does not terminate the importing process)

Meta Title

* If the line isn't for a variant, meta title can't be more than 255 characters.

Meta Description

* If the line isn't for a variant, meta description can't be more than 255 characters.

Meta Keywords

* If the line isn't for a variant, meta keyword can't be more than 255 characters.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk