Filter Rules CSV
The values for the filter rules of the offer defined in offer details CSV needs to be uploaded in this section.
It is mandatory to upload filter file if any of the offer has any filter rule associated with it.
If any offer has a filter value and corresponding value is not uploaded, an error will be shown to the user.
If any offer doesn’t have a filter rule but filter value is uploaded, an error will be thrown.
Multiple values against a Filter Type and Offer Code can be uploaded by adding multiple rows with different filter values for a combination of Filter Type and Offer Code
|
Offer Code
|
Filter Type
|
Filter Value
|
|---|---|---|
JUSPAY01
| UDF1
| TEST56
|
JUSPAY02
| CUSTOMER_ID
| ID_560989
|
JUSPAY02
| CUSTOMER_ID
| ID_560990
|
Offer Code
Offer code of the offer where filter rules were specified in Offer Details CSV.
Filter Type
Filter type of the offer where rules were specified
|
Accepted Values
|
Description
|
|---|---|
CUSTOMER_ID
| Customer ID
|
CUSTOMER_EMAIL
| Customer email
|
CUSTOMER_MOBILE
| Customer mobile number
|
GATEWAY_REFERENCE_ID
| Gateway Reference ID
|
CARD_BIN
| Card bins
|
UDF1
| Order UDF1
|
UDF2
| Order UDF2
|
UDF3
| Order UDF3
|
UDF4
| Order UDF4
|
UDF5
| Order UDF5
|
UDF6
| Order UDF6
|
UDF7
| Order UDF7
|
UDF8
| Order UDF8
|
Filter Value
Filter value for the corresponding filter type added in the CSV
Product Rules CSV
The product rules for the offer defined in offer details CSV needs to be uploaded in this section.
It is mandatory to upload product rules file if any of the offer has any filter rule associated with it.
If any offer has a product rule and corresponding value is not uploaded, an error will be shown to the user.
If any offer doesn’t have a product rule but product rule value is uploaded, an error will be thrown.
|
offer_code
|
Product_id
|
min_quantity
|
max_quantity
|
min_amount
|
max_amount
|
applicable max quaniity
|
eligible_products_for_applicability
|
|---|---|---|---|---|---|---|---|
JUSPAY01
| id1
| 1
| 5
| 300
| 600000
| id1
|
|
JUSPAY02
| id2
| 2
| 5
| 400
| 1
| id2
|
Offer Code
Offer code of the offer where Product rules were specified in Offer Details CSV
Product ID
Product ID of the SKU where Eligibility & Applicability checks needs to be performed
Min quantity
Minimum quantity of the SKU above which SKU is eligible for the Offer
Max quantity
Maximum quantity of the SKU beyond which SKU is ineligible for the Offer
Min amount
Minimum price of the SKU above which SKU is eligible for the Offer
Max amount
Maximum price of the SKU beyond which SKU is ineligible for the Offer
Applicable Max Quantity
Quantity of SKUs where offer needs to be applied
Eligible Products for Applicability
Apply offer on the SKU only when the SKUs given are eligible