{"id":310044,"date":"2026-06-04T08:13:48","date_gmt":"2026-06-04T08:13:48","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/spreadsheet-calculator\/"},"modified":"2026-06-04T13:33:21","modified_gmt":"2026-06-04T13:33:21","slug":"yps-spreadsheet-calculator","status":"publish","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/yps-spreadsheet-calculator\/","author":18635923,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"3.0.1","stable_tag":"3.0.1","tested":"7.0","requires":"6.7","requires_php":"8.1","requires_plugins":null,"header_name":"Spreadsheet Calculator for WooCommerce - YourPlugins.com","header_author":"YourPlugins.com","header_description":"Price Calculator for WooCommerce","assets_banners_color":"eef1f3","last_updated":"2026-06-04 13:33:21","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/yourplugins.com\/product\/your-spreadsheet-calculator","header_author_uri":"https:\/\/yourplugins.com","rating":0,"author_block_rating":0,"active_installs":0,"downloads":68,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"3.0.0":{"tag":"3.0.0","author":"yourplugins","date":"2026-06-04 08:27:09"},"3.0.1":{"tag":"3.0.1","author":"yourplugins","date":"2026-06-04 13:33:21"}},"upgrade_notice":{"3.0.1":"<p>Minor admin and product-page presentation update.<\/p>","3.0.0":"<p>Major update with a redesigned editor and improved calculator workflows. Test your calculators before updating a live store.<\/p>"},"ratings":[],"assets_icons":{"icon-256x256.png":{"filename":"icon-256x256.png","revision":3560483,"resolution":"256x256","location":"assets","locale":"","width":256,"height":256}},"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":3560483,"resolution":"1544x500","location":"assets","locale":"","width":1544,"height":500},"banner-772x250.png":{"filename":"banner-772x250.png","revision":3560483,"resolution":"772x250","location":"assets","locale":"","width":772,"height":250}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["3.0.0","3.0.1"],"block_files":[],"assets_screenshots":[],"screenshots":{"1":"<p>Create the fields customers will use to configure the product.<\/p>","2":"<p>Build a calculator with a formula or spreadsheet mapping.<\/p>","3":"<p>Preview the product-page calculator and adjust the field order.<\/p>","4":"<p>Let customers configure the product and add it to the cart with the calculated price.<\/p>","5":"<p>Review calculator values in the cart, checkout and order details.<\/p>"}},"plugin_section":[],"plugin_tags":[142522,244387,15432,265762,9471],"plugin_category":[],"plugin_contributors":[265763],"plugin_business_model":[],"class_list":["post-310044","plugin","type-plugin","status-publish","hentry","plugin_tags-cost-calculator","plugin_tags-custom-pricing","plugin_tags-price-calculator","plugin_tags-product-calculator","plugin_tags-spreadsheet","plugin_contributors-yourplugins","plugin_committers-yourplugins"],"banners":{"banner":"https:\/\/ps.w.org\/yps-spreadsheet-calculator\/assets\/banner-772x250.png?rev=3560483","banner_2x":"https:\/\/ps.w.org\/yps-spreadsheet-calculator\/assets\/banner-1544x500.png?rev=3560483","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/yps-spreadsheet-calculator\/assets\/icon-256x256.png?rev=3560483","icon_2x":"https:\/\/ps.w.org\/yps-spreadsheet-calculator\/assets\/icon-256x256.png?rev=3560483","generated":false},"screenshots":[],"raw_content":"<!--section=description-->\n<p>Spreadsheet Calculator for WooCommerce helps you sell products whose price changes according to customer choices, measurements, quantities or spreadsheet formulas.<\/p>\n\n<p>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.<\/p>\n\n<p>The workflow is simple:<\/p>\n\n<ol>\n<li>Create the fields your customer needs to fill in.<\/li>\n<li>Build a formula or map those fields to cells in a spreadsheet.<\/li>\n<li>Assign the calculator to a WooCommerce product.<\/li>\n<li>Let customers configure the product and add it to the cart with the calculated price.<\/li>\n<\/ol>\n\n<p>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.<\/p>\n\n<p>This plugin is not affiliated with, endorsed by or sponsored by WooCommerce or Automattic.<\/p>\n\n<p>What you can do with the free plugin:<\/p>\n\n<ul>\n<li>Create product calculator fields for numbers, text and picklists.<\/li>\n<li>Use formulas to calculate a WooCommerce product price.<\/li>\n<li>Upload a spreadsheet and map input and output cells.<\/li>\n<li>Show calculated results to customers on the product page.<\/li>\n<li>Assign a calculator to a WooCommerce product.<\/li>\n<li>Reorder fields so the product form is easy to follow.<\/li>\n<li>Mark fields as required and show clear validation messages.<\/li>\n<li>Keep customer selections visible in the cart, checkout, emails and order details.<\/li>\n<li>Review calculator values inside WooCommerce order screens.<\/li>\n<li>Show calculator data in WooCommerce Cart Blocks.<\/li>\n<li>Export and import calculator configurations when you need to move or back up a setup.<\/li>\n<\/ul>\n\n<p>Example use cases:<\/p>\n\n<ul>\n<li>Online printing: flyers, labels, posters, banners and business cards.<\/li>\n<li>Made-to-measure products: panels, covers, furniture parts and custom cuts.<\/li>\n<li>Products priced by area, length, weight, quantity or material.<\/li>\n<li>Custom services that need customer inputs before the final price is known.<\/li>\n<li>B2B products where a spreadsheet is already used internally to calculate the quote.<\/li>\n<\/ul>\n\n<p>Useful links:<\/p>\n\n<ul>\n<li>Plugin information: https:\/\/yourplugins.com\/product\/your-spreadsheet-calculator<\/li>\n<li>Documentation: https:\/\/yourplugins.com\/your-spreadsheet-calculator-documentation<\/li>\n<\/ul>\n\n<h3>Development Source<\/h3>\n\n<p>The non-minified JavaScript source files for this release are available in this source archive:\nhttps:\/\/yourplugins.com\/wp-content\/uploads\/sources\/yps-spreadsheet-calculator-3.0.1-source.zip<\/p>\n\n<p>Build instructions:<\/p>\n\n<ol>\n<li>Run <code>npm install<\/code><\/li>\n<li>Run <code>npm run build<\/code><\/li>\n<\/ol>\n\n<h3>Getting Started<\/h3>\n\n<ol>\n<li>Choose a product that needs a calculated price.<\/li>\n<li>List the customer inputs needed to calculate that price, such as width, height, quantity, material or options.<\/li>\n<li>Create those inputs as calculator fields.<\/li>\n<li>Use a formula when the price rule is simple.<\/li>\n<li>Use spreadsheet mapping when your pricing table or quote logic is easier to maintain in a worksheet.<\/li>\n<li>Assign the calculator to a WooCommerce product and test it before publishing.<\/li>\n<\/ol>\n\n<!--section=installation-->\n<ol>\n<li>Unzip the files and upload the <code>yps-spreadsheet-calculator<\/code> folder into the <code>\/wp-content\/plugins\/<\/code> directory<\/li>\n<li>Activate the plugin through the 'Plugins' menu in WordPress<\/li>\n<li>Make sure WooCommerce is active.<\/li>\n<li>Create the fields your customer should complete.<\/li>\n<li>Create a calculator and choose whether to use a formula or spreadsheet mapping.<\/li>\n<li>Assign the calculator to a WooCommerce product.<\/li>\n<li>Open the product page and test the calculator before publishing.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id=\"does%20this%20plugin%20require%20woocommerce%3F\"><h3>Does this plugin require WooCommerce?<\/h3><\/dt>\n<dd><p>Yes. The plugin calculates WooCommerce product prices and uses WooCommerce cart, checkout and order APIs.<\/p><\/dd>\n<dt id=\"what%20kind%20of%20products%20can%20i%20build%20with%20it%3F\"><h3>What kind of products can I build with it?<\/h3><\/dt>\n<dd><p>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.<\/p><\/dd>\n<dt id=\"do%20i%20need%20to%20use%20a%20spreadsheet%3F\"><h3>Do I need to use a spreadsheet?<\/h3><\/dt>\n<dd><p>No. You can build a calculator with a formula. Use a spreadsheet when your pricing rules are easier to manage in a worksheet.<\/p><\/dd>\n<dt id=\"can%20i%20use%20spreadsheet%20formulas%3F\"><h3>Can I use spreadsheet formulas?<\/h3><\/dt>\n<dd><p>Yes. You can upload a spreadsheet file and map calculator fields to spreadsheet cells.<\/p><\/dd>\n<dt id=\"can%20one%20calculator%20be%20assigned%20to%20multiple%20products%20or%20product%20categories%3F\"><h3>Can one calculator be assigned to multiple products or product categories?<\/h3><\/dt>\n<dd><p>The editor included in this package assigns a calculator to one WooCommerce product. Existing saved category or multi-product assignments are preserved for compatibility.<\/p><\/dd>\n<dt id=\"which%20field%20types%20are%20included%20in%20the%20core%20plugin%3F\"><h3>Which field types are included in the core plugin?<\/h3><\/dt>\n<dd><p>This package includes numeric fields, text fields and picklists.<\/p><\/dd>\n<dt id=\"can%20customers%20edit%20their%20choices%20after%20adding%20a%20product%20to%20the%20cart%3F\"><h3>Can customers edit their choices after adding a product to the cart?<\/h3><\/dt>\n<dd><p>The free plugin keeps calculator values visible in the cart, checkout and order details so customers and store managers can review the selected configuration.<\/p><\/dd>\n<dt id=\"is%20this%20an%20official%20woocommerce%20plugin%3F\"><h3>Is this an official WooCommerce plugin?<\/h3><\/dt>\n<dd><p>No. This plugin works with WooCommerce, but it is not affiliated with, endorsed by or sponsored by WooCommerce or Automattic.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>3.0.1<\/h4>\n\n<ul>\n<li>Added an admin banner that links to the paid Pro version.<\/li>\n<li>Removed duplicate native WooCommerce add-to-cart controls on calculator product pages.<\/li>\n<li>Refined the default calculator layout by removing unnecessary borders.<\/li>\n<li>Improved admin settings copy.<\/li>\n<\/ul>\n\n<h4>3.0.0<\/h4>\n\n<ul>\n<li>Renamed the plugin and improved compatibility with existing stores.<\/li>\n<li>Redesigned the calculator editor so fields, formulas, spreadsheet mapping, preview and settings are easier to find.<\/li>\n<li>Made field management clearer, with a better separation between customer inputs and calculated outputs.<\/li>\n<li>Improved the product-page calculator experience for customers.<\/li>\n<li>Improved spreadsheet mapping and made the Price result cell easier to configure.<\/li>\n<li>Marked the Base product price cell as optional for simpler spreadsheet setups.<\/li>\n<li>Added calculator preview and product-page display controls.<\/li>\n<li>Improved upload handling between product page, cart and order details.<\/li>\n<li>Improved how calculator values appear in the cart, checkout, emails and WooCommerce order screens.<\/li>\n<li>Added support for showing calculator item data in WooCommerce Cart Blocks.<\/li>\n<\/ul>\n\n<h4>2.7.10<\/h4>\n\n<ul>\n<li>Fixed PhpSpreadsheet autoload conflicts with other plugins.<\/li>\n<\/ul>\n\n<h4>2.7.9<\/h4>\n\n<ul>\n<li>Fixed AJAX errors and added <code>error_text<\/code> settings.<\/li>\n<\/ul>\n\n<h4>2.7.8<\/h4>\n\n<ul>\n<li>Fixed spreadsheet calculation engine issues.<\/li>\n<\/ul>\n\n<h4>2.7.5<\/h4>\n\n<ul>\n<li>Fixed worksheet changes after the first calculator creation.<\/li>\n<\/ul>\n\n<h4>2.7.4<\/h4>\n\n<ul>\n<li>Added item attributes for WooCommerce Blocks.<\/li>\n<\/ul>\n\n<h4>2.7.3<\/h4>\n\n<ul>\n<li>Added support for radio and select list items from spreadsheet validation rules.<\/li>\n<\/ul>\n\n<h4>2.7.2<\/h4>\n\n<ul>\n<li>Fixed picklist and radio default values.<\/li>\n<li>Fixed calculated cart decimals.<\/li>\n<\/ul>\n\n<h4>2.7.1<\/h4>\n\n<ul>\n<li>Fixed product category checks.<\/li>\n<\/ul>\n\n<h4>2.7.0<\/h4>\n\n<ul>\n<li>Added compatibility with PHP 8.2.<\/li>\n<\/ul>\n\n<h4>2.6.42<\/h4>\n\n<ul>\n<li>Added validation picklist items.<\/li>\n<li>Added the <code>awspc_filter_html_price<\/code> hook.<\/li>\n<li>Fixed dump and import features.<\/li>\n<\/ul>\n\n<h4>2.6.41<\/h4>\n\n<ul>\n<li>Added hooks.<\/li>\n<\/ul>\n\n<h4>2.6.40<\/h4>\n\n<ul>\n<li>Fixed \"order again\" behavior.<\/li>\n<\/ul>\n\n<h4>2.6.39<\/h4>\n\n<ul>\n<li>Added pricing cache.<\/li>\n<\/ul>\n\n<h4>2.6.38<\/h4>\n\n<ul>\n<li>Added product list cache.<\/li>\n<\/ul>\n\n<h4>2.6.37<\/h4>\n\n<ul>\n<li>Added an option to enable Bootstrap JS on the front end.<\/li>\n<\/ul>\n\n<h4>2.6.36<\/h4>\n\n<ul>\n<li>Added debugging features.<\/li>\n<li>Fixed formula calculator taxes.<\/li>\n<\/ul>\n\n<h4>2.6.35<\/h4>\n\n<ul>\n<li>Fixed interception in the spreadsheet engine.<\/li>\n<\/ul>\n\n<h4>2.6.34<\/h4>\n\n<ul>\n<li>Fixed selected picklist values after adding the product to the cart.<\/li>\n<\/ul>\n\n<h4>2.6.33<\/h4>\n\n<ul>\n<li>Changed the cart item hook position used to print fields.<\/li>\n<li>Avoided price error alerts in the cart.<\/li>\n<\/ul>\n\n<h4>2.6.15<\/h4>\n\n<ul>\n<li>Improved the way products are added to or removed from calculators from the product page.<\/li>\n<\/ul>\n\n<h4>2.6.14<\/h4>\n\n<ul>\n<li>Fixed product removal from the WooCommerce product page.<\/li>\n<\/ul>\n\n<h4>2.6.13<\/h4>\n\n<ul>\n<li>Fixed range slider JavaScript.<\/li>\n<\/ul>\n\n<h4>2.6.12<\/h4>\n\n<ul>\n<li>Fixed cURL error 28 timeout handling.<\/li>\n<\/ul>\n\n<h4>2.6.10<\/h4>\n\n<ul>\n<li>Fixed a 400 error related to cookies.<\/li>\n<\/ul>\n\n<h4>2.6.3<\/h4>\n\n<ul>\n<li>Added compatibility with the latest WordPress version at the time.<\/li>\n<li>Changed the plugin name.<\/li>\n<li>Updated the session handler.<\/li>\n<li>Cleaned up the codebase.<\/li>\n<li>Improved sanitization.<\/li>\n<\/ul>","raw_excerpt":"Create WooCommerce product price calculators with custom fields, formulas and spreadsheet files.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/310044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=310044"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/yourplugins"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=310044"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=310044"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=310044"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=310044"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=310044"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=310044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}