#!/usr/bin/env python3
"""Debug: sample rows from Van Arendonk CSV to see why 0 sneakers matched."""
import requests, csv, io

TOKEN = "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiIxMDAwMzEiLCJqdGkiOiIwNjM5ODEwYzQ0YzM1MTBlZmZiMGRkYWNiM2EyNWFlNTg2YzFmNmQ5ODNjNGQ2MDA4NzkwZmM0NTkzY2EyNjg4ZGViZDE4NTgwOThmYjJjYiIsImlhdCI6MTc3MTUxNjc4OS44MzAxMzUsIm5iZiI6MTc3MTUxNjc4OS44MzAxMzcsImV4cCI6MjA4NzA0OTU4OS44MjcwODgsInN1YiI6IjIwMTcwOCIsInNjb3BlcyI6W119.ZxlCDsyBI7_SNUWjO-PUxDYKvQVfuUBzU5n-SgqHdAZCnOj9253yVcJIS5NRXJLrnyx0E_9bn8ymfXS71cvPISA4hPAlKCSMjdkv9f2k2FFwdAlQQ6mdhBB2m9dzHUIn34QwA8s4-ikB1ATKIZeqiJL-3Gh9eiMYPpvaJdCCjN-oGPMhhlehkgA04cZSgwy6HfKgb6uPvUSG9w_tvN8U06uEHKV11DedQHNWWGzuXpd2FEL3baV0z9KjSNMZsJZHx2yHUb6gVWJwaR7_louahMvrPXG-YLgnGvNMcPDPjm-z5HJ-JKcPv9_FBqAYGItZxgeGgVoS8MVhW6lc1a-6CvYtVanfXF42MPPNP-Qq76qRtHPLRBdkIATMuBxVJrMzlprT3n4F0sUUltGR4ixZuzMUm5LeyPMHgmjy2UfYzsl9eVqx0oJCmKUyY9maBXwFLJa8J1NHM_nWp3hPpCGkMyhzHK1DIf_z8Wirg1hp5vKts93eERWJBlQwhucUUS_KnZeC_gVaQ7kT4jCwaEWkpPxPxyXWRoK0mcYS_JGz3JbpVhRLj5DVYIB9k54DXqjYlCx8ezJZE9sf2SX3VWvPvD1xSQD1caTCm0To0B-MkeU1YpEfWdUslpCJXrpOy2Wbs8iDHR1BzNrMnOEr4zbz_EoB4JJe3tGTGjzNLNIw6XI"

FEEDS = [("17108", "Van Arendonk"), ("36168", "Patta"), ("18588", "Baskets")]
BASE = "https://platform-api.webgains.com/auth/publishers/1347930/campaigns/1622230/feeds/products"

for fid, name in FEEDS:
    url = f"{BASE}?feedIds[]={fid}&format=csv"
    r = requests.get(url, headers={"Authorization": f"Bearer {TOKEN}"}, timeout=60)
    reader = csv.DictReader(io.StringIO(r.text))
    rows = list(reader)
    
    print(f"\n=== {name} ({fid}) — {len(rows)} rows ===")
    print(f"Columns: {reader.fieldnames}")
    
    # Find sneaker-like rows
    sneaker_brands = {'nike', 'adidas', 'new balance', 'puma', 'asics', 'jordan', 'converse', 'vans'}
    found = 0
    for row in rows:
        brand = (row.get('brand') or '').lower()
        title = (row.get('title') or '').lower()
        gcat = row.get('google_product_category') or row.get('google_product_category_text') or ''
        ptype = row.get('product_type') or ''
        if brand in sneaker_brands or 'sneaker' in title:
            if found < 3:
                print(f"\n  Brand: {row.get('brand')}")
                print(f"  Title: {row.get('title')}")
                print(f"  google_product_category: {gcat}")
                print(f"  product_type: {ptype}")
                print(f"  google_product_category_text: {row.get('google_product_category_text', 'N/A')}")
            found += 1
    print(f"  Found {found} sneaker-brand rows out of {len(rows)}")