I've seen a similar question being asked about giving specific customers an automatic discount, but no clear solution to the problem has been posted that I can see.
Shopify provides by default the "Automatic Discount", but unlike promo codes, for some reason you cannot create an automatic discount that applies to groups of customers.
So fine. I am creating a Custom App in order to try to accomplish this.
Before I spend a week or two going down a rabbit hole that won't work, I thought I would put it to this community to weigh-in on the relative stupidity of the ideas I have come up with:
Create a webhook to fire off on the createCheckout action.
The webhook responder will (somehow??) figure out which customer created the checkout, query the app's own database to find the discount rate for that customer then use Discount API to create a one-time use promo code on Shopify
Basically do the same as above: somehow figure out which customer this is and create a one-time use Promo Code based on their discount
Am I missing something? Is there an obvious better way to do this? Should we have used WooCommerce after all??