Looking for the v10 manual? Visit our new user's guide!
 
Search Descriptions Version
 
 
This article applies to: ML8, MultiStore

Monthly Maintenance


From the Configuration menu, click Maintenance → Monthly Maintenance

From this page, store admins can run periodic maintenance which is necessary for keeping the store running smoothly and quickly. For the first 5 tasks, store admins can choose whether to do that maintenance for all records, no records, or only records older than 30/60/90/120/150/180 days old. Multiple actions can be performed at once. This should be done during off-peak hours, as various parts of the database may be temporarily locked during maintenance, preventing customers from using the site normally.

NOTE: These tasks can take a while to complete. Once you click 'Go' to start the process, do not interact with the admin site until you see the completed message. All currently logged-in admin users will be logged out.

Option NameDescription
Clear all Shopping CartsThis will clear the contents of any saved customer shopping carts older than the age selected. If you have changed prices on your store or discontinued items, you may wish to do this to ensure that customers do not check out with products/prices they should not get because they added them before they change.
Clear all Wish ListsThis will clear the contents of any saved customer wish lists older than the age selected. If you have changed prices on your store or discontinued items, you may wish to do this to ensure that customers do not check out with products/prices they should not get because they added them before they change.
Clear all Gift RegistriesThis will clear the contents of any saved customer gift registries older than the age selected. If you have changed prices on your store or discontinued items, you may wish to do this to ensure that customers do not check out with products/prices they should not get because they added them before they change.
Erase Credit Cards/eCheck from Order RecordsThis option will remove the (encrypted) CC information from order records older than the date selected. This information is generally not required after the initial purchase is made, so storing it presents an unnecessary risk.
Erase SQL LogIf SQL logging is enabled ( ), this option will clear the contents of the SQLLog table, to prevent it from getting too large. These records are not necessary for the operation of the store, they just provide an audit record if necessary.
Clear Profiles Older Than (version 9 ONLY)This option clears the customer Profile which stores the cookie data and site settings for customers. Although it is generally safe to delete all Profile data, it is best to retain the last 30 days.
Clear Product Views Older ThanThis option clears the customer product views, which are saved for uses such as dynamic related products.
Invalidate All User LoginsIf this box is checked when you click Go, all admins and customers will be forced to log into the site on their next visit, even if they had set it to keep them logged in.
Purge Anon CustomersThis will clear the records of 'anonymous' customers - customers who performed an action on your site that caused a temporary record to be created for them (added to the cart, chose a locale, etc) but never registered or checked out. These records are not necessary and clearing them will not hurt the store.
Erase Credit Card/eCheck info from Address recordsIf your site is storing credit card numbers, customers who have allowed their information to be stored will have their CC info in their Address records, completely separate from any orders they've placed. This option will clear that information out of your database.
Purge all records that are marked as DeletedMany of the 'Delete' buttons in the store admin site do not actually permanently remove the selected object (products, customers, etc). Those things are just marked as 'deleted' in the database, and no longer appear in the admin site. This is so that they can be recovered in the future if necessary. If you wish to permanently remove those records, this option will do so.
Tune IndexesThis option performs basic maintenance on your database, which can increase site performance.
Save SettingsThis option saves your selections on this page, so that you can quickly perform the same tasks next time maintenance needs to be run.

NOTE: If your data is too large for Monthly Maintenance to be run from within the admin console (times out or throws error), you will need to run the stored procedure directly on the database (requires database access - check with your server host):
  1. Access the db using SQL Server Management Studio or other valid means
  2. Go to Programmability - Stored Procedures
  3. Right-click on aspdnsf_MonthlyMaintenance and choose 'Execute Stored Procedure'
  4. Use a value of 1 for YES, or 0 for NO for the tinyint items
  5. Use the number of days (such as 30) for the smallint items for the number of days back to retain
    - A value of -1 will "Clear All Regardless of Age", and a value of 0 will produce no change.
  6. Click OK and wait