cheli3

Hi, Try this one... http://www.oscommerce.com/community/contributions,1310

Greetings All, OK... I have been playing around with this stuff and I think I have found out how to show % savings. I've put it up as a contribution here... http://www.oscommerce.com/community/contributions,1310 Be Kind, it's my first one. Steve :D

Hi Brian and All, Don't meen to doubt you but the mod does work on MS2. http://www.oscommerce.com/community/contributions,1373 I have installed it on a copy without any problem. IMHO,It is a great mod. Steve

Thanks Lord Illicious, I needed that. I was looking back at some old topics and couldn't find it. Works perfectly now :!: Steve

Greetings All, Phelan, this little tip is GREAT!!!! Exactly what I was looking for. THANK YOU :!: One question though... For some reason I have two(2) Buy It Now buttons? If I change the configuration not to show the Buy It Now Button, I now show two(2) price columns. This can't be good. Any ideas :?: TIA, Steve

Hi Kevin, You need to add the following statement to your database thru mysql... ALTER TABLE `products` ADD `products_retail_price` decimal(10,2) default NULL AFTER `products_price`; Steve

Hello All, I have tried this hack on a fresh MS2 install and it works correctly. I used the code I tweeked. Some of Seans line numbers are off, so beware and BACK UP :!: :!: :!: At the indicated line number, you might have to look ahead some for the correct line to replace. Don't forget to add the correct dB statement in your sql dB. Steve

Hi James, Try this one... http://www.oscommerce.com/community/contri...ions,397/page,3 HTH Steve :D

That would be great tpfaff. Anytime you are ready, no rush. Steve

Sorry. Haven't tried this on Ian's Loaded 5. I am using MS1 without any problem. Steve

Greetings All!! I have posted the working script below. Some of the values need to be changed from Sean's original contrib. All credit goes to Sean, I just tweeked it a bit. Main changes are in bold. =============================================== EZ new fields v1.0 easy way add retail price in the product_info.php Total 3 files need change: catalog/admin/includes/languages/english/categories.php catalog/admin/categories.php catalog/product_info.php please backup your files first. INSTALL 1. add a table in product( database ) ALTER TABLE `products` ADD `products_retail_price` decimal(10,2) default NULL AFTER `products_price`; 2. in catalog/admin/includes/languages/english/categories.php add define('TEXT_PRODUCTS_RETAIL_PRICE_INFO', 'Retail Price:'); define('TEXT_PRODUCTS_RETAIL_PRICE', 'Products Retail Price:'); 3. in catalog/admin/categories.php ------------------------------------------------------------------------------------------- line:198 after this line: 'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']), add this line: 'products_retail_price' => tep_db_prepare_input($HTTP_POST_VARS['products_retail_price']), ------------------------------------------------------------------------------------------- line:259 about this line: $product_query = tep_db_query("select products_quantity, products_model............ before products_price add products_retail_price, --------------------------------------------------------------------------------------------- line:262 about this line: tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model................... before this: products_price add products_retail_price, before this: '" . $product['products_price'] . add '" . $product['products_retail_price'] . "', ---------------------------------------------------------------------------------------------- line:319 about this line: $product_query = tep_db_query("select pd.products_name, pd.products_description.................. brfore this: p.products_price add p.products_retail_price, ----------------------------------------------------------------------------------------------- line:458-461 after these lines: <tr> <td class="main"><?php echo TEXT_PRODUCTS_PRICE; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_price', $pInfo->products_price); ?></td> </tr> add there lines: <tr> <td class="main"><?php echo TEXT_PRODUCTS_RETAIL_PRICE; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_retail_price', $pInfo->products_retail_price); ?></td> </tr> -------------------------------------------------------------------------------------------------- line:503 about this line: $product_query = tep_db_query("select p.products_id, pd.language_id......................... before this: p.products_price add p.products_retail_price, -------------------------------------------------------------------------------------------------- line:530 after this line: <td class="pageHeading" align="right"><?php echo $currencies->format($pInfo->products_price); ?></td> add this line: <td class="pageHeading" align="right"><?php echo $currencies->format($pInfo->products_retail_price); ?></td> --------------------------------------------------------------------------------------------------- line:692 about this line: $products_query = tep_db_query("select p.products_id, pd.products_name....................... before this: p.products_price add p.products_retail_price --------------------------------------------------------------------------------------------------- line:694 about this line: $products_query = tep_db_query("select p.products_id, pd.products_name......................... before this: p.products_price add p.products_retail_price -------------------------------------------------------------------------------------------------- line:869 replace this line: $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_PRICE_INFO . ' ' . $currencies->format($pInfo->products_price) . '<br>' . TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity); by this line: $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_PRICE_INFO . ' ' . $currencies->format($pInfo->products_price) . '<br>' . TEXT_PRODUCTS_RETAIL_PRICE_INFO . ' ' . $currencies->format($pInfo->products_retail_price) . '<br>' .TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity); -------------------------------------------------------------------------------------------------- 4. in catalog/product_info.php -------------------------------------------------------------------------------------------------- line:46 about this line: $product_info_query = tep_db_query("select p.products_id, pd.products_name................ before this: p.products_price add p.products_retail_price -------------------------------------------------------------------------------------------------- put this line: <?php echo $product_info['products_retail_price']; ?> in anywhere you want in product_info.php Don't forget adding the Dollars Sign $ and retail price text in front this line <?php echo $product_info['products_retail_price']; ?> in product_info.php, if you want. ------------------------------------------------------------------------------------------- NOTES: these change works with version: product_info.php,v 1.92 2003/02/14 product_info.php,v 1.86 2002/08/02 categories.php,v 1.133 2002/06/09 i think these work with all versions. you can following this rules and add new fields like: retail price: 89.99 our price: 45.00 you save: 44.99 or 50% ----------------------------------------------------------------------------- Currently working on: EZ new fileds v1.5 Automatically caculate the save field ( you save: 44.99 or 50% ), so you don't have to do it by youself. ----------------------------------------------------------------------------- sean wang 6.21.2003 =============================================== Hope that helps. Steve

Hi All, In response to my previous post, I have figured out the correct statement. (Smash,Smash) Therefore I will share with the rest of the class... :arrow: Should read---> ALTER TABLE `products` ADD `products_retail_price` decimal(10,2) default NULL AFTER `products_price`; Hope that it helps someone else :!: Steve

Hi All :D , I also agree that this a great mod, but being a "newbe", what is the correct SQL statement I need to add it to my database? Here is what is listed in the mod... 1. add a table in product( database ) products_retail_price decimal(10,2) Null No Thanks in advance everyone :!: Steve

Hello All, First of all BIG THANKS TO wasson65 and Dynamok for comming up with these mods and really making it easy for those of us who have 1000's of items :!: :!: :!: Tim --- 2 Questions First - Is there a way to add the basic tax class to excel so that it can be imported as well? Other wise it has to be done manually for each product. How can we do this? Second - Is there a way not to use the sub-catagory entry. I now leave mine blank, and only use the first one. After upload, it shows a sub-catagory within the main catagory. And I get this in the catagories box... Test--->(11), (11) Thanks Again Tim, Steve

Has anyone looked at Yahoo Auctions? Or we in the same boat as ebay? Just wondering. :?: Steve