> For the complete documentation index, see [llms.txt](https://docs.sellermagnet.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sellermagnet.com/selling-tools/repricer-overview/bulk-import-export.md).
# 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
{% hint style="info" icon="circle-info" %}
**CSV or Excel.** The **Export** button is a split menu, after choosing what to export you pick **CSV** or **Excel (.xlsx)**. Both formats contain the same columns; only the file type differs. See [Choosing a format](#choosing-a-format) below.
{% endhint %}
### What Gets Exported
Clicking **Export** opens the **Export options** modal where you choose what to export (a *Products & Fees* template, a blank import template, or your *current repricers*). The current-repricers export contains 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 |
### Choosing a Format
When you click **Export**, the download button offers two formats with **identical columns**, the only difference is the file type:
| Format | File type | Best for |
| --------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **CSV** | `.csv` | Re-importing into SellerMagnet, feeding into another tool, or any plain-text pipeline. CSV is the format the importer reads, so always choose CSV if the file is going to be edited and uploaded back. |
| **Excel** | `.xlsx` | Reading, sorting, filtering, sharing with your team, or sending to a supplier. Opens cleanly in Excel / Google Sheets with proper columns and no parsing setup. |
{% hint style="warning" icon="triangle-exclamation" %}
**One exception:** the blank **Import template** mode always downloads as CSV, because it exists to be filled in and re-imported. The *Products & Fees* and *Current repricers* modes both honour your CSV / Excel choice.
{% endhint %}
> **Recommendation:** Export to **Excel** for human review and to **CSV** for any round-trip that ends in a re-import. Whichever you pick, the data is the same, so a backup taken as Excel is just as complete as one taken as CSV.
***
## 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 |
| ------------------ | ---------- | ------------------------------------------------------------------------------------ |
| `lowest` | Reseller | Always be the cheapest offer, undercutting the lowest competitor within your min/max |
| `buybox` | Reseller | Win and hold the Buy Box at the highest profitable price |
| `position` | Reseller | Hold a target price rank (e.g. 2nd lowest) among all sellers |
| `same` | Reseller | Mirror a specific seller's price by their Seller ID |
| `brandguard` | Brand / PL | Demand-, stock-, and competitor-ASIN-driven brand pricing |
| `competitor_sync` | Brand / PL | Sync to a competitor ASIN's Buy Box price times an adjustment factor |
| `velocity_balance` | Brand / PL | Demand-driven pricing from your own sales rate, no competitor required |
### 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 %}
***
## ๐พ Saving imported costs to your products (COGS sync)
The purchase price you put in an import file lives inside the Repricer. SellerMagnet can also copy it onto the **product itself** as its cost of goods (COGS), so the Products tab and every profit/analytics screen use the same cost - with no double entry.
After a successful import, if the rules you just created have a purchase price, a dialog asks **"Save these costs to your products?"** - *"Right now these purchase prices only exist inside the repricer. Save them on the products too, so the products tab and your profit analytics use them."*
{% hint style="info" icon="circle-info" %}
The same prompt appears when you create a repricer manually, or when you edit a repricer and **change** its purchase price - it only offers the SKUs whose price actually changed.
{% endhint %}
### Reading the preview
Each SKU is listed with a checkbox, its **current cost โ new cost**, and a status badge:
| Badge | Meaning |
| ------------------------------ | ------------------------------------------------------------------------------------------------------------------ |
| **No product cost yet** | The product has no cost on record. These rows are **pre-ticked** - saving is safe. |
| **Updates existing flat cost** | A flat cost already exists and differs. Ticking replaces it. |
| **Overrides batch costs** | The product uses inventory **batch** costs. Saving a flat cost overrides those batches in ALL profit calculations. |
| **Multiple prices - pick one** | The same SKU appears at more than one price in the file - choose which price to save. |
| **Already in sync** | The product cost already matches - nothing to do (row disabled). |
| **Current cost unknown** | The current cost couldn't be read - left unticked so nothing is overwritten by accident. |
{% hint style="warning" %}
Rows marked **"Overrides batch costs"** already have inventory batches. Only tick those if you really want one flat cost to replace your batch costs everywhere. **Rows that would change or override an existing cost are never saved unless you tick them yourself** - only "No product cost yet" rows are pre-selected.
{% endhint %}
Tick the rows you want and click **Save to products (N)**, or choose **Not now** to skip. Only the purchase price is written; it becomes the product's flat cost and is enabled automatically.
### Remembering your choice
The **"Next time"** dropdown sets what happens on future imports and edits for this project:
* **Ask me every time** (default) - always show this dialog.
* **Save automatically (only products without any cost)** - silently save the safe "No product cost yet" rows, never touching products that already have a cost.
* **Never ask again** - skip the prompt entirely.
{% hint style="info" icon="circle-info" %}
**Shipping cost is not synced.** The `shipping_cost` column is a Repricer input used for its own min/max price math and (for FBM sellers) profit figures. The "Save to products" action writes only the **purchase price** as COGS - it does not change the product's shipping rate.
{% 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 %}