Changing the Multiple Price Options utility

Hi Sam - long time not talky. Been having surgeries and am now ready to get back to it.
I really like the new utility: Multiple Price Options.
I would like to change the Multiple Price Options utility within XLEcom to add lables for each of the drop-down boxes (like the 'Stock Noes') and to have the boxes below one another instead of side-by-side. I have modified the code to do so but can't paste it into the cell as the cell is protected.
Is there any way I can do this? Perhaps you can modify the code and give us a second version of this great tool.
This is the modified code (I think it will work)....

<tr><td colspan=2 width=163 valign=middle height=21>

</td></tr>
<tr><td valign=middle height=93>
<p align=center>
</p></td>

<p align=center>
<form action="http://ww7.aitsafe.com/cf/add.cfm" method="post" target="shopcart"><input type="hidden" name="userid" value="98103224"><input type="hidden" name="price" value=""><input type="hidden" name="product[]" value=""><input type="hidden" name="return" value="http://xlecom.com">

<!--- Quantity box - Pre-filled --->

<p align=center><font color="#348781" size="-2" face="Verdana">Enter a Quantity: &nbsp
<input type="text" name="qty" size="3" value="1">

<p align=center><font color="#348781" size="-2" face="Verdana">Select a Display: &nbsp
<select name="productpr"><option value="ABCO-15TTFB 15 inch display:150">ABCO-15TTFB 15 inch display ($150)<option value="ABCO-17TTFB 17 inch display:250">ABCO-17TTFB 17 inch display ($250)<option value="ABCO-19TTFB 19 inch display:350">ABCO-19TTFB 19 inch display ($350)<option value="ABCO-20TTFB 20 inch display:450">ABCO-20TTFB 20 inch display ($450)<option value="ABCO-24TTFB 24 inch display:950">ABCO-24TTFB 24 inch display ($950)</option></select>

<p align=center><font color="#348781" size="-2" face="Verdana">Select a mount: &nbsp
<select name="product[]"><option value="Desktop Mount">Desktop Mount<option value="Wall Mount">Wall Mount</option></select>

<p align=center><font color="#348781" size="-2" face="Verdana">Select a color: &nbsp
<select name="product[]"><option value="Black">Black<option value="Silver">Silver</option></select>

<p align=center><br><input type="submit" value="Buy Now" OnClick="window.open('','shopcart','scrollbars,resizable,status,width=740 height=550')"></form></p>

What do you think?
- Carlos

Thanks - That's going to be a lot of work

Thanks Sam.
That's going to be a lot of work for the number of items I have to change. We do personalized gifts and some have many variables for many items (200+).

Is there a way to modify the original Multiple Price Options utility code so that I just have to enter the data in the fields of the new 'Add to Cart' page for all my items and it will be formatted like above in rows?
I know I would have to not only enter the data into the current fields of the 'Add to Cart' page, but also add the 'Labels' for the drop downs which would be the new fields added to the changed code.
thanks again,
- Carlos
P.S. I put the line breaks in to make it easier for me to read the code and see the variables.

RE: Thanks - That's going to be a lot of work

Customizing the program would be too difficult to do for your particular case.

Maybe you can create a spreadsheet using formulas to do it for you.

Sam Raheb
XLEcom Program Developer

I'm not that good at spreadsheets

I'm not that good at spreadsheets.
I guess I didn't realize that you would have to change the entire program to make the option boxes be below one another - but I can see that now.
Perhaps for the next iteration you may contemplate adding that?

Can the code be easily modifed just to add the labels for the additional options in the new 'Add-to-Cart page in the spreadsheet as I have added in my code?
Once again, thanks for your time.
- Carlos

RE: I'm not that good at spreadsheets

Carlos:

There is a relatively simple work around method for adding the Add-to-Cart form input box labels to the product ads.

In order for this work around to function properly, you must Publish the site using the "Single Ad Column Layout". By the way, the "Single Ad Column Layout" is a better visual looking format if you are using the long Item Descriptions.

Instructions:

(1) Using the "Site Setup" function, choose the "Single Ad Column Layout" for the Product Ad layout format.

(2) Using the "Ad Design" function, set the "Ad Fixed width size" to greater or equal to 650 pixels to prevent wrapping of the Add-to-Cart form.

(3) Add the following input box labels Table HTML code to the "Stock Note" column on the Categories sheet.

