Total : 0.00 €

Documentation

8 Creating a calculator from a spreadsheet file (PRO)

With this module it's possible to load a calculation sheet, therefore the product's calculator will be based on this calculation sheet when working out the prices.

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

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

  4. From this screen 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, it will be displayed to the visitor a formatted numeric value by following the rules of the field. If the output spreadsheet cell contains a string value, it will be displayed a text to the visitor.

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

    You can set a Base Price cell. AWS Price Calculator writes in this cell the WooCommerce Product Regular Price.


  5. The information that must be given to 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 to right, to hide move to left the item. 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 right, to hide move to left the item. 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 a 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 goes directly to the checkout
    • 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 a mapping 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 allow you to create unlimited fields.

How to install properly 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, they 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 more 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 an 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 in the free version. You can remove the powered by buying a subscription of Our Price Calculator PRO.

How can i do 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 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 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 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.

Cart

Total : 0.00 €