Saturday, December 21, 2024 3:40:56 PM
Amazon products export
Does the feed manager support products with product attributes? i.e export each product attribute combination as a separate product?
An example product is https://www.stitchtastic.com/store/jute-bag-medium
As you can see, this is the same item in 3 different colours. Each colour is in fact a separate product with its own SKU, GTIN and MPN. In order to import these into Amazon, I would need to import 3 separate products, i.e. 3 separate lines in the amazon feed.
Is this possible?
An example product is https://www.stitchtastic.com/store/jute-bag-medium
As you can see, this is the same item in 3 different colours. Each colour is in fact a separate product with its own SKU, GTIN and MPN. In order to import these into Amazon, I would need to import 3 separate products, i.e. 3 separate lines in the amazon feed.
Is this possible?
No, plugin doesn't support this feature from the box.
We added this feature for several customers for Google feed (customization).
Customers wanted to upload parent product as a Grouped product and all product combinations as a subproducts.
Write me the name of Amazon template. I'll see and answer.
We added this feature for several customers for Google feed (customization).
Customers wanted to upload parent product as a Grouped product and all product combinations as a subproducts.
Write me the name of Amazon template. I'll see and answer.
Thanks. It is the "Amazon - Home, Home Decor, Kitchen & Garden" template.
Just to clarify, it is not grouped products in nopCommerce, but Product Attributes of a single product. I am not sure it you meant this or variations in Amazon.
So it would be ideal for it to apear like this listing in Amazon - https://www.amazon.co.uk/dp/B00HQHBNFG But if it was seperate listings then that is OK also.
I know a variation in Amazon like above is created in the feed by a separate row for each listing and then another row to group them together.
Just to clarify, it is not grouped products in nopCommerce, but Product Attributes of a single product. I am not sure it you meant this or variations in Amazon.
So it would be ideal for it to apear like this listing in Amazon - https://www.amazon.co.uk/dp/B00HQHBNFG But if it was seperate listings then that is OK also.
I know a variation in Amazon like above is created in the feed by a separate row for each listing and then another row to group them together.
I understand you. I added for Google. Google support grouped product and product variations.
But i don't know how to do grouped product for Amazon.
I think we can add new products from product combinations without main product...
Can you read Amazon documentation and ask Amazon support?
But i don't know how to do grouped product for Amazon.
I think we can add new products from product combinations without main product...
Can you read Amazon documentation and ask Amazon support?
I have found a link here https://www.amazon.com/gp/help/customer/display.html/?nodeId=200779220 which has some good info on how variations work.
I have also downloaded the "Home and Decor" xls filesheet which is used to upload the data. If you look on the "Data Definitions" and "Valid Values" tabs then there is lots of info on how it works.
You can get it at https://s3.amazonaws.com/seller-templates/ff/na/us/Flat.File.Home.xlsm
I've found an old spreadsheet from 2014 I used to upload a variation before and I will email it over to you now.
I am happy to upload some sample files if you need to test anything.
I have also downloaded the "Home and Decor" xls filesheet which is used to upload the data. If you look on the "Data Definitions" and "Valid Values" tabs then there is lots of info on how it works.
You can get it at https://s3.amazonaws.com/seller-templates/ff/na/us/Flat.File.Home.xlsm
I've found an old spreadsheet from 2014 I used to upload a variation before and I will email it over to you now.
I am happy to upload some sample files if you need to test anything.
Thanks for such a quick turnaround. I have done some initial testing and have come up with the following. Note, I have not tried an upload yet but I will do that this afternoon.
In the child items there is no distinction for key fields. i.e the product name, description and image are all the same.
Product Name
Could you append the product attribute value to the product name (e.g. “Jute Bag – Large (pink)” where pink is the attribute value). Is there some way of creating composite fields? Then I could do this in the feed definition.
Picture
Currently the main product picture is used for all, can the link be to the picture specified in the product attributes value record.
Description
I don’t think there is anything to be done about the description field as this would have to be hand written. It would be nice to be able to edit the overridden feed values at the product attribute combination level as well as the product level but I can see this would be a lot of extra work.
The parent_child and relationship_type fields
I have always left these blank when a variation is not being created (i.e. simple products). From the spreadsheet docs on parent_child - “If the product does not participate in a variation relationship, use the value child.” At the moment, parent is the default.
I am not sure if the relationship_type field will be accepted as variation with no parent record, I will test this.
Bug
The quantity field is being populated from the main product (even though it is set to track by product attribute combination) so this value is invalid. Although I do not use it, the inventory export also has this issue.
One final suggestion, the default of the update_delete field is “Update” which is the default Amazon have. I find this highly dangerous and always thought it should default to “PartialUpdate”. I have wiped key data for a large section of my listings in the past because of this simple error (not with your plugin) and there is no way to get it back from Amazon.
In the child items there is no distinction for key fields. i.e the product name, description and image are all the same.
Product Name
Could you append the product attribute value to the product name (e.g. “Jute Bag – Large (pink)” where pink is the attribute value). Is there some way of creating composite fields? Then I could do this in the feed definition.
Picture
Currently the main product picture is used for all, can the link be to the picture specified in the product attributes value record.
Description
I don’t think there is anything to be done about the description field as this would have to be hand written. It would be nice to be able to edit the overridden feed values at the product attribute combination level as well as the product level but I can see this would be a lot of extra work.
The parent_child and relationship_type fields
I have always left these blank when a variation is not being created (i.e. simple products). From the spreadsheet docs on parent_child - “If the product does not participate in a variation relationship, use the value child.” At the moment, parent is the default.
I am not sure if the relationship_type field will be accepted as variation with no parent record, I will test this.
Bug
The quantity field is being populated from the main product (even though it is set to track by product attribute combination) so this value is invalid. Although I do not use it, the inventory export also has this issue.
One final suggestion, the default of the update_delete field is “Update” which is the default Amazon have. I find this highly dangerous and always thought it should default to “PartialUpdate”. I have wiped key data for a large section of my listings in the past because of this simple error (not with your plugin) and there is no way to get it back from Amazon.
Thank you suggestion.
>Product Name
I added product attribute value in product name.
>Picture
Virtual product from product combination has only one own picture (first product attribute picture).
>Description
I left original product description from parent product.
>The parent_child and relationship_type fields
You are right . I left empty this parameter for simple product.
>Bug. The quantity field is being populated from the main.
if product has value "ManageStockByAttributes" plugin exports product combination quantity.
>the default of the update_delete field is “Update”
I left old value. You can change this value yourself.
I added several new feature.
New item in menu - "Unxeported products". If you enabled "Don't upload new products". It will help you to manage new products.
I'll upload new release after one hour.
Try it.
We didn't change the release number.
>Product Name
I added product attribute value in product name.
>Picture
Virtual product from product combination has only one own picture (first product attribute picture).
>Description
I left original product description from parent product.
>The parent_child and relationship_type fields
You are right . I left empty this parameter for simple product.
>Bug. The quantity field is being populated from the main.
if product has value "ManageStockByAttributes" plugin exports product combination quantity.
>the default of the update_delete field is “Update”
I left old value. You can change this value yourself.
I added several new feature.
New item in menu - "Unxeported products". If you enabled "Don't upload new products". It will help you to manage new products.
I'll upload new release after one hour.
Try it.
We didn't change the release number.