SQL Query to see which sessions are holding which products?

  • pduclo

    (@pduclo)


    3 years, 8 months ago

    Hi James,

    Can you help with an SQL Query to show which sessions/users are holding which products?

    We mostly deal with variable products and I am curious if one user is adding a bunch of the variations to their cart and holding them there. If so, I will implement a limit.

    Thanks,
    Phil

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author James Golovich

    (@jamesgol)

    3 years, 8 months ago

    That’s a little out side of the scope of support provided for the plugin here.

    Thread Starter pduclo

    (@pduclo)

    3 years, 8 months ago

    Understandable. I’ll dig a little and see what I can come up with. Thanks for the great plugin!

    Thread Starter pduclo

    (@pduclo)

    3 years, 8 months ago

    I see now that I can look at the cart contents in wp_woocommerce_sessions. Should have thought about that a little more before reaching out.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘SQL Query to see which sessions are holding which products?’ is closed to new replies.