Stocks by attributes

[philip937]

I don't have a SQL script handy that does this, and I would need help myself to construct one (seems there would be a bit of complexity in this kind of update script that is beyond my basic SQL knowledge) but to answer your question generally, yes, you could construct some SQL to do this update..

Only if you update the variant quantities via a direct upload..

Does anyone know the query that gets sent to the database when clicking the sync qtys button? If I knew this I should imagine I could simply add this to the end of my update qty syntax???
Posted via Mobile Device

[DivaVocals]

Does anyone know the query that gets sent to the database when clicking the sync qtys button? If I knew this I should imagine I could simply add this to the end of my update qty syntax???
Posted via Mobile Device

Don't know why I didn't think of that.. I personally don't know the query off the top of my head, but if you dig through the files for this add-on, it should be easy to locate it yourself..

[kuroi]

In the products_with_attributes_stock class you'll find this short function

function update_parent_products_stock($products_id)
{
  global $db;
  $query = 'select sum(quantity) as quantity from '.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.' where products_id = "'.(int)$products_id.'"';
  $quantity = $db->Execute($query);
  $query = 'update '.TABLE_PRODUCTS.' set  products_quantity="'.$quantity->fields['quantity'].'" where products_id="'.(int)$products_id.'"';
  $db->Execute($query);
}

It first collects the summed total for a product's attribute variants and then applies it to the product table for that product.

To avoid the php and apply it to all products, you would probably want to create a database view or a temporary table based on the first query and then apply the resulting rows in that to all matching rows in the product table.