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.
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