Importing & Exporting – Download & Edit Your Product Inventory

importing into & exporting from repricer

In this article, we’ll introduce you to the import screen. This will show you how to export your products from Repricer and how to import them back in after making any necessary edits.

There are two ways to download your products, you can either download your entire product inventory under the import screen or if you’d like to download specific products you can do that on the product screen.

Exporting from the Product Screen

First, we’re going to show you how to do this via the product screen.

Open the product screen and filter to the products you would like to download (you can also use the search option if you prefer). 

In this example we’ll filter for Buy Box winners.

export-from-product-screen

Once we have the list of Buy Box winners displayed on the screen, choose the ‘select all’ option which will display everything on this page. You can also choose this option to download everything that’s been filtered, even those not on the screen. Next, choose the ‘bulk edit’ option and choose to download via CSV.

download csv file

If you have a limited number of products on your list this will download the file directly so you will just have it pop up like any download from any other website.

If however, it’s a large number of products this export might take a few minutes in which case you can download the file from the import screen.

Export from the Import Screen

On the Import Screen, you can download all your inventory quickly and easily. 

To do this simply choose this ‘Download Amazon Template’ option. This will download a template file with all of your listed products.

download amazon template

In the downloaded file you can see there are a number of columns that contain all the information about your product inventory. However, don’t get overwhelmed as you won’t need most of these.

exported csv file

To make this as easy as possible you can remove columns you don’t want to work with or don’t need. 

Let’s quickly run through what options there are you can edit.

Firstly, there are your Price Min/Max fields, which you can use to update these values in the system.

Next, there are a number of fields that relate to your cost price. This is not only your unit cost but others including shipping, pick pack and also fees. Beyond these you have your various repricing rule options and finally there are a number of informational columns that provide information on your listings.

Let’s say we just want to update the Price Min/Max prices and the repricing rule. So we’ll quickly run through the spreadsheet and remove any columns we don’t need. Now, we don’t want to remove all the columns as there are certain fields required for us to match up your product, which are SKU, Marketplace, Merchant ID and FBA fields. Ensure that these fields are included in any file you import otherwise it won’t work.

removing fields on csv file

As well as removing columns you don’t need, you can also remove rows. This is very easy and allows you to reduce the size of your file especially if you have a lot of products.

You may also notice that the SKU field doesn’t fully show the full SKU number. This will need to be changed back into its original form when importing back into Repricer, if not, the field will become permanently corrupted and you’ll need to start again. To do this:

  • Highlight the column
  • Right-click & choose format cells
  • Choose number and change the decimal places to zero 
  • Click OK

Once you have made your changes, you can now save your file and then reopen Repricer to import it.

Import CSV File into Repricer

To import, all you need to do is choose the option to import.

importing csv file

Browse to the file and select it, once the file imports it’ll display success or failure.

If the file however was unsuccessful it would display some feedback as to why on screen. If you’re still having trouble at that stage, get in touch with our support team. They’ll be more than happy to help.

Ronan White
Ronan White
SEO and content marketing executive at Repricer. Loves cycling, cinema, a few beers and all things outdoors.
Condividi questo articolo
Una soluzione dedicata per aiutare i rivenditori online a crescere più velocemente e a vendere di più!

Repricer

Riprezzamento automatico su Amazon per rimanere competitivi 24 ore su 24, 7 giorni su 7. Vincete la Buy Box e moltiplicate i vostri guadagni. Per saperne di più...

Prova gratuita di 14 giorni

Non è richiesta la carta di credito

I più popolari
Indice dei contenuti

Altro da esplorare

informed repricer alternatives
Alternative a Informed.co Repricer

Cercate un repricer Amazon alternativo a Informed.co? Allora abbiamo l’elenco perfetto per voi. Sebbene Informed sia stata un’opzione affidabile per qualche tempo, le recenti modifiche

See our Privacy Notice for details as to how we use your personal data and your rights.