Imports are a great manner to save time and bulk edit products in your Repricer.com business relationship using the template provided.

This help file will guide y'all through updating products in majority through an Amazon import.

Before you start

  • Y'all need to have a Repricer.com business relationship. To find out how to create one, click here.
  • You'll need to take Amazon added as a marketplace. If you want to detect out more than about connecting Amazon to Repricer.com, click hither.

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

01 Imports Screen

It's very easy to admission the Imports screen inside your Repricer.com business relationship, but follow the simple instructions beneath:

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

Once on the tab, you will become through a iii footstep process.

02 Download your Amazon Product Data.

In this department, you will exist 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 wait equally 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/Farthermost template. To find out more nearly Subscription Plans, click here.

Each template contains the post-obit columns:

  • Bones/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 volition be able to work on it and make the changes you want.

  • Required Columns (all plans)

The following template columns are required in whatever upload when making a alter to the template data. Deleting the header cavalcade row volition make the Product Template invalid. The required columns are dependent upon which Repricer plan y'all are on.

  • SKU: This is pre-populated with the SKU that you use on Amazon.

  • Marketplace: The market in which the production is sold (due east.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 Y (yeah) orN (no) format. Y means that the SKU is FBA, while N means that the SKU is not FBA. This is pre-populated from Amazon on the file.

  • Optional Columns

The post-obit template columns are not required in any upload merely if you do wish add together information to these, you need to include the header.

  • Price_Min: The minimum landed price (aircraft included) that y'all are prepared to sell at. Enter this in the local currency for each market place. 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 price (shipping included) that you want to sell at. In the absenteeism of any contest, this cost will utilise. 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 tin can be plant in the Repricing Rules tab.

  • (Farthermost and Ultimate only)

Ultimate and Farthermost user templates have additional cost-based required columns compared to Basic/Plus users. While all price-based fields do not have to exist filled in for the upload to be successful, the cavalcade headers must remain on the template file.

  • Unit_Cost: This is your product buy cost, excluding any additional fees (shipping, fulfilment, warehousing, etc.). This figure is needed to calculate your profits (see notation below).

  • Unit_Currency: This is the currency used to purchase the product (i.due east. USD, EUR, GBP, CAD). Conversion rates are automatically updated each day to preserve your margins (see note below).

  • Shipping_Cost: Cost of shipping the production to your customers. It is an optional field but you should enter a value here for accurate turn a profit adding.

  • Shipping_Currency: This is the currency used to ship the production (i.e. USD, EUR, GBP, CAD). Conversion rates are automatically updated each day to preserve your margins.

  • Pickpack_Cost: Pick and pack price of each unit according to your own internal calculations. You can fill this in for a more accurate calculation of turn a 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 tin 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 production (i.e. USD, EUR, GBP, CAD). Conversion rates are automatically updated each twenty-four hours to preserve your margins.

  • VAT_Rate: The rate of Value Added Revenue enhancement to use (a number between 0 and 100). This is commonly set to zero exterior Europe.

  • FEE_Listing: Amazon'south listing fee for this SKU (eastward.g. use xv for fifteen% list fee).

  • FBA_Fee: Amazon's FBA fee for fulfillment. Merely required for FBA-blazon SKU. Note that Amazon's actual charge will be used instead when bachelor. This tin 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.eastward. USD, EUR, GBP, CAD). Conversion rates are automatically updated each twenty-four hour period to preserve your margins.

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

  • Informative Columns

The following columns are for informational purposes and are not required when uploading the Production Import template file. Changes to these fields will not exist pushed onto Repricer.

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

  • Lowest_Landed_Price: The estimated lowest landed price (shipping toll 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 electric current shipping price to your customers that you lot have inputted into your Amazon Seller Central account. If this amount is 0, and 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 yous currently have inputted within your Seller Central account. The quantity value field will only change the values shown on Repricer. They volition not dispense the live information on your sSeller Cardinal business relationship.

04 Import your updated Amazon Product Data.

In one case yous're happy with your file, you tin and then re-import it to your Repricer.com account.

  • If your file is successfully imported:

The import screen volition so change to the following and the Repricer.com will start processing your file.
Yous volition so be able to check the progress of the import (if the file did non immediately import) in the Recent Imports screen and download a re-create of any prior files they have imported.

  • If your file is not successfully imported:

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

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

  • Changeable information has been changed.

Farther Readings

If you would like to find out more than about creating Minimum and Maximum prices on Repricer.com, click hither.

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