Mini plugin: Disable WooCommerce prices and add to cart for visitors

This is a mini plugin that lets you hide WooCommerce prices
and the add to cart button for non logged in visitors of your site.

Install and activate to hide the elements site-wide.
Shop overview:

Single Product page:

Download Disable WooCommerce prices and add to cart for visitors plugin


Tested with:
WordPress 4.8.2
WooCommerce 3.2.1

How to fix revolution slider MySQL Fatal error: Uncaught exception ‘Exception’ with message ‘fetch

Today I was playing around with Revolution Slider and had trouble getting it to run in my Multisite test environment.

Upon activation this error would pop up:

“Fatal error: Uncaught exception ‘Exception’ with message ‘fetch – <b>Unknown column ‘type’ in ‘where clause'</b><br>—<br> Query: select * from wp_revslider_sliders where type !=

To solve this edit revslider.php located in revslider root directory:


$rsv = get_option(‘rs_version’, 0);
if(version_compare($revSliderVersion, $rsv, ‘>’)){
update_option(‘rs_version’, $revSliderVersion);

Right before:

add_action(‘plugins_loaded’, array( ‘RevSliderFront’, ‘createDBTables’ ));

How to setup one time / on-off payment or free plan in WooCommerce Subscriptions

Setting up a one time payment

WooCommerce Subscriptions offers a signup fee you can use to collect a one time payment using WooCommerce Subscriptions.
Here is how.

Set the recurring price to zero
Set the duration to the required time
Set the sign up fee to the full amount you want to collect

click on the image to enlarge.

Setting up a free plan to downgrade to

If you want your users to be able to downgrade to a free plan you can use WooCommerce Subscriptions and setup a variable Subscription product.

Setup a plan type attribute


How to fix saving issues in WooCommerce and WordPress

Sometimes you have trouble saving settings in WooCommerce. Your shipping zones do not get saved or your WooCommerce Bookings resources fail to get saved. Here are possible issue scenarios for you
to check.


 Corrupted WooCommerce database tables

Not being able to save may indicate damage to your WooCommerce MySQL database tables. The best way to fix this is to completely deinstall WooCommerce manually followed by a new installation. This rebuilds the database tables anew

Plugin conflict interfering

The form failing to save may be due to conflict between active components.

How to find the right CSS class to edit to apply custom CSS in WordPress

There are many plugins for WordPress that allow you to apply custom CSS. Most theme have their dedicated sections. However how do you know which class you need to modify?

Use Google Chrome development tools to inspect

I use Google Chrome development tools for this. Here is a quick screencast that shows how to find the right class and edit / apply custom CSS:

Here is what I do step by step

The tab titles “Description” and “Reviews” are crammed into the left corner.

WooCommerce plugin features and inter-compatibility

WooCommerce is simplicity and stablility

WooCommerce itself follows the same principle that WordPress has been true to successfully for many years. The core is simple and above all stable and easily extendable.

If you are running a self hosted shop, you need to do configure and extend your shop until it meets you or your clients requirements. There are many, many plugins that you can use to extend your WooCommerce shop.

Here are a few things to consider.

Plugins are not compatible with each other

Plugin A will not work with plugin B and C, unless specifically stated.

WooCommerce Order/Customer CSV Export cart discount and order discount column missing

These two columns were removed in version 3.11.0 when support for WooCommerce 2.2: cart_discount and order_discount was removed as well.

These two columns remained after WooCommerce 2.3 was released for backwards compatibility and no longer apply as version 2.3 introduced changes to the coupon system – more details here:

Since it’s no longer possible to have both order discounts and cart discount, the WooCommerce Customer/Order CSV Export extension now only has a discount_total column.

I suggest that you apply the required changes in any integrations using the CSV export to work with the current state of columns exported

How to troubleshoot WooCommerce products with fail to save issues or corrupt database entries

Break it down

A good technique to resolve problems where the editing or saving of a WooCommerce product fails is to start fresh. This is best done by recreating the scenario you are dealing with but with minimum requirements.

Lets say you are troubleshooting a WooCommerce Bookings issue. You have this elaborated product with perfect configuration. Everything was working fine yesterday, but today the booking process has stopped working as it should.

You have tried everything. Toggling all different features, tried on different browsers, checking every configuration, but the error pertains.