I’m trying to create an automatic discount using the built-in discount, but I want it to only apply based on the shipping region. With the segments I have created a sample customer segment which has a query like this:
FROM customers
SHOW customer_name, note, email_subscription_status, location, orders, amount_spent
WHERE customer_regions CONTAINS ‘PH-XXX’
ORDER BY updated_at
In the “Eligibility” I select “Specific Customer Segments” and selected the sample segment I made. When I try to checkout, the discount applies even when my selected shipping region does not match that of the discount. Likely due to I have multiple address and one of those address matches the region of the discount. What I want to happen is that even if the case that the customer has multiple address, if the selected shipping address’s region does not match that of the discount, then the discount should not apply. It should only apply if the customer’s selected shipping for their checkout/order matches the discount. Is there a proper way to apply this or is there a Shopify App that can do this?