Below is a compact, practical guide you can use to write “perfect” AI prompts to generate PrestaShop products, categories and CMS pages. It covers the prompt structure, required fields, recommended output formats (JSON / CSV / HTML) and several ready‑to‑use prompt templates and examples you can paste into ChatGPT or other LLMs. 1) What makes a perfect prompt (the minimal structure) - Context / role: who the model should pretend to be (e.g., “You are an ecommerce product copywriter for a premium cosmetics brand”). - Goal: what you want produced (e.g., “Generate product data ready for PrestaShop import”). - Required fields / schema: specify exact fields and field types to return. - Style & tone: voice, target audience, SEO keywords, format constraints (word counts, char limits). - Output format: JSON, CSV row(s), or HTML (explicitly say “output only the requested format”). - Examples / few‑shot: include 1–2 examples if you want consistency. - Constraints: things to avoid (legal claims, unverified specs), language, multi‑language needs. - Validation: ask the model to validate/mention any missing info. 2) Typical PrestaShop fields to request - Product (main): id (optional), active (0/1), name, categories (list of names or IDs), price_excl_tax, tax_rules_id, wholesale_price, on_sale, reference (SKU), supplier_reference, manufacturer, EAN13/UPC, ecotax, width/height/depth, weight, quantity, minimal_quantity, visibility, short_description, description (HTML allowed), tags (list), meta_title, meta_description, link_rewrite (slug), available_for_order, condition (new/used/refurbished), image_urls (list), combinations (attributes & impacts), features (Name:Value), customizations, pack_contents, related_products (list of SKUs or names). - Category: id (optional), active, name, parent_category, description (HTML), meta_title, meta_description, link_rewrite, image_url, position, id_shop (if multishop). - CMS page: id (optional), active, title, content (HTML), meta_title, meta_description, link_rewrite, position, id_shop. 3) Output formats and why to choose them - JSON: best for programmatic ingestion (useful with an import script or API). - CSV row(s): best for direct PrestaShop CSV import — make sure columns match your PrestaShop version. (I’ll show CSV templates below.) - HTML: if you want final product descriptions ready for the front end (wrapped with clean tags). - Give the model an explicit schema so it returns exactly the fields you can import. 4) Example JSON schema (copy/paste into prompt to instruct the model) Tell the model: “Return only valid JSON conforming to this schema (no extra commentary).” Example product JSON schema (concise): { "sku": "string", "active": 0|1, "name": "string", "categories": ["string"], "price_excl_tax": number, "tax_rules_id": number, "wholesale_price": number, "on_sale": 0|1, "reference": "string", "manufacturer": "string", "ean13": "string", "quantity": integer, "minimal_quantity": integer, "visibility": "both/front/search", "short_description": "string (20-35 words)", "description": "string (100-250 words, HTML allowed)", "features": [{"name":"string","value":"string"}], "combinations": [{"attributes":{"Size":"M","Color":"Blue"},"quantity":10,"price_impact":0.00}], "tags": ["string"], "meta_title": "string (<=70 chars)", "meta_description": "string (120-160 chars)", "link_rewrite": "string-slug", "image_urls": ["https://..."], "related_products": ["sku1","sku2"] } 5) Ready‑to‑use prompt templates A) Single product (JSON) — basic You can paste this to the LLM: You are a professional ecommerce product copywriter. Generate product data in JSON only, following this schema: [insert schema above]. Use this brand voice: friendly, slightly technical, aimed at mid‑level buyers. Short description: 20–30 words. Long description: 120–180 words in HTML (use

and

for features). SEO: meta_title <=70 chars, meta_description 140–160 chars. link_rewrite must be a lowercase hyphenated slug. Provide 3–5 tag keywords and at least 3 image_urls (absolute URLs). If any data is unknown, set to null. B) Bulk products CSV for PrestaShop import (single line per product) You can instruct: Produce CSV rows with these columns exactly in this order: Active;Name;Categories;Price tax excluded;Tax rules ID;Wholesale price;On sale;Reference;Supplier;Manufacturer;EAN13;Width;Height;Depth;Weight;Quantity;Minimal quantity;Visibility;Short description;Description;Tags;Meta title;Meta description;URL rewritten;Available for order;Condition;Image URLs;Feature (Name:Value:Position) Return only CSV content with header row. Separate fields with semicolons. Use categories as “Parent Category > Subcategory” where appropriate. C) Category creation (JSON) You can instruct: Return JSON array of categories. Each object must contain: name, parent, description (HTML), meta_title, meta_description, link_rewrite, image_url, active (0/1). Return only JSON. D) CMS page (HTML + metadata) You can instruct: Generate CMS page content and metadata in JSON: { "title": "...", "link_rewrite": "...", "meta_title": "...", "meta_description": "...", "content": "

...

...

" }. Keep meta_description <=160 chars. Tone: brand voice. Return only JSON. 6) Example — single product prompt + AI output example Prompt: You are an ecommerce product copywriter for "OceanCraft Outdoors" (outdoor gear). Generate JSON only, following this schema: [paste schema]. Product: SKU OCO-BRUSH-01, name "Voyager Camp Brush", categories ["Camping Tools","Cleaning"], price_excl_tax 12.99, tax_rules_id 1, wholesale_price 6.50, quantity 120, manufacturer "OceanCraft", features: bristles=stiff nylon, handle=ergonomic bamboo. Tone: friendly, practical; audience: campers and hikers. Short description 25 words. Long description 140 words with

and

. meta_title <=70, meta_description <=155. Provide 3 image URLs. Expected JSON (example): { "sku":"OCO-BRUSH-01", "active":1, "name":"Voyager Camp Brush", "categories":["Camping Tools","Cleaning"], "price_excl_tax":12.99, "tax_rules_id":1, "wholesale_price":6.5, "on_sale":0, "reference":"OCO-BRUSH-01", "manufacturer":"OceanCraft", "ean13":null, "quantity":120, "minimal_quantity":1, "visibility":"both", "short_description":"Stiff‑bristle camp brush with ergonomic bamboo handle—ideal for tents, stoves and cookware on the trail.", "description":"

The Voyager Camp Brush is designed for outdoor cleanup: durable stiff nylon bristles and a comfortable bamboo handle make quick work of soot and dirt. Lightweight and compact, it packs easily in your kit.

• Stiff nylon bristles for deep cleaning
• Ergonomic bamboo handle
• Compact 18 cm length
", "features":[{"name":"Bristles","value":"Stiff nylon"},{"name":"Handle","value":"Bamboo"},{"name":"Length","value":"18 cm"}], "combinations":[], "tags":["camping","cleaning","bamboo"], "meta_title":"Voyager Camp Brush — OceanCraft", "meta_description":"Durable stiff‑bristle camp brush with bamboo handle. Compact, lightweight and perfect for tents, stoves and cookware.", "link_rewrite":"voyager-camp-brush", "image_urls":["https://example.com/images/voyager-brush-1.jpg","https://example.com/images/voyager-brush-2.jpg","https://example.com/images/voyager-brush-3.jpg"], "related_products":[] } 7) Good vs bad prompt examples - Bad: “Write product descriptions for my shop.” (too vague) - Good: “You are a product copywriter for [Brand]. For the product named X, return JSON with fields: name, sku, price_excl_tax (number), short_description (20–30 words), description (120–180 words, HTML), meta_title (<=70), meta_description (120–160), link_rewrite (slug). Tone: technical and concise. Return only JSON.” 8) Practical tips and constraints - Always specify output format (JSON/CSV) and say “no extra commentary.” - Give word/char limits for meta fields (meta_title <=70, meta_description 140–160). - Provide brand voice and a short s guide: formal vs casual, US vs UK spelling, allowed claims (e.g., “Do not claim ‘medical’ or unverified performance”). - For multilingual stores, ask for each translation explicitly and provide keywords per language. - For bulk imports, include required PrestaShop columns exactly; test with 1–2 items first before bulk import. - Validate image URLs and preferred filenames; the import will download images from provided URLs. - If you rely on the LLM for technical data (dimensions, materials), verify against product specs — don’t assume accuracy. - Use few‑shot examples for consistent tone across many items. 9) CSV specifics for PrestaShop import - PrestaShop’s CSV expects particular column names & separators. When using the CSV prompt, include the exact column header set from your PrestaShop version and the separator (comma/semicolon). - Example header row (simple): Active;Name;Categories;Price tax excluded;Tax rules ID;Reference;Quantity;Short description;Description;Tags;Meta title;Meta description;URL rewritten;Image URLs - Ask the model to escape delimiters or wrap fields in quotes if needed. 10) Checklist before generation / import - Do you have consistent category names or IDs? (use IDs if safer) - Are slugs (link_rewrite) unique and URL-safe? - Are image URLs publicly accessible? - Are required fields for your PrestaShop version present? - Have you set the correct CSV delimiter and encoding (UTF‑8)? - Run a 1–5 item test import, review product pages, then bulk import. 11) Final copyable prompt templates (pick one and customize) Template A — Single product JSON (copy/paste) You are a professional ecommerce product copywriter for [Brand]. Produce ONLY valid JSON matching this schema: { "sku":string, "active":0|1, "name":string, "categories":[string], "price_excl_tax":number, "tax_rules_id":number, "wholesale_price":number|null, "quantity":int, "short_description":string, "description":string (HTML), "tags":[string], "meta_title":string, "meta_description":string, "link_rewrite":string, "image_urls":[string], "features":[{"name":string,"value":string}], "combinations":[...] }. Tone: [friendly|technical|luxury|...] (choose). Language: [en-US|fr|...]. Short description 20–30 words. Long description 100–200 words with

and

. meta_title <=70 chars. meta_description 120–160 chars. Provide 3 image_urls. If a field is unknown, return null. No extra text — JSON only. Template B — Bulk CSV (copy/paste) You are an ecommerce data generator. Produce CSV content with this header (semicolon separated): Active;Name;Categories;Price tax excluded;Tax rules ID;Reference;Quantity;Short description;Description;Tags;Meta title;Meta description;URL rewritten;Image URLs. Output only CSV rows, one product per line, using semicolons and wrapping fields in double quotes when necessary. Use categories like "Parent > Child". Keep meta_description <=160 chars. If you want, tell me: - The brand voice (one sentence), - Which fields you must have exactly (I’ll make the schema), - Example product or category (1 example) for few‑shot, and I’ll generate a ready‑to‑import JSON or CSV for X products.