CSV Filling Guide (for Partners)
This page provides a comprehensive reference for all columns in the partner listing CSV format. Use this guide to understand the data types, validation rules, and examples for each field.
How CSV Import Works
The CSV import system allows you to manage all your PianoHub listings efficiently using spreadsheet files:
- Export your current PianoHub listings as a CSV file to get the current data status.
- Edit or supplement the CSV file with changes, updates, or new listings.
- Important: All existing listings you want to keep must remain in the CSV. Missing listings will be marked for deletion by the import tool.
- To add new listings (e.g., via AI conversion), merge your existing data with the new listings in a single CSV file before importing.
Quick Reference
Overview of all columns in the CSV format:
| Column Name | Type | Required |
|---|---|---|
public_id | readonly | No |
summary | text | Yes |
instrument_type | dropdown | Yes |
brand | text | Yes |
model | text | No |
price | number | Yes |
currency | dropdown | Yes |
color | dropdown | Yes |
year_built | number | No |
production_country | text | No |
serial_number | text | No |
height | number | No |
width | number | No |
depth | number | No |
weight | number | No |
condition | dropdown | Yes |
description | description | Yes |
email | text | Yes |
image_urls | text | No |
Detailed Column Descriptions
public_id - ID
Required: No | Type: Read-only identifier
The listing ID. This field is automatically assigned when you create a listing and cannot be changed. Leave empty for new listings.
When updating existing listings, the CSV row must contain the public_id previously assigned by PianoHub. Listings are identified by this ID, not by the title or other fields.
Example: 12345
summary - Title
Required: Yes | Type: Text
A short, descriptive title for the piano. This appears in search results and should be concise but informative.
Example: Yamaha U1 Upright Piano Black
Max length: 80 characters
instrument_type - Instrument Type
Required: Yes | Type: Dropdown selection
The type of instrument. Must be one of the predefined values listed below.
Allowed values:
UPRIGHT_PIANO- Upright PianoGRAND_PIANO- Grand PianoDIGITAL_PIANO- Digital PianoOTHER- Other
brand - Brand
Required: Yes | Type: Text
Manufacturer or brand name.
Important: If you are listing a piano from one of the particularly popular brands listed below, use the spelling documented here. Deviating spellings (e.g., "C. Bechstein" instead of "Bechstein") will cause users not to find your listing when they filter by brand using the search function on PianoHub.
- Baldwin
- Bechstein
- Blüthner
- Bösendorfer
- Boston
- Essex
- Fazioli
- Feurich
- August Förster
- Grotrian-Steinweg
- Haessler
- W. Hoffmann
- Ibach
- Irmler
- Kawai
- Mason & Hamlin
- Petrof
- Pfeiffer
- Samick
- Sauter
- Schimmel
- Seiler
- Steingraeber & Söhne
- Steinway & Sons
- Yamaha
- Zimmermann
Example: Yamaha
Max length: 30 characters
model - Model
Required: No | Type: Text
Model designation or name. Optional field.
Example: U1
Max length: 30 characters
price - Price
Required: Yes | Type: Number
Price without currency symbol. Enter only the number.
Example: 3500
Min: 0.01
currency - Currency
Required: Yes | Type: Dropdown selection
Currency code. Must be one of the predefined values listed below.
Allowed values:
CHFEURGBPUSD
color - Color
Required: Yes | Type: Dropdown selection
Primary color of the instrument. Must be one of the predefined values listed below.
Allowed values:
BLACK- BlackWHITE- WhiteWOOD- WoodOTHER- Other Color
year_built - Year Built
Required: No | Type: Number
Year of manufacture. Optional field.
Example: 2005
Min: 1800 | Max: 2026
production_country - Production Country
Required: No | Type: Text
Country where the instrument was manufactured. Optional field.
Example: Japan
Max length: 30 characters
serial_number - Serial Number
Required: No | Type: Text
Manufacturer's serial number. Optional field.
Example: 5678901
Max length: 15 characters
height - Height
Required: No | Type: Number (in cm)
Height of the instrument in centimeters. Optional field.
Example: 121
Min: 1
width - Width
Required: No | Type: Number (in cm)
Width of the instrument in centimeters. Optional field.
Example: 153
Min: 1
depth - Depth
Required: No | Type: Number (in cm)
Depth of the instrument in centimeters. Optional field.
Example: 65
Min: 1
weight - Weight
Required: No | Type: Number (in kg)
Weight of the instrument in kilograms. Optional field.
Example: 230
Min: 1
condition - Condition
Required: Yes | Type: Dropdown selection
Condition of the instrument. Must be one of the predefined values listed below.
Allowed values:
NEW- New instrumentUSED- Used Instrument
description - Description
Required: Yes | Type: Text
Detailed description of the instrument. Include important details, condition notes, and any special features.
Example: Well-maintained Yamaha U1 in excellent condition. Regular maintenance, new strings installed 2020.
Max length: 4000 characters
email - Email
Required: Yes | Type: Email address
Contact email for inquiries about this listing. This can differ from your partner account email.
Example: partner@example.com
Max length: 255 characters
image_urls - Image URLs
Required: No | Type: Comma-separated URLs
URLs to images of the instrument. Separate multiple URLs with commas. All images must be publicly accessible. Optional field.
Reusing images from your own website:
If you already have listings on your own website and want to additionally list them on PianoHub, you can use the image URLs from your website directly. This way, you don't need to upload or store images twice.
Tip: Right-click on an image in your browser and select "Copy image address" to get the URL.
Example: https://example.com/img1.jpg,https://example.com/img2.jpg