You should be able to do that, but I would not recommend it. Better create a blank flat file and insert the values for the mandatory fields. Then do the changes you want to do and upload it as partial update.
In the Listing Loader template even if you choose the (completely delete from the System) option, will be the product backgrounds like sales history, ranking and etc. will be deleted as well?
Hi, no the sales history, rankings, reviews and so on will NOT be deleted, as they are linked to the ASIN. With the Listing Loader file you delete the SKU (not ASIN).
I have a question, if I have a field already with data, so if I use Update instead of the PartialUpdate, and leave that field blank, it will remove the existing data from that field, right?
Hi, Amazon is updating the flat file all the time. It is not possible to make an update for every change. The flat file still works the same. If you are unsure about some fields, please have a look in the data definitions of the file. If the file looks completely different, you might have the wrong file.
How are you able to have the dropdown in every cell? No matter if I use Sheets, Excel or Excel online, I can never get those and I have serious troubles with formatting.
Hi Milos, I am sorry, but I cannot help you with this issue. It may have something to do with your Excel version or the way you open the file. Sometimes there is a pop-up when opening the file with two options (I dont remember which options right now) - but maybe try out different approaches and it may help.
We encounter some issues when modifying the variation name, and used inventory loader to delete, waited 24 hours, then flat file to load. Still not working. Can you help or provide some advise? It's very very fraustrating (with Amazon support)
hello sir i want to add variation, my product has variations but the category doesn't offer any, how can i do? the excel they gave me, there is no variations column
If there are no variations allowed in your category then you cannot use variations. Amazon got very strict about this in the last 1-2 years. You can try a different category, but this could impact your visibility negatively.
@@MarkusPfister ok but if amazon sees, do I risk being banned, the product I want to sell has variations, I saw with my competitors in their listing, customers can choose the size
@@joharnonyamnyamstyle2920 I cannot guarantee you anything on that, but usually Amazon will change the category automatically if they think it is in the wrong category. I have not seen a ban or something like that happen. If your competitor listings are older, then they might have been able to create the variations when it was still possible. That could be an explanation.
Hello! For some reason the dropdown menus don't work in my flat file. I'm using Google Sheet and I've already changed all the possible settings. Could someone help me with this issue?
Hi guys, do you know which column to put the size in EUR when I want to sell shoes? I already tried to upload this file but it came back with "duplicate values" errors. Thanks a lot.
this was very clear introduction into flat files, many thanks for the great work!
You're very welcome!
Can you use the category listing report as the flat file to do a partial update?
You should be able to do that, but I would not recommend it. Better create a blank flat file and insert the values for the mandatory fields. Then do the changes you want to do and upload it as partial update.
Yes, you can. That is what we all do.
Great video, very detailed, thank you!!!!!!
Glad it was helpful!
In the Listing Loader template even if you choose the (completely delete from the System) option, will be the product backgrounds like sales history, ranking and etc. will be deleted as well?
Hi, no the sales history, rankings, reviews and so on will NOT be deleted, as they are linked to the ASIN. With the Listing Loader file you delete the SKU (not ASIN).
I have a question, if I have a field already with data, so if I use Update instead of the PartialUpdate, and leave that field blank, it will remove the existing data from that field, right?
yes, this will delete the data
Thanks Orange klik for this Amazing video
Glad you enjoyed it! :)
My flat file looks different from yours. Did they update it? If so can you make an updated guide. Thanks
Hi, Amazon is updating the flat file all the time. It is not possible to make an update for every change. The flat file still works the same. If you are unsure about some fields, please have a look in the data definitions of the file. If the file looks completely different, you might have the wrong file.
How are you able to have the dropdown in every cell? No matter if I use Sheets, Excel or Excel online, I can never get those and I have serious troubles with formatting.
Hi Milos, I am sorry, but I cannot help you with this issue. It may have something to do with your Excel version or the way you open the file. Sometimes there is a pop-up when opening the file with two options (I dont remember which options right now) - but maybe try out different approaches and it may help.
@@MarkusPfister No worries man, thanks for your reply. I might just try what you suggested there, I usually just go with the default option.
We encounter some issues when modifying the variation name, and used inventory loader to delete, waited 24 hours, then flat file to load. Still not working. Can you help or provide some advise? It's very very fraustrating (with Amazon support)
you have to try to change it with the amazon support
hello sir i want to add variation, my product has variations but the category doesn't offer any, how can i do? the excel they gave me, there is no variations column
If there are no variations allowed in your category then you cannot use variations. Amazon got very strict about this in the last 1-2 years. You can try a different category, but this could impact your visibility negatively.
@@MarkusPfister ok but if amazon sees, do I risk being banned, the product I want to sell has variations, I saw with my competitors in their listing, customers can choose the size
@@joharnonyamnyamstyle2920 I cannot guarantee you anything on that, but usually Amazon will change the category automatically if they think it is in the wrong category. I have not seen a ban or something like that happen.
If your competitor listings are older, then they might have been able to create the variations when it was still possible. That could be an explanation.
hello. if i change width or height of columns of flat file would it be a problem?
No, as long as you do not change any of the values in the header area everything is fine.
Hello! For some reason the dropdown menus don't work in my flat file. I'm using Google Sheet and I've already changed all the possible settings. Could someone help me with this issue?
Thank you so much for this. Who is the IDIOT who made this Flat File Upload part of Amazon ! It is ridiculous !
We agree - it is totally confusing!
@@orangeklik I had to hire someone from Fiverr just to upload it to my Seller central account.
Hi guys, do you know which column to put the size in EUR when I want to sell shoes? I already tried to upload this file but it came back with "duplicate values" errors. Thanks a lot.
To be clear, I found some of these products already online on Amazon, so in this case I'm just tying to link these items with already existing
You didn’t show how you can be in more than one category