<table border=0 width=500><tr><td width=50><font size=-2>Qnty</font></td><td width=270><font size=-2>Select a Display</font></td><td  width=120><font size=-2>Select a mount</font></td><td width=60><font size=-2>Color</font></td></tr></table>

Note: The Table HTML code cannot exceed 256 characters if it is to work properly.

(4) From the Product Design sheet, select the Table HTML code from the "Stock Note" drop-down scroll list to add it to the product ad.

The following screen shot shows of the results utilizing this work around method:

Sam Raheb
XLEcom Program Developer

Thanks for the work-around

Thanks for the work-around Sam.
It works. I hope I can use your program to do what I need - I am still experimenting with an options selection table as well that will link to the ads with the final options.

Just to give you an idea of some of my needs I have enclosed the code for the initial idea of such a table. The 1st 4 links in the 'Certificate Only' column go to my item images - those will be replaced by the page the actual ad is on withthe final options (artwork selection, frame color, or whatever).

Take a look at it and tell if you think this would be a good way to go. If not very feasable, I may have to go to a regular e-commerce hosting that has more variables.

Carlos: Your sample code posted here was exported to an extrenal HTML file for review by technical support. It was then removed from this post due to its excessive length.

Thanks again for your help and consideration,
- Carlos

RE: Thanks for the work-around

Carlos:

It seems to me that you are looking for a custom solution that requires manual effort.

If you want to build a website out of the general design realm of XLEcom, then you can use the "Data Export" utility within the XLEcom program to create and export your Product Ads or Add-to-Cart links to an external file for use with other applications.

See the following topic:

Data Export - Exporting All your Product Ads to a Single File

Sam Raheb
XLEcom Program Developer

Data Export

Thanks again Sam.
I'll check that out and see if that solution works.
Have a great day.
- Carlos

RE: Changing the Multiple Price Options utility

Carlos:

The way to create your custom Add-to-Cart form so it is presented in a vertical fashion is to first remove all the table HTML code and line breaks from your Add-to-Cart form code shown in your original posting. Your cleaned up Add-to-Cart form code would be the following:

Cleaned up Add-to-Cart form code:

<form action="http://ww7.aitsafe.com/cf/add.cfm" method="post" target="shopcart"><input type="hidden" name="userid" value="98103224"><input type="hidden" name="price" value=""><input type="hidden" name="product[]" value=""><input type="hidden" name="return" value="http://xlecom.com"><!-- Quantity box - Pre-filled --><p align=center><font face="Verdana" color="#348781" size="-2">Enter a Quantity: &nbsp;</font><input type="text" name="qty" size="3" value="1"> <p align=center><font face="Verdana" color="#348781" size="-2">Select a Display: &nbsp;</font><select name="productpr"><option value="ABCO-15TTFB 15 inch display:150">ABCO-15TTFB 15 inch display ($150)<option value="ABCO-17TTFB 17 inch display:250">ABCO-17TTFB 17 inch display ($250)<option value="ABCO-19TTFB 19 inch display:350">ABCO-19TTFB 19 inch display ($350)<option value="ABCO-20TTFB 20 inch display:450">ABCO-20TTFB 20 inch display ($450)<option value="ABCO-24TTFB 24 inch display:950">ABCO-24TTFB 24 inch display ($950)</option></select> <p align=center><font face="Verdana" color="#348781" size="-2">Select a mount: &nbsp;</font><select name="product[]"><option value="Desktop Mount">Desktop Mount<option value="Wall Mount">Wall Mount</option></select><p align=center><font face="Verdana" color="#348781" size="-2">Select a color: &nbsp;</font><select name="product[]"><option value="Black">Black<option value="Silver">Silver</option></select> <p align=center><br><input type="submit" value="Buy Now" OnClick="window.open('','shopcart','scrollbars,resizable,status,width=740 height=550')"></form>

Next, add this Add-to-Cart form code to the last column cell in the database labeled "Custom Add-to-Cart Form" for the particular Product Ad. Once you do this, remember to change the value in the third database column labeled "Display Add to Cart" to "FALSE".

Note: To add the Add-to-Cart form code to the "Custom Add-to-Cart Form" cell, first highlight the cell and then paste the code into formula bar. This makes things easier and will not cause any unforeseen problems.

The above procedure yields the following results shown in the image screen shot below:

Sam Raheb
XLEcom Program Developer