Printable View
Hi,
I have mass populated my products_with_attributes_stock with all product variant qty's.
I have now realised ALL 4000+ lines need resyncing with the overall product qty.
I there a way for me to run an sql query to do this to ALL lines???
Also, I assume that this needs doing everytime I update my variant qtys.
Many Thanks
Phil
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..Quote:
Originally Posted by philip937
Only if you update the variant quantities via a direct upload..Quote:
Originally Posted by philip937
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???Quote:
Originally Posted by DivaVocals
Posted via Mobile Device
Don't know why I didn't think of that.. :laugh: 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..:smile:Quote:
Originally Posted by philip937
In the products_with_attributes_stock class you'll find this short functionIt first collects the summed total for a product's attribute variants and then applies it to the product table for that product.Code: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);
}
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.
Thanks kuroi, I shall take a look at this synatx and see if I can create one that repeats the same funtion on all products. So am I right in thinking:
it looks at the attributes qty table and all matching rows of a particular product id, adds up all the corrosponding values in the quantity column and the updates the product id qty with the result in the products table??
Posted via Mobile Device
Hi All
I am having an issue with my stock by attributes. When I select Catalog > Products with attributes stock, Most of the timne I get a message saying a script has stopped working? something to do with Ajax??
Also it says: Suchen: ??what does this mean?
has anyone else got this problem, and or know any other problems before I go live with this add on???
Regards,
Phil
Let me answer with a quote from Kuroi.. (who IMO has written the ONLY version of this add-on that is worth installing)
I've posted in this thread what my opinion is about the "others" (AKA the Ajax and the MultiAdd versions of SBA). I won't repeat it, but here's the link:Quote:
Originally Posted by kuroi
http://www.zen-cart.com/forum/showpo...&postcount=776
Quote:
Originally Posted by philip937
oh dear well I know Kuroi knows their stuff.Quote:
Originally Posted by DivaVocals
In this case, can someone please give me step by step as to how to roll back to 4.7...? I dont want to mess this up...
Yes he does..Quote:
Originally Posted by philip937
I'm afraid no one has written a step by step to remove one of the errant versions of SBA..
Best way to approach this is to open up the folder where you have the source files that you used for your install and one by one open each folder and remove those same files from your store..
That said, I cannot say for sure, but you may be able to simply install the Kuroi version over the Ajax version.. I haven't tried that personally to know if it works..