Imports are a great way to save time and bulk edit products in your Repricer.com account using the template provided.
This help file will guide you through updating products in bulk through an Amazon import.
Before you start
- You need to have a Repricer.com account. To find out how to create one, click here.
- You’ll need to have Amazon added as a marketplace. If you want to find out more about connecting Amazon to Repricer.com, click here.
Note: if you're trying to import a file for eBay, click here.
Related Videos
The following video covers the same content as this article,
01 Imports Screen
It's very easy to access the Imports screen within your Repricer.com account, simply follow the simple instructions below:- Click on Imports at the bottom left of the screen.
- Select the Amazon tab.
Once on the tab, you will go through a 3 step process.
02 Download your Amazon Product Data.
In this section, you will be able to click the orange Download Template button to retrieve the import file containing all of the Amazon products currently in your Repricer.com account.
The file will look as follows:
There would be two different types of Product Templates depending upon which Repricer plan you are on. The Basic/Plus template, and the Ultimate/Extreme template. To find out more about Subscription Plans, click here.
Each template contains the following columns:
-
Basic/Plus Template: SKU, Marketplace, Merchant_ID, Price_Min, Price_Max, Repricer_Name, Estimated_Seller_Count, Lowest_Landed_Price, My_Price, My_Shipping, FBA, ASIN, Open_Date, Last_Sale, Quantity
-
Ultimate/Extreme Template: SKU, Marketplace, Merchant_ID, Price_Min, Price_Max, Unit_Cost, Unit_Currency, Shipping_Cost, Shipping_Currency, Pickpack_Cost, Pickpack_Currency, RRP_Price, RRP_Currency, VAT_Rate, Fee_Listing, FBA_Fee, FBA_Currency, Repricer_Name, Estimated_Seller_Count, Lowest_Landed_Price, My_Price, My_Shipping, FBA, ASIN, Open_Date, Last_Sale, Quantity
03 Update your Amazon Product Data.
Now that you downloaded the file, you will be able to work on it and make the changes you want.
-
Required Columns (all plans)
The following template columns are required in any upload when making a change to the template data. Deleting the header column row will make the Product Template invalid. The required columns are dependent upon which Repricer plan you are on.
-
SKU: This is pre-populated with the SKU that you use on Amazon.
-
Marketplace: The marketplace in which the product is sold (e.g. AUK is Amazon UK).
-
Merchant_ID: Your Amazon Merchant/Seller ID.
-
FBA: The FBA (Fulfilled by Amazon) status of each of your SKUs. This will be in a Yes or No format. Yes means that the SKU is FBA, while No means that the SKU is not FBA. This is pre-populated from Amazon on the file.
-
Optional Columns
-
Price_Min: The minimum landed price (shipping included) that you are prepared to sell at. Enter this in the local currency for each marketplace. i.e. for Amazon UK, you would calculate your Min/Max prices in GB Pounds.
-
Price_Max: The maximum landed price (shipping included) that you want to sell at. In the absence of any competition, this price will apply. Enter this in the local currency for each marketplace. i.e. for Amazon UK, you would calculate your Min/Max prices in GB Pounds.
-
Repricer_Name: The name of the repricer rule that wish to apply to this SKU. The names of your repricers can be found in the Repricing Rules tab.
-
(Extreme and Ultimate only)
Ultimate and Extreme user templates have additional cost-based required columns compared to Basic/Plus users. While all cost-based fields do not have to be filled in for the upload to be successful, the column headers must remain on the template file.
-
Unit_Cost: This is your product purchase price, excluding any additional fees (shipping, fulfilment, warehousing, etc.). This figure is needed to calculate your profits (see note below).
-
Unit_Currency: This is the currency used to purchase the product (i.e. USD, EUR, GBP, CAD). Conversion rates are automatically updated each day to preserve your margins (see note below).
-
Shipping_Cost: Cost of shipping the product to your customers. It is an optional field but you should enter a value here for accurate profit calculation.
-
Shipping_Currency: This is the currency used to ship the product (i.e. USD, EUR, GBP, CAD). Conversion rates are automatically updated each day to preserve your margins.
-
Pickpack_Cost: Pick and pack cost of each unit according to your own internal calculations. You can fill this in for a more accurate calculation of profit on each sale.
-
Pickpack_Currency: This is the currency used in relation to the pick and pack costs associated with the product (i.e. USD, EUR, GBP, CAD). Conversion rates are automatically updated each day to preserve your margins.
-
RRP_Price: The Recommended Retail Price (RRP) of the product. This can be used if you would like to to set your maximum sale price according to the RRP.
-
RRP_Currency: This is the currency used in relation to the RRP of the product (i.e. USD, EUR, GBP, CAD). Conversion rates are automatically updated each day to preserve your margins.
-
VAT_Rate: The rate of Value Added Tax to apply (a number between 0 and 100). This is usually set to zero outside Europe.
-
FEE_Listing: Amazon's listing fee for this SKU (e.g. use 15 for 15% listing fee).
-
FBA_Fee: Amazon's FBA fee for fulfillment. Only required for FBA-type SKU. Note that Amazon's actual charge will be used instead when available. This can take up to 24 hours after the product is initially listed.
-
FBA_Currency: This is the currency used in relation to the FBA fees paid on the product (i.e. USD, EUR, GBP, CAD). Conversion rates are automatically updated each day to preserve your margins.
-
Informative Columns
The following columns are for informational purposes and are not required when uploading the Product Import template file. Changes to these fields will not be pushed onto Repricer.
-
Estimated_Seller_Count: The estimated number of competitor sellers on this product.
-
Lowest_Landed_Price: The estimated lowest landed price (shipping price included) that this product is currently selling for on Amazon.
-
My_Price: The current price that your product is selling for on Amazon.
-
My_Shipping: The current shipping price to your customers that you have inputted into your Amazon Seller Central account. If this amount is 0, then free shipping has been offered.
-
ASIN: The ASIN (Amazon Standard Identification Number) of the SKU.
-
Open_Date: The date that the SKU was first listed on Amazon.
-
Last_Sale: The date that the last sale of the SKU occurred.
-
Quantity: The amount of this product that you currently have inputted within your Seller Central account. The quantity value field will only change the values shown on Repricer. They will not manipulate the live information on your sSeller Central account.
04 Import your updated Amazon Product Data.
Once you're happy with your file, you can then re-import it to your Repricer.com account.
- If your file is successfully imported:
The import screen will then change to the following and the Repricer.com will start processing your file.
You will then be able to check the progress of the import (if the file did not immediately import) in the Recent Imports screen and download a copy of any prior files they have imported.
- If your file is not successfully imported:
To find out why the file didn't import, it might be worth checking the following:-
All columns are present and headers are correct in the file.
-
The mandatory fields are present.
-
Readable columns don't have the wrong data present.
-
Changeable data has been changed.
Further Readings
If you would like to find out more about creating Minimum and Maximum prices on Repricer.com, click here.
Interested to find out more about Bulk Uploads with Repricer.com, click here.
