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.

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

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

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

  • UPC
  • EAN
  • GTIN
  • GCID

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

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

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

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

mens
brand_name Product Vendor

Puma
manufacturer Product Vendor

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

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

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

TOP

Offer

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

Column Source Field in Shopify
standard_price 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.

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

199.99
sale_from_date Metafield “sale_from_date” in “amazon” namespace.

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

2018-02-28
quantity Product Variant inventory quantity.

546
merchant_shipping_group_name Metafield “merchant_shipping_group_name” in “amazon” namespace.

Dimensions

These attributes specify the size and weight of a product

Column Source Field in Shopify
website_shipping_weight Product Variant weight. Should be > 0.

75.00
website_shipping_weight_unit_of_measure Product Variant weight unit

oz

Discovery

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

Column Source Field in Shopify
bullet_point1 Metafield “bullet_point1” in “amazon” namespace.

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

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

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

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

Feature number 5

Images

These attributes provide links to images for a product

Column Source Field in Shopify
main_image_url Product image #1

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

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

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

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

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

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

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

https://cdn.shopify.com/1234/993/image8.png
other_image_url8 Product 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)

Column Source Field in Shopify
parent_child 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
parent_sku 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.

234872634873
relationship_type 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
variation_theme Will 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.

Column Source Field in Shopify
Created At Date and time, when the Product was created in your Shopify store.

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

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

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

Column Source 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 Name Sends data to field in Amazon export
product_description product_description

Metafield: amazon.product_description
feed_product_type feed_product_type

Metafield: amazon.feed_product_type
item-name item_name

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

Metafield: amazon.item_type
model model

Metafield: amazon.model
part_number part_number

Metafield: amazon.part_number
sale_from_date sale_from_date

Metafield: amazon.sale_from_date
sale_end_date sale_end_date

Metafield: amazon.sale_end_date
bullet_point1 bullet_point1

Metafield: amazon.bullet_point1
bullet_point2 bullet_point2

Metafield: amazon.bullet_point2
bullet_point3 bullet_point3

Metafield: amazon.bullet_point3
bullet_point4 bullet_point4

Metafield: amazon.bullet_point4
bullet_point5 bullet_point5

Metafield: amazon.bullet_point5
size_name size_name

Variant Metafield: amazon.size_name
size_map size_map

Variant Metafield: amazon.size_map
color_name color_name

Variant Metafield: amazon.color_name
color_map color_map

Variant Metafield: amazon.color_map
generic_keywords generic_keywords

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