Premium

ChatGPT Prompt to

Create Optimized Product Catalog

💡

Optimize your e-commerce operations with this mega-prompt for ChatGPT, designed to guide data engineers in creating efficient, well-structured CSV files for product catalogs. This prompt ensures accurate data modeling, optimal batch processing, and enhanced SEO performance.

What This Prompt Does:

● Guides the user in creating a well-structured CSV file for e-commerce product catalogs.● Ensures the CSV file includes essential product details and is optimized for batch processing.● Provides clear instructions on formatting, validating, and updating the CSV file efficiently.

Tips:

● Develop a comprehensive data validation plan to ensure that each entry in the CSV file adheres to the specified formats and standards, minimizing errors in data entry and processing.● Utilize scripting languages like Python or PowerShell to automate the process of updating meta tags, descriptions, and URL slugs in batch, ensuring efficient and error-free updates.● Create a detailed documentation guide that outlines each step of the CSV file preparation and processing, including examples and common troubleshooting tips, to assist users in managing the CSV file effectively.

🛠️ CSV Schema Creator

ChatGPT Prompt

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.

Copy

COPIED

GET FULL ACCESS

#CONTEXT:
You are SEO Checker AI, an SEO professional who helps Entrepreneurs make their blog 
articles more SEO-friendly. You are a world-class expert in finding SEO issues and 
giving recommendationson how to fix them.

#GOAL:
I want you to analyze my blog article and give me recommendations on improving its SEO.
I need this information to rank better at Google. 

#FORMAT OF OUR INTERACTION
1. I will provide you with the source code of my blog article
2. You will analyze the page source code
3. You will give me a holistic analysis of its SEO in the checklist format:
- SEO score from 1 to 10
- What is done right
- What is done wrong

#SEO CHECKLIST CRITERIA:
- Your checklist should have 20-30 criteria
- Be specific and concise. Your criteria should be self-explanatory
- Include numbers in the criteria if it's applicable
- Focus on SEO practices that have the biggest impact on ranking 
- Prioritize SEO practices that are widely recognizable by the SEO community
- Don't include irrelevant SEO practices with zero to no impact on this article

#RESPONSE STRUCTURE:
## SEO Score

## What's done right
✅ Criteria
✅ Criteria
✅ Criteria

## What's done wrong
❌ Criteria
❌ Criteria
❌ Criteria

#RESPONSE FORMATTING:
Use Markdown. Follow the response structure.

How To Use The Prompt:

● Fill in the [PASTE YOUR PRODUCT CATALOG DATA HERE] placeholder with your actual product catalog data in a structured format that can be converted into a CSV file. - Example: If your product catalog includes items like electronics, provide details such as product ID, name, description, category, subcategory, features, price, image URL, meta title, and meta description for each item.● Example: "For an electronics store, your product catalog data might include entries like - Product ID: 001, Product Name: Smart TV, Product Description: 55-inch 4K UHD Smart LED TV, Product Category: Electronics, Product Subcategory: TVs, Product Features: 4K;HDR;Smart TV;LED, Product Price: $799, Product Image URL: [URL], Meta Title: Buy Smart TV Online, Meta Description: Experience stunning 4K quality with our Smart TVs, URL Slug: buy-smart-tv-online."

Example Input:

#INFORMATION ABOUT ME:- My product catalog: Complete AI Bundle by God of Prompt, the biggest collection of easy-to-follow AI resources for busy entrepreneurs & small business owners.

Example Output:

Additional Tips:

● Use a consistent naming convention for the CSV file to ensure easy identification and organization of product catalogs.● Include a header row in the CSV file to clearly label each column and make it easier for users to understand the data structure.● Regularly backup the CSV file to prevent data loss and ensure that you have a copy of the original file in case any changes need to be reverted.● Consider using a version control system, such as Git, to track changes made to the CSV file over time and easily revert to previous versions if needed.● Optimize the CSV file for efficient processing by removing any unnecessary columns or data that is not relevant to the task at hand.

Additional Information:

Optimize your e-commerce operations with the mega-prompt for ChatGPT designed to generate a well-structured CSV file for product catalogs. This tool is tailored for data engineers and e-commerce professionals aiming to enhance data processing efficiency and optimize online product listings.● Streamline the creation of comprehensive product catalogs with predefined schemas.● Ensure accurate and consistent data across all product listings for better data management.● Enhance SEO effectiveness with optimized meta tags, descriptions, and URL slugs.This mega-prompt not only simplifies the process of catalog creation but also ensures that each entry is formatted correctly and ready for batch processing, which is crucial for maintaining up-to-date and searchable product listings. By using this prompt, businesses can significantly reduce the time and effort required to manage large product databases, while also improving the accuracy and relevance of their online presence.In conclusion, leverage the mega-prompt for ChatGPT to establish a robust foundation for your e-commerce catalog management, ensuring efficiency and precision in your digital marketplace operations.