WooCommerce calculation look up tables

Often, you might want to calculate your product price based on user measurements. And, in some cases, you need to round up the user measurements to specific values in order to return your price. In this article, we’ll look at creating a WooCommerce calculation field using a look up table or pricing grid.

WooCommerce calculation look up tables

We can use calculation fields in the Pro version of the WooCommerce Product Add-Ons Ultimate plugin for complex calculations. And there’s a complete guide to WooCommerce measurement price calculators here.

But, in this specific case, we want to use a look up table to return our prices.

Here’s an example.

Selling made to measure blinds and curtains through WooCommerce

In our example, we’re selling made to measure blinds. The customer enters the width and the height (or drop) required. Then our product calculates the price.

However, we don’t want to use the exact measurements provided by the customer to calculate the price. Instead, we want to round each value up to one of our predefined values then get our price from a pricing table.

The screenshot below of a spreadsheet should help to explain. Across the horizontal x axis on the top row you can see values in centimetres, i.e. 80, 100, 120 etc. These are our values for the width of the blind.

And down the first column, the vertical y axis, you can see values in centimetres again. These are our values for the blind’s height.

We can use this grid to return a price based on user measurements. So if the user enters 139cm width by 178cm height, we round up both measurements to the nearest value in the table, which will be 140cm for the width and 180cm for the height.

Then we look across to the 140 column and down to the 180 row to find the price. In this case, the price will be $414.

You can take a look at this in action in the demo product.

Creating the look up table

To upload the look up table, you’ll need the Advanced Calculations extension for Add-Ons Ultimate.

This extension requires the Pro version of Add-Ons Ultimate.

Uploading look up tables as CSV files

The Advanced Calculations extension allows you to upload your look up tables as CSV files. You’ll need to format the files in a specific way:

• Give each table a unique name in the top left cell. Table names should be alphanumeric – they can’t just contain numbers. Note that you can upload multiple tables in just one file using this method.
• Enter your X-axis values along the first row
• Enter your Y-axis values in the first column of each subsequent row
• If you have multiple tables, just add the next table as a subsequent row – the plugin will work out that this is a new table. Don’t leave any empty rows

Here’s an example of what a CSV will look like:

You can see that this file contains two tables – ‘TABLE 1’ and ‘TABLE 2’. These are different look up tables that can be used by different calculation fields. You can have as many look up tables as you like in the CSV file.

To upload your CSV file, just go to Product Add-Ons > Calculations.

Creating add-on fields for a pricing grid calculation field

With your CSV file uploaded, you can now assign tables to different calculation fields.

We need to create two number fields for our width and height measurements. You can take a look at the support document or in the main calculation field article for how to do this.

Now we need to create a calculation field that will use the measurements. To add the calculation field:

• Click ‘Add Field’
• Choose ‘Calculation’ in the ‘Field Type’
• In the ‘Formula’ field enter {look_up_table} – make sure you include the curly brackets
• In the ‘Action’ field, choose ‘Display As Cost’. This will ensure that the result of the calculation will be formatted with the correct currency and add to the product price

Then:

• In ‘Field ID for X’ enter the field ID for the values along your x axis
• In ‘Field ID for Y’ enter the field ID for the values along your y axis
• In ‘Look Up Table’, select the name of your table from your CSV file

You can now publish your product.

WooCommerce calculation look up tables – recap

The Pro version of the Product Add-Ons Ultimate plugin and the Advanced Calculations extension make it easy to use look up tables to determine prices based on user inputs and measurements.