ORIGINAL REDDIT POST

Amazon Listing & Management Tool Help

Hello Everyone, we manage around 60,000 listings on Amazon and we’re constantly uploading Flat Files into Amazon. This is annoying and is prone to errors. We need a Tool that can automatically connect to Vendors FTP and update stock and pricing based on that.…

Original postr/FulfillmentByAmazon

Hello Everyone, we manage around 60,000 listings on Amazon and we’re constantly uploading Flat Files into Amazon. This is annoying and is prone to errors. We need a Tool that can automatically connect to Vendors FTP and update stock and pricing based on that. Can anyone recommend something that isn’t $500 a month? Haha Let me know best to do this guys. Happy selling

Collected discussion

14 comments

u/AutoModerator

Moderator Announcement Read More » Join the r/FulfillmentByAmazon Discord Server! We created a Discord server for our community and would like to invite all of you to join! You'll be able to discuss FBA with users around the world and discuss events in real time! There are separate channels for many FBA topics which you can opt in and out of, including; PPC, Listing Optimization, Logistics, Jobs, Advanced FBA, Top Secret/Insider Info, Off-Topic I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

u/Emotional-Pea-1899

This is what I was thinking lol.

u/Disastrous_Sundae484

At 60k listings, $500 a month is a steal.

u/knowoneknows

I would advise against blindly uploading data from the vendor into Amazon. Preferably, I would advise setting up a data lake or data warehouse to ingest data. You can create a developer account for the seller / vendor account. You can create scripts / cron jobs to build out pushes directly (through API) into your Vendor & Seller Central.

u/Wave-in-Kanagawa

hopted for amazon sellers and vendors has bulk listing editing from spreadsheets (they call it writebacks) that allow you to send up to 100k listing updates. google for 'hopted writebacks'. and it costs around 60-70 usd. thye pull data in g sheets, u can choose some columns as editable. after editing you can review before submitting so kind of a governance of changes is there looks smth like this

u/LostMyMilk

Just stock levels and pricing? Build it with AI in an afternoon.

u/m-fasciano

If you're managing 60,000 SKUs I'd skip the off-the-shelf tools and just build it. Connect directly to your suppliers' FTP servers, pull the stock and price files on a schedule, map them to your Amazon SKUs, then push updates through the SP-API. Once it's running it's fully automated, you're just paying for hosting instead of another $500/month. I've built a few of these integrations and the hardest part is always cleaning up supplier data, not the automation itself. Inconsistent column names, missing UPCs, pricing in different currencies, that's where the time goes, not the FTP connection. Out of curiosity, how many vendors are you syncing with?

u/TexGiant

If you want to outsource this part, we can talk.

u/yyyogev

At 60k listings the flat file grind is worth wiring up once. What you're after is a small middle layer that watches each vendor's FTP, maps their columns to your SKUs and pushes stock and price on a schedule, with a log so bad rows get caught before Amazon does. Some tools do pieces of it but the vendor mapping is usually where the off the shelf ones break, so a light custom connector tends to fit better. Can walk through how I'd handle the FTP side if that's useful.

u/eStoreFactoryUS

At 60k listings the real risk isn't the FTP connection, it's ungoverned data flowing straight into Amazon and triggering suppressions or pricing errors at scale. A couple of people already nailed the technical path (SP-API plus scheduled jobs pulling the supplier files), and that's the right direction over a generic $500/mo tool. The thing I'd add from doing this on larger catalogs: put a validation and staging layer between the vendor feed and your actual submit step. Before anything posts, check for missing UPCs, currency and unit mismatches, min/max price guardrails, and MAP violations. That one layer catches the errors that otherwise go live across thousands of SKUs before you notice. Also batch your feeds by SKU groups instead of one giant push, so a single bad file doesn't take down thousands of listings at once. And log every submission report so you can catch partial failures, because Amazon will happily accept 9,800 of 10,000 rows and stay quiet about the 200 that failed. Honestly the supplier data cleanup is where 90% of the pain lives, not the automation itself. Inconsistent column names, missing identifiers, prices in different formats, that's the time sink. If building in house isn't realistic in the near term, a middleware tool is a fine bridge, but the guardrails matter way more than the price tag. We manage catalog and feed operations at this kind of scale for clients, so happy to share the validation checklist we use if it helps. Out of curiosity, how many vendor feeds are you syncing?

u/Emotional-Pea-1899

at 60k listings $500/mo is a steal for sure. But you could build out your own system, the way you want it, for pretty inexpensive. But storage costs are going to be pretty significant for the amount of data. Get the Vendor Central API access and I can help.

u/medieval_items

hey dude can you teach me how to use flat file on amazon