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.

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.

Column Example Source 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: Product Title

For child rows: Product Title – Product Variant Title

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.

List of some possible values can be found here.

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_delete This 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

Column Example Source 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_name Metafield “merchant_shipping_group_name” in “amazon” namespace.

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

Column Example Source 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

Column Example Source 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

Column Example Source 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

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

Column Example Source 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.

Column Example Source 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

Column Example Source Field in Shopify
size
XS
Taken from Product Variant Option whose name is “Size”.
color Red Taken from Product Variant Option whose name is “Color”.

Metafields for Amazon

List of all Metafields that allow you to save in Shopify the data for Amazon export.

All those Metafields should be saved in namespace “amazon”.

Metafield Name Column in Excelify import/export template Sends 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_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

Good To Know

  • Dependng on the Product Category you need to import, specify TemplateType value in the A1 cell of the import File.
  • You don’t have to have all 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 fields, and their allowed values.
  • To export only a portion of Products, you can apply product filters by pressing the filter button in the products row.
  • If any of this information is unclear, or you need it to be different, ask our Support, it’s quite easy customisable.