AI-Assisted CSV Conversion (for Partners)

If you already have your listings in a tabular format (e.g., database export from your own dealer website's database) and want to convert them to the CSV format suitable for PianoHub with minimal effort, you can use AI chatbots like ChatGPT, Claude, or Gemini to convert it into the PianoHub CSV format automatically.

Step-by-Step Instructions

1. Copy the AI prompt below

Click the copy button to copy the ready-to-use prompt template to your clipboard.

2. Open an AI chatbot

Start a new conversation with the AI chatbot of your choice (e.g., ChatGPT or Gemini).

3. Paste the prompt

Paste the copied prompt into the chat.

4. Add your data

Replace the "[PASTE YOUR DATA HERE]" placeholder with your actual piano inventory data. You can paste from Excel, copy from a document, or even type it directly.

5. Send and receive

Send the message and the AI will convert your data into the correct CSV format.

6. Copy the result

Copy the generated CSV data from the AI's response.

7. Save as CSV file

Paste the data into a text editor (e.g. Notepad on Windows or TextEdit on macOS), save the text file with a .csv extension, and import it using the CSV import function on the listing management page.

AI Prompt Template

Copy this prompt and paste it into the conversation with the AI chatbot. Remember to replace the placeholder "[PASTE YOUR DATA HERE]" with the piano inventory data to be converted.

I need your help converting my piano inventory data into a specific CSV format.

Please convert my data into a CSV file with these exact column names (in this order):
public_id;summary;instrument_type;brand;model;acquisition_type;currency;price_on_request;price;price_type;rent_price;color;year_built;production_country;serial_number;condition;description;number_of_keys;height;width;depth;weight;moderator_pedal;sostenuto_pedal;silent_system;player_system;humidity_control;provider_transport;transport_price_included;email;image_urls;video_urls

Column descriptions:
- public_id: Your internal ID (optional, leave empty for new listings)
- summary: Short title describing the piano (required, max 80 characters)
- instrument_type: Must be one of: UPRIGHT_PIANO, GRAND_PIANO, DIGITAL_PIANO, OTHER (required)
- brand: Manufacturer name (required, e.g., Yamaha, Steinway & Sons)
- model: Model designation (optional, e.g., U1, Model D)
- acquisition_type: How the instrument can be acquired. Must be one of: BUY, RENT, BOTH (required). Use RENT if only available for rent, BOTH if it can be bought or rented.
- currency: Must be one of: EUR, USD, GBP, CHF (required when acquisition_type is BUY or BOTH and price_on_request is false; also required when acquisition_type is RENT or BOTH for rent price display)
- price_on_request: Whether to show "Price on Request" instead of a buy price (true/false). IMPORTANT: If true, leave price and price_type EMPTY. Does not affect rent_price. Leave empty when acquisition_type is RENT (not applicable in that case).
- price: Buy price as number without currency symbol (required when acquisition_type is BUY or BOTH and price_on_request is false, leave empty otherwise)
- price_type: Must be one of: FIXED, NEGOTIABLE (required when acquisition_type is BUY or BOTH and price_on_request is false, leave empty otherwise)
- rent_price: Monthly rent price as a number without currency symbol (required when acquisition_type is RENT or BOTH, leave empty otherwise)
- color: Must be one of: BLACK, WHITE, WOOD, OTHER (required)
- year_built: Year of manufacture (optional, 1800-now)
- production_country: Country where built (optional, e.g., Japan, Germany)
- serial_number: Manufacturer's serial number (optional)
- condition: Must be one of: NEW, USED (required)
- description: Detailed description (required, max 4000 characters)
- number_of_keys: Number of keys (required, integer 1-100, typically 61-88)
- height: Height in cm (optional)
- width: Width in cm (optional)
- depth: Depth in cm (optional)
- weight: Weight in kg (optional)
- moderator_pedal: Has moderator pedal (optional, true/false)
- sostenuto_pedal: Has sostenuto pedal (optional, true/false)
- silent_system: Has silent system (optional, true/false)
- player_system: Has player/self-playing system (optional, true/false)
- humidity_control: Has humidity control system (optional, true/false)
- provider_transport: Whether seller provides transport (optional, true/false)
- transport_price_included: Transport price is included (optional, true/false)
- email: Contact email for this listing (required)
- image_urls: URLs to images, separated by comma (optional)
- video_urls: YouTube or Vimeo video URLs, separated by comma (optional, other providers not supported)

Important formatting rules:
- Use semicolon (;) as delimiter
- First row must be the header with column names
- Put text with special characters in quotes
- Leave optional fields empty if you don't have the data
- All predefined values (instrument_type, currency, color, condition, acquisition_type) must match EXACTLY
- Boolean fields: Use exactly "true" or "false" (lowercase, no quotes in CSV)

Example rows (Note: The "public_id" column is left empty for new listings because IDs are automatically assigned after import):
public_id;summary;instrument_type;brand;model;acquisition_type;currency;price_on_request;price;price_type;rent_price;color;year_built;production_country;serial_number;condition;description;number_of_keys;height;width;depth;weight;moderator_pedal;sostenuto_pedal;silent_system;player_system;humidity_control;provider_transport;transport_price_included;email;image_urls;video_urls
;Yamaha U1 Upright Piano Black;UPRIGHT_PIANO;Yamaha;U1;BUY;EUR;false;3500;NEGOTIABLE;;BLACK;2005;Japan;5678901;USED;Well-maintained Yamaha U1 in excellent condition. Regular maintenance, new strings installed 2020.;88;121;153;65;230;true;true;false;false;true;true;false;partner@example.com;https://example.com/img1.jpg,https://example.com/img2.jpg;
;Steinway & Sons Model D Concert Grand;GRAND_PIANO;Steinway & Sons;Model D;BUY;EUR;false;145000;FIXED;;BLACK;2018;USA;K2001234;NEW;Brand new concert grand piano. Includes bench and climate control system.;88;102;274;156;480;true;true;true;true;true;true;true;partner@example.com;;
;Rare Bösendorfer Imperial;GRAND_PIANO;Bösendorfer;Imperial;BUY;;true;;;;BLACK;;;;USED;Extremely rare Bösendorfer Imperial Grand Piano. Price available upon request.;97;;;;;;false;true;false;false;true;false;false;partner@example.com;;
;Yamaha U3 Rental Upright Piano;UPRIGHT_PIANO;Yamaha;U3;RENT;EUR;;;;149;BLACK;2010;Japan;;USED;Well-maintained Yamaha U3 available for rent. Ideal for students and beginners.;88;126;153;65;247;true;false;false;false;false;true;true;partner@example.com;;

Here is my data that needs to be converted:
[PASTE YOUR DATA HERE]

Data Privacy Notice

For privacy reasons, sensitive data (such as email addresses or phone numbers) should not be included in the AI prompt. You can remove this data before conversion and add it manually to the CSV file afterwards. AI chatbot providers may store and process the prompts you submit.

Tips for Best Results

The more structured your input data, the better the AI can convert it. Tables or lists work best.
If the AI makes mistakes, you can ask it to fix them. For example: "Please change all colors to BLACK"
Double-check the dropdown values (instrument type, currency, color, condition) before importing. They must match exactly.
You can convert data in batches. Start with a few listings to test, then do the rest once you're confident.
After conversion, review the data e.g. in Excel or LibreOffice before importing to catch any issues early.