Bulk Import & Export
Mass-configure repricer rules using CSV import, and export existing configurations for backup, auditing, or cross-marketplace migration.
Difficulty: 🔴 Advanced · Reading time: ~7 min
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.
📋 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
Navigate to the Repricer page from the left menu.
In the Items Table toolbar, look for the Import and Export buttons.
📤 Export
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 below.
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:
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
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:
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.
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.
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:
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
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
Validation Rules
The import system checks for:
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.
Note: To update only specific fields, export first, modify the columns you want to change, and re-import. Unchanged columns retain their current values.
💾 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."
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.
Reading the preview
Each SKU is listed with a checkbox, its current cost → new cost, and a status badge:
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.
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.
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.
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.
🎯 Realistic Example
Scenario: You sell 500 products on Amazon.de and want to set up repricers for all of them with the BuyBox strategy.
Export your current catalog from Seller Central (or use SellerMagnet's product export).
Open the file in Excel / Google Sheets.
Add the required columns: Strategy (
buybox), Min Price (calculated per product), Max Price (e.g., 2x your cost).Save as CSV.
Click Import on the Repricer page.
Review the preview: 493 rules valid, 7 flagged (SKU mismatches).
Fix the 7 issues, re-upload.
All 500 repricers activate simultaneously.
Time saved: ~8 hours of manual wizard configuration reduced to ~30 minutes of spreadsheet work.
⚠️ Common Mistakes to Avoid
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
Always export before importing: This creates a backup you can restore if the import produces unexpected results.
Use the exported file as your template: It guarantees correct column names and format.
Validate in Excel first: Use conditional formatting to flag rows where Min Price >= Max Price or where required fields are empty.
Start with a small test batch: Import 10-20 rules first, verify they work correctly, then import the full batch.
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?
Create & Manage Repricer RulesRepricer OverviewLast updated