For Information – PHP & Server settings

We successfully exported 6000 orders from a production site to a new DEV site to complete customer upgrade requiring PHP8.1.12 on our server. Our setup is 6 AMD Operteron 62xx class CPU and 12GB RAM with an enterprise infiniband network running 80GBps.

The typical import of 10 records per chunk was pretty much the only way to make this work. We increased our input vars (3000) and script times to unusually high amounts, around 1800 to get this part of the job done. Using order ID (not sku) the import would run maybe 20 or 30 records and then throw an error. Each time we re-run the import it would scan & skip the previous successful imports and then add another random amount of successful imports, maybe up to 220 orders then error out again. Early on in the logs I noticed a php error calling the shipping method being shipping_order_item_id so I made a custom template to skip the shipping part of the import because my client has virtual downloads and dvd shipping options which for past orders were not really important. The client uses SKU’s occasionally so we only opted to use order ID’s.

PHP Warning: Undefined variable $shipping_order_item_id in /var/www/vhosts/oursite.com/wp-content/plugins/order-import-export-for-woocommerce/admin/modules/order/import/import.php on line 1648 (and then line 1651 same message.

During the script process I looked at HTOP in a terminal and the Load average: 0.9 1.23 1.67 were very normal, less than 40% of RAM and minimal swap being used.

Our issue is not that it didn’t work, but that it took over 4 hours and 23 imports (from the logs). Most time consuming was that the system had to scan (near the end) over 5000 existing records (skipping) before it would import the next batch before error. Nothing in the NGINX or Mysql error logs during this period. We included the NGINX directive you specify in our setup.

Is there something on our end we could have done to make this more efficient.

Thanks!
Stu