Before you update
This guide is for stores currently using Your Spreadsheet Calculator 2.x and moving to version 3.x. The update is usually simple, but it should be tested on a staging copy before changing the live website.
Install the new plugins
Version 3.x uses the new Spreadsheet Calculator plugin family. Do not keep the old 2.x plugin active together with the new 3.x plugin.
- Create or refresh a staging copy of your website.
- Deactivate the old 2.x plugin and any old 2.x add-ons on staging.
- Install and activate the new base plugin from WordPress.org.
- If you use Pro features, install and activate the new Pro plugin too.
- If you use add-ons, install the matching new add-on versions.
After confirming everything works, repeat the same process on the live website. Keep a backup of the old setup until the live migration has been tested.
What changes in 3.x
- The admin area is cleaner and easier to follow.
- Calculators have clearer product assignments.
- Fields belong to the calculator that uses them, instead of being shared globally.
- The product-page calculator has a newer frontend layout.
- Most formulas can keep working without being rewritten.
The main thing to review is not usually the formula itself. It is the product assignment, the frontend look, and any custom CSS or JavaScript added to the old calculator.
Migration checklist
- Open each important calculator in staging.
- Check that the calculator fields and formulas are still correct.
- Check which WooCommerce products are assigned to each calculator.
- Open one product page for each important calculator.
- Test the full customer flow: calculate price, add to cart, cart, checkout, and order details.
- Clear cache, CDN and minification layers after updating.
Product type migration
Version 3.x includes a Migrate products to Spreadsheet Calculator action. It changes linked WooCommerce products to the dedicated Spreadsheet Calculator product type.
Run this only after you have checked the calculator assignments in staging. If a calculator is assigned by category, the migration may affect many products at once.
When to be more careful
Plan a deeper staging review if your site uses:
- custom CSS for the old calculator layout
- custom JavaScript or jQuery connected to calculator fields
- theme overrides or custom product-page templates
- custom snippets that depend on old field IDs or old markup
- the Multi-step add-on, which has not been migrated to the latest version yet and is not currently available for 3.x
These customizations may need small adjustments for the new 3.x frontend.
Final check
Once staging is confirmed, repeat the same plugin changes on production, clear all cache layers, and test one real product before considering the migration complete.