19 Responses

  1. Faisal Zamir
    Faisal Zamir June 22, 2018 at 17:45 | | Reply

    Bundle of thank bro, you to give me helpful guide.
    Very amazing and useful content blog.

  2. Bob Morris
    Bob Morris June 23, 2018 at 19:44 | | Reply

    Excellent in-depth article. Yes, if the site is big with lots of sales, $249+ a month isn’t that much, especially if it means few if any performance worries and issue.

  3. bursa travesti
    bursa travesti June 23, 2018 at 20:36 | | Reply

    The information you have published in your blog is really useful and I will apply this useful information to the seo studies of my own website and blog page. It’s a pleasure to take advantage of this useful information on your blog page. Thank you.

  4. Matt K
    Matt K June 26, 2018 at 01:05 | | Reply

    Hi there,

    Thanks for the article!

    You mentioned two approaches — WordPress plugin / Hosted e-commerce solution. I’d recommend also considering a “hybrid” one: hosted shopping cart with storefront in WordPress. So, all your products and sales are stored in cloud (automatic infrastructure scaling, backups, updates, maintenance), while your storefront is displayed on your WordPress site where you can add/remove widgets, customize appearance, add products/categories to different WordPress pages etc. This way you’re not that dependant on the hosting you are using — the service provider stores your data and scales automatically when needed. Traffic to the site is still important though — if you have a lot of visits, a cheap hosting can be a bottle neck.

    Try Ecwid (http://wordpress.org/plugins/ecwid-shopping-cart/) — it’s using the WordPress+SaaS approach I just described. And it’s way cheaper than most premium hostings.

  5. Shakshi Rana
    Shakshi Rana June 27, 2018 at 02:39 | | Reply

    Great List. I have now bookmarked it so that I can keep referring back to it when writing certain blog posts and articles. Thank you.

  6. Erlend Eide
    Erlend Eide June 29, 2018 at 01:36 | | Reply

    The database schema in WooCommerce is far from optimal, but changing the order structure will reduce compatibility with other Woo/WP plugins (hence, give you new headaches) and it does not address the key problem with WooCommerce and the database. Custom order tables may solve server side hosting challenges at scale when having many transactions, or processing many orders – but it will not improve the overall page speed of a WooCommerce shop.

    The most effective way of speeding up WooCommerce (all parts of it) is to increase the database performance. The advantage of having better performing databases outpaces any other performance enhancements, because every page request (both frontend and backend) will be way faster.

    In practice a WooCommerce site with a few plugins can easily produce pages with hundreds of database queries on a single page load (category pages, or a bunch of relevant products etc). When using faster databases, this works fine if one makes sure that the queries properly use indexes.

    A WooCommerce running on hosting with fast databases usually moves the bottleneck to PHP. This makes performance issues much easier to address for the average developer (most developers do not have hard core SQL skills).

    WooCommerce can be lightning fast on good hosting and built right, check out https://bogartstore.no as an example (hosted in Norway, without CDN). This site is running without full page caching or object caching (so just plain PHP + MariaDB).

  7. Madeline
    Madeline July 26, 2018 at 05:08 | | Reply

    Thanks for this blog post. This was quite helpful for me while developing the website.

Leave a Reply