article
Supplier import could rewrite another supplier's products
When a spreadsheet row didn't match a supplier's own catalog, my import searched every product and wrote case sizes to whatever it found, and the schema let two suppliers share a product. I deleted the wide lookups, put an ownership check and a preflight in front of the writes, moved one-supplier-per-product into the database, and left a few loose ends I'm still not happy about.
Read more