Guest Posted October 4, 2006 Posted October 4, 2006 I have looked at several different contributions, but none of them are what I am loooking for exactly. On some of my items that I sell online, I have to advertise a SMAP price, which is an advertised price I have to advertise online. BUT how can I set it up to show the MAP Price but below say "See lower price in cart" underneath the MAP price, so when they click add to cart it gives our discounted price instantly in shopping cart. Here is an example from another site that is exactly what I am wanting my webpage to do. ==> note: competitors site above <=-= My current online site I can only show the MAP price and then I had to make a seperate area to do the discount to get lower price, which works but is too many steps for a customer. i want it simpler to them. I would like for customers to be able to add to cart with corrected lower price then smap price without having to use a discount. I know this is possible as I have seen it on 3 different sites. ANY Idea?
steve_s Posted October 4, 2006 Posted October 4, 2006 in products table add an extra field for smap price, then in admin you will need to create a text box to enter smap price and also to alter sql so that gets writen to the table then will have to alter sql in products_description.php to call new field then you can output the smap price where u want. so basicaly smap price just becomes an extra product attribute same as price is
Guest Posted October 4, 2006 Posted October 4, 2006 in products table add an extra field for smap price, then in admin you will need to create a text box to enter smap price and also to alter sql so that gets writen to the table then will have to alter sql in products_description.php to call new field then you can output the smap price where u want. so basicaly smap price just becomes an extra product attribute same as price is THANKS, but can you explain in 'easy' terms and instructions, what file or HOW to exactly do this in instructions?
steve_s Posted October 4, 2006 Posted October 4, 2006 in the product table insert a field called products_smap_price Field = products_smap_price; type = decimal 15,4 ; null = No ; deafalut = 0.0000 then in categories.php in admin folder insert between lines 217 & 218 'products_smap_price' => tep_db_prepare_input($HTTP_POST_VARS['products_smap_price']), then insert in line 290 products_smap_price, after proudct_price, then insert in line 293 tep_db_input($product['products_smap_price']). after tep_db_input($product['products_price']). then insert between lines 366 & 367 'products_smap_price' => '', then insert into line 379 p.products_smap_price, after p.products_price, then after line 525 add <tr bgcolor="#ebebff"> <td class="main">Smap Price</td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_smap_price', $pInfo->products_smap_price, 'OnKeyUp="updateNet()"'); ?></td> </tr> then goto line 609 and add p.products_smap_price to sql statement ie add p.products_smap_price, after p.products_price then insert into line 815 p.products_smap_price, after p.products_price, same as above in line 817 that conludes admin section now product_info.php in your catalog folder insert into line 72 p.products_smap_price, after p.products_price, insert after line 80 $products_smap_price = $currencies->display_price($product_info['products_smap_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); amend line 94 <td class="pageHeading" align="right" valign="top">Our Price <?php echo $products_price; ?></td> insert after line 95 <tr> <td class="pageHeading" valign="top"></td> <td class="pageHeading" align="right" valign="top">SMAP <?php echo $products_smap_price; ?></td> </tr> your all done if you want pm me with email and email you the 2 files mine is not custmised if your store is customised line numbers will be different in product_info.php admin shoudl still be the same
luckysonfirst Posted October 11, 2006 Posted October 11, 2006 Hi, I'm using this one and it seems to work for 90% of the pages. It doesn't work in the What's new area. I don't know if anyone else has used it. Or how to fix that page. Pretty new to this. You will have to use an editor and change all of the MAP_WARNING to 'See Price In Cart' but that's not a big deal... You will also have to modify your mysql database. Full instruction including the manual edits are included along with the replacement files http://www.oscommerce.com/community/contributions,1725 It's listed as the Minimum Advertised Price Module Good Luck
Recommended Posts
Archived
This topic is now archived and is closed to further replies.