meccabooks Posted July 25, 2013 Share Posted July 25, 2013 I am using Advance stock Management in my newly re-launched website.. what I have noticed is that lets say I have 100 qty's of a item, a customer comes and adds 10 to the cart, it reduces the qty to 90, and if the customer never places the order, the available qty of the item stays at 90 because 10 of them are sitting in someone cart. How do I get over this problem, as these abandoned carts can really cause me reduced sales as customer who really want the items will not be able to add them in the cart. Please let me know the best solution possible. Link to comment Share on other sites More sharing options...
swsindonesia Posted July 25, 2013 Share Posted July 25, 2013 Hi there, In that case you can delete the abandoned carts using the administration menu : Customers -> Shopping Cart click on the "trash bin" icon in the right side. please note this feature may not be available in the older version of PS A better and elegant way of doing this is by setting up a scheduled job to delete shopping carts that have been abandoned for let say 48 hours of more. Link to comment Share on other sites More sharing options...
meccabooks Posted July 25, 2013 Author Share Posted July 25, 2013 Hi there, In that case you can delete the abandoned carts using the administration menu : Customers -> Shopping Cart click on the "trash bin" icon in the right side. please note this feature may not be available in the older version of PS A better and elegant way of doing this is by setting up a scheduled job to delete shopping carts that have been abandoned for let say 48 hours of more. Yes in 1.4 I could select all carts and select delete, same is not the case with 1.5 I have to delete one by one. Also, can you please tell me how to setup a cron job? Link to comment Share on other sites More sharing options...
swsindonesia Posted July 25, 2013 Share Posted July 25, 2013 Another way is to delete the record directly in your database from these tables: ps_cart, ps_cart_product, ps_cart_cart_rule by using ps_cart.id_cart as your keys, and where ps_cart.date_upd <= NOW-48 hours as your reference date AND id_cart is not exists in ps_orders.id_cart as your deletion criteria. You can set this in a simple php script (executed using wget / curl / php), or database script (executed from terminal) if you're using a hosting service, login to your hosting control panel, they should have a menu there to setup a cron job. Link to comment Share on other sites More sharing options...
w3bsolutions Posted December 18, 2013 Share Posted December 18, 2013 Isn't there a better solution for this? I don't understand why it is not programmed so that the stock amount only decreases when the order is confirmed. It doesn't make sense that the stock would reduce when a visitor just adds the product to the cart. Link to comment Share on other sites More sharing options...
GeroDolja Posted March 12, 2015 Share Posted March 12, 2015 I'm having the same problem, any "back-office option" like solution? Link to comment Share on other sites More sharing options...
Recommended Posts