Exports

An export turns your listings into a CSV or Excel file, with the prices, competitors, fees and strategies you choose, ready to open in a spreadsheet.

An export turns your listings into a spreadsheet file. You choose which columns go in it, the Repricer builds the file, and you download it. You can then open it in Excel, Google Sheets, Numbers, or anything else that reads a spreadsheet.

What you get is one row per listing. On that row you can have your prices and your cost, the Buy Box and the competition, the fees and the estimated profit. You can also have the strategy the listing is on, and the dates it was last synced and last repriced. Most people export for one of three reasons. They want to work on their pricing outside the Repricer, or to send a list to someone who does not have an account. Or they want to change a lot of numbers in a spreadsheet and send them back through imports.

You find all of this under Uploads, in the Exports section of the list on the left. The Create export button above the table opens one dialog where you set the whole export up. The table under it lists every export your team has run, with a status on each one.

Before you start

What your role lets you do

What your role does not let you do is hidden rather than grayed out, so you never see a button you cannot use. Roles are set in team, roles and permissions.

Your file is deleted after 14 days

This matters more than it sounds. An export is not a backup and it is not storage. Treat it as something you make, download, and keep somewhere yourself.

How to export

1. 1

   Open the export dialog

   From Uploads, click Exports in the list on the left, then click Create export above the table. A dialog called Export Listings opens with every field already checked.

2. 2

   Choose your fields

   Under Select Fields, click Show on a group to open it, and uncheck what you do not need. Or click one of the buttons under Quick Presets to jump to a ready-made selection.

3. 3

   Narrow it to the listings you want

   Click Add Filters, to the right of Select Fields, build one condition, and click Apply. Skip this step to get every listing you have.

4. 4

   Choose the file format

   Under File Format, click CSV or Excel.

5. 5

   Start it

   Click Export at the bottom of the dialog.

That is the whole flow. Your export appears at the top of the table right away, moves from Pending to Processing while it builds, and shows a Download button when it is ready. You also get an email when it finishes.

Everything below explains that dialog one part at a time. You do not need any of it for a simple export.

Every option in detail

The export dialog has four parts, from top to bottom: Quick Presets, Saved Templates, Select Fields and File Format. Saved Templates only appears once somebody on your team has saved one. The sections below follow that order. The last two are the limits and what an export cannot do.

Start from a preset

Quick Presets is the row of buttons at the top of the export dialog. A preset is a ready-made field selection: click one and it replaces whatever you had checked.

A preset is a starting point and not a lock. Check or uncheck anything you want after that, and the button stops being highlighted the moment your selection stops matching it.

Choose your fields

Select Fields is the middle of the export dialog, and it has nine groups of fields. Click Show on the right of a group to open it, then check or uncheck the fields inside. Each group shows a count of how many of its fields you kept. To do the whole list at once, use Select All and Clear All, on the right of the Select Fields label.

Every field is checked when you arrive, so the work here is taking things out, not putting them in. A field you uncheck is simply not a column in your file.

One thing can stop you unchecking a field. A field used by one of your filters is held in the selection, and its checkbox is disabled until you delete that filter. Adding a filter checks its field for you as well, so the column that explains why a row is in your file is always in your file.

The Export button at the bottom of the export dialog stays gray until at least one field is checked.

Filter which listings you get

Without filters you get every listing in your organization. A filter narrows that down, so you can export one integration, one strategy, or only the listings with no cost on them.

Click the Add Filters button, to the right of Select Fields in the export dialog, and a dialog called Select filters for your export opens. It starts with one empty condition.

The comparisons you get depend on what kind of column you picked.

Type a price the way you would type it in the app. A Value of 25.99 on a price column means 25.99 in the listing’s own currency. The box shows Amount ($) to remind you it wants a plain amount.

Two of the dropdowns are built from your own data. Region lists the regions on the accounts you have connected, and Strategy lists your strategies by name. Pick an Integration first and both of them narrow to match it, and a Strategy that no longer fits the integration you picked is cleared for you.

A condition you only half filled in is thrown away when you click Apply, and nothing tells you it happened. If your file has more rows than you expected, reopen Add Filters and check that every condition still has all three parts.

Choose the file format

File Format is near the bottom of the export dialog, with two buttons. CSV is the one it opens on.

Choose Excel if you are going to open the file and work in it, because it comes out as one sheet ready to read. Choose CSV if you are going to feed the file to another system, because plain text is the format everything reads.

The button says Excel, and what you get is a file ending in .xlsx. The exports table calls the same thing XLSX in its Format column.

Save a setup as a template

If you build the same export every week, save it once and load it next time. Save as Template appears under File Format in the export dialog as soon as your setup stops matching a preset, or as soon as you add a filter. Click it, type a name of up to 250 characters, and click Save.

From then on the setup is a button under Saved Templates, near the top of the export dialog, and anyone in your organization can click it. Clicking a template fills in the fields and the filters it was saved with.

Because the file format is not part of a template, pick CSV or Excel again each time you load one.

Two things stop you saving a template. A name somebody already used is rejected. So is a setup identical to a template that already exists. In that second case the matching button highlights itself and Save as Template disappears, which is the app telling you the setup is already saved.

You cannot edit a template. To change one, delete it with the × on its button and save a new one. You are asked to confirm first. Deleting a template does not delete the exports you already ran with it, though those rows stop showing its name in the Template column.

Limits

What an export cannot do

What your file looks like

Two things about the file surprise people the first time. The columns are not named the way the export dialog names them, and every date is written out in words. Both are explained here.

What the columns in your file are called

The export dialog shows you a friendly label, Product Title or Min Price. Your file uses the Repricer’s own name for that column, which is almost always the label in lowercase with underscores instead of spaces: product_title, min_price. That name is in the header row at the top of the file.

Two rules cover most of the rest. A date column adds _at on the end, so Last Synced becomes last_synced_at. A price column keeps its plain name and gets a plain number, so Cost becomes cost.

Those names are the same whatever language you use the app in, so you and a teammate on the other language get a file that reads identically.

How values are written in the file

Every date is written in your own timezone, the one on your profile under Settings, and each one names that timezone at the end so nobody has to guess. An Excel file is a single sheet called Data, with the header row on top of it.

A filter that matches no listings still gives you a file. It has the header row and nothing under it, and the Rows column in the exports table says 0 rows.

When something goes wrong

Watching your export run

Your export appears in the exports table under Uploads right away, and moves through these statuses.

The row keeps itself up to date while the export runs, so there is nothing to refresh. The Rows column says 0 rows the whole time it is running, and shows the real count when it finishes. A 0 there is not a sign that anything went wrong.

A Failed export leaves you nothing to download, and the row does not say why it failed. Build it again from Create export.

Reading the exports table

Search, Filter, Columns and Density, above the table, work the way they do on every other table in the Repricer. Filters covers what each one does.

Renaming and downloading your file

Rename and Download are the two buttons on the right of every row of the exports table.

Rename opens a small dialog with a File Name box, up to 250 characters. You change the name only, never the extension, which is shown to the right of the box. You can rename an export while it is still running, and the name you type is the name the file downloads under.

Download stays gray until the export is finished. Click it and the file saves right away. The link behind that button works for 1 hour, and clicking again gets you a fresh one, so an expired link is never something you have to think about.

The email you get

Whoever created the export gets an email when it is ready, written in their own language. Nobody else is told, and there is no way to send the file to an address you type in.

That email gives you the export type, the file name and the row count. Its button brings you back to Uploads in the app. The file is never attached to it and never linked from it, so the table is where every download starts. You can turn the email off under Export ready, in the System group of Notifications in your settings.

Messages you might see

Where to go next