BUG: searching with SKU is empty is not working with WPML
š Holiday Notice - Support Vacation š
ATTENTION: From December 28, 2025 to January 6, 2026 our support team will be on vacation.
Important information:
- ā No ticket responses from December 28 to January 6
- ā Support will resume on January 7, 2026
- š You can still submit tickets during vacation - they will be queued and answered starting January 7
- ā ļø Urgent technical issues: Please check our documentation and codex first
š Season's Greetings! š
We want to thank all our amazing customers for your trust and support throughout 2025!
Merry Christmas and Happy New Year to you and your families! š
We wish you:
- š Successful online stores
- š° Growing sales
- š Happy customers
- šÆ Achieved goals in 2026
Thank you for being with us! We appreciate every one of you and look forward to continuing our work together in the new year.
Rest, recharge, and see you in 2026!
Best regards,
PluginUs.Net Team
If you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Hello , When i search for sku as empty , not results will be shown. if I deactivate WPML plugins. it work fine
Do you got temporary solution?
This is the last query run by your plugin with WPML when I press on filter button
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_sku' ) LEFT JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (
wp_postmeta.post_id IS NULL
) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private')) AND ( ( ( wpml_translations.language_code = 'ar' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','blocks','product','product_variation','featured_item' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','blocks','product','product_variation','featured_item' ) ) AND ( wp_posts.ID IN(41417,41413,41409,41404,41405) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title DESC LIMIT 0, 100
if I remove manually
( wpml_translations.language_code = 'ar' OR 0 ) AND
it will work
PRIVATE DATA
Hello
Please dropĀ meĀ wp-admin access - https://c2n.me/43SC6rb.png ->https://c2n.me/42BAoj4.png
Describe in more detail what I must do to get this error
Sent your wp-admin acccess
just to go to bulk editor page , and in quick search select sku = empty and test it
there will be no results
Hello
Ok!Ā pleaseĀ drop meĀ FTP access
Just sent you
Hello
PleaseĀ check yourĀ FTPĀ access - folder isĀ empty - https://c2n.me/49IMvuG.png
Please login as SFTP not ftp
I just test it and it's working fine
Hello
SFTP - so does not connect at all