View Full Version : Pricing on Items


escoyne
11-23-2009, 06:27 AM
Ok, I'm trying to see what woud be the best way to do this.

I have products that have two different prices based on the color. Would it be best to have the two prices in a table? or would it be easier to use a multiplication type function to get the pricing based on the standard price?

Keep in mind that the end results would be printed on a sales receipt/invoice.

Product = Mug

Mug = Standard color = $5.00
Mug = Speciality color = $7.50 (50% more than standard color)

ajetrumpet
11-23-2009, 06:38 AM
treat is as two seperate products, and thus two separate records in your products table. easier this way in the long run.

escoyne
11-23-2009, 09:10 AM
WOW, that makes for alot of products...

ajetrumpet
11-23-2009, 11:19 AM
WOW, that makes for alot of products...

lots a products better than lots a confusion...