Nothing to export. Please, adjust your filters

please open section “Misc Settings”, mark “Enable debug output” , press Preview.

run phpMyAdmin and test SQLs

Here’s the preview:

SELECT ID AS order_id FROM cctv24posts AS orders WHERE orders.post_type in ( ‘shop_order’) AND 1 AND orders.ID >= 519456 AND orders.ID <= 0 AND orders.post_status in (‘wc-pending’,’wc-processing’,’wc-on-hold’,’wc-completed’) AND orders.post_status NOT in (‘auto-draft’,’trash’)

SQL results: https://prnt.sc/jGdmZGlx6e_x

Orders: https://prnt.sc/NCbuQF0OGDVl

please, remove space from filter “Orders Ids”.

2nd value is not empty

I have tried both

SELECT ID AS order_id FROM cctv24posts AS orders WHERE orders.post_type in ( ‘shop_order’) AND 1 AND orders.ID >= 519456 AND orders.ID <= 519410 AND orders.post_status in (‘wc-pending’,’wc-processing’,’wc-on-hold’,’wc-completed’) AND orders.post_status NOT in (‘auto-draft’,’trash’)

and

SELECT ID AS order_id FROM cctv24posts AS orders WHERE orders.post_type in ( ‘shop_order’) AND 1 AND orders.ID>= 519456 AND orders.ID<= 519410 AND orders.post_status in (‘wc-pending’,’wc-processing’,’wc-on-hold’,’wc-completed’) AND orders.post_status NOT in (‘auto-draft’,’trash’)

Still getting nothing?

please, run phpMyAdmin , review records in table cctv24posts

Do they have correct values in columns post_type and post_status

I just purchased a license for the pro version, would your support be able to troubleshoot if I open a ticket?

yes, please do it

Outdated versions don’t support HPOS mode .

The problem was solved by updating the plugin.

• This reply was modified 3 months, 1 week ago by algol.plus.