Provide all column names in English for proper addressing of your feed. StoreAutomator accepts .xlsx, .csv, .txt, .zip file formats. File size should not exceed 20MB. Below is a list of Required Fields for the system to process your data at a minimum level.

Click to download Product Data Specs File

Name

Description

Notes

sku

SKU

Max, 50 characters

title

Product Name

Max, 150 characters

description

Product description

Max, 5000 characters

brand_name

Brand Name

Max, 100 characters, brand name to be created if it doesn’t exist

price

Regular price

If you want to take advantage of advanced features like parentage, repricer, and dashboard PNL analysis, you also can provide those applicable fields.

Optional fields

Name

Description

Notes

short_description

Product short description

published

Product published state on channels

Values: Yes, no, true, false

parentage

If this product is a variation, parent put “parent”

If this product is a variation, put “child.”

Empty for single products

variation_types

Option types for the variations

Color, size, scent, type, etc

If the product has multiple variation types, separated by comma ‘,’ e,g,: ‘Color, Size.’

variation_options

Variation option combination for the specific product

Order of options to be the same as the order of variation types.

E.g.: ‘Red, M’

parent_sku

Parent product SKU to be used if this product is a child.

Max, 50 characters, must refer to a line with Parentage column set to ‘Parent.’

is_discontinued

The item is discontinued or not

Yes, no, true, false. Default value ‘false.’

quantity

quantity

width

Item width

length

Item length

height

Item height

weight

Item weight

amount_of_contents

Item amount_of_contents

unit_of_content

Item unit_of_content

Pcs, oz, kg, g, lb, floz, fl oz, l, ml, gal, in, inches, inch, m, mm, cm, ft. Default value: pcs.

location

Item’s warehouse location

cost

The unit cost of the product

Used by dashboard and repricer to calculate the profit margin

sale_price

Sale price if the item is on sale

sale_price_start_date

Start date of the item sale price

Date format: YYYY-MM-DD

sale_price_end_date

The end date of the item sale price

Date format: YYYY-MM-DD

MSRP

Manufacturer’s Suggested Retail Price

MAP

Minimum Advertised Price

tax

Tax Percentage of Tax Class id

E.g., 2001234

product_id

Barcode or Specific product id

product_id_type

Item barcode or specific product id type. Value to be selected amongst UPC, EAN, ISBN, ASIN, GCID, GTIN, EPID

Default value: ‘UPC’

mpn

Manufacturer code

image_url_x

A valid web address where we can download the product image, x represents the source number

Max.250 characters each.Up to 10 URLs. URLs to start with HTTP:// or HTTPS://

E.g. header: image_url_1

category_codes

Your category codes, assigned by yourself

Multiple category codes, to be separated by comma ‘,’

category_x

Category, path separated by ‘>’ sign

Max.250 characters each. Up to 5 category columns, 1<X<5

E.g. header: category_1

E.g. value: ‘Electronics>Mobile Phones > Accessories’

Category to be created if it doesn’t exist in our system

meta_description

Meta descriptions

Max 250 characters

meta_keywords

Meta keywords

Separate with a comma ‘,’

bullet_point_x

Bullet point (Mainly used by Amazon)

Up to 5 bullet points. 1<x<5

E.g. Header: Bullet_point_1

search_term_x

Search term (Mainly used by Amazon)

5 search terms. 1<x<5

E.g., Header: Search _Termt_1

used_for_x

Used for (Mainly used by Amazon)

Up to 5 used_for points. 1<x<5

E.g. Header: Used_For_1

other_attribute_x

Other item attribute (Mainly used by Amazon)

Up to 5 bullet attributes. 1<x<5

E.g. Header: other_attribute_1

target_audience_x

Target Audience (Mainly used by Amazon)

Up to 5 target audience. 1<x<5

E.g. Header:target_audience_1

attr_name_x

Custom field name: A custom field x consists of name and value columns named attr_name_x and attr_value_x. Use pairs like: attr_name_1|attr_value_1 , attr_name_2|attr_value_2, etc…

Max. 50 characters, only English letter numbers and dash ‘-’ accepted. No spaces. Up to 50 custom fields, 1<x<50

E.g. header: attr_name_1

E.g., Value: model-year

attr_value_x

The value associated with the custom field

Max 250 characters,

E.g. header: attr_value_1

E.g., value: 1977

update_delete

Put ‘Update’ or leave empty to update the product.

Pur; delete’ to delete an existing product

Although a feed can contain CREATE, UPDATE, and DELETE operations simultaneously, we recommend that you create individual feeds for each operation.

Click to download Product Data Specs File

Did this answer your question?