Shopify Bulk Product Limits: CSV Import Guide for Large Catalogs

Set product limits for hundreds of Shopify products at once with an OrderRules CSV. Export your current limits (or download the sample template), fill in daily, weekly and monthly caps, minimum order quantities and step quantities in any spreadsheet, and import the file from Product Limits. OrderRules matches each row to a product by Product ID or SKU and checks the limits at checkout like any limit set by hand.

When bulk import saves time

Setting limits product by product is fine for a dozen items. Past 100, a spreadsheet is faster:

• Production-limited catalogues — 300 baked goods, each with its own daily cap.
• Case-packed goods — wine, beverages or supplements that must be bought in 6s, 12s or 24s.
• Seasonal changes — lowering caps across 200 products for a holiday week, then restoring them.
• Moving from another app — rebuilding limits you already had somewhere else.

The CSV covers product and variant limits. Per-customer limits, collection limits, store hours and delivery rules are set in their own screens.

The CSV format

Header names are matched loosely — case and spaces don't matter — and column order doesn't matter. Export your current limits or download the sample template to start from the exact headers.

Exports also include Used, % and Status columns showing current usage. The importer ignores them, so you can re-import an edited export as it is.

Example

SKU,Product ID,Product Title,Variant ID,Variant Title,Daily Limit,Weekly Limit,Monthly Limit,Min Order Qty,Step Quantity
,gid://shopify/Product/123456,Sourdough loaf,,,40,,,,
CASE-12-RED,,Red wine case,,,,,,6,6
CB-12,,Cold brew 12-pack,,,20,,,12,12
,gid://shopify/Product/789012,Hoodie,gid://shopify/ProductVariant/345678,Medium / Blue,5,25,100,,

• Sourdough loaf — 40 orders a day across all shoppers.
• Red wine case — found by SKU; at least 6, in multiples of 6.
• Cold brew 12-pack — 20 orders a day, and each order in 12s.
• Hoodie, Medium / Blue — its own daily, weekly and monthly limits.

Step by step

1. Get a file with the right headers

In the OrderRules dashboard, open Product Limits:

• ↓ Export All downloads every product limit in the current view.
• ↓ Export Selected downloads just the rows you've ticked.
• Import CSV → ↓ Download Sample Template gives you a blank file.

2. Fill in the rows

One row per product, or per variant if a variant needs its own limits. Use Product ID from an export where you can. SKU works too: OrderRules looks up the product by SKU, and a row fails if no product matches.

3. Check it before importing

• Every row has Product ID or SKU, and Product Title.
• Every row sets at least one limit.
• Step Quantity is 2 or more, and Min Order Qty is a multiple of it if you use both.
• A product and variant appear only once. If they appear twice, the last row wins.

4. Import

Click Import CSV and drop the file in. OrderRules parses it and lists row errors with the row number and field. Then choose what happens to products that already have limits:

• Replace existing limits — overwrite them with the values in the file.
• Skip existing products — only add limits to products that don't have any yet.

Review the preview of the first 10 rows, then confirm. A message shows how many limits were imported and how many rows failed.

5. Spot-check

Open a few products in Product Limits, and test a cart that breaks a rule — too few units, the wrong multiple — to confirm checkout blocks it, including with Shop Pay.

Common uses

Seasonal caps

Before a holiday week, export all limits, lower the daily caps on your busiest products, and import with Replace existing limits. Afterwards, import the original export again to restore them.

Case packs across a catalogue

For a range sold in cases, set Min Order Qty and Step Quantity to the case size on every row. These apply to every shopper. If only wholesale buyers should see them, use quantity rules on a Shopify B2B catalog instead — they're native on every plan since April 2026.

Production caps by delivery date

For made-to-order items, set a Daily Limit or Daily Qty Limit and Count By fulfillment, and each day's cap counts against the delivery or pickup date customers choose rather than the day they order. This needs delivery dates turned on (Advanced plan). See limits by delivery date.

Troubleshooting

• "Either SKU or Product ID is required" — the row has neither.
• "Could not find product for SKU" — no product has that SKU. Check it in Shopify, or use Product ID.
• "At least one limit … must be set" — the row has no limit values.
• "Step Quantity must be 2 or greater" — leave it blank for no step.
• Some products didn't change — you chose Skip existing products and they already had limits.
• Limits show in OrderRules but not on the storefront — make sure the OrderRules app embed is enabled in your theme. Checkout still enforces the limits either way.

Plans

CSV import and export are in Product Limits on every plan. The free Starter plan allows limits on up to 3 products, so bulk import pays off on Pro ($9.99/month), which removes the cap and adds weekly and monthly caps, collection limits and per-customer limits. Counting daily limits by delivery date needs delivery dates on (Advanced, $19.99/month). See pricing.

Related reading

• How to set order limits on Shopify
• Minimum order quantity on Shopify · Selling in multiples
• Complete guide to Shopify order rules
• CSV bulk import docs

Manage limits at scale

Install OrderRules from the Shopify App Store, export your first limits, and edit your whole catalogue in one spreadsheet.