CSV Bulk Import & Export
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
- 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.
- Fill in the rows in Excel, Google Sheets or Numbers, then save as
.csv. - Import. Click Import CSV, drop the file in, and choose what to do with products that already have limits.
- 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.
| Column | Required | What it sets | Example |
|---|---|---|---|
| Product ID | One of Product ID or SKU | The Shopify product | gid://shopify/Product/123456 |
| SKU | One of Product ID or SKU | Used to look up the product when Product ID is empty | CASE-12-RED |
| Product Title | Yes | Label shown in OrderRules | Cold brew 12-pack |
| Variant ID | No | Limit one variant instead of the whole product | gid://shopify/ProductVariant/345678 |
| Variant Title | No | Label for the variant | Medium / Blue |
| Daily Limit, Weekly Limit, Monthly Limit | At least one limit column | Maximum orders per period for this product, shared across all shoppers | 10 |
| Daily Qty Limit, Weekly Qty Limit, Monthly Qty Limit | (limit column) | Maximum units per period, shared across all shoppers | 50 |
| Min Order Qty | (limit column) | Minimum units per order | 6 |
| Step Quantity | (limit column) | Order in multiples of this number (2 or more) | 6 |
| Count By | No | What 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.