Total : 0.00 €

Documentation

8 - Creating a calculator from a spreadsheet file (PRO)

This module will help you in creating product’s price calculator by loading and using the calculation spreadsheet. The calculator uses the same formula described in the spreadsheet to calculate prices for products (with dynamic measurements).
The process contains two major steps.

  • Creating WooCommerce Product
  • Creating WooPrice Calculator (from spreadsheet)

 

Creating WooCommerce Product

First of all, you need to create your WooCommerce Product:

  • Click on "Products > Add New" on the left Wordpress sidebar
  • Insert the name of the Product and set the product mode as "Simple Product": The plugin will override the WooCommerce simple product features.
  • Set a price in "Regular Price". Also putting "0" is fine. This is important otherwise, WPC can't attach its features to the product page.
  • Save the product by clicking on "Publish"

 

Adding WooCommerce Product for WPC

After you've created the WooCommerce Product and after you've created your customer input/output fields (See How to create fields) you are now ready to create the calculator.

Creating WooPrice Calculator

To create the calculator, go in the "Calculator" tab and click on "Upload your worksheet":

  1. Find the calculation sheet using the "Browse" function, select it and click on "Upload"

  2. Choose the desired sheet from the list and click on "Next"

  3. From this screen(shown below) the cells in the sheet can be mapped to the ones in the calculator. The Input fields must be set, meaning the fields that will be used by the visitors to insert the data, along with the Output cells that holds the formulas which will show the output values. Anyway, you're required to map the Price field because it's the default field. If the output spreadsheet cell contains a numeric value, a formatted numeric value will be displayed to the visitor (by following the rules of the field). If the output spreadsheet cell contains a string value, a text will be displayed to the visitor.

    Once all the fields have been mapped, click on "Next".

    You can set a Base Price cell as well. AWS Price Calculator will write this base price as WooCommerce Product Regular Price..


  4. The required information for the calculator will be displayed:
    • * Name: This value is only needed to remember what the calculator is for, and to find it in the list of calculators
    • Description: A more detailed description of what the calculator does
    • Input fields: Show or hide the input fields you want. To show move the item to right. To hide, move the item to left. You can drag&drop the fields on the right to change fields' order.
    • Output fields: Show or hide the output fields you want. To show move to the right, to hide move the item to the left. You can drag&drop the fields on the right to change fields order.
    • Overwrite WooCommerce Weight: You can overwrite the default weight of WooCommerce by setting an output field. In this way, the weight will be calculated by using the spreadsheet formula.
    • Products: The products that the calculator must be linked to; you can assign the calculator to whole categories.
    • Redirect to checkout if "Add to cart" is clicked: The visitor will be redirected to the checkout after adding the product to the cart if “Yes”. The visitor will not be redirected and will continue shopping if “No”.
    • Empty cart: If "Yes" it empties the cart when a product has been added to the cart. It's useful for services.
    • Themes: The theme used to see the calculator

To modify the mapping of the calculator, click on "Edit Mapping" in the calculator list. To edit the other information click on "Edit".

 

Price format and price approximation are made by WooCommerce (See WooCommerce > Settings > General tab)

F.A.Q (constantly updated)

How many fields can I create in PRO version?

PRO version allows you to create unlimited fields.

How to properly install the plugin?

Our Price Calculator PRO plugins are about 32MB size (for WordPress) and 13MB (for Joomla). They need to be installed throught the CMS admin panel in order to create automatically also tables on batabase.

Are our plugins compatibles with PHP7?

Yes, the plugins are compatible with PHP7 version.

What happens to the pro features after subscription expires?

Nothing happens to pro features in your website over subscription time.
After subscription expires, you’ll not be able to get further updates (with new features and bugfix) and forum support until you renew it.

How can I create a new template for my product page?

You can create a new template by following the example code here

How can I customize the default template for my product page?

You can customize the default template by following the example code here

How can I create fields?

You can create fields by following the instructions here

How can I create a mathematical formula for the calculator?

You can create the formula by following the instructions here

How can I create a calculator from excel?

You can create the calculator by following the instructions here

How can I customize the CSS style of the fields?

You can customize the CSS style by following the instructions here

How can I translate labels and values of fields?

You can translate them by following the instruction at: here
If there is no example, you can create the file you need.

Example (WordPress):

en_GB.php:

<?php
return array( 
'height' => 'Height',
);

it_IT.php:

<?php
return array(
'height' => 'Altezza',
);

The same method works for items of a dropdown. So if you create a new dropdown field, you can translate every item of the dropdown.

How can I remove the "powered by wooprice calculator" promotion in the product page?

You can't remove it in the free version. You can remove the "powered by wooprice calculator" after buying a subscription of Our Price Calculator PRO.

How can I create conditional formulas?

You can do it with Excel Sheet. With Excel, you can write conditional formulas "=IF() " and assign inputs fields and output price to your products.
Take a look at our PRO here

Can this plugin calculate any excel formulas?

Check if WPC does work for you directly in our live demo:

Why do I see a blank page or an empty area?

If you are working with our plugin and you see a blank page or an empty area of the screen then it means there could be some errors but WordPress doesn't let see you them.

To show those errors you need to:

  1. Edit via FTP the file "wp-config.php", change define( 'WP_DEBUG', false ); to define( 'WP_DEBUG', true ); For more information click here
  2. Go again where you saw the blank page or the empty area. Now you should be able to see the errors.
  3. Maybe you can solve the problem on your own because most times it's a PHP extension missing on your server, a permission/ownership file problem, etc). But if you don't understand the error make a screenshot and open a new support request in the forum and we'll be happy to help you.

Which kind of spreadsheet files I can upload to deploy a clculator?

Our plugins allows to upload Excel, LibreOffice, OpenOffice spreadsheet files to deploy calculators.

Cart

Total : 0.00 €