Spreadsheet Calculator for WooCommerce – YourPlugins.com

Сүрөттөө

Spreadsheet Calculator for WooCommerce helps you sell products whose price changes according to customer choices, measurements, quantities or spreadsheet formulas.

It is built for stores where a fixed product price is not enough. You can create a calculator for made-to-measure products, printed materials, configurable items, custom services, components sold by size or quantity, and other products that need a quote-like buying experience.

The workflow is simple:

  1. Create the fields your customer needs to fill in.
  2. Build a formula or map those fields to cells in a spreadsheet.
  3. Assign the calculator to a WooCommerce product.
  4. Let customers configure the product and add it to the cart with the calculated price.

The calculated price is used by WooCommerce in the cart, checkout and order details, so the store owner and customer can review the selected configuration after purchase.

This plugin is not affiliated with, endorsed by or sponsored by WooCommerce or Automattic.

What you can do with the free plugin:

  • Create product calculator fields for numbers, text and picklists.
  • Use formulas to calculate a WooCommerce product price.
  • Upload a spreadsheet and map input and output cells.
  • Show calculated results to customers on the product page.
  • Assign a calculator to a WooCommerce product.
  • Reorder fields so the product form is easy to follow.
  • Mark fields as required and show clear validation messages.
  • Keep customer selections visible in the cart, checkout, emails and order details.
  • Review calculator values inside WooCommerce order screens.
  • Show calculator data in WooCommerce Cart Blocks.
  • Export and import calculator configurations when you need to move or back up a setup.

Example use cases:

  • Online printing: flyers, labels, posters, banners and business cards.
  • Made-to-measure products: panels, covers, furniture parts and custom cuts.
  • Products priced by area, length, weight, quantity or material.
  • Custom services that need customer inputs before the final price is known.
  • B2B products where a spreadsheet is already used internally to calculate the quote.

Useful links:

  • Plugin information: https://yourplugins.com/product/your-spreadsheet-calculator
  • Documentation: https://yourplugins.com/your-spreadsheet-calculator-documentation

Development Source

The non-minified JavaScript source files for this release are available in this source archive:
https://yourplugins.com/wp-content/uploads/sources/yps-spreadsheet-calculator-3.0.1-source.zip

Build instructions:

  1. Run npm install
  2. Run npm run build

Getting Started

  1. Choose a product that needs a calculated price.
  2. List the customer inputs needed to calculate that price, such as width, height, quantity, material or options.
  3. Create those inputs as calculator fields.
  4. Use a formula when the price rule is simple.
  5. Use spreadsheet mapping when your pricing table or quote logic is easier to maintain in a worksheet.
  6. Assign the calculator to a WooCommerce product and test it before publishing.

Орнотуу

  1. Unzip the files and upload the yps-spreadsheet-calculator folder into the /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ menu in WordPress
  3. Make sure WooCommerce is active.
  4. Create the fields your customer should complete.
  5. Create a calculator and choose whether to use a formula or spreadsheet mapping.
  6. Assign the calculator to a WooCommerce product.
  7. Open the product page and test the calculator before publishing.

FAQ.KG

Does this plugin require WooCommerce?

Yes. The plugin calculates WooCommerce product prices and uses WooCommerce cart, checkout and order APIs.

What kind of products can I build with it?

It is useful for products that need customer input before the final price is known, such as printing products, custom dimensions, made-to-measure items, configurable components and quote-style products.

Do I need to use a spreadsheet?

No. You can build a calculator with a formula. Use a spreadsheet when your pricing rules are easier to manage in a worksheet.

Can I use spreadsheet formulas?

Yes. You can upload a spreadsheet file and map calculator fields to spreadsheet cells.

Can one calculator be assigned to multiple products or product categories?

The editor included in this package assigns a calculator to one WooCommerce product. Existing saved category or multi-product assignments are preserved for compatibility.

Which field types are included in the core plugin?

This package includes numeric fields, text fields and picklists.

Can customers edit their choices after adding a product to the cart?

The free plugin keeps calculator values visible in the cart, checkout and order details so customers and store managers can review the selected configuration.

Is this an official WooCommerce plugin?

No. This plugin works with WooCommerce, but it is not affiliated with, endorsed by or sponsored by WooCommerce or Automattic.

Сын-пикирлер

There are no reviews for this plugin.

Contributors & Developers

“Spreadsheet Calculator for WooCommerce – YourPlugins.com” is open source software. The following people have contributed to this plugin.

Мүчөлөрү

Өзгөртүүлөр

3.0.1

  • Added an admin banner that links to the paid Pro version.
  • Removed duplicate native WooCommerce add-to-cart controls on calculator product pages.
  • Refined the default calculator layout by removing unnecessary borders.
  • Improved admin settings copy.

3.0.0

  • Renamed the plugin and improved compatibility with existing stores.
  • Redesigned the calculator editor so fields, formulas, spreadsheet mapping, preview and settings are easier to find.
  • Made field management clearer, with a better separation between customer inputs and calculated outputs.
  • Improved the product-page calculator experience for customers.
  • Improved spreadsheet mapping and made the Price result cell easier to configure.
  • Marked the Base product price cell as optional for simpler spreadsheet setups.
  • Added calculator preview and product-page display controls.
  • Improved upload handling between product page, cart and order details.
  • Improved how calculator values appear in the cart, checkout, emails and WooCommerce order screens.
  • Added support for showing calculator item data in WooCommerce Cart Blocks.

2.7.10

  • Fixed PhpSpreadsheet autoload conflicts with other plugins.

2.7.9

  • Fixed AJAX errors and added error_text settings.

2.7.8

  • Fixed spreadsheet calculation engine issues.

2.7.5

  • Fixed worksheet changes after the first calculator creation.

2.7.4

  • Added item attributes for WooCommerce Blocks.

2.7.3

  • Added support for radio and select list items from spreadsheet validation rules.

2.7.2

  • Fixed picklist and radio default values.
  • Fixed calculated cart decimals.

2.7.1

  • Fixed product category checks.

2.7.0

  • Added compatibility with PHP 8.2.

2.6.42

  • Added validation picklist items.
  • Added the awspc_filter_html_price hook.
  • Fixed dump and import features.

2.6.41

  • Added hooks.

2.6.40

  • Fixed “order again” behavior.

2.6.39

  • Added pricing cache.

2.6.38

  • Added product list cache.

2.6.37

  • Added an option to enable Bootstrap JS on the front end.

2.6.36

  • Added debugging features.
  • Fixed formula calculator taxes.

2.6.35

  • Fixed interception in the spreadsheet engine.

2.6.34

  • Fixed selected picklist values after adding the product to the cart.

2.6.33

  • Changed the cart item hook position used to print fields.
  • Avoided price error alerts in the cart.

2.6.15

  • Improved the way products are added to or removed from calculators from the product page.

2.6.14

  • Fixed product removal from the WooCommerce product page.

2.6.13

  • Fixed range slider JavaScript.

2.6.12

  • Fixed cURL error 28 timeout handling.

2.6.10

  • Fixed a 400 error related to cookies.

2.6.3

  • Added compatibility with the latest WordPress version at the time.
  • Changed the plugin name.
  • Updated the session handler.
  • Cleaned up the codebase.
  • Improved sanitization.