Is there a recommended maximum safe number of products?

Hello. We are creating a WordPress multisite store for a client. Each subsite will be mapped to a separate domain. We have activated MarketPress at the subsite level (not Network Activate). We have set Stripe payments and FedEx and UPS shipping info per subsite, though they all use the same credentials.

This is our second build of this network. A month ago, we had a perfectly functioning network of sites and were ready to deliver it to the client. Our final task was to upload the remaining products for sale. When we crossed about 2,000 products per site, we started noticing quirky behavior in MarketPress. The site began running slowly, Store Settings needed to be reset periodically, the Orders admin sometimes did not display orders or portions of orders, out of stock products would display even though they were set not to, and checkout would not always complete successfully. Eventually, all of the subsites became completely dysfunctional and we had to rebuild from scratch.

You can bet that our second installation of this project was built with extreme care and documentation.

Now that we are within days of delivering this long overdue project to our more-than-patient client, we began filling his store with products. Much to our horror, we are seeing the same dysfunction returning to our painstakingly rebuilt network. The subsites that have a full complement of 5,000 products are displaying out of stock products even though they are set not to, the Billing/Shipping Address accordion on the checkout page opens and closes randomly while the user is trying to fill it out. But more importantly, these sites will not render an order status page or mp-create-account-lightbox at checkout. The orders are being placed, but the user has no way of knowing that by looking at the screen that just shows an infinitely spinning icon.

Is it possible that MP has a critical mass threshold for the number of products it can handle? Please share with us your recommendations or guidelines for how many products and images it is safe to upload for optimum performance.

The subsites that will no longer checkout properly, and have more than 3,500 products are:
https://001.amazingwholesalejewelry.net
https://002.amazingwholesalejewelry.net
https://005.amazingwholesalejewelry.net

The subsites that will checkout properly, though slowly, and have less than 2,000 products are:
https://004.amazingwholesalejewelry.net
https://006.amazingwholesalejewelry.net
https://007.amazingwholesalejewelry.net

The subsites that work the best, and have less than 800 products are:
https://011.amazingwholesalejewelry.net
https://012.amazingwholesalejewelry.net

I have screenshots of the errors I see after clicking the Submit Now button at checkout.

Thank you in advance for your help.

Mihal
(Ehventerprise LLC)

  • Kasia Swiderska
    • Support nomad

    Hello Ehventerprise LLC,

    I was able to confirm all those issues on your site - however I don't have installation with so many products to try to replicate it on the my server.
    Would you mind allowing support access so we can have a closer look at this?
    To enable support access you can follow this guide here:
    https://premium.wpmudev.org/manuals/wpmu-dev-dashboard-enabling-staff-login/

    Also could you enable debug mode in your WordPress? To enable it, open your wp-config.php file and look for define(‘WP_DEBUG’, false);. Change it to:

    define('WP_DEBUG', true);

    In order to enable the error logging to a file on the server you need to add yet one more similar line:

    define( 'WP_DEBUG_LOG', true );

    In this case the errors will be saved to a debug.log log file inside the /wp-content/directory.

    Depending on whether you want your errors to be only logged or also displayed on the screen you should also have this line there, immediately after the line mentioned above:

    define( 'WP_DEBUG_DISPLAY', false );

    The wp-config.php is located in your WordPress root directory. It’s the same file where the database configuration settings are. You will have to access it by FTP or SFTP in order to edit it. I would need then to see contents of the debug.log file - so please paste it to the text file and attach to post.

    I will ping plugin developer with question about limitation of products number and about error 405 in browser console.

    kind regards,
    Kasia

  • Kasia Swiderska
    • Support nomad

    Hello Ehventerprise LLC,

    Could I see debug.log? Maybe there is nothing relevant but its worth to check. Could you please send in the following via our secure contact form https://premium.wpmudev.org/contact/ :

    - Mark to my attention, the subject line should contain only: ATTN: Kasia Swiderska
    - Do not include anything else in the subject line, doing so may delay our response due to how email filtering works.
    - Link back to this thread
    - link to debug.log uploaded to Dropbox or google drive or similar service
    - Include any relevant URLs for your site

    IMPORTANT: Please make sure you select "I have a different question" for your topic, so it doesn't go back to the forums - this and the subject line ensure that it gets assigned to me.

    kind regards,
    Kasia

  • Rupok
    • Support Ninja

    Hi Ehventerprise LLC

    Hope you had a wonderful day.

    I've personally pinged our developer to check this thread and I believe, he will come up with his valuable feedback very soon.

    Please keep in mind, our developers work round the clock and they have to deal with lots of critical issues and other things. So it may take a little while for them to check this and provide feedback.

    Have a nice day. Cheers!

  • Gilad and Mihal (Ehventerprise LLC)
    • Flash Drive

    OK. Thanks.

    I've had to move forward with building sites that will function as well as possible for our client; so I am deleting all the sites that had more than 1,500 products, and rebuilding them from scratch.

    The hide products that are out of stock functionality is still our highest priority for this initial release. However, being able to support sites that have more than 1,500 products will quickly be a necessity as well.

    Thanks again,
    Mihal (Ehventerprise LLC)

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.