Guest Posted October 25, 2002 Posted October 25, 2002 What I'd like to do is assign a MSRP (separate from the selling price) for each product. Then have the selling price be a percentage off MSRP based on manufacturer. This way, all products from manufacturer A can be 10% off retail, manufacturer B 15%, etc... Can someone give me a push in the right direction? Even a starting point would be extremely helpful.
Ajeh Posted October 27, 2002 Posted October 27, 2002 You could add a field products_price_list to the products table then add a filed manufactures_discount to the manufactures table. Now add a function that when you want a price, if there is a manufactures_id in the products table ... get the discount, if it > 0, from the manufacturer's table and subtract that from the new products_price)list in the products table. You will have to check for anywhere that the price is retrieved, but the most obvious locations would be where the cart is processed. Change the settings where the products price is either the product's special.specials_new_products_price or products.products_price to special.specials_new_products_price or products.products_price-(manufacturers.manufactures_discount*products.products_price) Got all that? :shock:
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.