24/7 Support: 800.608.6482

Get Started

Reference Guide

Database Tools

Delete Shopping Baskets

Just like in a brick–and–mortar store, items that are in shopping baskets are removed from your inventory. It's fairly common, however, for customers to add products to their baskets but never complete the purchase. For example: a customer visits your store, adds products to their basket, then changes their minds and closes their browser. The products in that basket can't be purchased by anyone else. If enough products accumulate in abandoned baskets it can appear that your store has run out of those items.

You can prevent this from happening by:

  • Setting the > Store Settings > Edit Store > Store Details tab > Settings section > Basket Timeout (Minutes) field.
  • The Basket Timeout sets an "idle time". When a customer hasn't purchased or changed the contents of their basket for that time, the basket is automatically expired. The items in their basket are still removed from your inventory, but an expired basket can't be used by a customer and is ready to be deleted.

  • Deleting the shopping baskets. When you delete expired shopping baskets, the items in those baskets go back to your inventory and are available to be purchased by other customers.

But see also Menu> Utilities > Add/Remove Modules tab > Available Modules section > Basket Inventory. Miva Merchant can report how many items are currently in baskets.

To Delete Expired Shopping Baskets

  1. Go to Menu> Data Management > Database Tools Tab.
  2. Click Delete Shopping Baskets.
  3. In the Delete Shopping Baskets screen, select:
    • Perform Module Cleanup Tasks: Some third party modules install and use their own tables in your store's database. If a third party module has been configured with some kind of table cleanup code, and you check this box and click the Delete button, it will cause the table cleanup code in that module to run.
    • Expired Shopping Baskets Only or All Shopping Baskets. In general you should only delete expired shopping baskets. An exception might be when you are certain the baskets aren't being used. For example, if your store is off-line, you might want to delete all baskets.
  4. Click the Delete button.

Pack Data Files

Clicking this button automatically starts a script which optimizes the database tables and improves performance. In general it should be done once a week, but if you have a very active store, you may want to click on this link more often. If you encounter any kind of server or database error while packing data files, please contact support.

Looking for Developer Docs?

We have a whole section for that, including: Developer Training Series, Template Language docs, Module Development tutorials and much, much more.

Head to the Developer Section

Miva believes that all online businesses should have access to a scalable ecommerce platform that can meet their unique business requirements. Miva offers PCI compliant ecommerce, hosting, and custom website design and development solutions. Miva customers have processed over $100 billion in online sales since 1997.

Copyright © 2016 Miva, Inc - All Rights Reserved   Privacy Policy | Store Policy

Links
Contact Us
Receive Tips & Updates

Copyright © 2016 Miva, Inc - All Rights Reserved

Back To The Top