mrjotd
Forum Replies Created
-
Forum: Plugins
In reply to: [Advanced Order Export For WooCommerce] Add value to custom field filterJust changed my formatting and all is well!
Thank you for your help Alex!
Forum: Plugins
In reply to: [Advanced Order Export For WooCommerce] Add value to custom field filterThe output is showing as 09/14/2018 , I am gathering that it may just be an issue with how I have stated the date output?
Thanks, Josh
Forum: Plugins
In reply to: [Advanced Order Export For WooCommerce] Add value to custom field filterHello,
This is the SQL I am seeing: SELECT ID AS order_id FROM wp_posts AS orders LEFT JOIN wp_postmeta AS ordermeta_cf_1 ON ordermeta_cf_1.post_id = orders.ID AND ordermeta_cf_1.meta_key=’byconsolewooodt_delivery_date’ WHERE orders.post_type in ( ‘shop_order’) AND 1 AND orders.post_status NOT in (‘auto-draft’,’trash’) AND ( ordermeta_cf_1.meta_value IN (’09/14/18′) ) AND orders.ID IN ( SELECT order_id FROM wp_woocommerce_order_items WHERE order_item_type=’shipping’ AND order_item_name IN (‘Flat Rate’) )
Forum: Plugins
In reply to: [Advanced Order Export For WooCommerce] Add value to custom field filterHello,
I have added the code to the ‘Misc Settings’ and tweaked the date to return as m/d/y as this is how I need it to be formatted, I also typed {today} in to the dropdown, this is not returning any results. When I test using a rendered value of the custom field the orders I expect to see appear however.