04
Apr

XSLPrice - Magento - Quick guide

  • Font size: Larger Smaller
  • Hits: 3351
  • Print

Moonsoft XLSPrice Calculator - Overview 

Show dynamic pricing for your products configured using an excel file. You will have available for creating your calculations all user inputs for the custom fields, user and group data, basic product data, the quantity...so you only have to place the calculated price at the output cell. You can also return a customized message and allow/disable the add to cart button for the options selected.


In order to calculate the result you can use the excel normally, introducing formulas, using functions, or searching data from other data sheets, like if you're working with an off-line excel file .

This is a quick guide intended to give an overview of the product functions, please check further entries of this blog to find out more details about backend configuration.


To create a calculator, you only need to attach it to the product and upload your excel file. The excel calculator will launch dynamically at the product page and also at the cart update. You'll be creating complex price rules a using a powerful tool.
XLSPrice calculator screenshot XLSPrice calculator screenshot

Products configuration. You can use default product custom fields to add options, texts or any other field to your products. The basic price of the product can be also used as an input for the calculation.

XLSPrice calculator screenshot

Build your excel You will have available for your excel the custom fields selected and also some additional values that you can use if needed for your calculation:

  • Store
  • Baseprice
  • Qty
  • User
  • Group
  • Product
  • Date
  • ..all custom fields


Configure the rest of your excel as preferred, using formulas, ranges, conditions or any other calculation you're able to build using the spreadsheet and the input parameters.

XLSPrice calculator screenshot


You can create as many different calculators as you need to configure your products prices.

XLSPrice calculator screenshot
Attach the calculators to products and/or categories of products. XLSPrice calculator screenshot XLSPrice calculator screenshot

Last modified on
Trackback URL for this blog entry.

Our clients' feedback