Invalid Product on Inventory when Product is confirmed in CCRS #68
Description
Trying to import Inventory Item '01H0NBNPWAT6R254'
It fails with a rejection from CCRS: "Invalid Product"
The Product is "WAJ430957.TYKTMWF" with the name="flower lot"
This Product definition has been shipped to CCRS at least 10 times.
On INSERT the Product upload we get the error "Duplicate External Identifier"
This error is expected, it means the product definition does exist in CCRS.
On UPDATE no error is received; which indicates the UPDATE is successful.
This confirms to us that this product is in CCRS and does have the name we've requested: "flower lot"
When we upload inventory with this Product -- we get a failure: "Invalid Product"
The core issue is that CCRS does not link by Primary Identifiers
I'm 100% certain this issue is related to name based lookups.
Since at least 1976 it's been a known good idea to use Primary Identifiers on these mapptings.
For example, uploading a Section by ID and Name, then a Product by ID and Name.
Then when uploading Inventory rather than Name-based columns, one could use ID-based.
This ancient method removes very large classes of bugs -- which this issue very much looks like.