OFFER ENGINE

Filter Rules CSV

The values for the filter rules of the offer defined in offer details CSV needs to be uploaded in this section.

  1. It is mandatory to upload filter file if any of the offer has any filter rule associated with it.

  2. If any offer has a filter value and corresponding value is not uploaded, an error will be shown to the user.

  3. If any offer doesn’t have a filter rule but filter value is uploaded, an error will be thrown.

  4. 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

Scroll inside to view more
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

Scroll inside to view more
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.

  1. It is mandatory to upload product rules file if any of the offer has any filter rule associated with it.

  2. If any offer has a product rule and corresponding value is not uploaded, an error will be shown to the user.

  3. If any offer doesn’t have a product rule but product rule value is uploaded, an error will be thrown.

Scroll inside to view more
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

Last updated 10 months ago