Lower price when adding to cart??

[Urbluffingme]

I sell GPS Receivers on my web site. Recently I had to sign an aggreement that requires me to advertise at a minimum price. I can sell them for whatever I want, but I can't advertise below the minimum set by the manufacturer. What most do is they advertise one price, and then when a customer adds it to their cart, the actual price is lower. Can anyone help me with this issue. I really need to address this asap. I can't sell any units at the price the manufacturers set, and if I get caught advertising for less, they can cut me off. Please help me. Thank you in advance.

Kevin

[Urbluffingme]

I received this reply to a post in a php forum. Can anybody help me do this in osC?

Ok, so it sounds like having a new table that contains sale info would be good. Somethng along the lines of:

 

Sale_items table:

id | item_id | price | good_from(date) | good_until(date)

 

NOTE: If you add a sale price field to the current table, that is a waste since not all items have sale prices.

----

 

When initially displaying an item (with non sale price) could you also query for a Sale_item_id as part of the query (just join the tables and ask for the additional data) and echo it into a hidden input? (Not the price but the id value or a flag of some kind)

<? 

//query for items including sale item_id 

<input value="<?=sale_price_id;?>" name="sale_price_id" /> 

?> 

That way on the next page you could see if that variable came over and then pull from db based upon that: 
<? 
if ($_POST['sale_price_id] != '') 
{ 
//just a sample 

"Select item from Table 
LEFT JOIN Sale_items 
ON items.item_id = Sale_items.item_id 
WHERE item_id = $_POST['item_id']" 
} 
else 
{ 
//run normal query 
?> 
Or, if not, just let the normal query run which brings in the reg price.

Or, if not, just let the normal query run which brings in the reg price.

 

--this is a side note. Have you contacted osCommerce to see if they have a solution?

 

 

Hope any of this helps.

 

Can anybody help me do this in osC?

[Urbluffingme]

Could I add a field to the db that is 'sale price' and then put an optional input field in admin? Then rewrite the add to cart function (if one exists) to check for 'sale price' and display it if it is not null?

[Urbluffingme]

Just so anybody knows who cares. Not like anybody cares, because this maybe the 15th time I asked for help and got silence. But anyway, I found a contribution that takes care of the problem. And dont give me that 'Use the search BS.' Osc's search is worthless. Find it here:

Map Pricing Contribution

 

Thanks for nothing again.

[Guest]

if you dont like it then go else where. you did find it, which means you needed to do some research. no one likes sarcaasm