You are an expert e-commerce product data extractor and content writer specialized in pet products.
I will give you:
1. Three product links of the **same product** (from different stores or the same store).
2. A hierarchical category tree.
Your tasks:
### 1. Category Selection
From the provided category tree, choose **only the most relevant last-child (leaf) category**.
Return the full path as well (e.g. Food And Treats > Cat Food > Cat Treats > Creamy Treats).
### 2. Extract & Generate Complete Product Data
Analyze all three links carefully and create high-quality data that matches this exact database structure:
#### Main Product Table (`products`)
- alt_en: SEO-friendly alt text in English
- alt_ar: SEO-friendly alt text in Arabic
- title_en: Clean, SEO-optimized product title in English
- title_ar: Clean, SEO-optimized product title in Arabic
- title_fa: Translate the english title to farsi.
- text_en: **Full rich HTML description** in English. Must include proper semantic HTML tags such as <h2>, <h3>, <h4>, <p>, <ul>, <ol>, <li>, <table>, <tr>, <td>, <th>, <b>, <strong>, <span>, <br>, etc. Use colors with inline styles when useful (e.g. <span style="color:#e74c3c">). Structure the content professionally with sections like Key Features, Ingredients, Benefits, Feeding Guide, etc. Make it long, detailed and sales-oriented.
- text_ar: Same rich HTML description fully translated into natural Arabic (keep all HTML tags).
- information: JSON object containing structured data.
**Important:** All keys and all values must be in both English and Arabic.
Only include real data found on the product pages.
- meta_description_en: Compelling meta description (max 160 characters) in English
- meta_description_ar: Compelling meta description (max 160 characters) in Arabic
- active: true
- iran_list_showing: true
- show_in_price_list: true
- company_id: null
- brand_id: null
- user_id: null
#### Tags (`product_tags`)
Suggest 5–12 relevant tags. For each tag provide:
- product_tag_en
- product_tag_ar
### Output Format (strictly follow this structure)
```json
{
"selected_category": {
"full_path": "Food And Treats > Cat Food > Cat Treats > Creamy Treats",
"leaf_name_en": "Creamy Treats"
},
"product": {
"alt_en": "",
"alt_ar": "",
"title_en": "",
"title_ar": "",
"title_fa": null,
"text_en": "<h2>...</h2><p>...</p>...",
"text_ar": "<h2>...</h2><p>...</p>...",
"meta_description_en": "",
"meta_description_ar": "",
"information": [{
"Detail_Name_EN": "Product Type",
"Detail_Value_EN": "Cat Treats",
"Detail_Name_AR": "نوع المنتج",
"Detail_Value_AR": "وجبات القطط" },
{
"Detail_Name_EN": "Flavor",
"Detail_Value_EN": "Chicken & Catnip",
"Detail_Name_AR": "النكهة",
"Detail_Value_AR": "دجاج وكاتنيب" }],
"active": true,
"iran_list_showing": true,
"show_in_price_list": true,
"company_id": null,
"brand_id": null,
"user_id": null
},
"tags": [
{
"product_tag_en": "",
"product_tag_ar": "",
}
]
}
Product Link 1:https:https:https:https:https:https://www.wanpy.com/cat-food/creamy-treat-turkey-cranberry-for-sterilized-cats
Product Linkhttpshttps:https:https://petcornerdubai.com/26859/product/wanpy-creamy-treat-for-sterilized-turkey-cranberry?gad_source=1&gad_campaignid=22035492187&gbraid=0AAAAApuGmPBiYtFIssVaF0Mjv-t4FRgwX&gclid=CjwKCAjwqJXUBhBNEiwA8BgG7k4RZDzz4ZBqPjb2_J3j3KhRkD7_-6gKxLrM1BdMwNJzdadm8lm0tBoCiksQAvD_BwE
Product Link 3httpshttps:httpshttps:https:https:https://www.noon.com/uae-en/wanpy-creamy-treat-for-sterilized-turkey-cranberry/Z19E9B2F300EBCC962DADZ/p/
Among all these categories, which last child is the most relevant to this product? [{"name_en":"Food And Treats","children":[{"name_en":"Cat Food","children":[{"name_en":"Cat Treats","children":[{"name_en":"Sticks","children":[]},{"name_en":"Creamy Treats","children":[{"name_en":"Functional Creamy Treats","children":[]}]},{"name_en":"Crunchy Treats","children":[]},{"name_en":"Soft Bites","children":[]},{"name_en":"Dental Treats","children":[]},{"name_en":"Freeze-Dried Treats","children":[]},{"name_en":"Hairball Control Treats","children":[]},{"name_en":"Grain-Free Treats","children":[]},{"name_en":"Snack","children":[]},{"name_en":"Liquid Treats","children":[]},{"name_en":"Jerky","children":[]}]},{"name_en":"Wet Food","children":[{"name_en":"Pouch","children":[]},{"name_en":"Cans","children":[]},{"name_en":"Woom","children":[]},{"name_en":"Gravy-Based","children":[]},{"name_en":"Jelly-Based","children":[]},{"name_en":"Loaf\/Pat\u00e9 Style","children":[]},{"name_en":"Grain-Free Wet Food","children":[]},{"name_en":"Kitten Wet Food","children":[]},{"name_en":"Stews","children":[]},{"name_en":"Fillets","children":[]},{"name_en":"Pudding","children":[]},{"name_en":"Meat Broth","children":[]}]},{"name_en":"Dry Food","children":[{"name_en":"Grain-Free","children":[]},{"name_en":"Kitten Dry Food","children":[]},{"name_en":"Dental Care Dry Food","children":[]},{"name_en":"Hairball Control","children":[]},{"name_en":"Adult Food","children":[]},{"name_en":"Junior Food","children":[]}]},{"name_en":"Healthy","children":[{"name_en":"Sterilized Food","children":[]},{"name_en":"Hypoallergenic","children":[]},{"name_en":"Sensitive Stomach","children":[]},{"name_en":"Low-Calorie","children":[]},{"name_en":"Urinary Health","children":[]},{"name_en":"Joint Support","children":[]},{"name_en":"Malt Paste","children":[]},{"name_en":"Supplement","children":[]}]}]},{"name_en":"Dog Food","children":[{"name_en":"Wet Food","children":[{"name_en":"Cans","children":[]},{"name_en":"Pouch","children":[]},{"name_en":"Stews","children":[]},{"name_en":"Loaf\/Pat\u00e9 Style","children":[]},{"name_en":"Gravy-Based","children":[]},{"name_en":"Jelly-Based","children":[]},{"name_en":"Grain-Free Wet Food","children":[]},{"name_en":"Puppy Wet Food","children":[]},{"name_en":"Senior Wet Food","children":[]},{"name_en":"Woom","children":[]},{"name_en":"Pudding","children":[]}]},{"name_en":"Dry Food","children":[{"name_en":"Grain-Free","children":[]},{"name_en":"Puppy Dry Food","children":[]},{"name_en":"Senior Dry Food","children":[]},{"name_en":"Large Breed Dry Food","children":[]},{"name_en":"Small Breed Dry Food","children":[]},{"name_en":"Adult Food","children":[]}]},{"name_en":"Dog Treats","children":[{"name_en":"Chew Sticks","children":[]},{"name_en":"Training Treats","children":[]},{"name_en":"Dental Chews","children":[]},{"name_en":"Soft Bites","children":[]},{"name_en":"Jerky","children":[]},{"name_en":"Biscuits","children":[]},{"name_en":"Rawhide-Free Chews","children":[]},{"name_en":"Freeze-Dried Treats","children":[]},{"name_en":"Grain-Free Treats","children":[]},{"name_en":"Creamy Treats","children":[]},{"name_en":"Snacks","children":[]}]},{"name_en":"Healthy","children":[{"name_en":"Weight Management Dry Food","children":[]},{"name_en":"Sensitive Stomach","children":[]},{"name_en":"Weight Management","children":[]},{"name_en":"Joint Support","children":[]},{"name_en":"Digestive Health","children":[]},{"name_en":"Urinary Health","children":[]},{"name_en":"Malt Paste","children":[]}]}]},{"name_en":"Birds Food","children":[{"name_en":"Bird Seeds","children":[]},{"name_en":"Bird Pellets","children":[]},{"name_en":"Suet Cakes","children":[]},{"name_en":"Millet Sprays","children":[]},{"name_en":"Fruit & Nut Mix","children":[]},{"name_en":"Egg Food","children":[]},{"name_en":"Nectar","children":[]},{"name_en":"Insect Mix","children":[]},{"name_en":"Vitamin-Enriched Food","children":[]},{"name_en":"Treats For Birds","children":[]},{"name_en":"Bird Biscuits","children":[]}]},{"name_en":"Rodents","children":[{"name_en":"Pellets","children":[]},{"name_en":"Hay","children":[]},{"name_en":"Seeds Mix","children":[]},{"name_en":"Dried Vegetables","children":[]},{"name_en":"Treats","children":[]},{"name_en":"Vitamin-Enriched Food","children":[]},{"name_en":"Grain-Free Food","children":[]},{"name_en":"High-Fiber Food","children":[]},{"name_en":"Dental Chews","children":[]}]},{"name_en":"Fish Food","children":[{"name_en":"Flakes","children":[]},{"name_en":"Pellets","children":[]},{"name_en":"Frozen","children":[]},{"name_en":"Treats","children":[]}]}]},{"name_en":"Apparel And Accessories","children":[{"name_en":"Dog Apparel","children":[]},{"name_en":"Cat Apparel","children":[]},{"name_en":"Carriers And Travel Accessories","children":[]},{"name_en":"Walking Accessories","children":[]},{"name_en":"Poop Bag Holders And Dispensers","children":[]},{"name_en":"Bowls And Feeders","children":[]},{"name_en":"Bottle","children":[]},{"name_en":"Cage","children":[]},{"name_en":"Aquarium And Fish Accessories","children":[{"name_en":"Aquariums And Tanks","children":[]},{"name_en":"Filters & Pumps","children":[]},{"name_en":"Heaters","children":[]},{"name_en":"Air Stones & Bubblers","children":[]},{"name_en":"Lighting Systems","children":[]},{"name_en":"Thermometers","children":[]},{"name_en":"Backgrounds & Decorations","children":[]},{"name_en":"Substrate (Gravel, Sand, Soil)","children":[]},{"name_en":"Live & Artificial Plants","children":[]}]}]},{"name_en":"Grooming Products","children":[{"name_en":"Nail Clippers And Files","children":[]},{"name_en":"Cleaning Items","children":[]},{"name_en":"Bath And Wash","children":[]},{"name_en":"Brushes And Combs","children":[]},{"name_en":"Dental Care","children":[]},{"name_en":"Shampoos And Conditioners","children":[]},{"name_en":"Ear And Eye Care","children":[]}]},{"name_en":"Health And Wellness","children":[{"name_en":"First Aid And Recovery","children":[]},{"name_en":"Flea And Tick Control","children":[]},{"name_en":"Nursing And Feeding Supplies","children":[{"name_en":"Pet Pacifier Bottle Set","children":[]},{"name_en":"Injector","children":[]}]},{"name_en":"Supplements And Vitamins","children":[]},{"name_en":"Wormers And Heartworm Prevention","children":[]},{"name_en":"Fish Medications","children":[]}]},{"name_en":"Collars, Leashes And Tags","children":[{"name_en":"Cat Collars And Leashes","children":[]},{"name_en":"Dog Collars And Leashes","children":[]},{"name_en":"ID Tags And Charms","children":[]},{"name_en":"Safety","children":[]}]},{"name_en":"Toys","children":[{"name_en":"Dog Toys","children":[]},{"name_en":"Cat Toys","children":[]},{"name_en":"Interactive Toys","children":[]},{"name_en":"Chew Toys","children":[]},{"name_en":"Scratch Toys","children":[]},{"name_en":"Training And Puzzle Toys","children":[]}]},{"name_en":"Beds And Furniture","children":[{"name_en":"Dog Beds And Mats","children":[]},{"name_en":"Cat Beds And Mats","children":[]},{"name_en":"Cat Trees And Condos","children":[]},{"name_en":"Crates, Gates And Pens","children":[]}]},{"name_en":"Hygiene","children":[{"name_en":"Cat Litter","children":[]},{"name_en":"Waste
