OK to purge _hikashop_cart table?

  • Posts: 195
  • Thank you received: 5
  • Hikashop Business
11 years 6 months ago #110767

We're in the process of implementing an 'abandoned cart' strategy (with AcyMailing).
We've got everything working, but noticed that our _hikashop_cart table has HUNDREDS of entries.
Many of these (after looking at the related session information) are for carts that were abandoned well over a month ago, which we don't have an need to save.

I'm wondering if there is a 'proper way' to clear this table - other than just deleting all the records in phpMyAdmin?

We've cleared sessions within Joomla and these still seem to remain.

We just want to start with a clean cart table and don't have any need of this data (unless HS needs it for some reason).

Will this cause errors to display for any of these users if they return to the site later (or will their cart just appear empty if we delete it)?

Please Log in or Create an account to join the conversation.

  • Posts: 83041
  • Thank you received: 13405
  • MODERATOR
11 years 6 months ago #110768

You can delete the data in that table. I also invite you to delete the data in the hikashop_cart_product table in the process.

HikaShop also has a "cart retaining period" option that you can configure to remove old carts. The carts are stored in the database for the period that you want so that you can run campaigns on them, or statistics, etc.

Finally, via the Customers>Carts menu, you can delete the carts as well, but it's the same than via phpmyadmin.

Please Log in or Create an account to join the conversation.

Time to create page: 0.052 seconds
Powered by Kunena Forum