Bulk Import & Export Repricers
Bulk importing repricers helps save time, especially for catalogs with hundreds or thousands of SKUs. This section walks you through every step — from file upload to live activation — and explains how
Step 1: Access the Bulk Import Panel
From the Repricer page, click the Import CSV button. You’ll open the bulk import flow with four sequential steps displayed at the top of the screen.
The steps include:
Select Connection
Upload CSV
Match Products
Adjust Settings
Step 2: Select Connection
Choose which Amazon marketplace or account you want to configure repricers for.
Choose Connection: Select your Amazon account (e.g., “JVAmazon”).
Cancel: Abort the import and return to the main Repricer dashboard.
Continue: Proceed to the next step.
Step 3: Upload CSV File
Drag and drop your .csv file or click inside the upload box to select it manually.
Once uploaded, the system automatically validates the structure of your file.
If the format is correct, you’ll see a confirmation message like “CSV validated successfully.” If there are missing or mislabeled columns, you’ll receive an error prompt.
Ensure your file headers exactly match the required column names to avoid validation errors.
Step 4: Match Products
Step 4: Match Products
SellerMagnet compares the SKUs in your CSV file with those in your Amazon account to confirm which items can be repriced.
Matched Products: SKUs found and ready for repricing.
Unmatched Products: SKUs not found or inactive in Seller Central.
Duplicate Rows: Repeated SKUs within the CSV.
You can go back to fix the file or continue to the next step if everything is correct.
Step 5: Adjust Settings
In this step, you can set your default strategy and choose whether to activate imported repricers immediately.
Strategy: Choose the repricing rule for this batch (e.g., Lowest Price, BuyBox, or BrandGuard).
Activate Repricer: Toggle on to enable the repricers automatically after import.
Back / Cancel: Navigate back or cancel the import.
Apply & Import: Confirm and apply all bulk settings.
Once you click Apply & Import, SellerMagnet processes your file and creates all repricers in bulk. Any errors or unmatched SKUs will be reported for manual correction.
Bulk importing is ideal for sellers managing large catalogs or agencies maintaining multiple accounts. You can upload hundreds of SKUs in seconds while keeping consistent pricing rules.
CSV File Structure (SellerMagnet bulk import file.csv)
The SellerMagnet bulk import file.csv template is used to bulk import all the data needed by the repricer. Each row represents one SKU on one specific marketplace, and the file must contain all of the following columns, in this exact order.
Item SKU
Product SKU from your catalog. Enter one SKU per row; it must match the SKU used in SellerMagnet/Amazon so that the repricer can link it correctly.
Marketplace
Amazon marketplace for this SKU (for example Amazon FR, Amazon DE, Amazon IT). This is used to apply the correct currency, VAT rate and fee structure.
Purchase Price
Net unit cost of the product, excluding VAT and any shipping already included in the inbound cost. This is the base product cost.
FBM Shipping Cost / FBA Fulfillment Fee
Per-unit shipping cost if you sell FBM, or the FBA fulfillment fee if you sell FBA. If you sell FBM and do not want this cost included in the calculations, you can safely enter 0. For FBA, however, you should not leave this field empty: if it is blank, the repricer will use unrealistic reference values and your profit margins will be distorted.
Miscellaneous Cost
Extra fixed cost per unit that is not included in Purchase Price or Shipping, such as special packaging, labels, additional handling, extra logistics, customs duties allocated per unit, external services, etc. This field can be left blank if you do not have extra fixed costs.
Miscellaneous Fee (%)
Additional cost percentage applied only to the Purchase Price. Use this if you prefer to add a percentage uplift instead of a fixed amount (for example to cover payment processing, insurance, general overhead). Enter the value as a percentage in the cell (for example 10% for ten percent). This field can also be left blank if you do not need a percentage component.
Min Margin (%)
Minimum profit margin (as a percentage of the selling price) that you want to keep for this SKU. The repricer will not go below this margin when computing the minimum price. Enter the value as a percentage (for example 15% for fifteen percent).
Max Margin (%)
Maximum profit margin (as a percentage of the selling price) allowed for this SKU. This prevents excessively high prices: the repricer will not exceed this margin when computing the maximum price. Enter the value as a percentage (for example 40%).
VAT (%)
VAT rate for the selected marketplace, as a percentage (for example 20%). Used to correctly calculate your gross prices and margins.
Amazon Fees (%)
Total Amazon fee percentage for this SKU (referral fee plus any other percentage-based Amazon charges). You can estimate this from Amazon fee calculators or your historical data. Enter the value as a percentage (for example 15%).
Technical notes for the CSV file
Every field that requires a percentage (Miscellaneous Fee, Min Margin, Max Margin, VAT, Amazon Fees) must be entered as a percentage in the cell, e.g.
20%to represent a 20% rate.Do not change column names and do not add extra columns: any structural change will prevent the file from being imported.
Always save the file in UTF-8 format to avoid issues with special characters (accented letters, symbols, etc.).
Practical tips for FBA, DSF and margins
Data for FBA Fulfillment Fee can be downloaded directly from the Reports section as a CSV, for each SKU. This allows you to use an average fee based on your actual order history, which is usually much more accurate than a manual estimate.
After repricers have been imported via CSV, you can perfectly synchronise FBA Fulfillment Fee data (for both minimum and maximum margin) and DSF (Digital Services Fee) by:
opening the Edit repricer screen and updating the values for a single rule, or
using the dedicated bulk synchronisation button (coming soon) to update many SKUs in one operation.
By default, repricers imported in bulk calculate profit margins as a percentage of the selling price, not as a markup over the total cost. The alternative mode, where margins are based on a markup over total cost, can be selected when you add or edit a single repricer manually from the SellerMagnet interface.
Exporting Repricers
Use the Export Unsuccessful button to download a list of repricers that are active but currently not winning the BuyBox.
This export lets you analyze underperforming repricers, adjust margins or strategies, and re-import updated data.
When you upload a corrected file:
Existing repricers are automatically updated.
Only modified SKUs are replaced; others remain unchanged.
Last updated