Admin Panel

Copy a criteria prompt, paste it into ChatGPT, then add your raw product list, text, or images.

Please convert my raw product catalog into upload-ready CSV text for my Product Edition system.

Return ONLY CSV text. Do not use markdown, code fences, notes, headings, or explanations.

Use this exact header and exact column order:
category_name,item_name,item_type,item_description,base_price,sku,barcode,stock_quantity,cost_price,variant_name,variant_group,variant_price,variant_sku,variant_barcode,variant_stock,variant_cost,is_available,sort_order

Rules:
1. category_name and item_name are required on every row.
2. item_type must be exactly single, variation, or deal.
3. For a normal single product: use one row, set item_type=single, put the selling price in base_price, and fill sku, barcode, stock_quantity, and cost_price when available. Leave all variant fields empty.
4. For a variation product: use one row per variation. Repeat category_name, item_name, item_type=variation, and item_description on every row. Leave base_price empty or 0 unless there is a genuine parent price. Put the option in variant_name, use variant_group=variation, and fill variant_price, variant_sku, variant_barcode, variant_stock, and variant_cost for that option.
5. For products with several option combinations, write the complete option name in variant_name, for example Black / Large.
6. For a bundle/deal product: use a main row with item_type=deal and the bundle selling price in base_price. Optional included components may use additional rows with variant_group=deal_item. Use variant_group=drink only when relevant.
7. sku and variant_sku are text identifiers. Preserve letters, dashes, spaces, and leading zeroes. Do not invent them.
8. barcode and variant_barcode are text values. Preserve leading zeroes and wrap long barcode values in double quotes.
9. stock_quantity and variant_stock must be numeric quantities. Use 0 when stock is unknown.
10. cost_price and variant_cost are purchase costs, not selling prices. Use 0 or leave empty when unknown.
11. is_available must be 1 for available or 0 for unavailable. Use 1 unless clearly unavailable.
12. sort_order must be a whole number. Use 10, 20, 30, etc.
13. Use numbers only for price and cost fields. Do not include Rs, PKR, currency symbols, or thousands separators.
14. If a value contains a comma, wrap that field in double quotes according to CSV rules.
15. Do not invent missing prices, SKU, barcode, stock, or cost values.
16. Do not add extra columns and do not omit any required column.

Now convert the raw product list I provide after this instruction into the required CSV.

Please convert my raw product updates into an upload-ready PRICE / STOCK UPDATE CSV for my Product Edition system.

Return ONLY CSV text. Do not use markdown, code fences, notes, headings, or explanations.

Use this exact header and exact column order:
category_name,item_name,item_type,item_description,base_price,sku,barcode,stock_quantity,cost_price,variant_name,variant_group,variant_price,variant_sku,variant_barcode,variant_stock,variant_cost,is_available,sort_order

Rules:
1. Include only products or variations that need updating.
2. item_name is required. category_name should be included whenever known because matching uses category + item name.
3. For a single product or deal: put the new selling price in base_price. Fill only the other item-level fields that must change: sku, barcode, stock_quantity, cost_price, is_available, or sort_order.
4. For a variation: use one row per variation, set item_type=variation, put its exact existing name in variant_name, use variant_group=variation, and fill only fields that must change: variant_price, variant_sku, variant_barcode, variant_stock, variant_cost, is_available, or sort_order.
5. Leave any field empty when it must not be changed.
6. Do not rename products or variations in an update CSV. Names must match the existing catalog exactly.
7. Preserve leading zeroes in SKU and barcode fields. Wrap long barcode values in double quotes.
8. Use numbers only for price, cost, and stock fields. Do not include Rs, PKR, currency symbols, or thousands separators.
9. is_available must be 1 or 0 when supplied.
10. Do not invent missing values.
11. Do not add extra columns and do not omit any required column.

Now convert the raw product updates I provide after this instruction into the required CSV.

Product Business System

SHOES

FORMALS

Product Business System

Global Settings

Add Category

Add New Item

Bulk CSV

Bulk Images

SHOES

FORMALS

Edit Category

Edit Item

Quick Match Image