[ic] Foundation 911 - Fixing Pricing

[Dog Tags]

Foundation 911 - Fixing Pricing

Hi All

I am learning IC using the Foundation demo in 4.8.3, and one of the biggest problems is the pricing stuff. 

Here is what I want IC pricing to do:

1. regular price for 1 item - products > price field ---- would prefer adding and using "price" field in pricing table instead of products table
2. quantity discount pricing - pricing > q2,q5,q10,q25,q100 fields
3. options pricing - options > size, material, specified features, special weights, special destinations, other fields
4. wholesale pricing - pricing > w2,w5,w10,w25,w100, etc. fields
5. designated group pricing - pricing > boyscouts-q1, boyscouts-q2, boyscouts-q3, church-q1, church-q2, school-q1, etc.
6. special destination pricing - pricing > ireland-q1, ireland-q2, ireland-q3, canada-q1, canada-q2, japan-q1, etc.
7. special pricing fields ----- sale_price, special_price, extra_shipping, "heavy_item", other special price fields - pricing > sale_price, special_price, extra_shipping, heavy_item, etc.
8. other stuff in the great beyond.....

What I have found is that catalog.cfg has includes for etc/before.cfg and etc/after.cfg. In before.cfg, there is no content. However, in after.cfg, there is a bunch of pricing code that seems to override what is in catalog.cfg. 

Here is an example of what is in the default after.cfg. Notice that 2 ProductFiles are named. In each file, there is a "price" field. Maybe this is where the confusion is. Here we go:

CommonAdjust   :sale_price, ;:price, ;$, ==:options
PriceField     0
Replace ProductFiles
ProductFiles   products options

And, here is what is in the default catalog.cfg:

ProductFiles   products
PriceField      0
CommonAdjust    :sale_price, ;:price, ;$, ==:options

Okay, now with Foundation in the default status, the only kind of pricing that works is the price field in the products.txt db. That's it. 

However, I changed a few things around, and I got some interesting results. In one case, I got the Quantity Discount pricing to work, but not the Options. In another case, I got the Options pricing to work, but not the Quantity Pricing.

Here is one setup.

In after.cfg, the following I believe will enable the Options pricing but negate the Quantity pricing:

CommonAdjust pricing:q2,q5,q10,q25,q100:, ;products:price, ;options:price, ==size:pricing, ==color:pricing
#PriceField     0
PriceField     no_price

#Replace ProductFiles
ProductFiles   products options
#ProductFiles   products

I'll keep experimenting with this thing, but if anyone has any pointers for how to get all of the pricing functions to work in Foundation, I would welcome your help. I sure could use all of the pricing features mentioned above.

Thanks very much.
-- 

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Win a ski trip!
http://www.nowcode.com/register.asp?affiliate=1net2phone3a