How can I include in the query for example the coupon used in the purchase?

Resolved

(@tiicaa)

Hello how can I make a query in the database to also show the user purchase by association?
I see the table with data, I get the query

SELECT users.*, members.membership_id, level.name 
FROM wp_users AS users 
JOIN wp_pmpro_memberships_users AS members 
ON users.ID = members.user_id 
JOIN wp_pmpro_membership_levels AS level 
ON members.membership_id = level.id 
WHERE members.status = 'active'

How can I include in the query for example the coupon used in the purchase?

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

Plugin Author Andrew Lima
(@andrewza)

3 years, 10 months ago

Hi @tiicaa

You should be able to JOIN on the ‘wp_pmpro_discount_codes_uses’ table ON the user_id column and WHERE the code_id is X (or by the user’s order ID).

Here’s a link to the structured data for the SQL tables – https://github.com/strangerstudios/paid-memberships-pro/blob/dev/includes/setup.sql#L59-L68

Thread Starter tiicaa
(@tiicaa)

3 years, 10 months ago

Ah, ok, but does that apply to woocommerce coupons? I am using woocommerce to purchase and use over there or use the coupon

Plugin Author Andrew Lima
(@andrewza)

3 years, 10 months ago

That was to filter using the Paid Memberships Pro discount codes. I’m not sure how WooCommerce handles discount code uses. I’d recommend reaching out to a local WordPress developer to assist you further.

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

The topic ‘How can I include in the query for example the coupon used in the purchase?’ is closed to new replies.