---
page_title: Filters & Product Rules  CSV
product: OFFER ENGINE
page_source: https://juspay.io/in/docs/offer-engine/docs/batch-offers/filters--product-rules--csv
llms_txt: https://juspay.io/in/docs/llms.txt
product_llms_txt: https://juspay.io/in/docs/offer-engine/llms.txt
---


## **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


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

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.


| 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

---

## See Also

- [Offer Details CSV](https://juspay.io/in/docs/offer-engine/docs/batch-offers/offer-details-csv)
- [Coupons / Auto-Apply Offers](https://juspay.io/in/docs/offer-engine/docs/payment-page-flow/coupons--autoapply-offers)