Home

Machines

Espresso machines

Super-automatic machines

Capsule and pod machines

Filter coffee machines

Manual brewing

Moka pots

French presses

Manual brewers

Grinders, roasters and more

Coffee grinders

Coffee roasters

Other

Partners

Dealers

Service Providers

Brand

Ascaso

Baratza

Bezzera

Bialetti

Bodum

Chemex

Comandante

DeLonghi

ECM

Eureka

Gaggia

Hario

Jura

La Marzocco

Lelit

Mahlkönig

Melitta

Miele

Nespresso

Niche

Probat

Profitec

Rancilio

Rocket Espresso

Siemens

Technivorm Moccamaster

Other Brands

No Signup

Create Listing

Edit Listing

Partners

Partner Dashboard

The Partner Program

CSV Filling Guide

AI-Assisted CSV Conversion

About Puckory

Overview

Team

FAQ

Terms and Conditions

Terms of Use

Privacy

Legal Notice

Credits

Good to Know

Buying Used

Selling Tips

Valuing Your Machine

Descaling and Cleaning

All Articles →

Settings

Language and Currency

Units

Manage Cookies

Contact
← CSV Filling GuideListing Management →

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 Puckory with minimal effort, you can use AI chatbots like ChatGPT, Claude, or Gemini to convert it into the Puckory 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 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 inventory data to be converted.

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]

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 (category, currency, 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.