Problem with products not switching off when out of stock..

[philip937]

Hi Everyone

Im hoping you can help. For some strange reason whether my

Configuration/Stock/Products status in Catalog when out of stock should be set to

is set to 0 or 1, neither is turning my products off when out of stock???

Is this a known issue, it is only recently I am trying to use this feature and do not know if it has occurred since installing other mods or customizing my zen??

is there any specific code I can check??

Any Help or Direction would be very much appreciated..

Regards
Phil

[clydejones]

Hi Everyone

Im hoping you can help. For some strange reason whether my

Configuration/Stock/Products status in Catalog when out of stock should be set to

is set to 0 or 1, neither is turning my products off when out of stock???

Is this a known issue, it is only recently I am trying to use this feature and do not know if it has occurred since installing other mods or customizing my zen??

is there any specific code I can check??

Any Help or Direction would be very much appreciated..

Regards
Phil

This fix might help

[philip937]

This fix might help

I might need more guidance on this. My standard product listings are showing out of stock products even when change status to 0 is selected. I'm not sure how to use the suggested fix for the New and upcoming products to fix my problem.

Thanks
Phil

[philip937]

I might need more guidance on this. My standard product listings are showing out of stock products even when change status to 0 is selected. I'm not sure how to use the suggested fix for the New and upcoming products to fix my problem.

Thanks
Phil

I looked in /includes/modules/products_listing.php and there doesn't seem to be any similar code to the suggested support thread? im lost, no idea where to begin looking.

[DrByte]

Your problem could be related to many things, including:
a) manually injecting product and attribute records instead of using the built-in UI designed for that purpose: http://www.zen-cart.com/forum/showthread.php?t=138644
b) using an addon that replaces the normal stock-handling logic http://www.zen-cart.com/forum/showth...881#post790881

[philip937]

Your problem could be related to many things, including:
a) manually injecting product and attribute records instead of using the built-in UI designed for that purpose: http://www.zen-cart.com/forum/showthread.php?t=138644
b) using an addon that replaces the normal stock-handling logic http://www.zen-cart.com/forum/showth...881#post790881

Assuming it's one of these 2, I'm going to for now assume it's not b as no one else using stock by attributes seems to have this problem. So if it's a, please help me understand the normal logic, if I manually inject stock levels, which yes I am, I would have thought this to be no different than setting a stock level to 0 through the admin UI? Ontop of which surely all the change status of product when stock is zero, just checks the value of the product_id's stock?

When I set an out of stock image to be placed next to a product listing when out of stock, this works fine, so zen must be recognising these levels regardless of manually setting stock levels no?

If you can explain to me the zen functions when calculating whether or not a products status should be on or not perhaps I can either check mines not corrupt or maybe adapt for the way I'm using zen?

Many Thanks
Phil
Posted via Mobile Device

[DrByte]

I'm not convinced that it's not your addon.

But if you've not set the out-of-stock product-status to 0 then it's not going to work either.

You can see that the code in a clean install of Zen Cart properly sets the product status to 0 by looking for this in the order.php class file:

 if (SHOW_PRODUCTS_SOLD_OUT == '0') {

[philip937]

I have set the out of stock status to 0, and it didn't work that's the point I figured there was something up.

I haven't however looked in order.php class file, so I shall check that this code is there I guess? So that is the code that the setting in configuration/stock looks at right?

Phil
Posted via Mobile Device

[philip937]

I'm not convinced that it's not your addon.

But if you've not set the out-of-stock product-status to 0 then it's not going to work either.

You can see that the code in a clean install of Zen Cart properly sets the product status to 0 by looking for this in the order.php class file:

 if (SHOW_PRODUCTS_SOLD_OUT == '0') {

I am just looking at the code you said about, I have the follwoing:

        if ($stock_left <= 0) {
            // only set status to off when not displaying sold out
            if (SHOW_PRODUCTS_SOLD_OUT == '0') {
              $db->Execute("update " . TABLE_PRODUCTS . " set products_status = 0 where products_id = '" . zen_get_prid($this->products[$i]['id']) . "'"); 

So does this database queery only take place when a product is checked out and stock then reaches 0? If so the option works differently to how i imagined, I thought that if you set the option to turn product status to 0 if out of stock it would just not show any products with stock less that 0 in the prduct listings???

Is there a way to do what I need it to do? so effectively hide all product_id's where their stock level is less than 0???

I really really dont want out of stock products showing

[DrByte]

The simplest way to do that is to go and set the products_status to 0 for all your products whose stock is less than 1.

Or, you can go through every query in the core code and adjust it to suit your own needs.