Note that you will need the Pro version of Add-Ons Ultimate and the Advanced Uploads extension to retrieve an uploaded PDF’s page count.

The first step is to enable the feature by going to WooCommerce > Settings > Product Add-Ons > Uploads. Enable these settings and click ‘Save changes’.

• Enable PDF uploads
• Enable PDF page count

Then, create the following fields.

An Upload field which now accepts a PDF file. You will need to disable ‘Allow multiple uploads’ as the calculation will only read 1 file.

Create a Calculation field that will reference the Upload field. When a PDF file is uploaded, the calculation will retrieve the number of pages.

The post How to retrieve the page count of an uploaded PDF appeared first on Plugin Republic.

Let’s say you’re using a price table like this:

Not all the possible combinations have a value. For example, if the user enters 220 in the x-axis field and 240 in the y-axis field, there’s no price to be returned.

Instead, you can just enter a star * in the field. Advanced Calculations will return a 0 value for this as the result of the look up. You can then use this 0 value to set conditions on other fields – e.g. to display a notification.

Change the empty result text

This is what the user will see as the result of the calculation field when the look up table returns an empty field. By default, it’s set to display a * but you can change it to any text.

To do this, go to WooCommerce > Settings > Product Add-Ons > Calculations and change the value in the ‘Empty cell signifier’ field.

Disabling the add to cart button

As an extra option, you can elect to disable the add to cart button if the look up table returns an empty value.

To do this, go to WooCommerce > Settings > Product Add-Ons > Calculations and check the option to ‘Disable Add to Cart button’.

If you don’t see these settings, please ensure you have the Advanced Calculations extension installed and active.

The post Look up table with empty cells appeared first on Plugin Republic.

Formatting your CSV files

CSV files need to be formatted in a certain way.

• Give each table a unique name in the top left cell. Table names should be alphanumeric – they can’t just contain numbers
• 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

This is how your CSV files should look:

Uploading your CSV file

To upload your CSV file:

• Go to Product Add-Ons > Calculations
• Click ‘Choose file’
• Navigate to your CSV file
• Click ‘Import’

Your CSV file will be uploaded and your tables displayed on the page:

Using look up tables

Look up tables are a type of calculation field in Add-Ons Ultimate. The Advanced Calculations extension makes it much easier to set up your look up tables.

Once you’ve imported your CSV file, you can edit a product with a look up table:

• Go to your product
• Create two ‘Number’ fields so that the user can enter their dimensions
• Create a calculation field and enter {look_up_table} as the formula
• Enter the field IDs for the X and Y axes using the Number fields you’ve just created
• Select the pricing table from the dropdown

Publish your product.

Using exact matches for values

By default, Advanced Calculations will use the next available value on each axis. So if the user enters a value, the plugin will find the nearest next value.

However, you might want to use exact matches (e.g. if you want to return values for zip codes). Just check the ‘Exact match for X axis’ or ‘Exact match for Y axis’ to only use exact matches.

Further information

There’s a detailed tutorial on using look up tables in your calculations in this article.

Troubleshooting

Common problems with CSV files include:

• Formatting: if you find that the CSV file uploads but doesn’t look right, please try converting your Excel file to a CSV file via this link: https://www.zamzar.com/convert/xls-to-csv/
• Ensure that your X and Y axes only contain numeric values. Only the top left cell, for the table name, should contain any non-numeric characters
• Ensure that your CSV is actually comma-separated. Don’t use semi-colons or other character as the separator
• If you are finding that the calculation result isn’t returned immediately, ensure that you don’t have any empty rows in your CSV files – even between tables. The file should contain no empty rows.

The post Uploading CSV files to Advanced Calculations appeared first on Plugin Republic.

When you purchase the plugin, you’ll immediately receive an email confirming your purchase. This email also contains:

• A link to download the plugin files
• Your licence key

Click on the link to download a zip file that contains the plugin. You don’t need to unzip this – just make a note of where it downloads to on your computer, e.g. your ‘Downloads’ folder.

Installing the plugin

To upload and install the plugin, go to Plugins > Add New > Upload Plugin. You can either drag the acaou.zip file into the upload file zone (see image below) or click the ‘Choose file’ button and browse to the file on your computer.

Once you’ve uploaded the file, click ‘Install Now’ then click ‘Activate’ (remember that you will need to have WooCommerce and Product Add-Ons Ultimate activated as well).

Enter your plugin licence

Go to WooCommerce > Settings > Product Add-Ons then click the ‘Licence’ subheading.

• Enter your licence key in the Advanced Calculations Licence Key field
• Click ‘Activate this licence’
• This will ensure that you receive automatic updates

The post Installation appeared first on Plugin Republic.