[2025-08-05 01:42:24] [stock_debug] Lock acquired successfully. PID: 3580924
FBA Stock Check Debug
Database Connection Test:
Total products in database: 41584
FBA Products Check:
FBA products in database: 18146
Sample FBA products:
- SKU: 00-P4P8-WHXQ, Last stock check: 2025-08-05 00:48:09
- SKU: 00-SK2J-MPED, Last stock check: 2025-08-05 00:48:09
- SKU: 0002187264-N-009, Last stock check: 2025-08-05 00:48:09
- SKU: 0006380905-VG-021, Last stock check: 2025-08-05 00:48:09
- SKU: 0007141394-N-009, Last stock check: 2025-08-05 00:48:09
Original Query Results:
Products found by original query: 50
First 3 products:
- SKU: new_KVEWIHFBOR, Last check: 2025-08-04 19:41:13
- SKU: new_CBJXOLUM, Last check: 2025-08-04 19:41:13
- SKU: new_GUASFBZVRF, Last check: 2025-08-04 19:41:13
SKUs to process: new_KVEWIHFBOR, new_CBJXOLUM, new_GUASFBZVRF, new_USAKCWNWZF, new_WEPADCYP, new_JRKTOGQVYK, new_LRFXQBEZBH, new_DEAMCSUCCY, new_DAYRVKAIEO, new_WIOHHUGQ, new_WQLNMZSTW, new_EDSUEAYZEK, new_BSRCOFWBLO, new_IOKNFOSKEA, new_VBGFYAUKTB, new_CVCDIHYCO, new_XYZWGNIPDV, new_PCIMSRYJCT, new_YRDDECCMCE, new_LUVEEAKBKH, new_VFRAZNPSOC, new_MMPXTHPNRD, new_XWZQUUPX, new_GOCZWMXKFX, new_AYUPWEURO, new_GQFVYFAVH, new_IPSPZTWNIT, new_PKHPYHDEU, new_QIPGZLHCIE, uvg_QFIYXALGHE, new_VTMFHLAANG, new_FGNTYGZGOZ, new_MNHTBUJOK, 65-RCPD-TCAP, 8M-EIW1-F21U, 8N-4U41-DX2R, 8O-EW17-0HH4, 8W-6AI6-J0LO, 68-V1IH-VFA7, 8E-EIY1-8TX1, 69-VR68-0VVV, 6B-C9TR-UCNW, 4P-NIJD-COSZ, 6D-NNF0-PPWD, 8K-0VC0-SLXK, 87-DTZ0-XSHG, 85-YJC5-85QW, 64-O37G-HS2H, 8E-10UU-3BX5, 8D-U0UZ-FD0O
API Test (without SKUs):
API call successful without SKUs
Total inventory summaries: 50
Sample inventory items:
- SKU: 00-P4P8-WHXQ, ASIN: B07FNY8RPR
- SKU: 00-SK2J-MPED, ASIN: 0099437090
- SKU: 0002187264-N-009, ASIN: 0002187264
API Test (with SKUs):
API call successful with SKUs
Inventory summaries found: 50
Found inventory items:
- SKU: new_KVEWIHFBOR, ASIN: 144726410X, Fulfillable: 0
- SKU: new_CBJXOLUM, ASIN: 0141346841, Fulfillable: 0
- SKU: new_GUASFBZVRF, ASIN: B003YC5X80, Fulfillable: 1
- SKU: new_USAKCWNWZF, ASIN: 0091938945, Fulfillable: 0
- SKU: new_WEPADCYP, ASIN: 0091938945, Fulfillable: 0
- SKU: new_JRKTOGQVYK, ASIN: 0856483206, Fulfillable: 0
- SKU: new_LRFXQBEZBH, ASIN: 0552779903, Fulfillable: 0
- SKU: new_DEAMCSUCCY, ASIN: 1526629763, Fulfillable: 0
- SKU: new_DAYRVKAIEO, ASIN: 0224101749, Fulfillable: 0
- SKU: new_WIOHHUGQ, ASIN: 0007512082, Fulfillable: 0
- SKU: new_WQLNMZSTW, ASIN: 0600623505, Fulfillable: 0
- SKU: new_EDSUEAYZEK, ASIN: 0008279497, Fulfillable: 0
- SKU: new_BSRCOFWBLO, ASIN: 1847370330, Fulfillable: 0
- SKU: new_IOKNFOSKEA, ASIN: 1860463495, Fulfillable: 1
- SKU: new_VBGFYAUKTB, ASIN: 1849492255, Fulfillable: 0
- SKU: new_CVCDIHYCO, ASIN: 1786852829, Fulfillable: 0
- SKU: new_XYZWGNIPDV, ASIN: 0091926335, Fulfillable: 0
- SKU: new_PCIMSRYJCT, ASIN: 1846686164, Fulfillable: 0
- SKU: new_YRDDECCMCE, ASIN: 1853756164, Fulfillable: 0
- SKU: new_LUVEEAKBKH, ASIN: 0552173703, Fulfillable: 0
- SKU: new_VFRAZNPSOC, ASIN: 0745638376, Fulfillable: 1
- SKU: new_MMPXTHPNRD, ASIN: 0956420583, Fulfillable: 0
- SKU: new_XWZQUUPX, ASIN: 1848451725, Fulfillable: 0
- SKU: new_GOCZWMXKFX, ASIN: 0008317852, Fulfillable: 1
- SKU: new_AYUPWEURO, ASIN: 1844081478, Fulfillable: 0
- SKU: new_GQFVYFAVH, ASIN: 0385614438, Fulfillable: 0
- SKU: new_IPSPZTWNIT, ASIN: 0857831046, Fulfillable: 1
- SKU: new_PKHPYHDEU, ASIN: 0008235627, Fulfillable: 0
- SKU: new_QIPGZLHCIE, ASIN: 0571316522, Fulfillable: 0
- SKU: uvg_QFIYXALGHE, ASIN: 0752851608, Fulfillable: 0
- SKU: new_VTMFHLAANG, ASIN: 1841811750, Fulfillable: 0
- SKU: new_FGNTYGZGOZ, ASIN: 1788424239, Fulfillable: 0
- SKU: new_MNHTBUJOK, ASIN: 0671714066, Fulfillable: 0
- SKU: 65-RCPD-TCAP, ASIN: B07FNY8RPR, Fulfillable: 0
- SKU: 8M-EIW1-F21U, ASIN: B099L7M7XL, Fulfillable: 0
- SKU: 8N-4U41-DX2R, ASIN: 147226407X, Fulfillable: 0
- SKU: 8O-EW17-0HH4, ASIN: 0091924855, Fulfillable: 0
- SKU: 8W-6AI6-J0LO, ASIN: B0C2NQ4PTC, Fulfillable: 0
- SKU: 68-V1IH-VFA7, ASIN: 1780897952, Fulfillable: 0
- SKU: 8E-EIY1-8TX1, ASIN: 0857524755, Fulfillable: 0
- SKU: 69-VR68-0VVV, ASIN: 0415533740, Fulfillable: 0
- SKU: 6B-C9TR-UCNW, ASIN: B07TN8SLWP, Fulfillable: 0
- SKU: 4P-NIJD-COSZ, ASIN: B07V9PNM7C, Fulfillable: 0
- SKU: 6D-NNF0-PPWD, ASIN: 1137289252, Fulfillable: 0
- SKU: 8K-0VC0-SLXK, ASIN: B07C7DWWXL, Fulfillable: 0
- SKU: 87-DTZ0-XSHG, ASIN: 178097907X, Fulfillable: 0
- SKU: 85-YJC5-85QW, ASIN: 0224036882, Fulfillable: 0
- SKU: 64-O37G-HS2H, ASIN: B01CML580G, Fulfillable: 0
- SKU: 8E-10UU-3BX5, ASIN: 1838773169, Fulfillable: 0
- SKU: 8D-U0UZ-FD0O, ASIN: 000835832X, Fulfillable: 0
Recommendations:
1. Found 50 FBA SKUs to process.
2. API should return inventory for these SKUs.
Script executed in 1.3047118186951 seconds. [2025-08-05 02:42:25] [stock_debug] Lock released successfully.