export data is not same as store

  • alexlii

    (@alexlii)


    8 years, 2 months ago

    Hello,

    I am trying to export the “complete order” from a specific period data, for example from 2016 to 2017, but the export data is not same as stored, please check the screenshot:http://prntscr.com/j2qapu

    Also, these data are not same as the exported data, please check this screenshot:

    http://prntscr.com/j2qcba

    Would you please let me what is wrong with my setting, or anyway to export the completed orders in a period from a specific day to another day?

    Thanks.

    Alex

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author algol.plus

    (@algolplus)

    8 years, 2 months ago

    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

    Thread Starter alexlii

    (@alexlii)

    8 years, 2 months ago

    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

    Plugin Author algol.plus

    (@algolplus)

    8 years, 2 months ago

    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

    Thread Starter alexlii

    (@alexlii)

    8 years, 2 months ago

    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: http://prntscr.com/j2qxhe

    Alex

    Plugin Author algol.plus

    (@algolplus)

    8 years, 2 months ago

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

    Thread Starter alexlii

    (@alexlii)

    8 years, 2 months ago

    Hello,

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

    http://prntscr.com/j2vep3

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

    Alex

    Plugin Author algol.plus

    (@algolplus)

    8 years, 2 months ago

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

    it’s above date range 😉

    Thread Starter alexlii

    (@alexlii)

    8 years, 2 months ago

    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

    Plugin Author algol.plus

    (@algolplus)

    8 years, 2 months ago

    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

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘export data is not same as store’ is closed to new replies.