Currently running PHP version 7.8.7 which was installed approx 12th July 2025.

Over the weekend we've noticed that an issue has occurred with the Stock Levels/Stock Management for product codes where the stock level is "Set By Product Options".

For any product code where the stock quantity was Nil/Zero and "Set By Product Options" the stock quantity now shows a random but extremely large stock quantity number e.g. 1626224185 and amongst other things this potentially means that out of stock products or obsolete product lines now appear as available to order from the website.

I noticed that with updater 7.8.5 there was mention of "There is a very important fix for stock management calculations for products which have stock set by options" and wonder if this is related to that fix in some way?

We can go in to each of the affect product codes and remove the stock level "Set By Product Options" setting and then change the stock level to zero (which will involve a bit of work to get things back to normal) but thought I would flag the issue up in case this is some sort of bot exploit going on or if we need to be delving deeper into the root cause?

Thanks in advance for any suggestions.

Neil

Also noticed that when changing any stock levels from the Product Admin>Administration page now getting the following warning flashed up on screen:

Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1

Update Successful !

You will now be forwarded to the admin home page.

If that does not happen automatically then please click here.

Hi Neil
I've tried it here and it seems fine with stock levels by product options so can you try getting the latest v7.8 updater and apply that fully just to make sure that all the scripts are good. Then if you still get the problem can you send the site FTP login to my email (vince AT ecommercetemplates DOT com) and I'll see what is up.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Hi Vince,

Many thanks for your reply

Have reapplied the latest update to the site as suggested.

Before reapplying the updater did a quick comparison using BeyondCompare for any changes/differences between the updater files applied to the site on 12 July and the various files in the latest updater downloaded today 5 August and the only files with minor code changes were:
\js\ectcart.js
\vsadmin\inc\uspsshipping.php

The code changes in the \js\ectcart.js have resolved an issue with the product options not showing on customer orders when they used the quickbuy button as highlighted in this separate topic https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=116327

But still getting the warning below when altering stock quantities.

There are still some product codes with the extremely large stock quantity numbers which appeared out of nowhere as mentioned in the original post e.g. 1626224185. Will these large values be the cause of the warning message (in which case I'll get the errant values all changed) or do you want the FTP login details at this stage for a looksee before I do anything else?

Neil

Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1Out of range value for column 'pInStock' at row 1