Products file upload script maxes out?

  • Resolved JOakland

    (@joakland)


    10 years, 10 months ago

    I have a client that would like to switch to WP-eCommerce after about six years of using OSCommerce alongside their regular WP installation. They are a bookstore, and their inventory is about 17,000+ titles. I have been building and testing a plugin that will upload a delimited text file to their WP database (the text file is exported from their in-house inventory software), but the script ends after uploading/updating only about 2300 titles. So, I have two questions:

    1) Can WP-eCommerce handle an inventory of their size?
    2) Are there memory limits I need to adjust in order to upload their entire inventory? I’m not seeing any errors generated by the script at the moment.

    Thanks! Happy to provide any additional information to get this problem sovled!

    https://ww.wp.xz.cn/plugins/wp-e-commerce/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Justin Sainton

    (@justinsainton)

    10 years, 10 months ago

    Hi JOakland,

    That’s great to hear. I got my start in eCommerce about 10 years ago, with osCommerce, so that’s a very neat transition to hear about for your client.

    WP eCommerce should be just fine on that size of inventory. The types of things you’ll want to avoid at that scale is things like sorting via drag and drop (or any non-indexed column in the database) and things of that nature.

    As far as timeouts for your import script – you may want to consider upping the resources on your server, or batching the import. You could look into PHP functions like set_time_limit() to increase the timeout limit.

    I hope that’s helpful! Do let me know if there’s anything else I can do for you.

    Thread Starter JOakland

    (@joakland)

    10 years, 10 months ago

    Thanks for the response, Justin!

    I added set_time_limit() to the script, and that seems to have done the trick. Now I’m running into another problem. After all of the products, are uploaded, I’m getting this error on the products admin page:

    Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 262144 bytes) in /Applications/MAMP/htdocs/upb/wp-includes/cache.php on line 631

    I’ve tried upding WP_MEMORY_LIMIT in wp-config, but that hasn’t helped. Any suggestions?

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

The topic ‘Products file upload script maxes out?’ is closed to new replies.