Suggestions for faster exports?

  • someka

    (@someka)


    5 years, 9 months ago

    Thanks for the cool plugin. It works very well so far.

    I was just wondering if anyone has some suggestions for faster exports? I sell digital products and we have around 3-5k orders per month. If I try to export full year it takes quite long (more than a hour)

    And doesn’t this plugin just runs a bunch of SQL queries in the background? What is taking this long? Is this a limitation and does pro version work faster?

    Any replies will be appreciated.

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

    (@algolplus)

    5 years, 9 months ago

    hi

    We have to run some sqls for each order too ( to get order and item details).

    But you can speed up export a bit (if your server is rather fast).
    Open file /classes/class-wc-order-export-admin.php and find line
    'ajax_orders_per_step' => '30',
    increase 30 to 60 . Will it help ?

    thanks, Alex

    Plugin Author algol.plus

    (@algolplus)

    5 years, 9 months ago

    No limits, free and pro versions use same code to extract data.

    You can turn on mysql low query log too.
    If you find something useful – could you provide details here or upload to helpdesk?

    thank you,
    Alex

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Suggestions for faster exports?’ is closed to new replies.