this was very clear introduction into flat files, many thanks for the great work!
@orangeklik Жыл бұрын
You're very welcome!
@mattmovalson96845 ай бұрын
Great video, very detailed, thank you!!!!!!
@orangeklik5 ай бұрын
Glad it was helpful!
@UmairRaheem Жыл бұрын
Thanks Orange klik for this Amazing video
@orangeklik Жыл бұрын
Glad you enjoyed it! :)
@amloga510 Жыл бұрын
Can you use the category listing report as the flat file to do a partial update?
@MarkusPfister Жыл бұрын
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.
@noisearchitect6 ай бұрын
Yes, you can. That is what we all do.
@iJDMTOYLighting5 ай бұрын
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?
@MarkusPfister5 ай бұрын
yes, this will delete the data
@underatexalex Жыл бұрын
My flat file looks different from yours. Did they update it? If so can you make an updated guide. Thanks
@MarkusPfister Жыл бұрын
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.
@RikBendayon Жыл бұрын
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?
@MarkusPfister Жыл бұрын
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).
@marlonhosten4693 Жыл бұрын
Thank you so much for this. Who is the IDIOT who made this Flat File Upload part of Amazon ! It is ridiculous !
@orangeklik Жыл бұрын
We agree - it is totally confusing!
@marlonhosten4693 Жыл бұрын
@@orangeklik I had to hire someone from Fiverr just to upload it to my Seller central account.
@milos8206 Жыл бұрын
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.
@MarkusPfister Жыл бұрын
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.
@milos8206 Жыл бұрын
@@MarkusPfister No worries man, thanks for your reply. I might just try what you suggested there, I usually just go with the default option.
@AhmetKalkan-s4b Жыл бұрын
hello. if i change width or height of columns of flat file would it be a problem?
@MarkusPfister Жыл бұрын
No, as long as you do not change any of the values in the header area everything is fine.
@joharnonyamnyamstyle2920 Жыл бұрын
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
@MarkusPfister Жыл бұрын
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.
@joharnonyamnyamstyle2920 Жыл бұрын
@@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
@MarkusPfister Жыл бұрын
@@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.
@xyq19437 ай бұрын
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)
@MarkusPfister7 ай бұрын
you have to try to change it with the amazon support
@matiasrohr698510 ай бұрын
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?
@lukasriha6007 Жыл бұрын
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.
@lukasriha6007 Жыл бұрын
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
@Ali-vj6we Жыл бұрын
You didn’t show how you can be in more than one category