Take a products attributes easily on/off for purchase - by sql/EP?

[terjekj]

Having a product with attributes (lets say a jersey, sizes S,M,L).

Once a size is sold out, I need to set it as 'show only'), so customers cannot buy/select it - only see it.

Easy Populate could work, but the columns in EP/fileformat does not make it easy to populate.

We're using an external ERP system(Navision) that keeps the orders and keep track of inventory. Once sold out, I'd like to create a file/sql that could be used to update regularly, ie. per day. I can create this output from ERP/Navision, but EasyPopulate is fairly complicated with all the columns ..

Any suggestions ?

[terjekj]

The are the rows i need to update :

SELECT p.products_model, products_name, a.products_id, a.attributes_display_only, v.products_options_values_name
FROM zen_products_attributes a, zen_products_description d, zen_products p, zen_products_options_values v
WHERE a.products_id = p.products_id
AND p.products_id = d.products_id
AND v.products_options_values_id = a.options_values_id


Gives me the solution;
Update zen_products_attributes set attributes_display_only='0'
where attributes_display_only='1'
and ... the correct select again here ...

I guess I need to run this manualy/once a day ..