omnisite

Thanks for sharing! I fixed it in 1.5.4.1 but my new version does not seem to show up in the WP repo yet. I will let you know when it’s updated.

Also, if I read correctly on your WP link, the numbered placeholders were re-introduced: https://core.trac.www.ads-software.com/changeset/42068

Sorry, typo: %1s is what I meant. You can just try the query in mysql itself. If you do post_id IN(‘123,145’) it will give you 1 result. Without the quotes like post_id IN(123,145) will give you multiple results.

I had the same and debugged until I found it:
In the method retrive_product_ids() the query has a bug ->
$select_Query = $wpdb->get_col($wpdb->prepare(“SELECT meta_value from $wpdb->postmeta where post_id IN(%s) and meta_key =’cwginstock_pid'”, $post_ids));

Change it to:
$select_Query = $wpdb->get_col($wpdb->prepare(“SELECT meta_value from $wpdb->postmeta where post_id IN(1%s) and meta_key =’cwginstock_pid'”, $post_ids));

So %s to 1%s. Because the current query will read post_id IN(‘123,145’) and thus will only look at 123 in the meta table, so only 1 product will be tracked. If you change to 1%s, it will be post_id IN(123,145), so without the quotes and will then result in all needed meta values.

Sorry, I had fixed it 22 days ago, but forgot to upload the changes to the WordPress plugin repo. Did that now.

Hi thanks, I saw it. The working of the plugin is not affected luckily. Only in debug mode will you see that message (I think) and only in the admin. Will be fixed asap.

Thanks!