I have a database where the columns in one of the tables are:
UPC, SKU, AliasOf, Quantity
123456789123, 123456789123a, null, 6
123456789123, 123456789123b, 123456789123a, 0
123456789123, 123456789123c, 123456789123a, 0
123456789123, 123456789123d, 123456789123a, 0
First question ever, thanks in advance :)
How can I set up the table, where when the quantity "6" is inserted on the top sku, that the quantity is updated on the 3 aliased skus ...
really, I want to make them all a group, and for any inventory change on any of the group to change the inventory for the entire group.
I have no idea what to do :)