search

mediabeastnz / craft-commerce-abandoned-cart

Abandoned Cart plugin for Craft Commerce 2
Other
1 stars 15 forks source link

Unrealistically high conversion rate #71

Open WHITE-developer opened 1 year ago

WHITE-developer commented 1 year ago

We've noticed some really high conversion rates in various shops for Craft 3 (but think the issue is also there in the 4 version).

After some quick research it turns out that rows in the abandoned_carts table are removed due to cascading. When the garbage collection then removes the inactive carts from Commerce, the corresponding rows in your table are also removed.

Now we're ending up with only recovered carts. So over time this rate is only getting higher as it is just simply divides the recovered carts by row count.

Can you please have a look?

Thanks

mediabeastnz commented 8 months ago

The only "solutions" I can think of (without redoing how this works currently) is to disable the cascading feature or have you increase the lifespan of inactive orders (i think this is configurable).

Without relying on the orders table I would need to store my own copy of the order so that we can accurately present that percentage value. If I added this to the plugin it wouldn't solve the issue for existing stores