[2025-08-05 02:18:58] [shopify_product_import] Lock acquired successfully. PID: 3589712
 🔍 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
<br />
<b>Warning</b>:  file_put_contents(/var/www/html/crons/logs/shopify_product_import.log): Failed to open stream: Permission denied in <b>/var/www/html/crons/shopify_product_import.php</b> on line <b>27</b><br />
<br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined method ShopifyProductUploader::getProductsToProcess() in /var/www/html/crons/shopify_product_import.php:156
Stack trace:
#0 /var/www/html/crons/shopify_product_import.php(193): ShopifyProductImportCron-&gt;run()
#1 {main}
  thrown in <b>/var/www/html/crons/shopify_product_import.php</b> on line <b>156</b><br />
[2025-08-05 03:19:02] [shopify_product_import] Lock released successfully.