---
title: "CSV Bulk Import & Export"
description: "Import and export product limits in bulk via CSV — daily, weekly and monthly caps, minimum order quantities and step quantities for hundreds of products at once."
contentType: "docs"
locale: "en"
localized: true
source: "https://orderrules.com/docs/guides/csv-bulk-import"
slug: "guides/csv-bulk-import"
---
## 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.

| 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**.

## Related

- [Per-Product Limits](/docs/product-limits/per-product-limits) · [Per-Variant Limits](/docs/product-limits/per-variant-limits)
- [Minimum Order Quantity](/docs/product-limits/minimum-order-quantity) · [Step Quantity](/docs/product-limits/step-quantity)
- [Limits by delivery date](/docs/delivery/delivery-date-limits)
