Get Excelify now
Get Excelify now

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.

ColumnSource Field in Shopify
item_skuProduct Variant SKUFor the parent row the Product ID will be used here. See “Variation” section below for more details.

SKU-1234345
external_product_idProduct 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.

123456789012
external_product_id_typeDetermined automatically from the Product Variant Barcode format.Possible types:

  • UPC
  • EAN
  • GTIN
  • GCID

GTIN
item_nameFor 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.

T-shirt with the whole Earth - Green / XS
product_descriptionTaken 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.

This T-shirt shows the whole Earth on it.
feed_product_typeTaken 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.

Kitchen
department_nameTaken 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.

mens
brand_nameProduct Vendor

Puma
manufacturerProduct Vendor

Puma
part_numberTaken 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.

ABC-123
item_typeTaken 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.

volleyball-nets
update_deleteThis field is always exported empty.But you can set your own value here after doing export, before importing to Amazon.
modelTaken 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.

TOP

Offer

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

ColumnSource Field in Shopify
standard_priceIf 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.

249.99
sale_priceIf 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.

199.99
sale_from_dateMetafield “sale_from_date” in “amazon” namespace.

2018-01-09
sale_end_dateMetafield “sale_end_date” in “amazon” namespace.

2018-02-28
quantityProduct Variant inventory quantity.

546
merchant_shipping_group_nameMetafield “merchant_shipping_group_name” in “amazon” namespace.

Dimensions

These attributes specify the size and weight of a product

ColumnSource Field in Shopify
website_shipping_weightProduct Variant weight. Should be > 0.

75.00
website_shipping_weight_unit_of_measureProduct Variant weight unit

oz

Discovery

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

ColumnSource Field in Shopify
bullet_point1Metafield “bullet_point1” in “amazon” namespace.

Feature number 1
bullet_point2Metafield “bullet_point2” in “amazon” namespace.

Feature number 2
bullet_point3Metafield “bullet_point3” in “amazon” namespace.

Feature number 3
bullet_point4Metafield “bullet_point4” in “amazon” namespace.

Feature number 4
bullet_point5Metafield “bullet_point5” in “amazon” namespace.

Feature number 5

Images

These attributes provide links to images for a product

ColumnSource Field in Shopify
main_image_urlProduct image #1

https://cdn.shopify.com/1234/993/image1.png
other_image_url1Product image #2

https://cdn.shopify.com/1234/993/image2.png
other_image_url2Product image #3

https://cdn.shopify.com/1234/993/image3.png
other_image_url3Product image #4

https://cdn.shopify.com/1234/993/image4.png
other_image_url4Product image #5

https://cdn.shopify.com/1234/993/image5.png
other_image_url5Product image #6

https://cdn.shopify.com/1234/993/image6.png
other_image_url6Product image #7

https://cdn.shopify.com/1234/993/image7.png
other_image_url7Product image #8

https://cdn.shopify.com/1234/993/image8.png
other_image_url8Product image #9

https://cdn.shopify.com/1234/993/image9.png

Variation

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

ColumnSource Field in Shopify
parent_childIf 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
parent_skuFor 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.

234872634873
relationship_typeIf Product in Shopify has variants, then this field will be set to “Variation”.If product has no variants, then it will be empty.

variation
variation_themeWill be automatically detected and mapped from your Variant Options.Currently able to detect the following variation themes:

  • Size
  • Color

size

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.

ColumnSource Field in Shopify
Created AtDate and time, when the Product was created in your Shopify store.

2018-02-06 14:43:23
Updated AtDate and time, when the Product was last updated in your Shopify store.

2018-02-06 14:43:23
Published AtDate 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.

2018-02-06 14:43:23
Shopify
Variant Title
Full title of the Shopify Variant. Taken from Product Variant Title in Shopify.

XS / Red
Shopify
Option1 Name
Option1 Name for Variant

Size
Shopify
Option1 Value
Option1 Value for Variant

XS
Shopify
Option2 Name
Option2 Name for Variant

Color
Shopify
Option2 Value
Option2 Value for Variant

Red
Shopify
Option3 Name
Option3 Name for Variant

Material
Shopify
Option3 Value
Option3 Value for Variant

Wool

Variation Values

ColumnSource Field in Shopify
Size
size_name
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

S
Size Map
size_map
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.

S
Color
color_name
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

Sage
Color Map
color_map
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 color_name field.

Green
Search Terms
generic_keywords
Taken from “Variant Metafield: amazon.generic_keywords”.

strong, waterproof, washable
Product Tax Code
product_tax_code
Taken from “Variant Metafield: amazon.product_tax_code”

A_GEN_NOTAX

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 NameSends data to field in Amazon export
product_descriptionproduct_description

Metafield: amazon.product_description
feed_product_typefeed_product_type

Metafield: amazon.feed_product_type
item-nameitem_name

For parent row - Metafield: amazon.item_name 
For child row - Variant Metafield: amazon.item_name
item_typeitem_type

Metafield: amazon.item_type
modelmodel

Metafield: amazon.model
part_numberpart_number

Metafield: amazon.part_number
sale_from_datesale_from_date

Metafield: amazon.sale_from_date
sale_end_datesale_end_date

Metafield: amazon.sale_end_date
bullet_point1bullet_point1

Metafield: amazon.bullet_point1
bullet_point2bullet_point2

Metafield: amazon.bullet_point2
bullet_point3bullet_point3

Metafield: amazon.bullet_point3
bullet_point4bullet_point4

Metafield: amazon.bullet_point4
bullet_point5bullet_point5

Metafield: amazon.bullet_point5
size_namesize_name

Variant Metafield: amazon.size_name
size_mapsize_map

Variant Metafield: amazon.size_map
color_namecolor_name

Variant Metafield: amazon.color_name
color_mapcolor_map

Variant Metafield: amazon.color_map
generic_keywordsgeneric_keywords

Variant Metafield: amazon.generic_keywords
product_tax_codeproduct_tax_code

Variant Metafield: amazon.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.