# Bulk Import & Export
{% hint style="info" %}
**Difficulty:** ๐ด Advanced ยท **Reading time:** \~7 min
{% endhint %}
{% hint style="success" icon="rocket" %}
**Best practice : start from an Export, not a blank CSV.** Before you write a single row, click **Export โ Products & Fees** in the Repricer toolbar. This downloads a **pre-filled template** with every synced product, their real Amazon fees (referral + FBA), VAT rates, and current prices already populated. You only need to fill in **Min Price**, **Max Price**, and **Strategy**, everything else is done for you. This one step saves hours and eliminates \~90% of validation errors.
{% endhint %}
## ๐ Overview
The **Bulk Import & Export** feature lets you create, update, and back up repricer configurations at scale using CSV files. Instead of configuring hundreds of repricer rules one by one through the wizard, you can prepare a spreadsheet offline and upload it in a single action.
This is essential for sellers with large catalogs, multi-marketplace operations, or teams that need to review and approve repricing configurations before they go live.
***
## Accessing Bulk Operations
1. Navigate to the **Repricer** page from the left menu.
2. In the Items Table toolbar, look for the **Import** and **Export** buttons.
***
## ๐ค Export
### What Gets Exported
Clicking **Export** downloads a CSV file containing every active and paused repricer rule in your account:
| Column | Description |
| ------------------------------------------------ | -------------------------------------------------------------- |
| **ASIN (Amazon Standard Identification Number)** | Amazon Standard Identification Number |
| **SKU (Stock Keeping Unit)** | Your Seller Central SKU for the listing |
| **Marketplace** | Amazon marketplace code (e.g., `A1PA6795UKMFR9` for Amazon.de) |
| **Condition** | New or Used |
| **Strategy** | Strategy name (e.g., `buybox`, `brandguard`) |
| **Min Price** | Minimum price boundary |
| **Max Price** | Maximum price boundary |
| **Current Price** | The listing's current Amazon price |
| **Status** | Active or Paused |
| **FBA/FBM** | Fulfillment type |
### Export Use Cases
| Use Case | Description |
| ------------------------------- | -------------------------------------------------------------- |
| **Backup** | Save a snapshot of all rules before making bulk changes |
| **Audit** | Share the file with team members for review and approval |
| **Cross-marketplace migration** | Copy configurations to adapt for a different marketplace |
| **Spreadsheet analysis** | Open in Excel/Google Sheets to sort, filter, and analyze rules |
***
## Import
### Preparing Your Import File
Use the exported CSV as a template. Each row represents one repricer rule. Modify existing rows or add new ones.
**Required columns for new rules:**
| Column | Required | Format |
| --------------- | -------- | ------------------------------------------------------ |
| **ASIN** | Yes | 10-character ASIN |
| **SKU** | Yes | Must match your Seller Central SKU exactly |
| **Marketplace** | Yes | Amazon marketplace identifier |
| **Condition** | Yes | `new` or `used` |
| **Strategy** | Yes | Strategy code (see strategy reference table below) |
| **Min Price** | Yes | Decimal number in marketplace currency (e.g., `19.99`) |
| **Max Price** | Yes | Decimal number, must be greater than Min Price |
| **Status** | No | `active` or `paused` (defaults to `active` if omitted) |
### Strategy Codes Reference
| Code | Category | Description |
| ----------------- | ---------- | ----------------------------------------------------------- |
| `buybox` | Reseller | Aggressive Buy Box winning |
| `position` | Reseller | Competitive pricing with margin protection |
| `lowest_price` | Reseller | Match or beat the lowest price |
| `same_price` | Reseller | Match only FBA competitors |
| `brandguard` | Brand / PL | MAP (Minimum Advertised Price) enforcement for brand owners |
| `competitor_sync` | Brand / PL | Stable pricing with controlled adjustments |
| `brandguard` | Brand / PL | Premium positioning above competitors |
### Uploading the File
{% stepper %}
{% step %}
#### Click the **Import** button in the Repricer toolbar.
{% endstep %}
{% step %}
#### Select your prepared CSV file (or drag and drop it into the upload area).
{% endstep %}
{% step %}
#### A preview screen shows the parsed rules with validation status.
{% endstep %}
{% step %}
#### Review any warnings or errors (highlighted rows indicate issues).
{% endstep %}
{% step %}
#### Click **Confirm Import** to create or update the rules.
{% endstep %}
{% endstepper %}
### Validation Rules
The import system checks for:
| Validation | Error if Violated |
| --------------------------------------- | ------------------------------------------------ |
| Min Price > 0 | "Minimum price must be greater than zero" |
| Max Price > Min Price | "Maximum price must exceed minimum price" |
| Valid ASIN format | "Invalid ASIN format" |
| SKU exists in Seller Central | "SKU not found in your catalog" |
| Valid strategy code | "Unknown strategy code" |
| No duplicate ASIN+Marketplace+Condition | "Duplicate rule detected" |
| Quota not exceeded | "Import would exceed your plan's repricer limit" |
***
## Updating Existing Rules via Import
If the import file contains an ASIN + Marketplace + Condition combination that already exists as a repricer rule, the system **updates** the existing rule rather than creating a duplicate. This lets you bulk-modify strategies or price boundaries.
{% hint style="info" icon="circle-info" %}
**Note:** To update only specific fields, export first, modify the columns you want to change, and re-import. Unchanged columns retain their current values.
{% endhint %}
***
## ๐ฏ Realistic Example
**Scenario:** You sell 500 products on Amazon.de and want to set up repricers for all of them with the BuyBox strategy.
1. **Export** your current catalog from Seller Central (or use SellerMagnet's product export).
2. Open the file in Excel / Google Sheets.
3. Add the required columns: Strategy (`buybox`), Min Price (calculated per product), Max Price (e.g., 2x your cost).
4. Save as CSV.
5. Click **Import** on the Repricer page.
6. Review the preview: 493 rules valid, 7 flagged (SKU mismatches).
7. Fix the 7 issues, re-upload.
8. All 500 repricers activate simultaneously.
**Time saved:** \~8 hours of manual wizard configuration reduced to \~30 minutes of spreadsheet work.
***
โ ๏ธ Common Mistakes to Avoid
| Mistake | Why It Hurts |
| -------------------------------------------- | ----------------------------------------------------------------- |
| Using commas instead of periods for decimals | CSV parsing fails or prices are incorrect |
| Forgetting to match SKUs exactly | Rules are rejected because the SKU does not exist in your catalog |
| Importing without exporting first | No backup to revert to if something goes wrong |
| Setting the same min and max price | The repricer has no room to adjust prices |
| Not checking the validation preview | Errors slip through and rules are not created as expected |
\## โ
Best Practices
1. **Always export before importing:** This creates a backup you can restore if the import produces unexpected results.
2. **Use the exported file as your template:** It guarantees correct column names and format.
3. **Validate in Excel first:** Use conditional formatting to flag rows where Min Price >= Max Price or where required fields are empty.
4. **Start with a small test batch:** Import 10-20 rules first, verify they work correctly, then import the full batch.
5. **Version your import files:** Name files with dates (e.g., `repricer-import-2026-04-12.csv`) for audit trail.
***
## โ FAQ
Can I import rules for multiple marketplaces in one file?
Yes. Include the marketplace identifier in each row. The system processes all marketplaces in a single import.
What happens to existing rules that are not in the import file?
They are unaffected. The import only creates or updates rules for ASIN + Marketplace + Condition combinations present in the file.
Is there a maximum file size for import?
The practical limit is 10,000 rows per import file. For larger catalogs, split into multiple batches.
Can I delete rules via import?
No. Deletion is handled through the dashboard interface (individual or bulk delete). The import only creates and updates.
What file encoding should I use?
UTF-8. This ensures special characters in product names and non-ASCII SKUs are handled correctly.
Can I schedule automatic imports?
Not currently. Imports are manual. For automated repricing setup, use the API (available on Enterprise plans).
***
## โก๏ธ What's Next?
{% content-ref url="/pages/OeeKq8tIohsSPfiBCG9n" %}
[Create & Manage Repricer Rules](/selling-tools/repricer-overview/create-manage-repricer.md)
{% endcontent-ref %}
{% content-ref url="/pages/XxiOnXmNvAunjLWPxJPP" %}
[Repricer Overview](/selling-tools/repricer-overview.md)
{% endcontent-ref %}
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.sellermagnet.com/selling-tools/repricer-overview/bulk-import-export.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.