Spreadsheet Calculator for WooCommerce - YourPlugins.com
| 开发者 | yourplugins |
|---|---|
| 更新时间 | 2026年7月6日 21:30 |
| PHP版本: | 8.1 及以上 |
| WordPress版本: | 7.0 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
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.
- 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.
- 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.
- Plugin information: https://yourplugins.com/product/your-spreadsheet-calculator
- Documentation: https://yourplugins.com/your-spreadsheet-calculator-documentation
安装:
- Unzip the files and upload the
yps-spreadsheet-calculatorfolder into the/wp-content/plugins/directory - Activate the plugin through the 'Plugins' menu in WordPress
- Make sure WooCommerce is active.
- Create the fields your customer should complete.
- Create a calculator and choose whether to use a formula or spreadsheet mapping.
- Assign the calculator to a WooCommerce product.
- Open the product page and test the calculator before publishing.
屏幕截图:
常见问题:
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.
更新日志:
3.0.2
- 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.
- 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.
- Fixed PhpSpreadsheet autoload conflicts with other plugins.
- Fixed AJAX errors and added
error_textsettings.
- Fixed spreadsheet calculation engine issues.
- Fixed worksheet changes after the first calculator creation.
- Added item attributes for WooCommerce Blocks.
- Added support for radio and select list items from spreadsheet validation rules.
- Fixed picklist and radio default values.
- Fixed calculated cart decimals.
- Fixed product category checks.
- Added compatibility with PHP 8.2.
- Added validation picklist items.
- Added the
awspc_filter_html_pricehook. - Fixed dump and import features.
- Added hooks.
- Fixed "order again" behavior.
- Added pricing cache.
- Added product list cache.
- Added an option to enable Bootstrap JS on the front end.
- Added debugging features.
- Fixed formula calculator taxes.
- Fixed interception in the spreadsheet engine.
- Fixed selected picklist values after adding the product to the cart.
- Changed the cart item hook position used to print fields.
- Avoided price error alerts in the cart.
- Improved the way products are added to or removed from calculators from the product page.
- Fixed product removal from the WooCommerce product page.
- Fixed range slider JavaScript.
- Fixed cURL error 28 timeout handling.
- Fixed a 400 error related to cookies.
- Added compatibility with the latest WordPress version at the time.
- Changed the plugin name.
- Updated the session handler.
- Cleaned up the codebase.
- Improved sanitization.