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

Repricer Bulk Import & Export wizard

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

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

1

Click the Import button in the Repricer toolbar.

2

Select your prepared CSV file (or drag and drop it into the upload area).

3

A preview screen shows the parsed rules with validation status.

4

Review any warnings or errors (highlighted rows indicate issues).

5

Click Confirm Import to create or update the rules.

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

Create Repricer modal: strategy, cost basis, and live price preview

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.

---

🎯 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?

Create & Manage Repricer RulesRepricer Overview