Keep these fields separate
- SKU
- A unique, stable internal product identifier that is never reassigned to a different item.
- Storage location
- The current room, rack, shelf, tote, or bin code; update this field when the item moves.
- Quantity
- The current available units tied to the product record, with marketplace handling reviewed separately.
- Cost and source
- Private acquisition cost, source, date, and preparation details used for internal reporting.
- Marketplace references
- Channel-specific listing or item identifiers connected to the same master product where supported.