About this plugin
Spreadsheet Calculator for WooCommerce lets you create product calculators that calculate the final WooCommerce price from customer inputs, formulas, or spreadsheet cells.
It is useful when a simple fixed price is not enough: made-to-measure products, printing products, custom cuts, configurable items, services, B2B products, or any product where customers enter dimensions, quantities, materials, or options before the final price is known.
Already using Excel or a spreadsheet to calculate quotes? This plugin helps you turn that pricing logic into a WooCommerce product calculator.
The workflow is simple:
- Create the fields your customer needs to fill in.
- Build a formula or map those fields to cells in a spreadsheet.
- Assign the calculator to a WooCommerce product.
- 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 build with Spreadsheet Calculator:
- 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:
zip
Build instructions:
- Run npm install
- Run npm run build
Getting Started
- Choose a product that needs a calculated price.
- List the customer inputs needed to calculate that price, such as width, height, quantity, material or options.
- Create those inputs as calculator fields.
- Use a formula when the price rule is simple.
- Use spreadsheet mapping when your pricing table or quote logic is easier to maintain in a worksheet.
- Assign the calculator to a WooCommerce product and test it before publishing.