Title: For Information – PHP & Server settings
Last modified: November 22, 2022

---

# For Information – PHP & Server settings

 *  Resolved [dblinks](https://wordpress.org/support/users/dblinks/)
 * (@dblinks)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/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

Viewing 1 replies (of 1 total)

 *  Plugin Support [WebToffee Support](https://wordpress.org/support/users/webtoffeesupport/)
 * (@webtoffeesupport)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/for-information-php-server-settings/#post-16230174)
 * Hi [@dblinks](https://wordpress.org/support/users/dblinks/),
 * Thanks for getting in touch with us.
 * If there is order ID in the order import CSV file, then during the import process
   it will check for existing ID in the database. So to make it fast, you can unmap
   the ID field on the import mapping screen or remove the ID column from CSV so
   that WordPress will automatically assign next available ID to the imported orders.
 * We will check regarding the warning message shown and will be updating it in 
   the next version.

Viewing 1 replies (of 1 total)

The topic ‘For Information – PHP & Server settings’ is closed to new replies.

 * ![](https://ps.w.org/order-import-export-for-woocommerce/assets/icon-256x256.
   gif?rev=3133964)
 * [Order Export & Order Import for WooCommerce](https://wordpress.org/plugins/order-import-export-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/order-import-export-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [WebToffee Support](https://wordpress.org/support/users/webtoffeesupport/)
 * Last activity: [3 years, 5 months ago](https://wordpress.org/support/topic/for-information-php-server-settings/#post-16230174)
 * Status: resolved