How do I automate Price Adjustment Customer Requests during sale?

Shopify Plus
, , , , ,
1

A price adjustment request is raised by customer when a customer has purchased a product/s before sale period at x price but in a few days during promotions the same products are at x-10% price. Our company policy is to honor such requests and we try to price match as much as we can.
We have been managing this well for flat discount promos “flat 30% off” by manually calculating the difference and refunding the customer. But for variable discount where an order has multiple items with different discounts% under “Upto 50% off” or “50%-70% off” promotions, it becomes very manual for an agent to calculate discounts at line item level for refund. This is also prone to human error. Is there a way to automate calculations for price adjustment request within Shopify or is there any Shopify App that can help us with this use case?

2

Hey @Pooja_9
Why not give them a store credit instead of discount or refund?

3

Thank you for the suggestion Prakash, but even for store credit, someone has to manually calculate the discount amount before issuing store credit. My concern is the manual step needed by the agents that is time consuming and also error prone. Would you have have some recommendation on that?

4

Hey @Pooja_9
There are two types of discounts we have

  1. Line-item level: I believe if a line-item level discount has been applied it is easy to calculate.
  2. Order level: In this case the shopify order json you will get allocated discount for each line-item so you can get it from there.

If this does not help then you can connect with me via email so we can discuss in details and I can suggest you best possible solution.

5

I’m not sure if such an app exists, but if it did, it would have to:

  1. Find all currently-running promotions (are you only using Shopify native discounts? Are you using compare at price? 3rd party discount apps?)
  2. Simulate Shopify’s discount logic to find out which products are eligible for discounts, and if so, how much to deduct
  3. Issue refunds accordingly (this would probably be the easy part)

As you can imagine, depending on your store’s specific requirements, it might be difficult to find a pre-made solution.

So, you might also consider finding a developer to implement a custom app for you. You can use the Shopify Forums to find someone, or a site like Upwork/Fiverr/etc.

Also, are you trying to use this with POS, or just the Online Store?