Shopify Export to Amazon Inventory Flat File

You can export your store data as the Amazon Inventory Flat File format. To do that, choose the “Amazon Inventory Flat File” in the dropdown next to Export button.

Tutorials

Exported Columns

The exported fields match minimal Amazon Services requirements, with some special ways how to fill in fields that are not normally available in Shopify.

Each column will have described the source – from which Shopify field the data is being taken, and how you can impact the values.

Parent and Child rows are generated to match Amazon requirements of product variations.

Some fields can be specified in Shopify Metafields, in the “amazon” namespace.

Basic – These are attributes that are important to buyers and should be populated for all your items. Some are required to create an offer.

ColumnExampleSource Field in Shopify
item_sku
SKU-1234345
Product Variant SKU

For the parent row the Product ID will be used here. See “Variation” section below for more details.

external_product_id
123456789012
Product Variant Barcode, but only if the Barcode format matches supported Amazon external product id types (see column “external_product_id_type”).

If your SKUs are not the Amazon registered ASINs, then you need to have Barcodes in your store, which are existing barcodes for those products. Or you will need to register those barcodes with Amazon separately. There is also an option that you ask Amazon to enable you mode where you don’t need valid barcodes – for example, if you manufacture your own products.

external_product_id_type
GTIN
Determined automatically from the Product Variant Barcode format.

Possible types:

  • UPC
  • EAN
  • GTIN
  • GCID
item_name
T-shirt with the whole Earth - Green / XS
For parent row:

1 – Taken “Metafield: amazon.item_name”.
2 – If such Metafield does not exist then taken from actual Product Title.

For child rows:

1 – Taken from “Variant Metafield: amazon.item_name”.
2 – If such Metafield does not exist then combines Product Title and Shopify Variant Title with a dash.

product_description
This T-shirt shows the whole Earth on it.
Taken from Metafield “product_description” in namespace “amazon”. This allows you to provide different product description for Amazon than you have in Shopify.

If there is no such Metafield, then Product Description is used. In that case, the description HTML code is automatically converted to the format that will be acceptable by Amazon, for example, all the images and special symbols are removed, all formatting is attempted to reformat so that the text is formatted as close as possible to the original HTML.

If you want to define your own HTML for Amazon, then put it the Metafield: amazon.product_description – that will not be changed in any way.

feed_product_type
Kitchen
Taken from Metafield “feed_product_type” in namespace “amazon”.

If there is no such Metafield, then it is taken from Product Tag that starts with “AmazonProductType:”. For example, if you have the Tag “AmazonProductType:Kitchen”, then it will use “Kitchen” as product type.

If those are empty, then it’s taken from the Product Type field.

List of some possible values can be found here.

department_name
mens
Taken from Metafield “department_name” in namespace “amazon”.

If there is no such Metafield, then it is taken from Product Tag that starts with “AmazonDepartment:”. For example, if you have the Tag “AmazonDepartment:mens”, then it will use “mens” as the department.

brand_name
Puma
Product Vendor
manufacturer
Puma
Product Vendor
part_number
ABC-123
Taken from Metafield “part_number” in namespace “amazon”.

If there is no such Metafield, then it is taken from Product Tag that starts with “AmazonPartNumber:”. For example, if you have the Tag “AmazonPartNumber:ABC-123”, then it will use “ABC-123” as part number.

item_type
volleyball-nets
Taken from Metafield “item_type” in namespace “amazon”.

If there is no such Metafield, then it is taken from Product Tag that starts with “AmazonItemType:”. For example, if you have the Tag “AmazonItemType:volleyball-nets”, then it will use “volleyball-nets” as product type.

update_deleteThis field is always exported empty.

But you can set your own value here after doing export, before importing to Amazon.

model
TOP
Taken from variant option “Model”, if there is product option with name “Model”.

If there is no such variant option, then it is taken from Metafield “model”, in namespace “amazon”.

If there is no such either, then it is taken from Product Tag that starts with “AmazonModel:”. For example, if your product has tag “AmazonModel:TOP”, then “TOP” will be taken as model.

Offer – These attributes are required to make your item buyable for customers on the site

