Order Anywhere / SKU / Database
Posted: Fri Feb 27, 2004 5:08 pmHello All!
One last question before the weekend. I am using the order anywhere feature
in 6.3 We built the cart after the fact and are trying to blend it into our
existing web site. I have loaded all of the part numbers into SS and have
generated the SKU db as instructed. In the website sections I list the
products sorted by partnumber ie.
http://www.ciscodata.com/routers/Cisco_1600_Series.asp this list is fed by a
sql db. I use an include to write the table for the product. In this include
I have put
<FORM action="http://store.ciscodata.com/cgi-bin/sc/order.cgi" method=post>
Qty: <input type=text size=1 name="=<%= rs("partnumber") %>:qnty" value="1"
<input type=hidden name=dbname value=products>
<input type=hidden name=function value=add>
<input type=hidden name=sku value=<%= rs("partnumber") %>>
<input type=image SRC="/images/add-to-cart-form.jpg" value=Submit
name=submit>
<input type=image SRC="/images/view-cart-form.jpg" value=Submit name=submit>
</FORM>
that way the name:qty and sku value change for each product depending on
what it is when the table is written.
This is the form data it yields:
<FORM action="http://store.ciscodata.com/cgi-bin/sc/order.cgi" method=post>
Qty: <input type=text size=1 name="CISCO1760:qnty" value="1" >
<input type=hidden name=storeid value=*****>
<input type=hidden name=dbname value=products>
<input type=hidden name=function value=add>
<input type=hidden name=sku value=CISCO1760>
<input type=image SRC="/images/add-to-cart-form.jpg" value=Submit
name=submit>
<input type=image SRC="/images/view-cart-form.jpg" value=Submit name=submit>
</FORM>
And this is the HTML that SS gives me when I tell it to generate the HTML
for me to past into my page:
<FORM action="http://store.ciscodata.com/cgi-bin/sc/order.cgi" method=post>
<BR>
Quantity <input type=text size=2 name="CISCO1760:qnty" value="1" >
<input type=hidden name=storeid value=*****>
<input type=hidden name=dbname value=products>
<input type=hidden name=function value=add>
<input type=hidden name=sku value=CISCO1760>
<input type=submit value="[Add to Cart]">
<input type=submit name=checkout value="[View Cart]">
</FORM>
Why doesnt it work??? I get:
Error in Form!
----------------------------------------------------------------------------
----
We're sorry, but there was an error in you form data!
Please specify a valid value for the sku .
Please press the Back button on your browser to correct the error.
What gives?
Chris
One last question before the weekend. I am using the order anywhere feature
in 6.3 We built the cart after the fact and are trying to blend it into our
existing web site. I have loaded all of the part numbers into SS and have
generated the SKU db as instructed. In the website sections I list the
products sorted by partnumber ie.
http://www.ciscodata.com/routers/Cisco_1600_Series.asp this list is fed by a
sql db. I use an include to write the table for the product. In this include
I have put
<FORM action="http://store.ciscodata.com/cgi-bin/sc/order.cgi" method=post>
Qty: <input type=text size=1 name="=<%= rs("partnumber") %>:qnty" value="1"
input type=hidden name=storeid value=*****
<input type=hidden name=dbname value=products>
<input type=hidden name=function value=add>
<input type=hidden name=sku value=<%= rs("partnumber") %>>
<input type=image SRC="/images/add-to-cart-form.jpg" value=Submit
name=submit>
<input type=image SRC="/images/view-cart-form.jpg" value=Submit name=submit>
</FORM>
that way the name:qty and sku value change for each product depending on
what it is when the table is written.
This is the form data it yields:
<FORM action="http://store.ciscodata.com/cgi-bin/sc/order.cgi" method=post>
Qty: <input type=text size=1 name="CISCO1760:qnty" value="1" >
<input type=hidden name=storeid value=*****>
<input type=hidden name=dbname value=products>
<input type=hidden name=function value=add>
<input type=hidden name=sku value=CISCO1760>
<input type=image SRC="/images/add-to-cart-form.jpg" value=Submit
name=submit>
<input type=image SRC="/images/view-cart-form.jpg" value=Submit name=submit>
</FORM>
And this is the HTML that SS gives me when I tell it to generate the HTML
for me to past into my page:
<FORM action="http://store.ciscodata.com/cgi-bin/sc/order.cgi" method=post>
<BR>
Quantity <input type=text size=2 name="CISCO1760:qnty" value="1" >
<input type=hidden name=storeid value=*****>
<input type=hidden name=dbname value=products>
<input type=hidden name=function value=add>
<input type=hidden name=sku value=CISCO1760>
<input type=submit value="[Add to Cart]">
<input type=submit name=checkout value="[View Cart]">
</FORM>
Why doesnt it work??? I get:
Error in Form!
----------------------------------------------------------------------------
----
We're sorry, but there was an error in you form data!
Please specify a valid value for the sku .
Please press the Back button on your browser to correct the error.
What gives?
Chris