> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://orichi.crisp.help/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to use XLSX file for bulk import?

## How to fill in the XLSX file
* One row = one rule.
* Leave any fields you don't need blank.
* Use `|` to separate multiple values inside column.
* Do not rename or remove columns.
* Use the correct **Target type** and **Target items** format.

| Column | Description | Allowed Values | Example |  |  |  |
| ---- | ---- | ---- | ---- | ---- | ---- | ---- |
| **Rule title** | Name of the rule must be unique | Any text | `Max 3 T-shirts` |  |  |  |
| **Target type** | What objects the limit rules applies to | `Product`, `Variant`, `Collection`, `Product Tag`, `Cart` | `Product` |  |  |  |
| **Target items** | List products/variants/tags/collections the rule applies to. The value depends on **Target type.**Please navigate to section [How to fill in Target items] for more details | **Product:** Product handle | `classic-t-shirt` |  |  |  |
| **Minimum quantity** | Minimum number of items customers must buy | Whole number | `2` |  |  |  |
| **Maximum quantity** | Maximum number of items customers can buy | Whole number | `10` |  |  |  |
| **Minimum weight** | Minimum weight | Number | `1.5` |  |  |  |
| **Maximum weight** | Maximum weight | Number | `10` |  |  |  |
| **Weight unit** | Unit used for minimum/maximum weight. Fill this when using minimum weight/maximum weight limit | `kg`, `g`, `lb`, `oz` | `kg` |  |  |  |
| **Minimum value** | Minimum order value in your store currency | Number only. Do not include a currency symbol. | `50` |  |  |  |
| **Maximum value** | Maximum order value in your store currency | Number only. Do not include a currency symbol. | `500` |  |  |  |
| **Multiples** | Requires customers to buy in multiples of this quantity | Whole number greater than `0` | `5` → 5, 10, 15... |  |  |  |
| **Allowed quantities** | Only allows customers to buy exact quantites of that item | Whole numbers separated by ` | \` | \`5 | 10 | 20` |
| **Products cannot be purchased with** | Products that cannot be purchased together with the target item(s) | Shopify **Product handles**, separated by ` | \` | \`gift-card | sample-pack` |  |
| **Stock thresholds: stock=max** | Changes the maximum purchase quantity when Shopify inventory reaches a certain level | `stock=max`, separated by ` | \` | \`100=5 | 50=3 | 10=1` |
| **Show limit table** | Show or hide the limit table on the storefront. By default, we hide this table | `Yes`, `No` | `Yes` |  |  |  |
| **Countries: ISO codes** | Countries where the rule applies. Leave blank means no limit to any countries | 2-letter country codes separated by ` | \` | \`US | CA | AU` |
| **Customer group** | Limit based on:Customer tagsCustomer without tagsNew customerOld customer | Select a value from the XLSX dropdown | `Customer with tag` |  |  |  |
| **Customer tags** | Customer tags use in case limit by customer group | Tags separated by ` | \` | \`VIP | Wholesale` |  |
| **Start date** | When the rule starts. Leave blank if no start date is needed | `MM/DD/YYYY HH:MM:SS` | `09/15/2026 09:00:00` |  |  |  |
| **End date** | When the rule ends. Leave blank if no end date is needed | `MM/DD/YYYY HH:MM:SS` | `09/30/2026 23:59:59` |  |  |  |
| **Message language** | Language used for storefront limit messages | Supported language code | `en` |  |  |  |
| **Show notice on product page** | Show or hide the limit notice on the product page | `Yes`, `No` | `Yes` |  |  |  |
| **Message in product page** | Message shown to customers on the product page. By default: Your selection doesn't meet the purchase limits. Adjust it to continue | Any text | `You can purchase a maximum of 3.` |  |  |  |
| **Alert in cart & checkout page** | Message shown on cart page and checkout page. Default value: Your cart doesn't meet the purchase limits. Update your cart to continue | Any text | `Please update your quantity to continue.` |  |  |  |
| **Disabled checkout button text** | Text shown on the disabled checkout button. Default value: Update cart to continue | Any text | `Purchase limit not met` |  |  |  |

### How to fill in Target items
The value in **Target items** depends on the selected **Target type**.
| Target type | What to enter in Target items | Where to find it in Shopify | Example | Important notes |
| ---- | ---- | ---- | ---- | ---- |
| Product | Shopify Product handle | Shopify Admin -> Products -> open the product. Check the product URL or Search engine listing | `classic-t-shirt` | From `your-store.com/products/classic-t-shirt`, enter only `classic-t-shirt` |
| Variant | Shopify Variant ID | Shopify Admin -> Products -> open the product -> open the variant. Check the variant URL | `44556677889900` | Use the numeric Variant ID, not the variant name or SKU |
| Collection | Shopify Collection handle | Shopify Admin -> Products -> Collections -> open the collection. Check the collection URL or Search engine listing | `summer-sale` | From `your-store.com/collections/summer-sale`, enter only `summer-sale` |
| Product Tag | Shopify Product tag | Shopify Admin -> Products -> open a product -> Tags | `Wholesale` | Enter the tag exactly as it appears in Shopify |
| Cart | Leave blank | Not applicable | N/A | Cart rules apply to the entire cart |