KI-gestützte CSV-Konvertierung (für Partner)

Wenn du deine Inserate bereits in einem tabellarischen Format vorliegen hast (z. B. Datenbank-Export aus der Datenbank deiner eigenen Händler-Website) und diese mit wenig Aufwand in das für Puckory geeignete CSV-Format umwandeln möchtest, kannst du KI-Chatbots wie ChatGPT, Claude oder Gemini nutzen, um es automatisch ins Puckory CSV-Format zu konvertieren.

Schritt-für-Schritt-Anleitung

1. Kopiere den KI-Prompt unten

Klicke auf den Kopieren-Button, um die fertige Prompt-Vorlage in deine Zwischenablage zu kopieren.

2. Öffne einen KI-Chatbot

Öffne eine neue Unterhaltung mit dem KI-Chatbot deiner Wahl (z. B. ChatGPT oder Gemini).

3. Füge den Prompt ein

Füge den kopierten Prompt in den Chat ein.

4. Füge deine Daten hinzu

Ersetze den Platzhalter "[PASTE YOUR DATA HERE]" durch deine tatsächlichen Inventardaten. Du kannst aus Excel einfügen, aus einem Dokument kopieren oder es direkt eintippen.

5. Senden und empfangen

Sende die Nachricht und die KI wird deine Daten ins korrekte CSV-Format konvertieren.

6. Kopiere das Ergebnis

Kopiere die generierten CSV-Daten aus der Antwort der KI.

7. Als CSV-Datei speichern

Füge die Daten in einen Texteditor (z. B. Notepad in Windows oder TextEdit in macOS) ein, speichere die Textdatei mit einer .csv-Endung und importiere sie über die CSV-Import-Funktion auf der Inseratsverwaltungsseite.

KI-Prompt-Vorlage

Kopiere diesen Prompt und füge ihn in die Unterhaltung mit dem KI-Chatbot ein. Denke daran, den Platzhalter "[PASTE YOUR DATA HERE]" durch die zu konvertierenden Inventardaten zu ersetzen:

I need your help converting my coffee equipment 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;category;brand;model;currency;price_on_request;price;price_type;condition;description;height;width;depth;weight;shipping_available;shipping_cost;email;image_urls;video_urls;usage;color;purchase_year;power_supply;power_watt;last_service_year;water_supply;water_tank_volume;operation;boiler_system;group_count;group_type;pump_type;pid;pressure_profiling;boiler_volume;portafilter_size;milk_system;bean_hoppers;grinder_material;brew_count;removable_brew_unit;capsule_system;milk_frother_included;brewing_type;carafe_type;capacity_l;programmable_timer;grinder_integrated;sca_certified;cups;material;induction_compatible;double_wall;brewer_type;grinder_type;grind_range;burr_type;burr_diameter;single_dose;roaster_type;heat_source;batch_capacity_kg

