How can we help you?

CSV upload/manage inventory guide

Setting up

Shop Settings

Screenshot 2024-01-31 at 3.23.21 PM.png

All these policies can be adjusted on individual listings, but we do require a baseline to add to new listings created via import.

  • All listings imported to Reverb must also conform to our listing standards and protocol. Please take a moment to review our listing guidelines and standards to ensure that your listings comply.

Once that’s done, you’re ready to start using the Manage Inventory tool, which can be found in your Listings tab:

Screenshot 2024-01-31 at 3.27.54 PM.png

Your first export

You only need to do this if you already have existing listings.

To get started, click on Export Your Listings. You will receive an email with a download link to your listings.  Note: the download link has a time expiration, so be sure to download it soon after.

Screenshot 2024-01-31 at 3.29.09 PM.png

Open up the resulting CSV, and you’ll be taken to a spreadsheet with all of your listings’ information.  Generally speaking, the columns on the spreadsheet follow the fields on the listing page such as make, model, year and finish.

pasted_image_0__1_.png

From here, you can update your listings, and then upload them as a CSV file in your Manage Inventory page. 

Note: Longer filenames may result in delays with inventory updates. Please try to keep filenames short and without special characters.

Creating new listings

You can also use your listings' CSV export to create new drafts. However, if you are starting completely from scratch and would like to create your first listings via an import, you can select Download our template from your Manage Inventory page and work on that document. 

In order to create a new listing, the following fields have to be filled out (the rest are optional and will greatly help your listings’ in increased exposure and detail for buyers):

Field Description
new_listing Enter "TRUE" for every new listing you are creating and "FALSE" if you're just updating an existing listing.
title Mandatory for new listings.
condition Options include Non Functioning, Poor, Fair, Good, Very Good, Excellent, Mint, Brand New.
inventory The inventory column is for Brand New, B-Stock, and Mint (with inventory) condition items only. Please leave the inventory field blank for listings in any condition less than mint. Value must be greater than “0” to be able to publish. If you enter "0" in the Inventory column for a new or existing listing, the listing will automatically be ended.
sku The SKU can be any unique identifier set for the product.
make The brand/manufacturer of the product (e.g. Fender).
model Specific model of the product (e.g. FSR Telecaster Goldtop).
description The more specific and detailed, the better. HTML tags are accepted.
price Mandatory.
shipping_price Unless a shipping_profile is assigned to the listing, this column requires a value. Set as "0" for free shipping.
shipping_profile_name Unless a shipping_price is assigned to the listing, this column requires a value. First head to your Shipping page to make shipping profiles and then enter the profile name(s) in this column.
product_image_1 Must be to a valid online URL (e.g. http or https). Some sellers have successfully used Google Drive, Photobucket or Dropbox to host their images. Make sure your permissions are open to the public.
offers_enabled Set as TRUE or FALSE.
UPC Brand New, B-Stock, and Mint with Inventory condition listings must have a UPC. If you do not have a UPC for the item you're listing, under the upc_does_not_apply column you must enter TRUE.

Updating your listings

Updating your listings is similar to editing the CSV per the guidelines above, except you only need the SKU column and whatever columns you wish to edit.

For example, if you are only updating inventory, you would require the SKU and inventory columns:

Screenshot 2023-12-18 at 12.59.51 PM.png

Only Brand New, Mint w/ Inventory, or B-stock items can have more than 1 inventory.

Once you’ve created your drafts on the spreadsheet, save the file as a CSV, and upload it via the Manage Inventory tab using the Import CSV button:

Screenshot 2024-01-31 at 3.50.57 PM.png

Soon after, you will get a loading bar for your listings.  Once finished, you will receive an Imports Results email:

Screenshot 2024-01-31 at 3.57.55 PM (1).png

The email will notify you of specific errors for any listings.  The following are possible error messages:

Error message

Resolution

Localized contents model for English can't be blank.

Typically, this means the “model” or “make” columns have missing info.

Model can't be blank

Ensure that the listing’s “model” column is filled out.

Product images must use a valid http:// or https:// URL.  Ensure the URL is formatted correctly.

Please note: the state column can’t be updated. 

Frequently asked questions

How many images can I upload?

A: Up to 25 images per listing via CSV.

The formatting of my text is weird/cells overflow with text?

A: Try clicking on all affected cells and going to Format -> Text Wrapping and ensure that “Wrap” is checked.

Can I just update one column?

A: Yes, just ensure that you include the SKU column.

How can I remove pre-order information from a listing via a CSV import?

A: Add a zero to the preorder_lead_time column for the selected SKUs and import.

Can I delete listings?

A: No, drafts and listings cannot be deleted using the CSV tool, but listings can be ended if the inventory is changed to 0. Any sold out or ended listings with a new inventory of 1 or more will be made live again.

Can I publish listings?

A: No, listings cannot be published using the CSV tool. After creating drafts using the CSV tool, you can mass-publish up to 10 listings per page in your Selling -> Listings -> Drafts tab.

Can I replace images?

A: Yes, images can be replaced via CSV by following the steps outlined in this guide.

Why are my UPCs in scientific notation (example: 981851000000 or 9.81 * x 10E11 instead of 9818510291802)?

A: Change the formatting of the column by highlighting the column, and then going to Format>Number and selecting Number.

I would like to start from scratch, but all of my SKUs are already used. What do I do? 

A: You can update SKUs in bulk. Please follow the steps outlined in this guide here.

For any additional questions, contact our Integrations team at integrations@reverb.com.
Was this article helpful?