WooCommerce REST API - Filter Orders By Date Modified

Question

I'm using the WooCommerce REST API (http://woocommerce.github.io/woocommerce-rest-api-docs/#introduction) and can download Customers, Orders, etc successfully.

I'm now trying to get a filtered list of Orders where the Date Modified for the Order is after a certain date, but haven't been able to get this to work so far. The response to get GET request for an Order includes:

"date_modified": "2016-12-21T00:33:38",

I've tried the following:

wp-json/wc/v1/orders?filter[modified]=2017-02-14

but that just returns all orders. I would like to change the = to be a >= so it gets all Orders after the specified date, but haven't been able to find an example of how to structure the request URL for this?

score 5 · Answer 1 · answered Jul 19 '20 at 08:00

5

This worked for me. Tested with Woo 4.0.x / API v3

add_filter('woocommerce_rest_orders_prepare_object_query', function(array $args, \WP_REST_Request $request) {
    $modified_after = $request->get_param('modified_after');

    if (!$modified_after) {
        return $args;
    }

    $args['date_query'][0]['column'] = 'post_modified';
    $args['date_query'][0]['after']  = $modified_after;

    return $args;

}, 10, 2);

/wp-json/wc/v3/orders/?modified_after=2020-05-09T14:00:00

Hope it helps someone.

answered Jul 19 '20 at 08:00

Muhwezi Jerald Basasa

466
6
13

1

By using `woocommerce_rest_product_object_query`, this exact solution works for products also. Thank you very much :) – Stranger Sep 23 '20 at 14:01
Worked for me, but returning only 10 results... with `&per_page=20` you can increase to 20... Note that the maximum is 100 results only ! :( – Meloman Nov 04 '21 at 08:50
@Meloman. tryout this and see whether it'll work for you. This is for products update to orders. https://stackoverflow.com/questions/48476534/get-all-products-from-woocommerce-using-rest-api/63187237#63187237 – Muhwezi Jerald Basasa Nov 07 '21 at 02:18

simplism · Answer 2 · 2023-03-04T11:05:37.367

4

As of WooCommerce 5.8 (released October 21, 2021), Muhwezi Jerald Basasa's solution is no longer necessary.

The WooCommerce API now supports the modified_after and modified_before parameters for the products, orders and coupons endpoints.

More information:

edited Mar 04 '23 at 11:05

answered Dec 28 '21 at 20:56

simplism

78
6

score 1 · Answer 3 · edited Jun 28 '19 at 09:51

1

This is working:

/wp-json/wc/v2/orders?after=2019-01-10T00:00:00Z&before=2019-01-10T23:59:59Z

edited Jun 28 '19 at 09:51

adiga

34,372
9
61
83

answered Jun 28 '19 at 09:38

Leandro Silva

27
1

2

this is for "date_created", but not "date_modified" date :-( – Иванцов Дмитрий Mar 30 '21 at 18:46

score 1 · Answer 4 · edited Sep 24 '21 at 10:20

I've solved the problem with the following steps:

Create a folder.

Create a file with the same name and the following content:

<?php

/**
 * Plugin Name: ModifyOrder
 */

function modify_orders_after_query($request) {
    $request['date_query'][0]['column'] = 'post_modified';
    return $request;
}

add_filter( "woocommerce_rest_orders_prepare_object_query", 'modify_orders_after_query' );

Drop it in the wp-content/plugins folder.
In the admin panel, you can see your folder name as a plugin, activate it and try!

score 0 · Answer 5 · edited Jan 25 '21 at 11:01

0

It's Working

WooCommerce.get("products?after=2020-11-24T09:01:14&before=2020-11-25T04:51:22")

edited Jan 25 '21 at 11:01

Martin Brisiak

3,872
12
37
51

answered Jan 25 '21 at 10:35

Parveen Sharma

11
1

score -1 · Accepted Answer · answered Mar 21 '17 at 23:54

-1

I was able to get this working using the following request format:

wc-api/v1/orders?filter[updated_at_min]=2017-02-22&filter[updated_at_max]=2017-02-25

answered Mar 21 '17 at 23:54

user982124

4,416
16
65
140

3

That works for me in my testing wit the v2 REST API. You would also try something like this: /wp-json/wc/v2/orders?after=2017-05-17T00:00:00Z&before=2017-05-17T23:59:59Z – user982124 May 17 '17 at 13:38
yes, the above used to work for orders, but this didn't work for customers. Also I think this is not a Woocommerce feature but a Wordpress one. – babis21 Dec 16 '19 at 11:25

score -1 · Answer 7 · answered May 18 '17 at 16:23

Ok, the woocommerce API doesnt actually implement the filter. Its from wordpress api which is used with woocommerce and latest wordpress doesnt support filter anymore. For latest wordpress you must add the filter functionality manually by adding wordpress rest api filter provided by the wp-api team

WooCommerce REST API - Filter Orders By Date Modified

7 Answers7

Linked