Jump to content
Dirty Butter

Store Sale - Number in Stock NOT change on Sale

Recommended Posts

We sold an item today I knew we only have one of. I always check the image and desciption in the store to be sure I get the right one out of stock. Lo and behold it was shown in the store as still available. This has never happened to me before.

As soon as I cleared Cache in Admin, the storefont data was correct.

Any idea how that happened?

Edited by Dirty Butter

Share this post


Link to post
Share on other sites

A couple questions to help eliminate the highly improbable:

1. Admin, Store Settings, Stock tab: "Reduce Stock Levels" when?
2. (Same tab): "Main stock level as matrix stock level summary" checked?

Share this post


Link to post
Share on other sites

When payment is made - been this way since the beginning

Main stock level as matrix stock level summary NOT checked - never has been

 

Edited by Dirty Butter

Share this post


Link to post
Share on other sites

You surprised this happened.

Therefore, I would think there is some unique property about the product, or a unique property about the customer, or the transaction had some unique event to it.

This 'uniqueness' caused CubeCart to do something odd.

Using an external database utility, such as phpMyAdmin, examine the table CubeCart_order_inventory looking for the subject item. Is there anything in the column 'options_identifier'?

In CubeCart's admin, view the Order details, History and Transaction Logs tabs. Anything out of the ordinary?

To be clear, you have "Show Stock Level" as enabled and you observed that the View Product page showed this item was in stock. In admin, Products, did you notice if the Product Details showed a stock level as well?

If the storefront indicated in-stock, but admin showed out-of-stock, then we can look for a SQL query for the storefront that erroneously used a cached query/result.

Share this post


Link to post
Share on other sites

The list of all Products DID show it as being in stock when it should have been zero. I'll check out the other areas you've asked about as soon as I can.

Share this post


Link to post
Share on other sites

Nothing in the options_identifier. I don't use Options - never have.

Order Details, Transaction log, and History all look normal

Store product details show in stock

Admin list of all products showed it in stock and in stock when I opened that product listing

EVERYTHING looked as it should in database, transaction, history, options_matrix. When I manually updated Cache from Admin - all behaved itself and corrected error.

I've never seen anything like this in all my years of using CC.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...