[intro]In this Guide you’ll learn how to create a Wallpaper Calculator on an existing Product with Variants on your EKM online shop. You need to have generated a spreadsheet beforehand by following the steps in this Guide. [/intro]

When you have downloaded your spreadsheet of Products, your first step is to delete the rows that contain any Products (and their Variants/Options rows), leaving only the Product and Variant/Options rows for the Product that already has the Product Calculator (to use as your guideline) and any Products and their Variants that you want to add the same kind of Product Calculator to. 

It’s worth colouring the guideline product rows a bright colour, so you can differentiate them from the Product you’re working on. In this example, the ‘Wallpaper with Variants’ Product has already got a Product Calculator added, so that is my template Product highlighted in yellow. In this Guide, I’ll be adding a Product Calculator to the ‘More Wallpaper With Variants’ Product:

1. First, you need to add the Edit command to the A/Action column. You can do this by highlighting this column and clicking the Find & Select icon in the top right-hand corner:

2. Select Replace from the drop-down menu, and in the window that appears, add the Edit command, like this, before clicking the Replace All button:

3. Close the Replace window down and then scroll along to the right, until you reach the columns related to Product Calculators:

CalculatorShow - This can be Yes or No, and designates whether you want the Product Calculator visible on the Product Page or not. 

CalculatorType - This needs to be set for the kind of Product Calculator you’re adding. Either paint, wallpaper, tile, flooring or fabric.

CalculatorAllowWastage - This can be either Yes or No, and designates whether you would like to offer your customers the option to allow for wastage when calculating how much they need to purchase. 

CalculatorMeasurement - This can be m (metres), cm (centimetres), mm (millimetres) or ft (feet).

CalculatorCoverageX - This represents the Width field.

CalculatorCoverageY - This represents the Length/Height field.

CalculatorCoverageArea - This needs to be left blank if you are adding a Wallpaper Calculator. 

CalculatorPackSize - This needs to be left blank if you are adding a Wallpaper Calculator. 

4. Your next step is to copy the information from your guideline Product and its Variant rows onto the Product and its Variants you want to add your Wallpaper Calculator to:

5. Now you need to delete your guideline Product rows (highlighted in yellow) and save your spreadsheet before uploading it back onto your EKM online shop.

[more]

[/more]

[contact] If you need our help with your EKM online shop, contact your Ecommerce Expert or the Customer Support Team, who will be able to point you in the right direction. We're open from 8am-6pm weekdays and 9am-5.30pm weekends. If you'd like to suggest a feature or an upgrade on any of the EKM platforms, please let us know on the EKM Suggestions Board. If you have a non-account-specific question to ask the EKM Team, join us in the EKM Community. [/contact]