Stock Increasing when a sale is made

[Jamie]

Will it be worth upgrading to 3.2?

Upgrading should be your first step in troubleshooting. Whether it will fix your problem is impossible to tell as I don't know what is causing it and can't determine that without access to your site via a helpdesk ticket.

We have noticed that when the last item is purchased instead of setting stock lever for that item to 0 it adds several items.

If you can provide step by step instructions in a helpdesk ticket that will reproduce that problem we can look into it.

Please advise best course of action

1. Document steps to reproduce the problem. Reproduce the problem to confirm it exists.

2. Make sure your TEMP_Sessions table is present, named EXACTLY TEMP_Sessions, and is not crashed by running the following 2 queries (one at a time) in our query tool:

Query #1:

SHOW TABLES; # to check the name and presence of the table

Query #2:

CHECK TABLE TEMP_Sessions;

3. If you find a problem, stop and report it.

4. Upgrade.

5. Try to reproduce the problem. If it happens again, open a helpdesk ticket and include steps to reproduce the problem.


I've seen zero confirmed reports of this happening in updated versions of Squirrelcart without messed up databases. If you are having this problem, its highly likely that you have a database issue.

[zapenterprises]

Hi Jamie

Thanks for your reply.

I have followed your steps 1,2,3
1. I was not able to make the problem happen, found a product that had wrong high stock levels in the Option Choices, not the warehouse and fixed the levels, then made several purchases via paypal with credit card and paypal account. All worked fine.

I did make the following observations
1a. Added item to Cart in Browser1 which has taken from Stock. Opened item in seperate browser2, adjusted stock levels to true value, them emptied cart in Browser1. Result is Option Size was kept same stock so level correct, Warehouse added an extra item so warehouse incorrect.
Continued with incorrect level and made a purchase , all worked fine, both levels decreased by 1.

1b. Stock levels corrected. Added item to cart in browser1. Browser2 stock levels so true stock value less item in cart of browser1. Needed to add more stock while cart live, added 1 item to Browser2 levels in options and warehouse. Then emptied cart in browser1. Result only warehouse was re-stocked, option choices was not restocked.

1c. Same as 1b but ran query DELETE FROM TEMP_Sessions; and got same result of 1b.

How does one add extra stock to the cart when many people are using the site without causing these issues?
********************************************

4. Not being able to see where the problem is and where these extra option choices stock figures are coming from I will now run the upgrade of the cart and go through the entire cart and re-set all the stock levels.

Is there a way to set all stock levels to 0 after the upgrade so we can start fresh, hopefully fixing the issue?

Once all this is done we can only monitor and hope the issue is fixed, if not get your to look at it more closely.

thank you for all your assistance so far.

[Jamie]

How does one add extra stock to the cart when many people are using the site without causing these issues?

If your site is that busy, the only way to accomplish that would be to take the store offline when updating stock or note the times when you are doing so and then adjust again if any orders came in during that time for items you altered.

4. Not being able to see where the problem is and where these extra option choices stock figures are coming from I will now run the upgrade of the cart and go through the entire cart and re-set all the stock levels.

Is there a way to set all stock levels to 0 after the upgrade so we can start fresh, hopefully fixing the issue?

You can do that by backing up your database and then running the following queries:
DELETE FROM REL_Products__Warehouse;
UPDATE Choices_Custom SET Stock = 0;