Skip to main content

CSV Formatting

Updated

 

On this page

 

Video Overview

Below is a video overview of our CSV Formatting, and how you can quickly create one with minimal fields for quick listings.

 

Download a sample CSV file

You can download and view a sample listing CSV file to use as a template. These files also contain our Category ID Taxonomy in a separate worksheet.

  1. Audiogon Bulk Upload Sample for Excel
  2. Audiogon Bulk Upload Sample Google Sheet 
    • You can easily make a copy of this sheet to your own Google Drive.

  • The sample file contains several example product listings. Your import file may contain many more products. If you use the sample file to create your own import file, then make sure that you remove all the example products.

  • The sample file includes the all import columns, which may not be necessary for your needs.

  • The Bulk Uploader allows for powerful control via the Bulk Import Wizard and your Default Listing Preferences. These two things can make bulk setting changes for your imported listings, and set default values (e.g. "I always ship to US & Canada"), which can make many of the imported columns unnecessary for you to provide values for.

 

Considerations for the listing CSV file

Before you use a product CSV file, review the following considerations.

Formatting the listing CSV file

For your product CSV file to function correctly, verify the that it meets the following criteria:

  • The first line of your product CSV file must be the column headers as specified in the bulk upload CSV fields table.

  • Each column must be separated by a comma.

If you use Excel to edit your CSV, then check Excel's export settings when you export the CSV to ensure that your file uses commas between values.

 

Required columns in the listing CSV file

These columns must be present under the following conditions:

  • Title, Category, Asking Price, Description, Condition, Images URL are required fields. When you create a listing CSV file to import, these columns must have appropriate values.

  • Refer to the Category ID Taxonomy support doc or Category ID Taxonomy worksheet in our sample files to match your listing's category properly.

  • Quantity is assumed to be 1 if a value is not explicitly provided, or the column is not in the CSV.

Create your listing CSV file

Whether you create your CSV from scratch, use one of our sample files as a template, or work off an export out of another system you use, you'll need to 

Prepare your images

A CSV file can only contain text, therefore, you need to make sure that all product images are on an existing website. Those image URLs are only used during the CSV file importing process. You can delete the URLs after your import is complete.

If the files are only on your computer, then to link to their URL, you must upload them to your eCommerce site, your Shopify store, or to another image hosting service.

When you have URLs for each product image, you can start building your CSV file.

Adding listing images in a CSV file

You can add listing images to your CSV file by uploading more images to your eCommerce site, your Shopify store, or to another image hosting service. 

  • You need to be able to edit a CSV file. Audiogon recommends using Google Sheets to view a formatted version of your CSV files.

  • You can add up to 16 images to a product.

  • For Audiogon to import your product images, they must be uploaded to a publicly accessible URL. That is, they should be behind an https:// protocol with no password protection. There are plenty of hosting sites that can do this. However, you most likely have hosting if you have a website. One example is uploading image files to your Shopify store.

    • To do this, you can upload images to the Files page of the Shopify admin. The URLs generate automatically. After you click Upload files, you can select up to a couple hundred images to upload in bulk.

Add multiple listing images to your CSV file

Once your images are externally hosted, and you have the image URLs, you can add multiple images to a single listing by simply separating the URLs by a comma in the Images URL column. We will then fetch those images and add them to the listing.

 

 

Formatting in Description Field

Audiogon will accept basic HTML markups in your Description field.

We support any of the formatting options available to Dealers: header tags, Bold, Italics, Underline, Ordered and Unordered Lists, Quotes, font color, image embeds, etc.

We recommend doing a test upload if your listing will have extensive HTML markup, as taking it from your website to a spreadsheet software to our site may result in some variances.

Your listing may also look slightly different due to the way we interpret line breaks (<br /> vs <p>) and other formatting quirks between platforms.

Comments

0 comments

Article is closed for comments.