[ic] Conditional Discounts

Ed LaFrance (New Media E.M.S.) ic_users at newmediaems.com
Sat Sep 18 10:51:10 EDT 2004

At 03:56 PM 9/17/2004, you wrote:

>Following on from the "I found the really complex stuff easy but am 
>getting stuck on the simple stuff" series, I'm trying to introduce a 5% 
>discount off of all products that have the "featured" field in the 
>"merchandising" table set to "disc5pc"
>I'm not entirely sure how to do the table value matching part, but here's 
>my attempt in plain English:
>[if merchandising.featured.[item-field sku] = "disc5pc"]
>  [discount [item-field sku]] $s * .95 [/discount]
>If someone can convert that first line into ITL (or a MySQL statement) 
>then I'd very much appreciate it and will post back a code snippet to the 
>group to put in flypage.html as my way of saying thanks.
>Regards, Ade.

I believe it would be:

[if-item-data merchandising featured eq disc5pc]
         [discount [item-code]] $s * .95 [/discount]

- Ed

New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          Ed.LaFrance at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax

More information about the interchange-users mailing list