Pull Down Menu with Multiple Price Changes

[schwartzy1]

Is it possible to have several pull down menus and based on each option, change the price accordingly? Here is a link to what I'm trying to do, but when the item is added to the cart, the pricing isn't what it should be.

http://www.churchsupplies.com/store/beau-veste-altar-cloth-1108mg.shtml

thanks!

[schwartzy1]

ooo, and here is the code i'm using...


<form action="[-- SHOPPING_CART_URL BASE --]/order.cgi" method=post>
<input type=hidden name=storeid value=[-- STORE_ID --]>
<input type=hidden name=dbname value=products>
<input type=hidden name=function value=add>
<input type=hidden name=itemnum value=[-- PRODUCT.RecordNumber --]>
[-- IF PRODUCT.DisplayOrderingOptions --]
<br>[-- PRODUCT.OptionText --]
[-- ORDER_OPTION_MENU COLUMN --]
[-- END_IF --]

[-- IF PRODUCT.OptionsBox --]
<textarea name="[-- PRODUCT.Recordnumber --]:freeopt"> </textarea>
[-- END_IF --]

<input type=image src="[-- OUTPUT_DIRECTORY_URL --]/store/media/Add-to-cart.gif" border=0 name="Add to Cart" alt="Add to Cart">
</form>

[Eamon]

I'm not 100% sure I understand the question, but I'm guessing what you want to do is the following:

Based on the Options selected, the Hemming Charge would change. I imagine to know the Hemming Charge, it's based on a formula that calculates the different variables which determine how much Hemming is required.

If this is the case, the Standard Ordering Options won't work since it's a simple addition formula, every option value can have a price change associated to it, but all ShopSite does is add all the price changes together for the final price.

I think your workaround would be to build a script that controls the price calculation and updates the on Page shopsite variable with the value that's needed. This would be done with a combination of a CALL script to pull on a per product basis the option pricing varaibles, and then with on Page javascript to update the actual price field passed to the shopping cart with the selected options.

The field on the page that needs to be updated through Javascript is <option value="Hemming Charge $32.00;+32">Hemming Charge $32.00

It's the $32.00;+32 that needs to change based on the Javascript.

It's not a simple project but it's definitly doable. You'll need to know how to do Javascript and probably PHP/Perl for your CALL script.

Let me know if you have any questions about the concept.

[schwartzy1]

sorry, i guess i wasn't clear. Of those 6 options, three of them affect the price. The hemming charge is always 32 and will never change. The other two options, length of the altar top and length of the side drops affect the price and are based on a per yard basis. For that one product, it is $60/yard. If the altar top is 5', then the price would be $60 * 1.67 yds. Then, if the customer wants side drops of 7" on each side, it would be $60 * .39 yds. The total price would be the result of those two plus the $32 hemming charge.

[Eamon]

In that case I think you can just use the standard features in ShopSite, but you would need to enter in the price for each Length option. In the backoffice of ShopSite for every product in the Ordering Options area you would set it up like this:

Altar Top;n
5' (-$100.20);+100.2
6' (-$110.42);+110.42

Side Drops;n
7" (+$23.40);+23.40
8" (+$31.22);+31.22

and then for another product, let's say it costs $40/yd, you'd enter in the correct pricing for it in the Ordering Options. All the math calculations would have to be done when you're entering the product information.

For more info on Ordering Options, ShopSite has some detailed help at http://www.shopsite.com/help/10.1/en-US/sc/pro/index.htm?page=/help/10.1/en-US/sc/pro/ordering.options.html

[schwartzy1]

hmm, I was trying to avoid that, it would make price updates in the future a nightmare...

[Eamon]

I understand. The only other way is to go about with the CALL script that produces the Ordering Options. For example, the Ordering Options, you would enter the Yard Value for each option. In a custom field you'd enter in the Price Per Yard.

The Call Script would take all that data, do the matemetical calculations and generate the Drop Down menu code on your product page formatted the way ShopSite needs it.

It's possible to do, and we do this type of work for our clients all the time. There is a lot of power with a CALL scripts and re-producing ShopSite code with them. There is no simple solution for it that I know of.