Cart Viper Logo

We understand that your ecommerce site is crucial to the success of your business, from time to time issues and questions can arise and you need to have the assurance there will be someone on hand to help resolve these in a timely fashion so you can spend your time driving your own business forward.

So if you are looking for faster responses to your questions or would like the assurance there is someone on hand for you to contact, fear not we have a number of paid support options that are available to you that can give your organisation the peace of mind knowing a member from the Cart Viper team will always be available to assist!

Purchase a Support Plan

Community Support

HomeHomeGeneral Informa...General Informa...Feature Request...Feature Request...Price lookup table - multiple variants with differnt pricesPrice lookup table - multiple variants with differnt prices
Previous
 
Next
New Post
6/22/2011 2:28 PM
 
johns
No Ranking

Joined: 6/22/2011
Posts: 21
I need my customer to choose from several variants that affect the price, but the variant price is dependent on the previous option chosen.  For example is they order a 10x14 print plus optional frame for $10, if they order a 16x20 print plus frame the frame now cost $25 (not $10).  This example shows two variants but I may have up to 4 variants.  Is it possible to do  table lookup for the pricing?  All of these products will have the same price.  An example of the table is at http://www.printthatimage.com/giclee-...   I prefer the customer choose the variants with dropdown boxes instead of clicking on a big table.  Any other suggestions are welcome.  The inventory/sku for variants you have would work if I could add a price there plus a valid flag (in case of an illogical combination.
 
New Post
6/23/2011 9:30 AM
 
Mark - Cart Viper Developer
7th Level Poster


Joined: 7/27/2010
Posts: 424
Hi John

I understand what you are trying to do with the variant pricing. You are working on a multi-dimensional price matrix which is used to work out the variant pricing based on selected options.

As you will have seen we work on a single dimension, in that other variant selection do not change the price for other variants.

The only way I can think is that you'd need to make a product for each canvas/print size then add in the options. I'm correct in thinking that the size of the print is the determining factor in the variant pricing?
Would that work for you?

Regards

Mark
 
New Post
6/26/2011 8:03 PM
 
johns
No Ranking

Joined: 6/22/2011
Posts: 21
Thanks for your quick reply.  Actually almost every variant affects the price.  Would it be possible to call a pricing function and pass the variants chosen, than  could do an SQL lookup?  Or allow SQL to be entered for the price  SELECT Price FROM PriceTable WHERE Size= 3 AND Medium= 'Watercolor' AND Matte = 'White' AND Frame = 125
 
New Post
6/27/2011 10:00 AM
 
Mark - Cart Viper Developer
7th Level Poster


Joined: 7/27/2010
Posts: 424
Hi John

I see you point, I think your idea for implement the feature on the variant inventory popup would be the best solution. 




Then during the store front page we would need to create an AJAX function which calls into the back office to determine if the the current variant options selected are valid.
If they are valid the user can add the item to the cart otherwise we'll display some generic error message.
This would the implement the multi-dimension pricing grid you need for you store.

At the moment this functionality doesn't exist, however we could discuss implement this feature and fast tracking the development of this if you were to sponsor the feature. Please drop me an email to mark@cartviper.com and we can talk further about it.

Regards

Mark
 
 Page 1 of 1
Previous
 
Next
HomeHomeGeneral Informa...General Informa...Feature Request...Feature Request...Price lookup table - multiple variants with differnt pricesPrice lookup table - multiple variants with differnt prices


 

We use cookies on our website to improve our service to you, by continuing you agree to our use of cookies. However you are able to update your settings at any time.

Continue View Cookie Policy Cookie Settings

Cookie Policy

A cookie, also known as an HTTP cookie, web cookie, or browser cookie, is a piece of data stored by a website within a browser, and then subsequently sent back to the same website by the browser. Cookies were designed to be a reliable mechanism for websites to remember things that a browser had done there in the past, which can include having clicked particular buttons, logging in, or having read pages on that site months or years ago.

Strictly Necessary Cookies

These cookies cannot be disabled

These cookies are necessary for the website to function and cannot be switched off. They are normally set in response to your interactions on the website e.g. logging in etc.

Cookies:
  • .ASPXANONYMOUS
  • .DOTNETNUKE
  • __RequestVerificationToken
  • authentication
  • CV_Portal
  • CV_Store_Portal_Cart_0
  • CV_USER
  • dnn_IsMobile
  • language
  • LastPageId
  • NADevGDPRCookieConsent_portal_0
  • userBrowsingCookie

Performance Cookies

These cookies allow us to monitor traffic to our website so we can improve the performance and content of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited or how you navigated around our website.

Cookies:
  • _ga
  • _gat
  • _gid

Functional Cookies

These cookies enable the website to provide enhanced functionality and content. They may be set by the website or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

Cookies:

Currently we are not utilizing these types of cookies on our site.

Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Cookies:

Currently we are not utilizing these types of cookies on our site.

Feedback