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.

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.

Products

Moroccan Nila Powder

Premium Moroccan Blue Nila Whitening Powder sulphate free for face and body glow

Stock: 0

Availability

Available

Type: Single

Discount: 0.00%

Available

Price
Rs. 1500.00

Natural Soap

Natural soap for deep cleansing tan and dullness care with soft fresh glowing skin feel

Stock: 0

Availability

Available

Type: Single

Discount: 0.00%

Available

Price
Rs. 600.00

Soothing Rose Water

Natural rose water for hydration pore freshness soothing care and natural glow

Stock: 0

Availability

Available

Type: Single

Discount: 0.00%

Available

Price
Rs. 250.00

Exfoliating Glove

Premium exfoliating glove for deep exfoliation dead skin removal and smoother brighter-looking skin

Stock: 0

Availability

Available

Type: Single

Discount: 0.00%

Available

Price
Rs. 350.00

Hammam Ritual Scrub

Hammam ritual exfoliating scrub for soft smooth radiant skin and relaxing self-care

Stock: 0

Availability

Available

Type: Single

Discount: 0.00%

Available

Price
Rs. 1250.00

Royal Hamam Ritual

Your flagship bundle includes Nila Powder, Rose Water, Exfoliating Glove, Scrub and Soap. Original price 3950. Deal price 3555.

Stock: 0

Availability

Available

Type: Deal

Discount: 0.00%

Available

Deal Price
Rs. 3555.00

Deal Item: Nila Powder + Rose Water + Exfoliating Glove + Scrub + Soap

Complete Glow Ritual

Best face and body glow bundle includes Nila Powder, Rose Water, Scrub and Soap. Original price 3600. Deal price 3240.

Stock: 0

Availability

Available

Type: Deal

Discount: 0.00%

Available

Deal Price
Rs. 3240.00

Deal Item: Moroccan Nila Powder + Soothing Rose Water + Hammam Ritual Scrub + Natural Soap

Glow Prep Bundle

Perfect pre-event and bridal bundle includes Nila Powder, Rose Water, Glove and Scrub. Original price 3350. Deal price 3015.

Stock: 0

Availability

Available

Type: Deal

Discount: 0.00%

Available

Deal Price
Rs. 3015.00

Deal Item: Moroccan Nila Powder + Soothing Rose Water + Exfoliating Glove + Hammam Ritual Scrub

Everyday Glow

Easy daily glow care bundle includes Nila Powder, Scrub and Soap. Original price 3350. Deal price 3015.

Stock: 0

Availability

Available

Type: Deal

Discount: 0.00%

Available

Deal Price
Rs. 3015.00

Deal Item: Moroccan Nila Powder + Hammam Ritual Scrub + Natural Soap

Shower Polish

Smooth skin shower combo includes Scrub and Soap. Original price 1850. Deal price 1665.

Stock: 0

Availability

Available

Type: Deal

Discount: 0.00%

Available

Deal Price
Rs. 1665.00

Deal Item: Hammam Ritual Scrub + Natural Soap

Glow Prep Trio

Simple 3-step glow essentials bundle includes Nila Powder, Scrub and Rose Water. Original price 3000. Deal price 2700.

Stock: 0

Availability

Available

Type: Deal

Discount: 0.00%

Available

Deal Price
Rs. 2700.00

Deal Item: Moroccan Nila Powder + Hammam Ritual Scrub + Soothing Rose Water

Daily Glow Duo

Quick everyday care duo includes Soap and Powder. Original price 2100. Deal price 1890.

Stock: 0

Availability

Available

Type: Deal

Discount: 0.00%

Available

Deal Price
Rs. 1890.00

Deal Item: Natural SoapDeal Item: Moroccan Nila Powder

Glow Polish

Polish and refresh duo includes Nila Powder and Scrub. Original price 2750. Deal price 2475.

Stock: 0

Availability

Available

Type: Deal

Discount: 0.00%

Available

Deal Price
Rs. 2475.00

Deal Item: Moroccan Nila Powder + Hammam Ritual Scrub

Morrocan Nila Powder

Global Settings

Main Setting

Main Brand Details

Page Passwords

Page Passwords

Main Page Passwords

Add Category

Add New Item

Bulk CSV

Bulk Images

Products

Moroccan Nila Powder

Natural Soap

Soothing Rose Water

Exfoliating Glove

Hammam Ritual Scrub

Royal Hamam Ritual

Complete Glow Ritual

Glow Prep Bundle

Everyday Glow

Shower Polish

Glow Prep Trio

Daily Glow Duo

Glow Polish

Edit Category

Edit Item

Quick Match Image