Loaded Commerce Community

When I run my stock sync php script it updates all my subproducts quantity values in align with the stock levels of my supplier.

However the total quantity at the top doesn't update, it simply stays at 0, unless I go into the editor and click update, without changing anything and then the total quantity shows the sum of the sub product quantities, as it should. I have hundreds of products and this would take far too long as I run my stock sync script daily. Is there any commands or scripts to update or run so I could update them all at once?

Any help would be greatly appreciated.
expbiz

What is the 'stock sync script'? Part of Cre? A lot of people just use an EPA Import just fine to update all their stock, prices, descriptions etc.

Simon

No it's not part of CRE it's just a php script I had wrote for me to update the product quantities. I have no knowledge of PHP therefore I can't edit it to do what you say and input the total quantity as well... Therefore I thought it would be easier to just update all the products after it has been ran, if I could find out how to!... what is EPA?

Right, so maybe contact the person that wrote the script?
EPA (Easy Populate Advanced) - have a read in the Cre docs here:
http://www.creloaded.com/Support/FAQ-Do ... pages.html

Simon

But can EPA sync your quantity values in your database with a remote database on another server? That's what I need...

So when you say 'update all products at once' you don't just mean on your server. So is the other server providing the qty updates? They provide the data, you update ... or are you running 2+ stores, 1 warehouse and trying to keep all stores in sync?

Sheesh, and I thought it was just a simple 'add all the subs together to get the parent product total qty' ...

Simon

The script grabs the values from a suppliers database and matches the UID or SKU of each size to the quantity accordingly.

It works and updates each of the sub products (each size of the product available) quantity, but each time it's ran the parent product quantity is set to 0, even say if each of the 5 subproducts has a quantity of 5, it would still read 0 not 25...

The only time the parent quantity updates to read the sum of the subproducts qtys, is when I go to edit (in admin>products/categories) and then save again (click update) this seems to trigger a script that totals the subproducts and lists this in the parent products quantity... obviously this would take too long to do on EACH prod.

The parent qty is the one CRE uses to list in order of qty, so each time I run my sync script (daily) it sets ALL parent prods to qty=0 so therefore the 'list in order of quantity' is useless. I hoping I could find the script that seems to be triggered when I edit and update each product and run it so it updates all products at once... So yes it is how you thought

Yeah I got the issue back at the OP ... so as mentioned ... get the script modified to add all the subs together and update the parent id as well with this total. This must be a 5 minute job for whoever wrote the script.

Not sure if anyone on here would have a script like yours - it sounds custom. Custom script = custom fix. Talk to your supplier - maybe they can help.

Simon