Cant sort options stock levels properly

qrios's picture
Offline
Cool profile pic award.Getting busy with the Ubercode.Internationalizationizer
Joined: 08/13/2007
Juice: 554
Cant sort options stock levels properly

I tried to workaround this by joining tables.
There is no way to link the order of the options to the stock levels or vice versa. This is a pity at least.

The uc_product_options table contains the ordering column.
The uc_product_stock table contains the stock column.

I can join data on NID, but NID is not unique per option. The uc_product_options table identifier is OID, The uc_product_stock table identifier is SKU. There is no way to link them together afaik.
I think the OID should be saved in the uc_product_stock table.

Please help!

uc_stock_skus does not use option weights By: qrios (4 replies) Wed, 09/17/2008 - 14:54