Overview
This prompt aims to help users create a structured CSV file for their e-commerce product catalog, enhancing SEO and data processing efficiency. E-commerce businesses and data engineers will benefit from streamlined product management and improved online visibility.
Prompt Overview
Purpose: This CSV file is designed to streamline the management of e-commerce product data for SEO optimization.
Audience: It is intended for data engineers and e-commerce managers looking to enhance product visibility online.
Distinctive Feature: The schema captures essential product details, ensuring compatibility with SEO best practices and efficient data processing.
Outcome: Users will achieve improved batch updates for meta tags, descriptions, and URL slugs, enhancing overall site performance.
Quick Specs
- Media: Text
- Use case: Content Creation, Conversion & Extraction, Data Extraction
- Industry: Creative Writing & Storytelling, E-Commerce & Retail Software, E-Commerce Platforms & Marketplaces
- Techniques: Output Constraints, Prompt Templates, Structured Output
- Models: Claude 3.5 Sonnet, Gemini 2.0 Flash, GPT-4o, Llama 3.1 70B
- Estimated time: 5-10 minutes
- Skill level: Beginner
Variables to Fill
- [PASTE YOUR PRODUCT CATALOG DATA HERE] – Paste Your Product Catalog Data Here
Example Variables Block
- [PASTE YOUR PRODUCT CATALOG DATA HERE]: Example Paste Your Product Catalog Data Here
The Prompt
# CONTEXT:
You are an expert data engineer with comprehensive knowledge in structured data formats, efficient data processing, and e-commerce product catalogs. Your task is to assist the user in generating a well-structured CSV file for a given product catalog, optimized for batch processing of meta tags, descriptions, and URL slugs.
# ROLE:
Adopt the role of an expert data engineer with expertise in data modeling and e-commerce best practices. Your goal is to create a schema that captures essential product features and categories.
# RESPONSE GUIDELINES:
– Create a CSV file with the following columns:
– `product_id`: Unique identifier for each product
– `product_name`: Name of the product
– `product_description`: Detailed description of the product
– `product_category`: Primary category of the product
– `product_subcategory`: Subcategory of the product (if applicable)
– `product_features`: Key features of the product, separated by semicolons
– `product_price`: Price of the product
– `product_image_url`: URL of the main product image
– `meta_title`: Meta title for the product page
– `meta_description`: Meta description for the product page
– `url_slug`: SEO-friendly URL slug for the product page
– Ensure that the CSV file is:
– Properly formatted, with appropriate delimiters and escaped characters where necessary.
– Validated for consistency and accuracy across all fields.
– Provide clear instructions on how to process the CSV file for efficient batch updates of:
– Meta tags
– Descriptions
– URL slugs
# TASK CRITERIA:
– Focus on capturing essential product features and categories in the schema.
– Ensure proper formatting of the CSV file, with appropriate delimiters and escaped characters.
– Validate data consistency and accuracy across all fields.
– Provide clear instructions for processing the CSV file for efficient batch updates.
– Avoid any unnecessary or redundant information in the CSV file.
# INFORMATION ABOUT ME:
– My product catalog: [PASTE YOUR PRODUCT CATALOG DATA HERE]
# RESPONSE FORMAT:
Return a well-structured CSV file following the specified column structure and formatting guidelines. Include clear instructions on how to process the CSV file for efficient batch updates of meta tags, descriptions, and URL slugs.
Screenshot Examples
How to Use This Prompt
- “`csv
- product_id,product_name,product_description,product_category,product_subcategory,product_features,product_price,product_image_url,meta_title,meta_description,url_slug
- 1,"Wireless Headphones","High-quality wireless headphones with noise cancellation
- ","Electronics","Audio","Bluetooth
- Noise Cancellation
- 20 hours battery life","149
- 99","http://example
- com/images/headphones
- jpg","Buy Wireless Headphones – Best Quality","Shop the best wireless headphones with noise cancellation
- ","wireless-headphones"
- 2,"Smartphone X","Latest smartphone with advanced features and sleek design
- ","Electronics","Mobile Phones","5G
- 128GB Storage
- 48MP Camera","799
- 99","http://example
- com/images/smartphone
- jpg","Smartphone X – Latest Technology","Discover the latest smartphone with advanced features
- ","smartphone-x"
- 3,"Gaming Laptop","High-performance gaming laptop with powerful graphics
- ","Computers","Laptops","16GB RAM
- NVIDIA GTX 1660
- 1TB SSD","1299
- 99","http://example
- com/images/gaming-laptop
- jpg","Gaming Laptop – Ultimate Performance","Experience high-performance gaming with our latest laptop
- ","gaming-laptop"
- “`
- ### Instructions for Processing the CSV File
- 1
- Batch Update Meta Tags:
- – Use a script or data processing tool to read the CSV file
- – Extract the `meta_title` and `meta_description` fields for each product
- – Update your website's database or CMS with the new meta tags
- 2
- Batch Update Descriptions:
- – Read the `product_description` field from the CSV
- – Ensure that the descriptions are properly formatted and free of HTML tags if necessary
- – Update the product descriptions in your database
- 3
- Batch Update URL Slugs:
- – Extract the `url_slug` field from the CSV
- – Ensure that the slugs are unique and SEO-friendly
- – Update the product URLs in your database or CMS accordingly
- ### Validation Tips
- – Ensure all fields are populated correctly, especially `product_id`, which must be unique
- – Check for any special characters in the `product_name` and `product_description` that may need escaping
- – Validate that the `product_price` is in a numeric format and that the `product_image_url` points to a valid image
Tips for Best Results
- Use Unique Identifiers: Ensure each product has a distinct `product_id` to avoid conflicts during updates.
- Optimize Descriptions: Write concise yet informative `product_description` to enhance SEO and user engagement.
- Standardize URL Slugs: Create `url_slug` using lowercase letters and hyphens for better readability and SEO performance.
- Validate Data Consistency: Regularly check for consistency in `product_category` and `product_subcategory` to maintain a structured catalog.
FAQ
- What is the purpose of a product catalog CSV file?
It organizes product data for efficient processing, including meta tags and descriptions. - What columns should be included in the CSV file?
Include product_id, product_name, product_description, product_category, product_subcategory, product_features, product_price, product_image_url, meta_title, meta_description, and url_slug. - How do you ensure data consistency in the CSV?
Validate each field for accuracy and ensure all entries follow the same format and delimiters. - What are the steps for batch updating meta tags?
Edit the CSV file with new meta tags, then upload it to your e-commerce platform for processing.
Compliance and Best Practices
- Best Practice: Review AI output for accuracy and relevance before use.
- Privacy: Avoid sharing personal, financial, or confidential data in prompts.
- Platform Policy: Your use of AI tools must comply with their terms and your local laws.
Revision History
- Version 1.0 (December 2025): Initial release.
