schmago

if you don’t use status as key in array like this
unset( $statuses['wc-processing'] );

I am not sure how I am supposed to remove unwanted status.

as always, problem solved!
Thanks!

yes, works well!

As usual, amazing work!
Huge help for us, thank you!

Now I can see my SKUs in the header.
But cells (for quantity) are empty.

Also I now have multiple rows for a same order (because we added Products(Product Order Items) fields I guess).

I have created the 2 fields and dragged them on the left side, but it didn’t work.
I have “-empty-” column where I have dragged 2 fields SKU and Quantity.

This is the header I see in the csv file :
Name,”Address 1″,”Address 2″,City,State,”Postal Code”,Country,Phone,Notes,-empty-

Thanks for “SKU in columns” solution, works great!
And thanks for the hint for CSV format, but I think it’s out of my knowledge ??

Done!
Thank you Alex

Hi,

I am using pro version, and used “order refund” with data range filter. And yes it returns me the order ID corresponding to the date of first refund date range that I am looking for.
But it doesn’t export all other fields that I need, which are attached to the main order (like the shipping country).

Also I tried to add the function you suggested, but doesn’t to work (or I miss something).
When I use the debug mode, I don’t see your SQL request being executed.

SELECT ID AS order_id 
  FROM wp_posts AS orders 
  WHERE orders.post_type in ( 'shop_order') 
  AND 1 AND orders.post_date>='2021-10-01 00:00:00' 
  AND orders.post_date<='2021-10-31 23:59:59' 
  AND orders.post_status in ('wc-refunded') 
  AND orders.post_status NOT in ('auto-draft','trash') 
  AND orders.ID IN 
    (SELECT DISTINCT order_items.order_id 
    FROM wp_woocommerce_order_items as order_items 
    LEFT JOIN wp_woocommerce_order_itemmeta AS orderitemmeta_product 
      ON orderitemmeta_product.order_item_id = order_items.order_item_id 
    WHERE order_item_type='line_item' 
    AND (orderitemmeta_product.meta_key IN ('_variation_id', '_product_id') 
    AND orderitemmeta_product.meta_value<>'0' 
    AND (orderitemmeta_product.meta_key = '_product_id')) )

Thanks.

Works great, thank you very much!

Thanks for quick answer.
Unfortunately, the result is not what I was looking for.
I want to have a date range like :
1st day of last mont <= _completed_date <= last day of last month

So I custom the tomorrow and today value :

$tomorrow = date("Y-m-d", strtotime('last day of -1 month'));
$today = date("Y-m-d", strtotime('first day of -1 month'));

But I only get orders from the last day of last month (1 day)
when I use
_completed_date LIKE {tomorrow}

and when I am on debug mode, I only see one condition link to the tomorrow date :
(ordermeta_cf_1.meta_value LIKE '%2021-09-30%' )

• This reply was modified 3 years, 4 months ago by schmago.
• This reply was modified 3 years, 4 months ago by schmago.