Unknown SKUs in inventory feeds: how to handle them safely
ERP and supplier feeds often include SKUs that no longer exist in the store. Without handling they cause errors, stuck queues and incomplete processing.
ERP and supplier feeds often include SKUs that no longer exist in the store. Without handling they cause errors, stuck queues and incomplete processing.
An inventory feed regularly contained SKUs no longer in the catalogue. Handling them explicitly stopped errors and kept valid updates flowing.
What goes wrong
- Imports failing part-way through
- Queues retrying the same bad records
- Other valid updates never processed
- Logs flooded with noise
Handle them properly
Validate SKUs up front, skip unknown ones, continue processing and send a daily summary of unmatched SKUs to the team responsible.
Common mistakes to avoid
How we help with ecommerce
Frequently asked questions
Should unknown SKUs create products?
Rarely — product creation should be a deliberate process.
How often do feeds drift?
Constantly in active catalogues.
Can you build the report?
Yes, as part of integration support.