Build a WooCommerce Wholesale Order Form with User Role Based Pricing & More

WooCommerce order form plugin demo

In this article, I’m going to tell you about a suite of 2 WordPress plugins that work together to create the perfect WooCommerce wholesale order form.

If you run a WooCommerce wholesale or role-based store, your customers need to see the correct prices for their wholesale status or user role. Wholesale customers also benefit from a tabular view of all the products available to them.

The WooCommerce Product Table plugin creates a table view of your products. It’s ideal when combined with a Wholesale or Role Based Pricing plugin. You can use product tables whether you have a full e-commerce store with online ordering, or catalog mode with ordering disabled.

I’ll tell you about different ways you can combine the WooCommerce Catalog Mode, Wholesale & Role Based Pricing and WooCommerce Product Table plugins to create a WooCommerce wholesale order form or read-only product catalog.

WooCommerce Catalog Mode, Wholesale & Role Based Pricing WooCommerce Product Table

What is the WooCommerce Product Table plugin?

WooCommerce Product Table will take all the products from your WooCommerce store and display them in a tabular format. It’s the perfect format for a WooCommerce wholesale order form plugin. You can choose to which columns are displayed in the order form. You can even add filters based on categories, tags, variations etc. The knowledge base will help you experiment with all the available options.

If your WooCommerce store is in catalog mode then you might want to hide the “Add to Cart” button instead of using it as a wholesale order form. This can easily be achieved by removing the field add to cart field from the product table, or by installing a WooCommerce catalog mode plugin (see below).

What’s great is that customers can select multiple products from the wholesale order form and click “Add Selected to cart“. This is a handy feature for wholesale customers, most of whom will be making a bulk purchase and want to buy quickly.

GET WooCommerce Product Table

What is the WooCommerce Catalog mode, Wholesale & Role Based Pricing plugin?

WooCommerce wholesale role based pricing pluginAs the name suggests, the Catalog mode of the plugin transforms your WooCommerce store into a catalog of all your products, hiding the “Add to Cart” functionality. You can choose to either completely turn your store into a catalog, or just disable online ordering for selected user roles (e.g. guests).

The most prominent feature of this plugin is that it offers discounts/markups based on WordPress user roles. This is an ideal way to sell products at reduced rates to wholesale customers. Your WooCommerce wholesale order form will display the correct prices for each user role.

WooCommerce Catalog Mode, Wholesale & Role Based Pricing

How to use both plugins to create a WooCommerce wholesale order form

The documentation for each plugin contains full instructions on installation and basic setup, so I will move directly to configuring the plugins. Together, they form a WooCommerce wholesale suite of plugins ideal for selling to the trade – either as an order form or in catalog mode.

First, set up WooCommerce Product Table

To start with WooCommerce Product Table, install the plugin and create 1 or more product tables. These will form the basis of your WooCommerce wholesale order form. Choose options such as the columns to be displayed; the filters to be added; image size, etc.

Once you have set up the WooCommerce order form plugin , view the product list view in the front end:

Person using WooCommerce Product Table on iPad

Next, set up the Catalog mode, Wholesale and Role Based Pricing plugin

Now, it’s time to set up the Catalog mode, Wholesale and Role Based Pricing plugin. Go to WooCommerce > Pricing and Discounts in the WordPress admin. I’ll tell you how to achieve several different scenarios to change the pricing and other features of your WooCommerce wholesale order form.

Wholesale role based pricing

First, we’ll consider a scenario where you would like to offer role based pricing. Let’s say you want to offer different prices to the “Administrators” and “Unregistered Users”. You can equally do this by using the User Role Editor plugin to create a dedicated Wholesale user level, and setting separate wholesale prices for that role.

For instance, let’s add a markup of 100% for administrators and 1000% for unregistered users:

WooCommerce wholesale role based pricing plugin

WooCommerce price for user role plugin

You can see the different prices in your WooCommerce wholesale order form. This is how the product list looks for the logged in administrator:
WooCommerce discount for logged in administrator

And for unregistered guest users:

WooCommerce different price for guest user

As you can see, different prices appear for each user role.

If you don’t want to use the wholesale order form layout for your retail customers, then you can add the product table to a separate page while continuing to direct retail customers to the main WooCommerce shop and category pages. Guests and retail customers will still see the correct pricing for their role, while wholesale customers will see the wholesale prices on the order form page.

Hide prices from guest users

Now, let’s consider another scenario where you want to hide the price for unregistered guest users only. To do that, go to the “Unregistered User” tab in the “Pricing and Discounts” plugin settings and enable “Hide Price”:
Hide WooCommerce price from guest users
Now, the price is hidden from unregistered users. Instead of appearing as a WooCommerce wholesale order form, the add to cart button has changed to a ‘Read more’ button because guests can’t place an orderL:
WooCommerce hide price from logged out users

Change the Add to Cart button text for guest users

Next, let’s consider another scenario where you would like to replace the text in the “Add to Cart” button for unregistered users:
WooCommerce change add to cart text for guest users
This change is also reflected in the product table:
WooCommerce change add to cart text

Tip: If you want to change the add to cart button text globally, check out the WooCommerce Customizer plugin. 

Add a suffix after product prices in the wholesale order form

In some of the above screenshots, you might have noticed the suffix “Sea” at the end of the product price. This suffix was added through the “Tax Option” tab of the Catalog mode plugin – another neat feature, if you need it:
WooCommerce add suffiix after price

Convert your WooCommerce wholesale order form to catalog mode

The “One click Catalog mode” option also works nicely with WooCommerce Product Table:

WooCommerce catalog mode
On enabling the Catalog mode option, prices and Add to Cart buttons are hidden for all your products. Instead of functioning as a WooCommerce wholesale order form, customers will see a read-only product list or catalog.

Are there any features of the plugins that don’t work together?

Though this wholesale suite of WooCommerce plugins are highly compatible and work very well together, there are some limitations to how they integrate. Next, I’ll tell you about the limitations and suggest workaround for some of them.

  1. When you hide the Add to Cart button from the Pricing and Discounts tab, the button will be hidden from the main WooCommerce Shop page as well as the single product page. However, the button will still appear in the product table. The workaround for this is to remove the add to cart column from the product table.
  2. When you replace the Add to Cart button with a custom URL, this URL won’t be used in the Product Table. Thus, the customer would still be able to purchase the product. Even in this case we would suggest you to remove the Add to Cart column and replace it with a custom field column, where you can manually add a button linking to any URL.
  3. None of the products can be hidden from the product table. If you hide specific products based on user roles, then these products will be hidden only from the shop page – they will still be visible in the product table.

Let us know in the comments how you got on with using the WooCommerce Catalog Mode, Wholesale & Role Based Pricing and WooCommerce Product Table plugins together. Do you use them for a WooCommerce wholesale order form or in catalog mode? If you have discovered any limitations other than the ones listed above, also feel free to comment.

WooCommerce Catalog Mode, Wholesale & Role Based Pricing WooCommerce Product Table