Clear customers cart

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
2 years 4 months ago #347603

Is there any config to clear customers cart history after 30 days?

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

  • Posts: 83675
  • Thank you received: 13545
  • MODERATOR
2 years 4 months ago #347606

Hi,

You have settings for that in the HikaShop configuration:
www.hikashop.com/support/documentation/5...g.html#advanced_main

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

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
2 years 4 months ago #347626

I have settings 1 week, but carts remains 1year.

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

  • Posts: 83675
  • Thank you received: 13545
  • MODERATOR
2 years 4 months ago #347628

Hi,

Can you provide a screenshot of the cart retaining settings in the HikaShop configuration ?
Also, how many carts do you have ?
Note that the setting only delete them 50 by 50, so if you have thousands of carts, this might take a while based on these settings.

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

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
2 years 4 months ago #347632

I have new cart entry every minute. So a lot. I think that some bot enters data.
Now I cleared table in database and set config to 5 days.

Attachments:

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

  • Posts: 83675
  • Thank you received: 13545
  • MODERATOR
2 years 4 months ago #347634

Him

If you configure the freauency to 1 day, it means that every day, it will delete 50 carts. But if you have 1 new cart every minute, then it means you will get more new carts than carts are being deleted. So it will just keep on piling up.
You should reduce the frequency like 1 every minute. That way, it will delete a lot more old carts every day and it should keep up with the new carts being created.

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

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
2 years 4 months ago #347643

Ok, now I get the logic ;)

Have any idea how to stop bots to create carts? As I see most IP is from msn bot.

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

  • Posts: 4820
  • Thank you received: 654
  • MODERATOR
2 years 4 months ago #347644

Hello,

You get how to proceed in such case from old forum subject, here .
Hope this will help you to prevent this.

Regards

Last edit: 2 years 4 months ago by Philip.

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

  • Posts: 349
  • Thank you received: 19
  • Hikashop Business
2 years 4 months ago #347672

The only working thing was htaccess block of bingbot.

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

  • Posts: 63
  • Thank you received: 1
  • Hikashop Essential
1 year 4 months ago #357928

Hello,

I am also having the same issue of a cart with thousands of items that were created months ago. I have tried the settings above (cart retaining period 3 days, frequency of checking carts 1 minute) but it doesn't work. Only when I save the configuration, 50 records are deleted from the cart, but then it is stuck there. Every time I save the settings, 50 other records are deleted. But none are deleted automatically as it is supposed to do.

As a more general request, I really wish it were possible to have a lighter Hikashop. No extension bloats my website and database like it. Thousands of records that get stuck in a cart, thousands of zones, dozens of shipping plugins, nearly 200 DB tables... it would be nice to be able to set some of these as options upon install for those who wish to have a lighter and less cumbersome component.

Thank you, and wishing you a happy new year!

Last edit: 1 year 4 months ago by jazzbird.

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

  • Posts: 83675
  • Thank you received: 13545
  • MODERATOR
1 year 4 months ago #357941

Hi,

Thanks, happy new year to you too !

HikaShop doesn't even add 50 tables to the database. The rest is Joomla and your other extensions. And an ecommerce solution has to be big. HikaShop is actually one of the lightest ecommerce solutions out there. Most of them have way more tables. For example, Prestashop's tables : github.com/PrestaShop/PrestaShop/blob/8....ata/db_structure.sql
That's hundreds of tables.
Zones are necessary for the customers to be able to enter their address.
There are only 10 shipping plugins preinstalled with HikaShop, so not dozens.
I assure you we're trying our best to make it as light as possible, while maintaining backward compatible as best as possible, and allowing for as much capabilities as possible within that frame.

Regarding your issue with carts, I actually answered in length about this same issue on this thread:
www.hikashop.com/support/forum/orders-ma...-customer-carts.html
So please read there and follow the instructions.

The following user(s) said Thank You: jazzbird

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

  • Posts: 63
  • Thank you received: 1
  • Hikashop Essential
1 year 3 months ago #358214

Okay, thanks, I think I figured it out!

And yes, I'm not sure where I got the "nearly 200 DB tables"... Sorry. I must have been looking at something else. I'm actually counting 43 tables, which is still about a quarter of all my website's tables! :)

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

Time to create page: 0.087 seconds
Powered by Kunena Forum