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 eBay 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 eBay added as a marketplace. If you want to find out more about connecting eBay to Repricer.com, click here.
Note: if you're trying to import a file for Amazon, click here.
The following video covers the same content as this article,
01 Imports ScreenIt'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 eBay tab.
Once on the tab, you will go through a 3 step process:
02 Download your eBay 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 eBay products currently in your Repricer.com account.
The file will look as follows:
03 Update your eBay Product Data.
Now that you downloaded the file, you will be able to work on it and make the changes you want.
The column headers are:
Marketplace* (READ): the marketplace in which the product is sold.
Store* (READ): the name of your eBay store.
SKU* (READ): this is pre-populated with the SKU (custom label) you use on eBay.
Price_Min (CHANGE): 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 (CHANGE): the maximum 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
My_Price: the current price that your product is selling for on eBay.
Quantity: the amount of this product that you currently have inputted within your Seller Central account
Title: the title of the product on eBay.
eBay_item_ID: the number ID of the item on eBay.
Rule* (CHANGE): the name of the Repricing Rule that you want to apply to this SKU. The names of your Rules can be found in the Repricing Rules tab.
Note: they have to exactly match - if there is a capital letter in your Repricing Rule, it needs to be entered in your CSV also. If you do not want to assign a Repricing Rule to a product, then you must populate the relevant field with Off.
Shipping_cost: the current shipping price for your customers that you have inputted on eBay
⇒ All fields marked with * are compulsory. A blank value in any of these columns will flag them as invalid and it will cause the file to fail to import.
⇒ All fields marked with (CHANGE) are changeable. This means that changing these fields on the file then importing it will apply the changes to Repricer.com.
⇒ All fields marked with (READ) are readable. This data is used to check which marketplace, SKU, etc is being updated. Changes to these values on the sheet will not be changed on Repricer when the file is imported. (They may cause the import to break if not set correctly though).
Note 2: all columns need to be present and in the right order in the file for it to import correctly.
04 Import your updated eBay Product Data.
Once you're happy with your file, you can then re-import it in 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.
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.