export data is not same as store

hello

I think one order was completed before selected “From Date”.
Probably, you should use “Filter by order, Status=Complete” + “Filter by order date” .

You see same order many times,
so you must open section “Setup fields”, scroll to Products
and select “Export as (*) columns”.

thanks, Alex

Thanks.

You see same order many times,
so you must open section “Setup fields”, scroll to Products
and select “Export as (*) columns”.

oh, This really make me confused, why the total number of orders will be different by Rows or columns?

Alex

Hello

We should duplicate order data for each item in “by rows” mode.

You can open tab “XLS”( or CSV) and
turn off checkbox “Populate other columns if products exported as rows”

thanks, Alex

Thanks.

I set all setting as per your instructions, but it does not work as expected since one of order was exported:

pLease check the screenshot: https://prntscr.com/j2qxhe

Alex

Please, set “Filter order by (*)order date”

Hello,

I tried, and but still there is one order which will be not exported, please check the screenshot:

https://prntscr.com/j2vep3

Actually, I checked all of exported order, that one is not in xlsx file.

Alex

Please, set “Filter orders by” (*) Order date

it’s above date range ??

Thanks, it works this time, but I do not understand why it will not export that one order if set filter order by complete date, would you please let me know, thanks.

BTW, here are two questions:

1.The purpose of exporting orders for us is to print shipping labels with Label printer, but it is will be much trouble for shipping carriers to collect products if the products are much more. The convenient for us is automatically uploading our orders with XML to their shipping system, then generate and fetch back A QR code with tracking code, after that we can print shipping label with that QR code. By this way, they will know how manny products we need shipping and they do not need input all the products information one by one.

I know there is a lots of plugin support that in other countries, it will do not need export and import , unfortunately, no one support China market.

I know most of shipping carriers provide APIs for different commerce platform development, but I have no idea with Woocommerce, any suggestion?

Alex

hi Alex

I think the order has empty “Completed date”.
You should check wp_postmeta for this order.

if you have api documentation – you can adapt code “custom XML” from page https://algolplus.com/plugins/code-samples/

thanks, Alex