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:
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 VendorPuma |
| manufacturer | Product VendorPuma |
| 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 unitoz |
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 #1https://cdn.shopify.com/1234/993/image1.png |
| other_image_url1 | Product image #2https://cdn.shopify.com/1234/993/image2.png |
| other_image_url2 | Product image #3https://cdn.shopify.com/1234/993/image3.png |
| other_image_url3 | Product image #4https://cdn.shopify.com/1234/993/image4.png |
| other_image_url4 | Product image #5https://cdn.shopify.com/1234/993/image5.png |
| other_image_url5 | Product image #6https://cdn.shopify.com/1234/993/image6.png |
| other_image_url6 | Product image #7https://cdn.shopify.com/1234/993/image7.png |
| other_image_url7 | Product image #8https://cdn.shopify.com/1234/993/image8.png |
| other_image_url8 | Product image #9https://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 |
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 VariantSize |
| Shopify Option1 Value | Option1 Value for VariantXS |
| Shopify Option2 Name | Option2 Name for VariantColor |
| Shopify Option2 Value | Option2 Value for VariantRed |
| Shopify Option3 Name | Option3 Name for VariantMaterial |
| Shopify Option3 Value | Option3 Value for VariantWool |
Variation Values
| Column | Source Field in Shopify |
|---|---|
| Size size_name | Can be taken from multiple fields with priority in this order:
S |
| Size Map size_map | Can be taken from multiple fields with priority in this order:
S |
| Color color_name | Can be taken from multiple fields with priority in this order:
Sage |
| Color Map color_map | Can be taken from multiple fields with priority in this order:
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_descriptionMetafield: amazon.product_description |
| feed_product_type | feed_product_typeMetafield: amazon.feed_product_type |
| item-name | item_nameFor parent row - Metafield: amazon.item_name For child row - Variant Metafield: amazon.item_name |
| item_type | item_typeMetafield: amazon.item_type |
| model | modelMetafield: amazon.model |
| part_number | part_numberMetafield: amazon.part_number |
| sale_from_date | sale_from_dateMetafield: amazon.sale_from_date |
| sale_end_date | sale_end_dateMetafield: amazon.sale_end_date |
| bullet_point1 | bullet_point1Metafield: amazon.bullet_point1 |
| bullet_point2 | bullet_point2Metafield: amazon.bullet_point2 |
| bullet_point3 | bullet_point3Metafield: amazon.bullet_point3 |
| bullet_point4 | bullet_point4Metafield: amazon.bullet_point4 |
| bullet_point5 | bullet_point5Metafield: amazon.bullet_point5 |
| size_name | size_nameVariant Metafield: amazon.size_name |
| size_map | size_mapVariant Metafield: amazon.size_map |
| color_name | color_nameVariant Metafield: amazon.color_name |
| color_map | color_mapVariant Metafield: amazon.color_map |
| generic_keywords | generic_keywordsVariant Metafield: amazon.generic_keywords |
| product_tax_code | product_tax_codeVariant 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.
