1. Home
  2. Knowledge Base
  3. Advanced Calculations for Add-Ons Ultimate
  4. Getting Started
  5. Uploading CSV files to Advanced Calculations
  1. Home
  2. Knowledge Base
  3. Advanced Calculations for Add-Ons Ultimate
  4. Uploading CSV files to Advanced Calculations

Uploading CSV files to Advanced Calculations

The Advanced Calculations extension for Add-Ons Ultimate makes it easier to manage look up tables, allowing you to upload CSV files instead of needing to edit PHP snippets.

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.

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

Was this article helpful?

Related Articles