Dirty Butter Posted February 3, 2019 Share Posted February 3, 2019 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? Link to comment Share on other sites More sharing options...
bsmither Posted February 3, 2019 Share Posted February 3, 2019 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? Link to comment Share on other sites More sharing options...
Dirty Butter Posted February 3, 2019 Author Share Posted February 3, 2019 When payment is made - been this way since the beginning Main stock level as matrix stock level summary NOT checked - never has been Link to comment Share on other sites More sharing options...
bsmither Posted February 3, 2019 Share Posted February 3, 2019 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. Link to comment Share on other sites More sharing options...
Dirty Butter Posted February 4, 2019 Author Share Posted February 4, 2019 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. Link to comment Share on other sites More sharing options...
Dirty Butter Posted February 4, 2019 Author Share Posted February 4, 2019 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.