Jump to content
  • Pricing Formulas with SKU Cabinets

       (0 reviews)

    Darth Moxy

    Here's the way we do the pricing in our template catalog for SKU cabinets that is pretty simple (and as a side note you can buy pieces of our template catalog to have them inside your own Allmoxy instance).

    You'll see we just base the price off of 1) the door style/finish option and 2) the size chosen. (Of course those names are just what we happened to call them. You may or may not offer finish options so maybe yours would just be called door style)




    In this example the price will vary when the customer chooses either more/less expensive style and a more/less expensive size (BNS12 meaning "Base No Shelf, 12 inch"). 

    Here's the way that pricing formula looks on the back end, it's a simple formula and I'll explain the variables/setup:




    This formula basically reads as "if they choose a door style in group 1 then give me the price from group A of the cabinet size attribute" and then continues for all the other options.

    Now let's look at where those variables are coming from/what information they're spitting out.

    You can see here the 1, 2 and 3 in the formulas are coming from the 'identifier' column of the door style/finish option attribute. The different styles are grouped (1, 2 or 3). 




    Then the A, B and C in the formula come from the size attribute. You can see here there are columns for A, B and C and there are corresponding prices in each cell. The price in column A is what is given if they choose door style/finish option with identifier of 1 (the least expense styles). The price in column A is what is given if they choose door style/finish option with identifier of 2, and so on with the next column. 




    So if you look back at the formula you'll see that the customer chooses a door style/finish option which will give the formula an identifier of 1,2 or 3 and then when they choose the size it will give the formula the corresponding dollar amount from column A, B or C.

    User Feedback

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.
    Note: Your post will require moderator approval before it will be visible.


  • Create New...

Important Information

Terms and conditions of this site