Database to get the cart abondonement

General
1

Anyone know which database to get the cart abondonement data?

2

Please check cscart_user_session_products

2 Likes
3

thankyou will try it

4

i’ve checked it, but can you tell me how to differentiate the abanadoned cart? is it by type or anything else?

5

Can you please clarify what do you mean? What exactly do you want to differentiate?

6

what i meant is, how can i get the abandoned cart rate from this table?

7

You can sum up the total cost of the products in the cart using the following formula:

  • user_id - session_id pair to determine a specific cart.
  • summarize all the products in a cart by adding them up using this formula: price * amount.