How to use XLSX file for bulk import?

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

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