Column descriptions:
- public_id: Your internal ID (optional, leave empty for new listings)
- summary: Short title describing the item (required, max 80 characters)
- category: Must be one of: ESPRESSO_MACHINE, SUPER_AUTOMATIC, CAPSULE_POD_MACHINE, FILTER_MACHINE, MOKA_POT, FRENCH_PRESS, MANUAL_BREWER, GRINDER, ROASTER, OTHER (required)
- brand: Manufacturer name (required, e.g., La Marzocco, Jura, Bialetti)
- model: Model designation (optional)
- currency: Must be one of: AUD, CAD, CHF, CZK, DKK, EUR, GBP, HUF, NOK, NZD, PLN, SEK, USD (required when price_on_request is false)
- price_on_request: Whether to show "Price on Request" instead of a price (true/false). IMPORTANT: If true, leave price, price_type and currency EMPTY.
- price: Price as number without currency symbol (required when price_on_request is false)
- price_type: Must be one of: FIXED, NEGOTIABLE (required when price_on_request is false)
- condition: Must be one of: NEW, USED, REFURBISHED (required)
- description: Detailed description (required, max 4000 characters)
- height: Height in cm (optional, whole number)
- width: Width in cm (optional, whole number)
- depth: Depth in cm (optional, whole number)
- weight: Weight in kg (optional, decimals allowed)
- shipping_available: Whether the seller ships the item (true/false, empty or false = pickup only)
- shipping_cost: Shipping cost in the listing currency (optional, only with shipping_available true; 0 = free shipping, empty = cost on request)
- 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)
- usage: one of: HOME, COMMERCIAL. Only for category ESPRESSO_MACHINE, SUPER_AUTOMATIC, CAPSULE_POD_MACHINE, FILTER_MACHINE, GRINDER, ROASTER; required for ESPRESSO_MACHINE, SUPER_AUTOMATIC, CAPSULE_POD_MACHINE, FILTER_MACHINE, GRINDER, ROASTER. Leave empty for other categories.
- color: one of: BLACK, WHITE, GREY, BROWN, BEIGE, RED, ORANGE, YELLOW, GREEN, BLUE, PURPLE, PINK, SILVER, GOLD, COPPER, OTHER. Only for category ESPRESSO_MACHINE, SUPER_AUTOMATIC, CAPSULE_POD_MACHINE, FILTER_MACHINE, MOKA_POT, FRENCH_PRESS, MANUAL_BREWER, GRINDER, ROASTER, OTHER; required for ESPRESSO_MACHINE, SUPER_AUTOMATIC, CAPSULE_POD_MACHINE, FILTER_MACHINE, GRINDER. Leave empty for other categories.
- purchase_year: year (1980-now). Only for category ESPRESSO_MACHINE, SUPER_AUTOMATIC, CAPSULE_POD_MACHINE, FILTER_MACHINE, MOKA_POT, FRENCH_PRESS, MANUAL_BREWER, GRINDER, ROASTER, OTHER; optional. Leave empty for other categories.
- power_supply: one of: HOUSEHOLD_230V, HOUSEHOLD_110_120V, THREE_PHASE_400V, OTHER. Only for category ESPRESSO_MACHINE, SUPER_AUTOMATIC, CAPSULE_POD_MACHINE, FILTER_MACHINE, GRINDER, ROASTER; optional. Leave empty for other categories.
- power_watt: whole number 1-20000 (W). Only for category ESPRESSO_MACHINE, SUPER_AUTOMATIC, CAPSULE_POD_MACHINE, FILTER_MACHINE, GRINDER, ROASTER; optional. Leave empty for other categories.
- last_service_year: year (1980-now). Only for category ESPRESSO_MACHINE, SUPER_AUTOMATIC, CAPSULE_POD_MACHINE, FILTER_MACHINE, GRINDER, ROASTER; optional. Leave empty for other categories.
- water_supply: one of: TANK, PLUMBED_IN, BOTH. Only for category ESPRESSO_MACHINE, SUPER_AUTOMATIC, FILTER_MACHINE; optional. Leave empty for other categories.
- water_tank_volume: number 0.1-100 (l). Only for category ESPRESSO_MACHINE, SUPER_AUTOMATIC, CAPSULE_POD_MACHINE; optional. Leave empty for other categories.
- operation: one of: SEMI_AUTOMATIC, VOLUMETRIC, LEVER. Only for category ESPRESSO_MACHINE; required for ESPRESSO_MACHINE. Leave empty for other categories.
- boiler_system: one of: SINGLE_BOILER, HEAT_EXCHANGER, DUAL_BOILER, THERMOBLOCK, MULTI_BOILER. Only for category ESPRESSO_MACHINE; required for ESPRESSO_MACHINE. Leave empty for other categories.
- group_count: whole number 1-4. Only for category ESPRESSO_MACHINE; required for ESPRESSO_MACHINE. Leave empty for other categories.
- group_type: one of: E61, SATURATED, OTHER. Only for category ESPRESSO_MACHINE; optional. Leave empty for other categories.
- pump_type: one of: ROTARY, VIBRATION. Only for category ESPRESSO_MACHINE; optional. Leave empty for other categories.
- pid: true/false. Only for category ESPRESSO_MACHINE; optional. Leave empty for other categories.
- pressure_profiling: true/false. Only for category ESPRESSO_MACHINE; optional. Leave empty for other categories.
- boiler_volume: number 0.1-100 (l). Only for category ESPRESSO_MACHINE; optional. Leave empty for other categories.
- portafilter_size: one of: MM_58, MM_54, MM_53, MM_51, OTHER. Only for category ESPRESSO_MACHINE; optional. Leave empty for other categories.
- milk_system: one of: NONE, STEAM_WAND, AUTOMATIC. Only for category SUPER_AUTOMATIC; required for SUPER_AUTOMATIC. Leave empty for other categories.
- bean_hoppers: whole number 1-2. Only for category SUPER_AUTOMATIC; required for SUPER_AUTOMATIC. Leave empty for other categories.
- grinder_material: one of: CERAMIC, STEEL. Only for category SUPER_AUTOMATIC, GRINDER; optional. Leave empty for other categories.
- brew_count: whole number 0-1000000. Only for category SUPER_AUTOMATIC; optional. Leave empty for other categories.
- removable_brew_unit: true/false. Only for category SUPER_AUTOMATIC; optional. Leave empty for other categories.
- capsule_system: one of: NESPRESSO_ORIGINAL, NESPRESSO_VERTUO, DOLCE_GUSTO, SENSEO, TASSIMO, LAVAZZA_A_MODO_MIO, CAFFITALY, K_FEE, KEURIG_K_CUP, ESE_POD, OTHER. Only for category CAPSULE_POD_MACHINE; required for CAPSULE_POD_MACHINE. Leave empty for other categories.
- milk_frother_included: true/false. Only for category CAPSULE_POD_MACHINE; optional. Leave empty for other categories.
- brewing_type: one of: DRIP, POUR_OVER_AUTOMATIC, BATCH_BREWER. Only for category FILTER_MACHINE; required for FILTER_MACHINE. Leave empty for other categories.
- carafe_type: one of: GLASS, THERMOS, NONE. Only for category FILTER_MACHINE; required for FILTER_MACHINE. Leave empty for other categories.
- capacity_l: number 0.001-100 (l). Only for category FILTER_MACHINE, FRENCH_PRESS, MANUAL_BREWER; required for FILTER_MACHINE, FRENCH_PRESS. Leave empty for other categories.
- programmable_timer: true/false. Only for category FILTER_MACHINE; optional. Leave empty for other categories.
- grinder_integrated: true/false. Only for category FILTER_MACHINE; optional. Leave empty for other categories.
- sca_certified: true/false. Only for category FILTER_MACHINE; optional. Leave empty for other categories.
- cups: whole number 1-18. Only for category MOKA_POT; required for MOKA_POT. Leave empty for other categories.
- material: one of: GLASS, CERAMIC, STAINLESS_STEEL, ALUMINIUM, PLASTIC, COPPER, OTHER. Only for category MOKA_POT, FRENCH_PRESS, MANUAL_BREWER; required for MOKA_POT, FRENCH_PRESS, MANUAL_BREWER. Leave empty for other categories.
- induction_compatible: true/false. Only for category MOKA_POT; required for MOKA_POT. Leave empty for other categories.
- double_wall: true/false. Only for category FRENCH_PRESS; optional. Leave empty for other categories.
- brewer_type: one of: POUR_OVER, AEROPRESS, SIPHON, COLD_BREW, IBRIK, OTHER. Only for category MANUAL_BREWER; required for MANUAL_BREWER. Leave empty for other categories.
- grinder_type: one of: ELECTRIC, MANUAL. Only for category GRINDER; required for GRINDER. Leave empty for other categories.
- grind_range: one of: ESPRESSO, FILTER, ALL_ROUND. Only for category GRINDER; required for GRINDER. Leave empty for other categories.
- burr_type: one of: FLAT, CONICAL, BLADE, OTHER. Only for category GRINDER; required for GRINDER. Leave empty for other categories.
- burr_diameter: whole number 10-200 (mm). Only for category GRINDER; optional. Leave empty for other categories.
- single_dose: true/false. Only for category GRINDER; optional. Leave empty for other categories.
- roaster_type: one of: DRUM, HOT_AIR, OTHER. Only for category ROASTER; required for ROASTER. Leave empty for other categories.
- heat_source: one of: ELECTRIC, GAS. Only for category ROASTER; required for ROASTER. Leave empty for other categories.
- batch_capacity_kg: number 0.05-1000 (kg). Only for category ROASTER; required for ROASTER. Leave empty for other categories.

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
- One sheet for all categories: fill only the attribute columns that belong to the row's category, leave the others empty
- All predefined values (category, currency, condition and the attribute options) 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;category;brand;model;currency;price_on_request;price;price_type;condition;description;height;width;depth;weight;shipping_available;shipping_cost;email;image_urls;video_urls;usage;color;purchase_year;power_supply;power_watt;last_service_year;water_supply;water_tank_volume;operation;boiler_system;group_count;group_type;pump_type;pid;pressure_profiling;boiler_volume;portafilter_size;milk_system;bean_hoppers;grinder_material;brew_count;removable_brew_unit;capsule_system;milk_frother_included;brewing_type;carafe_type;capacity_l;programmable_timer;grinder_integrated;sca_certified;cups;material;induction_compatible;double_wall;brewer_type;grinder_type;grind_range;burr_type;burr_diameter;single_dose;roaster_type;heat_source;batch_capacity_kg
;La Marzocco Linea Mini Dual Boiler;ESPRESSO_MACHINE;La Marzocco;Linea Mini;EUR;false;3200;NEGOTIABLE;USED;Well-maintained Linea Mini, descaled regularly. Works with water tank or plumbed in.;;;;;true;59;partner@example.com;https://example.com/img1.jpg,https://example.com/img2.jpg;;HOME;SILVER;2021;HOUSEHOLD_230V;;;BOTH;;SEMI_AUTOMATIC;DUAL_BOILER;1;;;true;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;Comandante C40 hand grinder;GRINDER;Comandante;C40 MK4;EUR;false;150;FIXED;NEW;Brand new hand grinder with stainless steel burrs.;;;;;true;0;partner@example.com;;;HOME;BLACK;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;MANUAL;ALL_ROUND;CONICAL;;;;;
;Faema E61 two-group commercial machine;ESPRESSO_MACHINE;Faema;E61 Legend;;true;;;USED;Two-group machine for gastronomy. Price on request.;;;;;;;partner@example.com;;;COMMERCIAL;BLACK;2012;THREE_PHASE_400V;;;PLUMBED_IN;;VOLUMETRIC;HEAT_EXCHANGER;2;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

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

Tipps für beste Ergebnisse

  • Je strukturierter deine Eingabedaten sind, desto besser kann die KI sie konvertieren. Tabellen oder Listen funktionieren am besten.
  • Wenn die KI Fehler macht, kannst du sie bitten, diese zu korrigieren. Zum Beispiel: "Bitte ändere alle Farben auf BLACK"
  • Überprüfe die Dropdown-Werte (Kategorie, Währung, Zustand) vor dem Import. Sie müssen exakt übereinstimmen.
  • Du kannst Daten in Chargen konvertieren. Beginne mit einigen Inseraten zum Testen, dann mache den Rest, sobald du sicher bist.
  • Überprüfe die Daten nach der Konvertierung z. B. in Excel oder LibreOffice, bevor du sie importierst, um Probleme frühzeitig zu erkennen.