[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:
>Howdy,
>
>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]
>
>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]
[/if-item-data]
- 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