ColumnExampleSource Field in Shopify
standard_price
249.99
If your Shopify Product variant doesn’t have “Compare At Price” set, then the Variant Price will be used.

It variant has “Compare At Price” set, then that will be used.

sale_price
199.99
If your variant has “Compare At Price” set, then Variant Price will be used here (because “Compare At Price” is used in standard_price in this case).

if your variant doesn’t have “Compare At Price”, then this field will be left empty.

sale_from_date
2018-01-09
Metafield “sale_from_date” in “amazon” namespace.
sale_end_date
2018-02-28
Metafield “sale_end_date” in “amazon” namespace.
quantity
546
Product Variant inventory quantity.
merchant_shipping_group_nameMetafield “merchant_shipping_group_name” in “amazon” namespace.

Dimensions – These attributes specify the size and weight of a product

ColumnExampleSource Field in Shopify
website_shipping_weight
75.00
Product Variant weight. Should be > 0.
website_shipping_weight_unit_of_measure
oz
Product Variant weight unit

Discovery – These attributes have an effect on how customers can find your product on the site using browse or search

ColumnExampleSource Field in Shopify
bullet_point1
Feature number 1
Metafield “bullet_point1” in “amazon” namespace.
bullet_point2
Feature number 2
Metafield “bullet_point2” in “amazon” namespace.
bullet_point3
Feature number 3
Metafield “bullet_point3” in “amazon” namespace.
bullet_point4
Feature number 4
Metafield “bullet_point4” in “amazon” namespace.
bullet_point5
Feature number 5
Metafield “bullet_point5” in “amazon” namespace.

Images – These attributes provide links to images for a product

ColumnExampleSource Field in Shopify
main_image_url
https://cdn.shopify.com/1234/993/image1.png
Product image #1
other_image_url1
https://cdn.shopify.com/1234/993/image2.png
Product image #2
other_image_url2
https://cdn.shopify.com/1234/993/image3.png
Product image #3
other_image_url3
https://cdn.shopify.com/1234/993/image4.png
Product image #4
other_image_url4
https://cdn.shopify.com/1234/993/image5.png
Product image #5
other_image_url5
https://cdn.shopify.com/1234/993/image6.png
Product image #6
other_image_url6
https://cdn.shopify.com/1234/993/image7.png
Product image #7
other_image_url7
https://cdn.shopify.com/1234/993/image8.png
Product image #8
other_image_url8
https://cdn.shopify.com/1234/993/image9.png
Product image #9

Variation – Populate these attributes if your product is available in different variations (for example color or wattage)

ColumnExampleSource Field in Shopify
parent_child
parent
If Product in Shopify has variants, then special first row will be created with “parent” as value in this column, and Product ID in the “item_sku” column.

If Product is Shopify has no variants, then this will always be “child”.

parent_sku
234872634873
For each child row, the Product ID will be used (the value of “item_sku” column), so that it points to the correct parent row.

For the parent row this will be empty.

relationship_type
variation
If Product in Shopify has variants, then this field will be set to “Variation”.

If product has no variants, then it will be empty.

variation_theme
size
Will be automatically detected and mapped from your Variant Options.

Currently able to detect the following variation themes:

  • Size
  • Color

Shopify Columns

Those columns will contain values from your Shopify products so that you can use them in the filters or variation themes manually if variations were not filled automatically for some reason.

When importing the Excel file to Amazon, you don’t have to delete those columns – Amazon will give warnings that it ignored those columns. If you don’t want to have those warnings, then you can delete those Shopify columns from the Excel file before importing.

ColumnExampleSource Field in Shopify
Created At
2018-02-06 14:43:23
Date and time, when the Product was created in your Shopify store.
Updated At
2018-02-06 14:43:23
Date and time, when the Product was last updated in your Shopify store.
Published At
2018-02-06 14:43:23
Date and time, when the Product was last published in your Shopify store. If the product is not published, then this value will be empty. That way you can filter out and remove products, which are not published in your store if you don’t want to publish them on Amazon either.
Shopify
Variant Title
XS / Red
Full title of the Shopify Variant. Taken from Product Variant Title in Shopify.
Shopify
Option1 Name
Size
Option1 Name for Variant
Shopify
Option1 Value
XS
Option1 Value for Variant
Shopify
Option2 Name
Color
Option2 Name for Variant
Shopify
Option2 Value
Red
Option2 Value for Variant
Shopify
Option3 Name
Option3 Name for Variant
Shopify
Option3 Value
Option3 Value for Variant

