louie171 This post is just a place to store handy SQL queries for Woocommerce. Get Order and all its information select p.ID as order_id, p.post_date, pm.* from wp_posts p join wp_postmeta pm on p.ID = pm.post_id join wp_woocommerce_order_items oi on p.ID = oi.order_id where post_type = ‘shop_order’ and p.ID = 14223 Generate an Orders report and … Read more
This is page dedicated to the Bromley in London coworking group for freelancers, small business etc to come along and do some work in the company of other freelancers. I started this group as a way to get out of the house and do some work with other freelancers locally. update: June 2019 – There … Read more
If your using product weights in Woocommerce, you might find you want to change from grams to kilograms at some stage. There are 2 parts to this: Part 1: Firstly in wp-admin you need to change a setting on the Woocommerce (below). However this doesn’t automatically convert grams to kilograms. Part 2: Converting existing products … Read more
Speed tuning in WordPress and Woocommerce This post contains details of how to supercharge your WordPress website. Here are some speed tuning tips for getting your Woocommerce store loading quickly and keep customers on your site (slow loading = loss of customers). Check file load times In firebug look at the console requests (eg … Read more
In this post I’m going to give some tips to help you increase your sales. Speed – Make your website load quickly Customers like fast sites they can browse quickly and find what they need. Slow loading pages will make many potential customers go to elsewhere site to buy, bottom line you lose money. There are lots … Read more
In this post I’ll going to explain how I took a WordPress Bootstrap Theme and made it Woocommerce Compatible. I couldn’t find many good tutorials on this so I’m writing this one, so that it might help someone else. The Process to make a theme Woocommerce Compatible I’m going to take the very nice DevDmBootstrap3 theme and make it Woocommerce … Read more