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 Menu> 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.
  • Menu> Utilities > Review 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

This website uses cookies to identify visitors, track visitors to our website, store login session information and to remember your user preferences. By continuing to use this site you agree to our use of cookies. Learn More.

This website uses cookies. By continuing to use this site you agree to our use of cookies. Learn More.


Copyright © 1997 – 2019 Miva©, Miva Merchant©, MivaPay©, MivaCon© Miva, Inc. All Rights Reserved.