Stock Central doesn’t match WooCommerce

maydel

Hello,

I’ve been using the ATUM free plugin mostly without issue, but all of a sudden today Stock Central is saying that all of my managed products are out of stock.

https://www.dropbox.com/scl/fi/bo90x3e5ym0x1a7dq1n9x/Screen-Shot-2024-05-06-at-10.26.58-PM.png?rlkey=lfloux3ascquco9khatem1hxr&st=koq3zi8o&dl=0

Even more confusing, when you click on the “Out of Stock” products tab, nothing shows in the table, and when I search for an individual product in the “All” tab, the products show up with their correct stock numbers and status.

https://www.dropbox.com/scl/fi/t51id30h0rgxaku41gajv/Screen-Shot-2024-05-06-at-10.30.01-PM.png?rlkey=069czvyx67il31bzs43p4p8mv&st=vgvgsh0o&dl=0

I’ve tried running both the “Update products’ calculated properties” and “Delete ATUM transients” tools, but nothing has changed. I’ve cleared the cache, deactivated and re-activated the plugin, too. I’ve added new simple products recently, but I haven’t installed or updated any plugins. I'm running the latest versions of Wordpress, WooCommerce, and ATUM. Even when all other plugins are disabled this problem persists.

Any idea what might be happening here? I'm unable to access the actual site files until my developer returns next week. Is there any way to view the PHP log through WP or my web host (e.g. PHP Admin)?

japiera

Hi maydel ,

I closed your ticket in the WordPress Forum.

However, you didn't answer all my questions:

Is anything added to your PHP Error log when accessing the “empty” Stock Central? Please read this if you don’t know how to enable it.

Best Regards,
José Andrés

maydel

Hi José,
Yes, I've just gotten the error log from my developer and there are many pages of errors being generated when I click to the different tabs, update a quantity, and run a search. For example, here is what it generates when I click to one of the tabs in Stock Central:
[08-May-2024 17:23:14 UTC] KILLED QUERY (16541 characters long generated in /nas/content/live/maydel/wp-content/plugins/atum-stock-manager-for-woocommerce/classes/Components/AtumListTables/AtumListTable.php:3021):
SELECT mdL8_posts.ID
FROM mdL8_posts INNER JOIN mdL8_atum_product_data ON ( mdL8_posts.ID = mdL8_atum_product_data.product_id ) INNER JOIN mdL8_atum_product_data AS apd1 ON ( mdL8_posts.ID = apd1.product_id )
WHERE 1=1 AND mdL8_posts.ID IN (19464,19460,19461.....4663,4664,4665) AND ((mdL8_posts.post_type = 'product' AND (mdL8_posts.post_status = 'publish' OR mdL8_posts.post_status = 'acf-disabled' OR mdL8_posts.post_status = 'future' OR mdL8_posts.post_status = 'draft' OR mdL8_posts.post_status = 'pending'
OR mdL8_posts.post_status = 'private')) OR (mdL8_posts.post_type = 'product_variation' AND (mdL8_posts.post_status = 'publish' OR mdL8_posts.post_status = 'acf-disabled' OR mdL8_posts.post_status = 'future' OR mdL8_posts.post_status = 'draft' OR mdL8_posts.post_status = 'pending'
OR mdL8_posts.post_status = 'private'))) AND (
(
CAST(mdL8_atum_product_data.atum_controlled AS SIGNED) = '1'
AND
apd1.atum_stock_status = 'instock'
)
)

Would it be helpful for me to upload the full error log somewhere? If so, please let me know where to post it.

Thank you!

japiera

Hi maydel ,

Thanks. I see.

Please create a private ticket here to upload the complete error log. Also, please tell us which hosting provider you use.

Best Regards,
José Andrés

maydel

P.S. I inserted the ellipsis between 19461 and 4663 in the product ID list since there were too many to paste.

maydel

Just submitted with full error log attached. Thank you for taking a look!

japiera

Hi maydel ,

You're welcome.

I already answered you there. Please keep the conversation there.

Best Regards,
José Andrés