where is the code that subtracts the stock when an order is placed?

[ink]

Hi

Can any of you Zen gurus tell me where the query is that subtracts the stock from the products_quantity field when an order is placed?

I have looked and looked in this forum but to no avail - please help!

Thanks

[Kim]

What are you wanting to do?

[ink]

Hi

I think it is in the orders class - around line 657, however the stock is not deducting when an order is placed - I am using 1.3.7.

Do you have any clues as to where I could look, with regards as to where else could be not functioning properly?

I ask this as it is probably a mod which I installed at some point but didnt notice this problem until now!

[Kim]

What are your settings in Admin> Configuration> Stock?

[ink]

Hi

Thanks for your reply. I looked there earlier as I found some reference to those configuration setfings in other threads.

However I searched my config table and dont seem to have the configuration values installed under I think it is cong group id 12 - I have Sage stock installed but am not using Sage, do you think that when I installed that it effectively paused the Zen stock control?

I which case do you know what SQL off hand, I should run to repair that process?

[ink]

Hi

In the unlikely event that anybody else runs into this same problem, with a bit of (tired) thinking this is how I just solved the problem:


1) If not present for some bizarre reason add:

9 Stock Stock configuration options 9 1

into table configuration_group

2) Again if not present add:

233 Subtract stock STOCK_LIMITED true Subtract product in stock by product orders 9 2 0000-00-00 00:00:00 2008-01-11 17:35:15 zen_cfg_select_option(array('true', 'false'),

into table configuration

3) Stock take :)