Order Anywhere / SKU / Database

This is an archive of old posting to the User Forum

Order Anywhere / SKU / Database

Postby Chris Moore » Fri Feb 27, 2004 5:08 pm

Hello 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=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
Chris Moore
 

Re: Order Anywhere / SKU / Database

Postby Jim » Fri Feb 27, 2004 6:20 pm

Chris Moore wrote:

Hello 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=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


The only error I get when I paste that code on a page and click on the

submit is that the storeid is bad. Make sure you use a valid storeid,
either the one you use when you log in or the encrypted one that has the
* infront of it. The encrypted version will be different every time it
is generated but it must may be any one of the encrypted versions.

Is there more than one form on your page? perhaps you have nested form
tags and that is what is causing the issue.

Jim
Jim
 


Return to User Forum Archive

Who is online

Users browsing this forum: No registered users and 32 guests