🔧 Quick Info: This tool bulk-creates, updates, and deletes complex product rules from a spreadsheet. Upload a file with SKU, rule conditions, and adjustments (price, weight, purchasing status), and we’ll apply the changes to your products.
What It Does
This tool updates the complex rules on your BigCommerce products from a spreadsheet. Complex rules (also called product or SKU rules) are what BigCommerce uses to adjust a product’s price, weight, purchasing status, and more, based on the combination of options (modifiers) or variants a shopper chooses. For example: “if Size = Large and Color = Red, add $5 and 2 lbs.” You upload a file, match its columns to the available fields, and the tool applies your changes to each product. For every row it can create a new rule, update an existing rule (when you include its Rule Id), or delete a rule (when you mark the row to delete and include its Rule Id). Each product is found by its SKU, and each rule is defined by the combination of option modifiers and/or variant SKUs you list. The work runs in the background, and you can get an email when it’s finished. Any rows that can’t be processed are reported back so you can fix and re-upload them.
When Should You Use This?
Use this tool whenever you need to add, change, or remove product rules in bulk instead of editing them one at a time. Common scenarios include adding or changing price or weight adjustments across many products at once, enabling, disabling, or marking rules as “stop” rules in bulk, turning purchasing on or off (with an optional message) for specific option combinations, removing a batch of existing rules quickly, or working in a spreadsheet instead of editing rules one product at a time in BigCommerce.
Before You Get Started
- Make sure the products you’re updating already exist in BigCommerce. Rules attach to existing products.
- Prepare your file so the first row contains column headers including SKU, Rule Id, Price Adjuster, and Weight Adjuster.
- Include a SKU column so each row can be matched to the right product.
- For options-based rules, the modifier names and values in your file must already exist on the product. For variant-based rules, the variant SKUs must already exist.
- Save the file in a format you can upload (CSV or Excel).
- Double-check you’re working in the correct store before you begin.
How to Use It
1 Open the Tool
Navigate to the Import Rules tool in your Your Store Wizards dashboard for your BigCommerce store.
2 Review File Requirements
On the Upload Rules step, you’ll see a note about file requirements. Your file’s first row must contain column headers including SKU, Rule Id, Price Adjuster, and Weight Adjuster.
3 Upload Your File
Choose your CSV or Excel file and upload it to the tool.
4 Map Your Columns
Once the file is uploaded, the column matching section appears. Map each column in your file to the matching field. At minimum, map your SKU column to the SKU field. Any columns you don’t map will be ignored.
5 Set Up Email Delivery
On the Email Delivery step, choose whether you’d like an email when the process completes, and confirm the email address.
6 Start the Import
Start the import. You’ll see a confirmation that the process has started. The work runs in the background, so you can close the page. When it finishes, check your email (if you opted in). If any rows had problems, download the errors file to see exactly what needs fixing.
File and Field Reference
Your file’s first row must be headers. After uploading, you map each of your columns to one of the fields below. You only need to include the columns relevant to the rules you’re changing. Each rule is defined by the combination of conditions you provide – either modifier name/value pairs or variant SKUs (not both in the same numbered slot). When creating a new rule, you need at least two conditions in total and at least a price adjustment or weight adjustment (unless the rule is defined purely by Enabled, Stop, or Purchasing Disabled).
| Column Name | Required? | Notes |
|---|---|---|
| Delete | No | Yes/No. Set to yes to delete the rule. Requires Rule Id. |
| Enabled | No | Yes/No (accepts y, yes, true, 1 / n, no, false, 0). Whether the rule is active. |
| Modifier Name 1-20 | No | The option (modifier) name that helps define the rule (e.g., “Size”). Must already exist on the product. Goes with Modifier Value in the same numbered slot. |
| Modifier Value 1-20 | No | The option value paired with the matching Modifier Name (e.g., “Large”). Required whenever its Modifier Name is set. |
| Price Adjuster Adjuster | No | How the price is adjusted (relative or fixed adjustment, as supported by BigCommerce). |
| Price Adjuster Adjuster Value | No | Numeric. The amount of the price adjustment. |
| Purchasing Disabled | No | Yes/No. Turns off purchasing for the matched option combination. |
| Purchasing Disabled Message | No | Message shown to shoppers when purchasing is disabled. |
| Rule Id | No | Include to update or delete an existing rule. Leave blank to create a new rule. |
| Sku | Yes | The product’s SKU. Used to find the product the rule belongs to. |
| Sku 1-20 | No | A variant SKU that defines the rule instead of a modifier name/value. Must already exist on the product. Use in place of Modifier Name/Value in the same numbered slot, not both. |
| Sort Order | No | Numeric. Controls the order in which rules apply. |
| Stop | No | Yes/No. Marks the rule as a “stop” rule. |
| Weight Adjuster Adjuster | No | How the weight is adjusted. |
| Weight Adjuster Adjuster Value | No | Numeric. The amount of the weight adjustment. |
Troubleshooting
A row says the SKU wasn’t found
The product SKU in that row doesn’t match a product in your store. Check the SKU and re-upload the affected rows.
A row says a modifier or variant SKU wasn’t found
The Modifier Name, Modifier Value, or variant SKU you listed must already exist on that product in BigCommerce. Create or correct the option/variant first, then re-upload.
A row says a modifier name or value is missing
Modifier Name and Modifier Value go together. If you fill in one, you must fill in the other for the same number. Don’t put both a Modifier Name and a Sku in the same numbered slot – choose one.
My delete didn’t work
To delete a rule, the row must be marked to delete (yes) and must include the rule’s Rule Id. Without a Rule Id, the tool doesn’t know which rule to remove.
It says I need at least two conditions
New rules need at least two valid conditions (modifier pairs and/or variant SKUs). If you’re updating an existing rule, include its Rule Id.
The tool says it can’t read my columns
Make sure the very first row of your file contains the column headers, including SKU, Rule Id, Price Adjuster, and Weight Adjuster columns. Fix the header row and re-upload.
I got an API permission error
Your store connection may be missing a required permission. Check out our guide on resolving API permission errors.
Where do my results go?
If you chose email delivery, you receive a note when the import completes. Any rows that couldn’t be processed are listed in a downloadable errors file.