[ic] quantity pricing for product groups

[Russ Mann]

Guten Tag Goetz,

I just set this up this way:

I have a product group called "BPS" which is supposed to be regular price,
unless 3-9 are ordered, when it's supposed to be $10.00 each, and when 10 or
more are ordered, it's $9.50 each.

In catalog.cfg, these are set:

PriceField     CommonAdjust

CommonAdjust   pricing:price_group,q3,q10, ;products:price, ;$
AutoModifier   pricing:price_group

Here's the structure dump of my pricing DB:

CREATE TABLE pricing (
  sku char(64) NOT NULL default '',
  price_group char(12) default NULL,
  q3 char(12) default NULL,
  q5 char(12) default NULL,
  q10 char(12) default NULL,
  q25 char(12) default NULL,
  q100 char(12) default NULL,
  w3 char(12) default NULL,
  w5 char(12) default NULL,
  w10 char(12) default NULL,
  w25 char(12) default NULL,
  w100 char(12) default NULL,
  PRIMARY KEY  (sku),
  UNIQUE KEY sku (sku),
  KEY sku_2 (sku)
) TYPE=MyISAM;

Each item that is in the BPS group to be discounted has an entry in the
pricing DB like this:

sku	price_group	q3	q5	q10	q25	q100	w3	w5	w10	w25	w100
BP084	BPS		10.00	10.00	9.50	9.50	9.50	NULL	NULL	NULL	NULL	NULL

I left the q5, q25, and q100 fields in there in case I want to set different
price breaks in the future.  The only drawback to this method I can tell is
the CommonAdjust pricing isn't processed the same way as the [discount] tag,
therefore a customer's quantity savings aren't going to show up using the
[item-difference] tag.

-Russ

-----Original Message-----
From: interchange-users-admin@interchange.redhat.com
[mailto:interchange-users-admin@interchange.redhat.com]On Behalf Of Gotz
Verdieck
Sent: Friday, January 25, 2002 4:33 AM
To: interchange-users@interchange.redhat.com
Subject: [ic] quantity pricing for product groups


Hallo,

I have one question about quantity pricing.

What is the best way to create quantity pricing for different product
groups.
For example     group01 has q1 q5 q10 an
                group02 has q500 q700 q800
So the quantity pricing should depend on the product group
and not on the SKU.

Is it a good solution to built for every product group a pricing table ?
An how can I switch to the correct quantity pricing ?
Will this be displayed correctly in the basket?

Any help is welcome.




Yours sincerely,


Goetz Verdieck
====================================================================
Com4Office GmbH
Kommunikations-Design
Haldenstieg 7
22453 Hamburg
Tel.      +49 40 / 557 60 59 2
Fax       +49 40 / 557 60 59 3
E-Mail    Goetz.Verdieck@com4office.de
Internet  http://www.com4office.de



_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users