This document outlines the process of determining a product’s eligibility for return based on its discount percentage. The comparison involves the item’s Line Item Original Unit Price (the price the customer paid) and a threshold percentage applied to either the Variant Compare at Price or the Variant Price.
Key Terminology
Variant Price
The current price of the item in the store.
Example: £11.20
Variant Compare at Price
The most recent price of the variant before the discount, displayed as a strikethrough price.
Example: £18.70
Line Item Original Unit Price
The price at which the customer purchased the item.
This is the price used for the comparison.
Example: £21.00
Discount Calculations
The discount percentage is calculated as follows:
Formula:
Discount Percentage = [(Line Item Original Unit Price - Price Used for Comparison) / Line Item Original Unit price] × 100
Example 1 (Using Variant Compare at Price):
Variant Compare at Price: £150
Line Item Original Unit Price: £250
Discount = [(250 - 150) ÷ 250] × 100 = 40%
Example 2 (Using Variant Price):
Variant Price: £100
Line Item Original Unit Price: £150
Discount = [(150 - 100) ÷ 150] × 100 = 33.3%
If the threshold is set to 30%, this item would not be eligible for return.
Process Summary
Condition Setup:
Apply the condition "Product Discount Is".
Set a threshold percentage in whole number or decimal.
Compare the Line Item Original Unit Price to a value derived from:
Compare at Price: The most recent price of the variant before discount.
Variant Price: The current price.
Action Setup
This condition is product-specific and can only be paired with product-specific actions.
If the condition evaluates to true (i.e., the discount exceeds the threshold), the product becomes ineligible for return.
Outcome:
If the discount exceeds the threshold, trigger the action: "This product cannot be returned".
If the discount is below the threshold, the product remains eligible for return.
Example UI
The above screenshot demonstrates the configuration:
Condition: "Product discount is greater than 30% of Compare at Price".
Action: "This product cannot be returned".
Example Summary
Blocked Return:
Variant Compare at Price = £200
Line Item Original Unit Price = £300
Discount = 33.3% (Threshold = 30%) → Not eligible for return.
Allowed Return:
Variant Compare at Price = £200
Line Item Original Unit Price = £220
Discount = 9.1% → Eligible for return.
This process uses Shopify's key pricing terms to determine eligibility for returns based on discount thresholds.