Shopify Bulk Product Limits: CSV Import Guide for Large Catalogs

Set product limits for hundreds of Shopify products at once using OrderRules' CSV bulk import. Export a template, fill in your product handles and limit values in any spreadsheet app, then upload — OrderRules applies all rules instantly. No manual product-by-product configuration needed.

When You Need Bulk Import

Configuring order limits manually works fine for small catalogs—but once you hit 100+ products, it becomes a bottleneck. CSV bulk import lets you define limits for your entire product range in one session.

Common scenarios where bulk import saves hours:

• Large catalogs with individual limits — You sell 500 SKUs and each needs a different maximum order quantity based on production capacity
• Seasonal limit changes — Every holiday season, you adjust quantity caps across 200+ products at once
• Migrating from another order limit app — You already have limits configured elsewhere and need to import them fast
• B2B catalogs with per-product minimums — Your wholesale customers need minimum order quantities that vary by product

Without bulk import, you'd click into each product individually and set limits. With CSV import, you edit one spreadsheet and upload once.

CSV File Format

OrderRules accepts CSV files with a specific column structure. You can use Excel, Google Sheets, Numbers, or any spreadsheet application—just export as CSV before uploading.

Required and Optional Columns

Column definitions:

• product_handle — Found in your Shopify product URL. For a product at yourstore.myshopify.com/products/ceramic-bowl-blue, the handle is ceramic-bowl-blue. Must match exactly (case-insensitive).
• variant_id — Optional. If you only want to limit a specific variant (like one size or color), enter its Shopify variant ID. Find this in your Shopify admin under product details. Leave blank to apply the limit to all variants.
• limit_type — Three options:
  • max_quantity — Maximum units per order (e.g., "no more than 20 units per order")
  • min_quantity — Minimum units per order (e.g., "must order at least 5 units")
  • max_orders — Maximum orders per time period (e.g., "only 3 orders per month")
• limit_value — The number itself. For max_quantity: 20, enter 20.
• period — Time window for the limit:
  • daily — Resets every 24 hours
  • weekly — Resets every Sunday at midnight
  • monthly — Resets on the first day of the month
• status — Set to active to enforce the limit immediately, or paused to keep it ready but disabled.

Example CSV Content

product_handle,variant_id,limit_type,limit_value,period,status
ceramic-bowl-blue,,max_quantity,20,monthly,active
ceramic-bowl-red,12345678,max_quantity,15,monthly,active
artisan-vase,,min_quantity,5,weekly,active
limited-edition-print,,max_orders,2,monthly,paused
hand-thrown-mug,,max_quantity,50,daily,active

Step-by-Step Guide to Bulk Importing Limits

Step 1: Access the CSV Import Tool

In your OrderRules dashboard, navigate to Settings → Bulk Import → CSV Import. You'll see the upload interface with a template download option.

Step 2: Download the Template (Optional but Recommended)

Click "Download CSV Template" to get a pre-formatted file with all columns in the correct order. This prevents formatting errors.

Step 3: Fill In Your Products

Open the template (or create your own) in Excel, Google Sheets, or your preferred spreadsheet app:

1. List each product by its Shopify handle in the first column
2. Leave variant_id blank unless you're targeting specific variants
3. Choose your limit_type (max_quantity, min_quantity, or max_orders)
4. Enter the limit_value (the number)
5. Set the period (daily, weekly, or monthly)
6. Mark each rule as active or paused

Add one row per product (or per variant if limiting specific variants separately).

Step 4: Save and Export as CSV

In Excel: File → Save As → Choose "CSV (Comma delimited)" format In Google Sheets: File → Download → Comma-separated values (.csv)

Step 5: Upload Your File

Return to the OrderRules CSV Import page and click "Choose File" or drag-and-drop your CSV. The system will validate it immediately and show any errors.

Step 6: Review the Import Preview

OrderRules displays a preview of all rules it will create. Verify the product handles match your Shopify store, and the limits are correct. This is your last chance to catch mistakes before applying.

Step 7: Confirm and Apply

Click "Import Rules" to apply all limits to your store. OrderRules processes the file instantly—depending on how many products you're importing, you'll see results within seconds to a few minutes.

Exporting and Editing Current Rules

OrderRules lets you export your existing rules as a CSV file, edit them in a spreadsheet, and re-import the modified version.

Why export existing rules?

• Backup — Keep a copy of all your rules in case you need to reference them
• Batch edits — Change 50 limits at once by editing one column in your spreadsheet
• Audit trail — Have a permanent record of what limits you've configured

To export current rules: Settings → Bulk Import → Export Rules. Download the CSV, make your changes, and re-import. OrderRules will update any existing rules that match the product handle.

Common Use Cases

Seasonal Inventory Limits

During the holiday rush, you know inventory will move faster. Export your rules, reduce limit_value for high-velocity products (e.g., from 50 to 25 units max per order), and re-import. When the season ends, export again, restore original limits, and import. Done in under 5 minutes.

Flash Sale Preparation

You're running a flash sale on 200 products tomorrow and want to enforce tight limits to prevent overselling. Create a CSV with those 200 handles, set each to max_quantity: 5 with status: paused. Upload it. At sale start time, change status to active and export/import again. Limits go live instantly.

B2B Minimum Order Quantities

Your wholesale catalog requires different minimums per product based on production costs. Build a CSV with handles and limit_type: min_quantity values ($5 product = 10-unit minimum, $50 product = 1-unit minimum). Upload once; the system enforces all minimums automatically.

Troubleshooting Common Errors

Error: "Invalid product handle"

Problem — You typed a handle that doesn't exist in your Shopify store.

Solution — Copy product handles directly from your Shopify admin. Go to Products → Click the product → Look at the URL slug or the product details page. Match it exactly, including hyphens and spacing.

Error: "Duplicate entries detected"

Problem — The same product handle appears twice in your CSV.

Solution — If you need multiple limits per product (e.g., both min and max quantity), use separate rows with different limit_type values. If the rows are truly duplicates, delete the extra row.

Error: "Missing required column: limit_type"

Problem — You forgot to include the limit_type column or left it blank for some rows.

Solution — Every row must have a value in limit_type (max_quantity, min_quantity, or max_orders). Add the column if missing, or fill in blank cells.

Limits applied but not showing on storefront

Problem — Rules imported successfully but customers aren't seeing limits on the product page.

Solution — Check that status is set to active, not paused. Also verify your Shopify theme has the order limit widget enabled (available in OrderRules settings). If rules are active and the widget is enabled, clear your browser cache and refresh the store.

Pro Plan Requirement

CSV bulk import is available exclusively on OrderRules' Pro plan ($9.99/month). The Pro plan also includes:

• Unlimited order rules
• Advanced limit types (max_orders, min_quantity)
• Rule scheduling and custom time periods
• Priority email support
• Bulk rule export and editing

For pricing details and plan comparison, see our pricing page.

Related Reading

Want to understand order limits from the ground up? Check out our guides:

• How to Set Order Limits in Shopify — Manual setup guide for individual products
• Complete Guide to Shopify Order Rules — Comprehensive overview of order rule types and strategies
• Prevent Overselling in Shopify — Best practices for inventory protection
• CSV Bulk Import Docs — Full technical documentation and troubleshooting

Manage Limits at Scale

Install OrderRules from the Shopify App Store and start your 14-day free Pro trial. Import limits for your entire catalog in minutes.