The Import feature in Repricer allows you to download and upload either your entire inventory or segments of your inventory using a .CSV file. It is an easy way to manage your products in bulk, with the ability to specify values for fields such as Min Price, Max Price, Repricing Rules and many more.
1) Downloading Your Product Template
Before uploading a .CSV with new data, you first need to download your Product Template on .CSV file. This will include your products and a number of columns, allowing you to make the changes that you desire.
1A) Download Entire Inventory
Go to the Import page and select the Download Template button under Step 1. This option will download all of your products, across all of your marketplaces, into a single file. For Repricer Extreme users with over 500,000 products, we will automatically split your products into files containing 500,000 products each).
1B) Download Specific Products From Your Inventory
Use the Products page’s filters to only show the products that you wish to include in your downloadable CSV template. Then click on Bulk Actions and select Download CSV Template.
2) Updating Your Products
When you have downloaded your CSV Template, you can open and edit it utilising any spreadsheet application, for example: Microsoft Excel, Numbers, Google Sheets, etc. To ensure that your template is processed without any errors, adhere to the following guidelines:
- Do no change the file format: always remember to save your file as a .CSV
- There are four required columns that must remain on your file to re-upload sucessfully. These four columns are: SKU, Marketplace, Merchant_ID, and FBA. All other columns are optional and can be removed.
- For products that you wish to update, you must ensure that all required fields are populated, even if it is just with null (disabled) values. If you wish to make any changes to a specific product, you can just remove the whole row. A full definition of every field can be found later within this guide:
3) Uploading your CSV File
When you are happy with the changes that you have made, save your CSV and upload via Step 3. You can simply drag and drop your CSV file onto the drop area or click on the drop area to choose a file from your computer.
You will see a green notification message if your upload was successful.
You will see a red notification and details of the error if your upload was unsuccessful.
If you have any difficulties, contact us on email@example.com
Within this section, you will find details on the various fields within the CSV Import templates.
Firstly, there are two different versions of the CSV template, depending upon your subscription:
For Basic and Plus users
- For Ultimate and Extreme users
The reason for the two versions is that Ultimate and Extreme users have extra fields relating to these packs' additional features, such as cost-based repricing. You can find more details within the CSV Template Fields table below.
Types of Fields
Within both versions of the template, there are three types of fields: Required, Optional and Informative.
- Required fields must be retained within the template and populated. Every single cell within a Required column must contain data.
- Optional fields are not mandatory, so they do not need to be populated. However, making changes to the values in these fields will impact the data within your Repricer account. These are included to provide a greater level of control over product data.
- Informational fields are included within the template to provide information to assist with editing other fields. These fields do not need to be populated and any changes to these fields will not be reflected within your Repricer account.
The following fields are included in all templates:
|SKU||This is pre-populated with the SKU that you use on Amazon.||Required|
|Marketplace||The marketplace in which the product is sold (e.g. AUK is Amazon UK).||Required|
|Merchant_ID||Your Amazon Merchant/Seller ID.||Required|
|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.||Optional|
|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.||Optional|
|Repricer_Name||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 that 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'.||Optional|
|Estimated_Seller_Count||The estimated number of competitor sellers on this product.||Informational|
|Lowest_Landed_Price||The estimated lowest landed price (shipping price included) that this product is currently selling for on Amazon.||Informational|
|My_Price||The current price that your product is selling for on Amazon.||Informational|
|My_Shipping||The current shipping price for your customers that you have inputted into your Amazon Seller Central account. If this amount is ), then free shipping has been offered.||Informational|
|FBA||The FBA (Fulfilled by Amazon) status of each of your SKUs. 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.||Required|
|ASIN||The ASIN (Amazon Standard Identification Number) of the SKU.||Informational|
|Open_Date||The date that the SKU was first listed on Amazon.||Informational|
|Last_Sale||The date that the last sale of the SKU occurred.||Informational|
|Quantity||The amount of this product that you currently have inputted within your Seller Central account.||Informational|
Ultimate and Extreme Template
For Ultimate and Extreme files, the Cost and Currency columns must be coupled together to successfully upload. For example: Unit_Cost and Unit_Currency must both be uploaded from the same file if you wish to upload your Unit Costs. The same for Shipping_Cost and Shipping_Currency if you wish to upload your Shipping Costs, etc. The following fields are only available for users within Ultimate or Extreme Repricer subscriptions:
|Unit_Cost||This is your product purchase price, excluding any additional fees (shipping, fulfilment, warehousing, etc.). This figure is needed to calculate your profits.||Optional|
|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.||Optional|
|Shipping_Cost||How much it costs you to get the item shipped to your customers. Is is an optional field but you should enter a value here for accurate profit calculation||Optional|
|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.||Optional|
|Pickpack_Cost||How much it costs to take this item off your warehouse shelf and package it up for your customer (This includes the price of the packaging, and also the wages of the person who had to do this work).||Optional|
|Pickpack_Currency||This is the currency used in relation to the pack and pack costs associated with the product (i.e. USD, EUR, GBP, CAD). Conversion rates are automatically updated each day to preserve your margins.||Optional|
|RRP_Price||The Recommended Retail Price (RRP) of the product. This can be used if you would like to set your maximum sale price according to the RRP. You can leave it at 0 otherwise.||Optional|
|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.||Optional|
|VAT_Rate||The rate of Value Added Tax (VAT) to apply. This is usually set to 0 outside of Europe||Optional|
|Fee_Listing||Amazon's listing fee for FBM products (e.g. use 15 for 15% listing fee). This is pulled automatically from Amazon, but may take up to 24 hours to populate after the product is first listed, so it is best to have a value entered here. (If you want to define your own fees, contact us on firstname.lastname@example.org)||Optional|
|FBA_Fee||Amazon's FBA fee for fulfilment. 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.||Optional|
|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.||Optional|