How to handle recurring supplier CSV and stock updates
Every supplier sends the file on their own schedule, in their own columns, with their own surprises. Here is how to stop bad rows from reaching your store.
The failure is almost never the import. The first import is clean. Then the supplier renames a column, drops a variation SKU, or changes a product code without telling you, and now you are matching on product name and quietly creating duplicates. The import plugins are fine. The discipline around them is what fails.
What breaks, in order of pain
- SKU drift. A product code changes and the old row reads as discontinued while a new duplicate appears. Nothing tells you they are the same product.
- Variation orphans. Suppliers rarely structure variations the way your store expects. Children lose parents, and listings go wrong in ways customers see.
- Silent price and stock moves. The file imports cleanly and the prices are simply different now. No error, no warning, margin gone.
- Missing products. Rows vanish. Was it discontinued, or did the export glitch? The file does not say.
A routine that holds
- Dry run first, live import second. Never import a supplier file straight into the live catalog. Stage it, review the rejects, then push.
- Diff against last week's file before importing. New rows, missing rows, price moves past a threshold. A large jump is usually a currency or tax change, not a real price move, and it is cheaper to spot in a diff than in your storefront.
- Read the rejected row report every time. The rejects are where the SKU drift and the orphans live. Skipping this step is how duplicates accumulate.
- Keep every file. Dated, untouched. When a customer disputes a price, the file from that week is the answer.
The earlier signal
The file is downstream. Upstream, the supplier's own catalog page, price list, or portal changed first. Watching that source tells you a new file is coming and what is in it before you download anything, which turns the weekly scramble into a planned update.
We watch supplier sources the same way: the catalog page or the file link, diffed, with old and new values in the alert. Start with the free source audit and bring your worst supplier file. Plans start around $25 per month.
Set up your first monitor free
Tell us the sources you check by hand. We wire them up, you get real alerts for one week, and you only pay if you keep it.