Imports are a great way to salve time and bulk edit products in your Repricer.com account using the template provided.

This assist file volition guide you through updating products in majority through an Amazon import.

Before you start

  • You demand to accept a Repricer.com account. To find out how to create ane, click here.
  • You'll need to take Amazon added every bit a market place. If y'all want to detect out more about connecting Amazon to Repricer.com, click here.

Note: if you're trying to import a file for eBay, click here.

01 Imports Screen

It's very easy to access the Imports screen within your Repricer.com business relationship, simply follow the uncomplicated instructions below:

  1. Click on Imports at the lesser left of the screen.
  2. Select the Amazontab.

Once on the tab, you will go through a 3 stride process.

02 Download your Amazon Product Data.

In this section, you will be able to click the orangish Download Template button to retrieve the import file containing all of the Amazon products currently in your Repricer.com account.
The file volition look every bit follows:
In that location would exist ii different types of Product Templates depending upon which Repricer plan you are on. The Bones/Plus template, and the Ultimate/Extreme template. To find out more near 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 lot downloaded the file, you lot will be able to piece of work on it and make the changes y'all desire.

  • 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 (east.g. AUK is Amazon Britain).

  • Merchant_ID: Your Amazon Merchant/Seller ID.

  • FBA: The FBA (Fulfilled by Amazon) status of each of your SKUs. This will be in a Y (yes) orN (no) format. Y means that the SKU is FBA, while N means that the SKU is non FBA. This is pre-populated from Amazon on the file.

  • Optional Columns

The following template columns are not required in any upload but if you exercise wish add together information to these, you need to include the header.

  • 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 United kingdom of great britain and northern ireland, you would calculate your Min/Max prices in GB Pounds.

  • Price_Max: The maximum landed cost (shipping included) that you want to sell at. In the absence of any competition, this price volition utilize. 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 use to this SKU. The names of your repricers can be found in the Repricing Rules tab.

  • (Extreme and Ultimate only)

Ultimate and Farthermost user templates have additional cost-based required columns compared to Basic/Plus users. While all cost-based fields practice not have to exist 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 buy the product (i.east. USD, EUR, GBP, CAD). Conversion rates are automatically updated each twenty-four hours to preserve your margins (meet note below).

  • Shipping_Cost: Cost of shipping the product to your customers. It is an optional field just 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 twenty-four hour period to preserve your margins.

  • Pickpack_Cost: Choice and pack price of each unit according to your own internal calculations. You tin can fill this in for a more authentic adding 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 twenty-four hours to preserve your margins.

  • RRP_Price: The Recommended Retail Price (RRP) of the product. This can be used if y'all would similar to to gear up your maximum sale price according to the RRP.

  • RRP_Currency: This is the currency used in relation to the RRP of the product (i.due east. USD, EUR, GBP, CAD). Conversion rates are automatically updated each twenty-four hours to preserve your margins.

  • VAT_Rate: The rate of Value Added Tax to apply (a number between 0 and 100). This is commonly set up to zero outside Europe.

  • FEE_Listing: Amazon'due south listing fee for this SKU (e.g. employ 15 for 15% listing fee).

  • FBA_Fee: Amazon's FBA fee for fulfillment. Just required for FBA-type SKU. Note that Amazon's bodily accuse will be used instead when available. This can take upward 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 solar day to preserve your margins.

Note:If the Unit_cost field is used then the Unit_currency field becomes mandatory.

  • Informative Columns

The post-obit columns are for advisory purposes and are non required when uploading the Product Import template file. Changes to these fields volition not be pushed onto Repricer.

  • Estimated_Seller_Count: The estimated number of competitor sellers on this production.

  • 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 production is selling for on Amazon.

  • My_Shipping: The current shipping price to your customers that you lot take inputted into your Amazon Seller Central account. If this amount is 0, and then gratis shipping has been offered.

  • ASIN: The ASIN (Amazon Standard Identification Number) of the SKU.

  • Open_Date: The appointment that the SKU was first listed on Amazon.

  • Last_Sale: The date that the final sale of the SKU occurred.

  • Quantity: The amount of this production that you lot currently take inputted inside your Seller Cardinal business relationship. The quantity value field volition only alter the values shown on Repricer. They will not manipulate the live information on your sSeller Central account.

04 Import your updated Amazon Product Information.

Once y'all're happy with your file, you can and so re-import it to your Repricer.com business relationship.

  • If your file is successfully imported:

The import screen volition then change to the following and the Repricer.com will start processing your file.
Y'all 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 re-create of whatsoever prior files they have imported.

  • If your file is not successfully imported:

The import screen will so change to the following.
To observe 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 nowadays.

  • Readable columns don't have the wrong data present.

  • Changeable data has been changed.

Further Readings

If you lot would like to find out more nigh creating Minimum and Maximum prices on Repricer.com, click here.

Interested to find out more than about Bulk Uploads with Repricer.com, click hither.