# Very full cart table

**URL:** <https://forum.shopware.com/t/very-full-cart-table/103335>\
**Category:** Programming (EN)\
**Tags:** general, programming\
**Created:** [15. März 2024 um 12:24 UTC](https://forum.shopware.com/t/very-full-cart-table/103335 "2024-03-15T12:24:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![NacScha](https://avatars.discourse-cdn.com/v4/letter/n/3bc359/32.png) [@NacScha](https://forum.shopware.com/u/NacScha)\
**Post date:** [15. März 2024 um 12:24 UTC](https://forum.shopware.com/t/very-full-cart-table/103335/1 "2024-03-15T12:24:25Z")

</div>

Hey all,

In one of our customers environment are somehow entries in the cart table generated.  
The table recently got really full with around **300.000** entries in the last 40 days. Most of them without a customer\_id, so we think they got generated by Bots ?!

We extended the existing CleanupCartTaskHandler to delete all entries without a customer after 2 days.  
Still there are around 10k of new cart entries each day.

Does someone has experiences with this?

---

<div class="post-metadata">

**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\
**Post date:** [17. März 2024 um 06:00 UTC](https://forum.shopware.com/t/very-full-cart-table/103335/2 "2024-03-17T06:00:01Z")

</div>

Do they use a plugin to share carts? These links are followed by bots, and could be an explanation.

Without that, to add articles to the cart the bots must support JavaScript, which is not that common.

---

<div class="post-metadata">

**Author:** ![NacScha](https://avatars.discourse-cdn.com/v4/letter/n/3bc359/32.png) [@NacScha](https://forum.shopware.com/u/NacScha)\
**Post date:** [22. März 2024 um 07:29 UTC](https://forum.shopware.com/t/very-full-cart-table/103335/3 "2024-03-22T07:29:27Z")

</div>

mhh, they have a plugin installed which is sending reminder Mails for abandoned carts. Within the Mail there is just a Link to restore an already existing cart.

But the links are not published anywhere and are just restoring already existing carts, so this shouldn’t be a problem.

What did you think about when you say „share carts“, like between users ? But these links shouldn’t be publically available either, shouldn’t they?

---

<div class="post-metadata">

**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\
**Post date:** [22. März 2024 um 20:22 UTC](https://forum.shopware.com/t/very-full-cart-table/103335/4 "2024-03-22T20:22:00Z")

</div>

There are plugins that add a link to the storefront which says „share the basket with friends“. Some crawlers execute JavaScript, add products into the basket and then crawl that link. Thus a lot of carts from crawlers exist.

---

<div class="post-metadata">

**Author:** ![NacScha](https://avatars.discourse-cdn.com/v4/letter/n/3bc359/32.png) [@NacScha](https://forum.shopware.com/u/NacScha)\
**Post date:** [2. April 2024 um 15:21 UTC](https://forum.shopware.com/t/very-full-cart-table/103335/5 "2024-04-02T15:21:25Z")

</div>

@Max_Shop Thanks for your response.

Hmm i am still thinking about this possibility.  
But if that could happen, the crawlers or bots should also be able to add products to the cart directly (with JS) shouldn’t they ?

Kind regards and thanks a lot for your help 🙂

---

<div class="post-metadata">

**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\
**Post date:** [2. April 2024 um 16:28 UTC](https://forum.shopware.com/t/very-full-cart-table/103335/6 "2024-04-02T16:28:25Z")

</div>

Crawlers only follow clickable actions. They do not execute any JS function they find.

Also, adding a product to the cart in the frontend adds a new entry in the database at that very moment.
