@zenweasel thats where im a bit confused... usually a variant has multiple attributes like size, color so if you have a shirt with 3 sizes in 5 colors u would have 1 product with 15 variants each with its own price, cost, sales price, inventory
I think what may be confusing is that there is an inventory record for every single item. And by that if you only had 10 Red Small t-shirts in stock and nothing else, you would have 10 inventory records
Yes, I’ve tested it with SKU sets in the 10’s of thousands. It doesn’t cause any issues on the customer side. Mostly because it’s never really directly exposed to customers. It can bog down the admin side.
We have a scheduled ticket to alleviate that: reactioncommerce/reaction#1370
makes sense, pretty common to keep the current inventory with the product, and just use your current table as a history of inventory items... although i'd guess most add a qty to your inventory model to allow for multiples to be added / sold
not sure that when u add 10 to an item that creating 10 records gets u much
I think we tried to make the inventory plugin as stand-alone as possible, thinking that many people will want to create their own and remove ours. Inventory is one of those things that changes a lot from business to business