Here is the refined prompt, following the new structure and preserving all key insights and details from the original: #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 help the user generate 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. - Validate the data to ensure consistency and accuracy across all fields. - Provide clear instructions on how to process the CSV file for efficient batch updates of meta tags, descriptions, and 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.
Pensando...
