[ic] Quick Entry Sku

[Christopher Wenham]

On Thursday 01 April 2004 14:10, Dan Bergan wrote:
> I have a "Quick Entry" field where I allow my users to enter a sku from
> our printed catalog and add it to their cart.  If a user enters an
> invalid sku, it just takes them to the basket page with no feedback.  I
> would like to be able to detect when they entered an invalid sku and
> give them some formatting hints.  In the error log I see "Attempt to
> order missing product code", but I'm not sure how to detect that this
> has happened.

 What code are you using to add the product to the basket?

 I would do something like just query the products table for a match. Like:

 [tmp quickentry][value name="quickentry" filter="sql"][/tmp]

 [query list="1" sql="SELECT sku FROM products WHERE sku = '[scratch 
quickentry]'"]
   [on-match]
	[bounce href=|[area href=ord/basket
					form="mv_order_item=[sql-param sku]
					mv_order_quantity=1
					mv_action=refresh"]|]
   [/on-match]

   [no-match]
	<p>... formatting hints ...</p>
   [/no-match]
 [/query]

Regards,
-- 
Chris Wenham - Synesmedia, Inc.
http://www.synesmedia.com
516-620-4110 / 1-888-255-7573