🔍 Executing SQL Query:

            SELECT 
                MIN(p.id) as first_id,
                p.isbn,
                p.pcondition,
                ANY_VALUE(p.product_name) as product_name,
                GROUP_CONCAT(p.sku) as skus,
                COUNT(*) as quantity,
                ANY_VALUE(p.price) as price,
                ANY_VALUE(pd.manufacturer) as manufacturer,
                ANY_VALUE(pd.bullet_points_json) as bullet_points_json,
                ANY_VALUE(pd.binding) as binding,
                ANY_VALUE(pd.edition) as edition,
                ANY_VALUE(pd.number_of_pages) as number_of_pages,
                ANY_VALUE(pd.publication_date) as publication_date,
                ANY_VALUE(pd.language) as language,
                ANY_VALUE(pd.description) as description,
                ANY_VALUE(pd.author_primary) as author_primary,
                ANY_VALUE(pd.author_secondary) as author_secondary,
                ANY_VALUE(pd.keywords) as keywords
            FROM amazon_products p
            LEFT JOIN amazon_product_details pd ON p.id = pd.product_id
            LEFT JOIN amazon_product_categories apc ON p.id = apc.product_id
            WHERE p.added_shopify IS NULL 
            AND p.active = 1 
            AND p.data_fetch_failed = 0
            AND p.fulfillment = 'FBM'
            AND p.fulfillable_quantity > 0
            AND apc.category_id IS NOT NULL
            GROUP BY p.isbn, p.pcondition
            ORDER BY first_id ASC
            LIMIT 1
        

❌ No products found. Debug info:
- Number of rows returned: 0
- Checking individual conditions:
  SELECT COUNT(*) as count FROM amazon_products WHERE added_shopify IS NULL
  Result: 27175 rows

  SELECT COUNT(*) as count FROM amazon_products WHERE active = 1
  Result: 12601 rows

  SELECT COUNT(*) as count FROM amazon_products WHERE data_fetch_failed = 0
  Result: 41447 rows

  SELECT COUNT(*) as count FROM amazon_products WHERE fulfillment = 'FBM'
  Result: 23387 rows

  SELECT COUNT(*) as count FROM amazon_products WHERE fulfillable_quantity > 0
  Result: 12518 rows

🔍 Executing SQL Query:

            SELECT 
                MIN(p.id) as first_id,
                p.isbn,
                p.pcondition,
                ANY_VALUE(p.product_name) as product_name,
                GROUP_CONCAT(p.sku) as skus,
                COUNT(*) as quantity,
                ANY_VALUE(p.price) as price,
                ANY_VALUE(pd.manufacturer) as manufacturer,
                ANY_VALUE(pd.bullet_points_json) as bullet_points_json,
                ANY_VALUE(pd.binding) as binding,
                ANY_VALUE(pd.edition) as edition,
                ANY_VALUE(pd.number_of_pages) as number_of_pages,
                ANY_VALUE(pd.publication_date) as publication_date,
                ANY_VALUE(pd.language) as language,
                ANY_VALUE(pd.description) as description,
                ANY_VALUE(pd.author_primary) as author_primary,
                ANY_VALUE(pd.author_secondary) as author_secondary,
                ANY_VALUE(pd.keywords) as keywords
            FROM amazon_products p
            LEFT JOIN amazon_product_details pd ON p.id = pd.product_id
            LEFT JOIN amazon_product_categories apc ON p.id = apc.product_id
            WHERE p.added_shopify IS NULL 
            AND p.active = 1 
            AND p.data_fetch_failed = 0
            AND p.fulfillment = 'FBM'
            AND p.fulfillable_quantity > 0
            AND apc.category_id IS NOT NULL
            GROUP BY p.isbn, p.pcondition
            ORDER BY first_id ASC
            LIMIT 1
        

❌ No products found. Debug info:
- Number of rows returned: 0
- Checking individual conditions:
  SELECT COUNT(*) as count FROM amazon_products WHERE added_shopify IS NULL
  Result: 27175 rows

  SELECT COUNT(*) as count FROM amazon_products WHERE active = 1
  Result: 12601 rows

  SELECT COUNT(*) as count FROM amazon_products WHERE data_fetch_failed = 0
  Result: 41447 rows

  SELECT COUNT(*) as count FROM amazon_products WHERE fulfillment = 'FBM'
  Result: 23387 rows

  SELECT COUNT(*) as count FROM amazon_products WHERE fulfillable_quantity > 0
  Result: 12518 rows

✅ 0/2 products uploaded