[ic] can I customize quantity pricing?

[ICDEV]

>>
I'd like to expand on Terry's question, as my client also has weird yet
numerous pricing models.  I'd like to to know if anybody here has heard
of this kind of a setup and if it is feasible with interchange?

Ok, not only do we have various qty items, such as 125/pack, 500/roll
and so on, but also quite a few sets of price break ranges (ex. 1-10 @
1.50, 11-19 @ 1.45, 12&up @ 1.25).  We have on the order of 70-80 unique
sets of price break ranges and probably 10-20 quantities (maybe more),
all in various combinations for 50,000 or so products.

So, has anybody done anything similar with interchange?  What was your
overall experience?

Any insight provided is greatly appreciated.

Thanks
Allyn Hunt
<<

Here is a snip of our pricing file:
sku	price_group	q1	q2	q3	q4	q5	q6	q10	q12	q15	q24	q25	q36	q48	q50	q72	q100
q144	q250	w2	w5	w10	w25	w100
sku12	ABUXX	2.66	2.66	2.66	2.66	2.66	2.66	2.66	2.4	2.4	2.4	2.4	1.99	1.99
1.99	1.99	1.99	1.99	1.99

This is based on the standard foundation pricing file, with a few more
discounts. You need to keep in mind that if someone orders one of the breaks
like q10, and you don't have a quantity break for that particular sku, you
have to set a value in this spot. It could be higher, or lower than the
adjacent price breaks depending on your price struture for broken
cases/boxes, etc. We just fill in the values with the previous break prices
until then next break price is met for that particular item.

I also maintain a pricegroupdiscount database that populates these values
based on predetermined discounts, per price_group. This is done outside
interchange, and hooks into the customers back end inventory & price system.

We haven't implemented wholesale price structures yet.

I have found this to be a very flexible structure.

-Steve