How Can We Help You?

CSV Upload/Manage Inventory Guide

TABLE OF CONTENTS

1. Setting Up

a) Shop Settings

b) Your First Export

2. Creating New listings

3. Updating Listings

4. Frequently Asked Questions

1) Setting Up

a) Shop Settings

pasted_image_0.png

Note: 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

 

b) Your First Export

You would 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. 

2) 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):

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 and Mint 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: Mandatory; set as “0” for free shipping.
shipping_profile: The shipping_profile column needs an entry. 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

 

 

3) 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

Note: 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:

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

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

 

4) Frequently Asked Questions 

How many images can I upload?

A: Up to 10 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: Images cannot be modified via a CSV import. Images can only be added when a new draft is created. 

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