[ic] Coupon codes...
Mon, 26 Mar 2001 21:00:40 -0500
On Mon, Mar 26, 2001 at 08:19:38PM -0500, Doug Alcorn wrote:
> "Dan McFarland" <email@example.com> writes:
> > I want to have several mailing peices for customers that say ENTER THIS
> > (ITEM?) CODE ##### and get a $--- discount.
> Here's what I think. Have a seperate table for discount codes. On
> the basket page, have an input for them to type in the discount code
> with it's own little "apply discount" submit button. Then you can
> take this entered value and look it up. If it exists, [discount] your
> totals. If it doesn't, give a warning.
> > First of all, is it possible to use a negative price and create an ITEM for
> > each code?
Yes, negative prices do work (as of 4.03). We use them for "Free
Saturday shipping" or "Free this or that" promotions. You will
probably want some sort of logic to control how they show up
(or don't). We use a "status" field in all our catalogs, -1
error/delete, 0 suspend/hide, 1 active.
A negative item is not at all the same as a "discount" in usual sense.
> I don't know, I haven't tried. My only concern with putting discounts
> in the products table is that it becomes searchable with the rest of
> the products. Maybe you don't care where your customers get the
> discount code as long as they buy something. Maybe you do.
> I think however you do it is going to require some programming.
> (__) Doug Alcorn (mailto:firstname.lastname@example.org http://www.lathi.net)
> oo / PGP 02B3 1E26 BCF2 9AAF 93F1 61D7 450C B264 3E63 D543
> |_/ If you're a capitalist and you have the best goods and they're
> free, you don't have to proselytize, you just have to wait.
> Interchange-users mailing list
Christopher F. Miller, Publisher email@example.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
Content management, electronic commerce, internet integration, Debian linux