Below is a concise guide and ready-to-use prompt templates you can paste into ChatGPT (or any LLM) to generate PrestaShop-ready content for products, categories and CMS pages. It covers what to include, best practices, required fields, output formats (CSV/JSON/HTML) and examples for single and bulk generation.
Quick principles
- Be explicit about output format (JSON/CSV/Markdown table/HTML). Ask the model to “return only” that format.
- Provide all factual inputs (SKU, brand, price, attributes, category IDs) so the model fills only creative fields.
- Specify tone, length limits (characters for meta descriptions), language, and SEO constraints.
- Ask for alt text and slug (link_rewrite) for SEO.
- For bulk generation, give the exact column headers for import and any constraints per field.
- Validate results against your PrestaShop version’s import field names and CSV delimiter settings.
Common PrestaShop fields to include in prompts
- Basic: name, sku (reference), price (tax excl/incl), wholesale_price, tax_rule_id, quantity, weight, visibility, active (1/0), condition (new/used/refurbished)
- Descriptions: description_short, description (HTML allowed), meta_title, meta_description, link_rewrite (slug), tags
- Categories: id_category_default, associations (list of category IDs or names)
- SEO: url_slug, meta_title (max ~70 chars), meta_description (max ~155–160 chars)
- Combinations: attribute_group (Color/Size) and combinations with impact on price/weight/quantity
- Images: filenames and alt texts/captions
- Other: minimal_quantity, available_for_order, availability_date, state, ecotax, additional_shipping_cost, visibility (both/none/catalog/search)
- CMS pages: meta_title, meta_description, content (HTML blocks), friendly_url, position, active
“Perfect” prompt structure (high-level)
1. Role & goal: what you want the LLM to do.
2. Inputs: provide data or CSV sample rows and any fixed defaults.
3. Output format: explicit template/headers/JSON schema and constraints.
4. Tone and SEO rules: length limits, keywords to include/exclude, audience.
5. Examples: 1–2 examples of ideal output.
6. Strict instruction: “Return only [JSON/CSV] with no extra text.”
Product prompt templates
A. Single product — short prompt (paste and edit)
You are a product copywriter for a PrestaShop store. Create the following fields for a single product and return only valid JSON matching the schema. Use British English, friendly but professional tone.
Schema:
{
"name": "",
"reference": "", // SKU
"price_tax_excl": "", // number, e.g. 24.99
"wholesale_price": "",
"quantity": "",
"weight": "",
"condition": "", // new/used/refurbished
"description_short": "", // max 320 chars
"description": "", // long HTML description
"meta_title": "", // max 70 chars
"meta_description": "", // max 155 chars
"link_rewrite": "", // slug (lowercase, hyphens)
"tags": [],
"id_category_default": "",
"associations": { "categories": [], "images": [] },
"images": [{ "filename": "", "alt": "" }]
}
Inputs (edit): name="Organic Cotton T-Shirt", brand="EcoWear", reference="EW-OC-TS-01", price_tax_excl=19.99, quantity=120, weight=0.2, id_category_default=45, keywords=["organic", "cotton", "t-shirt", "sustainable"].
Rules: description_short ≤ 320 chars. meta_description ≤ 155 chars. Return only JSON.
B. Single product — detailed prompt (more control)
System: You are an expert ecommerce copywriter and SEO specialist. Produce product data for PrestaShop.
User:
- Product name: Organic Cotton T-Shirt
- Brand: EcoWear
- SKU/reference: EW-OC-TS-01
- Price (tax excl): 19.99
- Wholesale price: 8.50
- Quantity: 120
- Default category id: 45 (Men > T-Shirts)
- Attributes (combinations): Color: White, Black; Size: S,M,L,XL. Add combination SKUs: append -COLOR-SIZE (e.g. EW-OC-TS-01-WH-S). No price impact.
- Images: 3 files image1.jpg, image2.jpg, image3.jpg — produce alt text for each
- SEO keywords to include: organic cotton, sustainable t-shirt, breathable
- Tone: eco-conscious, premium, concise
- Output format: CSV with these exact columns (for PrestaShop import): name;active;categories;price;tax_rules_id;description_short;description;link_rewrite;meta_title;meta_description;reference;quantity;width;height;depth;weight;available_for_order;show_price;condition;minimal_quantity;visibility;images;tags;feature_values;combinations
- Constraints: each CSV field must not include unescaped semicolons; meta_description ≤ 155 chars; link_rewrite lowercase.
Example row format (first row header): name;active;categories;price;tax_rules_id;... (fill headers exactly)
Generate 1 CSV row for the product and separate rows for combinations if required by PrestaShop import (or include combinations field with the specified syntax). Return only the CSV content (no commentary).
Category prompt template
You are a PrestaShop content specialist. For category name "Men > T-Shirts" (id 45), write a short SEO category description, a longer category description (HTML), meta_title (≤ 70 chars), meta_description (≤ 155 chars), and recommended image alt text. Return only JSON:
{
"id_category": 45,
"name": "Men > T-Shirts",
"description_short": "",
"description": "", // HTML, include
of key subtypes if helpful
"meta_title": "",
"meta_description": "",
"link_rewrite": "men-t-shirts",
"image_alt": ""
}
CMS page prompt template
You are a PrestaShop CMS writer. Create a “Shipping & Returns” CMS page for an ecommerce store selling clothing. Use friendly, clear tone; include H2 sections: Shipping Options, Delivery Times, International Shipping, Returns & Refunds, How to Contact Us. Keep meta_title ≤ 70 chars and meta_description ≤ 155 chars. Provide ready-to-paste HTML content for CMS (include headings, short paragraphs, bullet lists). Return only JSON:
{ "meta_title":"", "meta_description":"", "friendly_url":"", "content":"", "active":1 }
Bulk generation example (generate multiple products as CSV)
System: You are an ecommerce product generator. Generate 20 products for the category IDs [45, 46, 47]. Use the product name templates and attributes list below.
User inputs:
- Number of products: 20
- Categories: 45 (Men T-Shirts), 46 (Women T-Shirts), 47 (Kids T-Shirts)
- Brand pool: EcoWear, GreenThread, PureCotton
- Price range: £9.99–£29.99
- Required output: CSV with these columns exactly: name;reference;price;quantity;id_category_default;description_short;description;meta_title;meta_description;link_rewrite;images;tags;attributes
- SEO rules: meta_description max 155 chars; include keyword “organic cotton” at least once per product; link_rewrite must be unique and lowercase.
Return only CSV. Ensure no extra commentary.
Practical tips and best practices
- Always request strict output formatting: “Return only JSON/CSV with header row and no explanatory text.”
- Provide examples of desired output to reduce ambiguity.
- When generating many items, seed with a small list of real facts (brands, SKUs) to keep output realistic.
- Ask the model to validate slugs (no special chars) and enforce uniqueness.
- For multilingual stores, ask for output as language-code keyed objects: { "en":{...}, "fr":{...} }.
- If you’ll import CSV into PrestaShop, first export a sample product CSV from your store to match exact column names and the delimiter; adapt the prompt accordingly.
- Use a low sampling temperature if you want reproducible structured content (e.g., temperature 0.0–0.3).
- Validate generated HTML for description and ensure no scripts or disallowed tags.
Example concise prompts you can copy/paste
1) Generate a product (quick)
Create a product for PrestaShop. Name: “Bamboo Bed Sheet Set — King”, brand “SleepWell”, SKU SW-BB-KG-01, price_tax_excl 64.99, quantity 40, default category id 101. Write description_short ≤ 200 chars, description (HTML, ~200–350 words), meta_title ≤ 70 chars, meta_description ≤ 155 chars, and link_rewrite slug. Use soothing, premium tone. Return only JSON with keys: name,reference,price_tax_excl,quantity,description_short,description,meta_title,meta_description,link_rewrite,images (list of {filename,alt}). Do not include any extra text.
2) Generate 50 product meta descriptions (bulk)
I will paste a CSV with columns: id;name;keywords. Produce a CSV with columns id;meta_title;meta_description;link_rewrite. For each row, create SEO-friendly meta fields in English, meta_description max 155 chars, meta_title max 70 chars, link_rewrite lowercase, hyphenated, no special chars. Return only the CSV rows for the same ids.
Validation checklist before import
- Ensure CSV delimiter and quoting match PrestaShop imports.
- Check that category IDs and tax_rule_id exist.
- Ensure SKUs are unique.
- Test-import a few rows first.
- Sanitize HTML and remove inline scripts.
If you want, tell me:
- whether you want JSON or CSV,
- one sample product or a small spreadsheet of inputs (names, SKUs, categories),
- PrestaShop version (so I can tailor field names),
and I’ll generate a ready-to-import file or exact prompt you can reuse.
