Skip to main content

CSV Bulk Import & Export

5 min read · Facts checked September 28, 2026

CSV Bulk Import & Export

Use CSV import to set product limits across a large catalogue at once: daily, weekly and monthly caps, minimum order quantities and step quantities. Export what you have, edit it in a spreadsheet, and import it back. Everything happens in Product Limits in the OrderRules dashboard.

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

How it works

  1. Get a file with the right headers. Click ↓ Export All to export your current limits, or open Import CSV and click ↓ Download Sample Template for a blank file.
  2. Fill in the rows in Excel, Google Sheets or Numbers, then save as .csv.
  3. Import. Click Import CSV, drop the file in, and choose what to do with products that already have limits.
  4. Review. OrderRules parses the file, lists any row errors, and shows a preview of the first 10 limits. Confirm to import.

Columns

Header names are matched loosely (case and spaces don't matter), and column order doesn't matter.

ColumnRequiredWhat it setsExample
Product IDOne of Product ID or SKUThe Shopify productgid://shopify/Product/123456
SKUOne of Product ID or SKUUsed to look up the product when Product ID is emptyCASE-12-RED
Product TitleYesLabel shown in OrderRulesCold brew 12-pack
Variant IDNoLimit one variant instead of the whole productgid://shopify/ProductVariant/345678
Variant TitleNoLabel for the variantMedium / Blue
Daily Limit, Weekly Limit, Monthly LimitAt least one limit columnMaximum orders per period for this product, shared across all shoppers10
Daily Qty Limit, Weekly Qty Limit, Monthly Qty Limit(limit column)Maximum units per period, shared across all shoppers50
Min Order Qty(limit column)Minimum units per order6
Step Quantity(limit column)Order in multiples of this number (2 or more)6
Count ByNoWhat daily limits count against: order (order date, the default) or fulfillment (the delivery or pickup date the customer picks — needs delivery dates on)fulfillment

The export also includes Used and % columns for each period and a Status column. They show current usage and are ignored when you import.

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
,gid://shopify/Product/789012,Hoodie,gid://shopify/ProductVariant/345678,Medium / Blue,5,25,100,,
  • Row 1: the sourdough loaf takes 40 orders a day, across all shoppers.
  • Row 2: found by SKU; customers must buy at least 6, in multiples of 6.
  • Row 3: one variant gets its own daily, weekly and monthly limits.

Rules the importer checks

  • Either Product ID or SKU is present, and a product is found. Rows whose SKU matches no product fail with an error.
  • Product Title is present.
  • At least one limit is set.
  • Step Quantity is 2 or more; Min Order Qty is 1 or more.
  • If the same product and variant appear more than once, the last row wins.

If a product already has limits

Choose one when you import:

  • Replace existing limits — overwrite the current values with the values in the file.
  • Skip existing products — only import products that don't have limits yet.

Exporting

  • ↓ Export All — every product limit in the current view.
  • ↓ Export Selected — only the rows you've ticked.

Export → edit → import is the fastest way to make a sweeping change, such as lowering daily limits for a holiday week. The export leaves SKU blank and fills Product ID, so a re-import matches products by ID.

Plans

Import and export are available in Product Limits on every plan. The free Starter plan allows limits on up to 3 products, so bulk import is most useful on Pro ($9.99/month), which removes the cap. Counting daily limits by delivery date needs delivery dates on (Advanced).

Troubleshooting

  • "Either SKU or Product ID is required" — the row has neither. Add one.
  • "Could not find product for SKU" — no product in your store 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.
  • Nothing changed for some products — you chose Skip existing products, and those products already had limits.

Need help? Contact support@orderrules.com.