How Can We Help You?

CSV upload/manage inventory guide

On June 29th, 2023, Reverb will be launching two new subcategories in “Keyboards and Synths”: Drum Machines and Samplers. Simultaneously, we’ll be retiring the current “Drum Machines and Samplers” subcategory in “Drums and Percussion” and moving all listings over to the new subcategories. Learn more about this update.

Setting Up

Shop Settings

pasted_image_0.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:

Screen_Shot_2020-03-17_at_2.07.12_PM_copy.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.

Screen_Shot_2020-03-17_at_2.02.27_PM_copy.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 download the CSV template from your Manage Inventory page and work on that document. 

Screen_Shot_2020-03-17_at_2.02.27_PM_copy_3_-_Download_template.png

 

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.
year The year the inventory was manufactured, or the general production year range, if the exact year is not known (i.e. "1980s", "1965 - 1973").
finish

Optional. The manufacturer finish name, if applicable, or the predominant color of the item.

price Mandatory.
product_type The gear category the listing falls under: accessories, acoustic-guitars, amps, band-and-orchestra, bass-guitars, dj-and-lighting-gear, drums-and-percussion, effects-and-pedals, electric-guitars, folk-instruments, home-audio, keyboards-and-synths, parts, and pro-audio.
subcategory_1 Optional. For the chosen product_type, select 1 corresponding subcategory that falls within the selected category.
subcategory_2 Optional. For the chosen product_type, select 1 corresponding subcategory that falls within the selected category.
shipping_price Unless a shipping_profile is assigned to the listing, this column requires a value. Set as "0" for free shipping.
shipping_profile 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, the new_listing column set to “FALSE”, and whatever columns you wish to edit.

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

pasted_image_0__2_.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 Choose CSV file button:

Screen_Shot_2020-03-17_at_2.02.27_PM_copy_2.png

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

pasted_image_0__3_.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 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.

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: Existing images can't be replaced or modified via CSV after a listing has already been created. However, you are able to add new images to a listing in addition to the existing ones. To do this, you must use the remaining available product image columns. For example: if you have 3 images in a listing, you could add new images to this listing by using the available columns product_image_4, product_image_5 and so on.

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 outline in this guide here.

Other questions? Email imports@reverb.com
Was this article helpful?