Variation Values

ColumnExampleSource Field in Shopify
Size
size_name
S
Can be taken from multiple fields with priority in this order:

  1. Variant Metafield: amazon.size_name
  2. Variant Metafield: amazon.size
  3. Variant Option whose name is “Size”
  4. Metafield: amazon.size
  5. Metafield: amazon.size_name
Size Map
size_map
S
Can be taken from multiple fields with priority in this order:

  1. Variant Metafield: amazon.size_map.
  2. If “Variant Metafield: amazon.size_map” does not exist then copy values from the size_name field.
Color
color_name
Sage
Can be taken from multiple fields with priority in this order:

  1. Variant Metafield: amazon.color_name
  2. Variant Metafield: amazon.color
  3. Variant Option whose name is “Color”
  4. Metafield: amazon.color
  5. Metafield: amazon.color_name
Color Map
color_map
Green
Can be taken from multiple fields with priority in this order:

  1. Variant Metafield: amazon.color_map.
  2. If “Variant Metafield: amazon.color_map” does not exist then copy values from the size_name field.
Search Terms
generic_keywords
strong, waterproof, washable
Taken from “Variant Metafield: amazon.generic_keywords”.
Product Tax Code
product_tax_code
A_GEN_NOTAX
Taken from “Variant Metafield: amazon.product_tax_code”

Metafields for Amazon

With the Excelify any Metafield that you have in the “amazon” namespace will be added as an additional column to the file with a name the same as the Metafield key.
There are multiple defined amazon Metafields listed below:

Metafield NameColumn in Excelify import/export templateSends data to field in Amazon export
product_description
Metafield: amazon.product_description
product_description
feed_product_type
Metafield: amazon.feed_product_type
feed_product_type
item-name
For parent row - Metafield: amazon.item_name
For child row - Variant Metafield: amazon.item_name
item_name
item_type
Metafield: amazon.item_type
item_type
model
Metafield: amazon.model
model
part_number
Metafield: amazon.part_number
part_number
sale_from_date
Metafield: amazon.sale_from_date
sale_from_date
sale_end_date
Metafield: amazon.sale_end_date
sale_end_date
bullet_point1
Metafield: amazon.bullet_point1
bullet_point1
bullet_point2
Metafield: amazon.bullet_point2
bullet_point2
bullet_point3
Metafield: amazon.bullet_point3
bullet_point3
bullet_point4
Metafield: amazon.bullet_point4
bullet_point4
bullet_point5
Metafield: amazon.bullet_point5
bullet_point5
size_name
Variant Metafield: amazon.size_name
size_name
size_map
Variant Metafield: amazon.size_map
size_map
color_name
Variant Metafield: amazon.color_name
color_name
color_map
Variant Metafield: amazon.color_map
color_map
generic_keywords
Variant Metafield: amazon.generic_keywords
generic_keywords
product_tax_code
Variant Metafield: amazon.product_tax_code
product_tax_code

Good To Know

  • Depending on the Product Category you need to import, specify TemplateType value in the A1 cell of the Import File.
  • If you need to have custom columns for your Amazon exported products, you can add Metafields in the “amazon” namespace. They will be added as an additional column to the file with a name the same as the Metafield key.
  • You don’t have to have all the data filled in. If it will not find the appropriate value, it will just leave it empty.
  • You can add values or change them in the exported file, before importing to Amazon.
  • To decide, what values are needed in which cases, please, consult the Inventory Templates on Amazon Services – there are detailed descriptions for each field and their allowed values.
  • To export only a portion of Products, you can apply product filters by pressing the filter button in the product row.
  • If any of this information is unclear, or you need it to be different, ask our Support, it’s quite easy customizable.