superstyling

Any ideas how to add products, specials, etc with images and buy now buttons to the phplist newsletter by retrieving them from the DB (such as newsletter products contrib. http://www.oscommerce.com/community/contributions,3398 ). This would make creating newsletters far easier than cutting and pasting.

mmm. this is where I got to yesterday with the error: Fatal error: Call to a member function on a non-object in catalog/admin/includes/modules/newsletters/newsletter_products.php on line 122 after adding require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); to the top of newsletters.php and $html_content .= '<td class="content" align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $images['products_id']) . '" class="content">' . tep_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES . $images['products_image'], $images['products_name'], LARGE_IMAGE_WIDTH, LARGE_IMAGE_HEIGHT) . '<br>' . $images['products_name'] . '</a></td> <td valign="top"><font size="3" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>' . $images['products_name'] . '</b></font><br><font size="3" color="#663366" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">' . $images['products_intro'] . '</font><br><font size="2" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">' . $images['products_description'] . $currencies->display_price($images['products_price'], $images['products_tax']) . '<font></td>'; to newsletter_products.php can you confirm this is what you mean? thanks.

Mark - I have the same issue. The only way I got to 2 decimal places was by aletering the database: ALTER TABLE `products` CHANGE `products_price` `products_price` DECIMAL( 15, 2 ) DEFAULT '0.00' NOT NULL but this does not help when adding tax (say 17.5%) an alternate way to the currencies class: . $images['products_price']*1.175 . and anyway, it may have an unwanted effect on other parts of OSC. scottb mentioned using something like $currencies->display_price($price_value, $tax_value, $quantity); to get the price w/tax and that all of those variables are something that should happen from within the newsletters.php file. If we can get this to work, you will have 2 decimal places -- need some help though.

Thanks for you reply scottyb - I was trying to use $currencies->display_price($price_value, $tax_value, $quantity); in the module. You say these variables should happen from within the newsletter.php file, and I am unsure how/where to go. I have not edited the newsletter.php file. What I have done to the $images_query in the newsletter_products.php file is simple as below: function html_content() { //create HTML string containing links & pics define('COLS', 1); $width = intval(25/COLS); $html_content = '<table border="0" width="100%" height="100%" cellpadding="2" cellspacing="3"><tr><td colspan="2" align="left" class="content">' . $this->content . '</td></tr><tr><td colspan="2">' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td></tr><tr>'; $col = 0; if ($this->products != ''){ $images_query = tep_db_query("select p.products_id, pd.products_name, pd.products_intro, pd.products_description, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and p.products_id in(" . $this->products . ")"); } while($images = tep_db_fetch_array($images_query)){ if($col > COLS-1){ $html_content .= '</tr><tr><td class="content" align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $images['products_id']) . '" class="content">' . tep_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES . $images['products_image'], $images['products_name'], LARGE_IMAGE_WIDTH, LARGE_IMAGE_HEIGHT) . '<br>' . $images['products_name'] . '</a></td> <td valign="top"><font size="3" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>' . $images['products_name'] . '</b></font><br><font size="3" color="#663366" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">' . $images['products_intro'] . '</font><br><font size="2" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">' . $images['products_description'] . $images['products_price'] . '<font></td>'; $col = 0; }else{ $html_content .= '<td class="content" align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $images['products_id']) . '" class="content">' . tep_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES . $images['products_image'], $images['products_name'], LARGE_IMAGE_WIDTH, LARGE_IMAGE_HEIGHT) . '<br>' . $images['products_name'] . '</a></td> <td valign="top"><font size="3" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>' . $images['products_name'] . '</b></font><br><font size="3" color="#663366" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">' . $images['products_intro'] . '</font><br><font size="2" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">' . $images['products_description'] . $images['products_price'] . '<font></td>'; } $col++; } $html_content .= '</tr></table>'; Mark, you mentioned adding specials price - if you have this sorted, perhaps you can help out with that?

scottyb - I think this is a fantastic contribution that seems to get less attention that it deserves. This module makes it easy for a shop to send newsletters to their customer base without the need for a graphic/web designer which is great. To add extra value to the recipient I have added the product name, short product info, and (net) price to the message, however attempting to add tax and currency has been fruitless so far with this error: Fatal error: Call to a member function on a non-object in ../admin/includes/modules/newsletters/newsletter_products.php Any ideas?

Hey defender39 What you've done looks good. Where can I find phpesp?

The manufacturer (x) of some cosmetic products I wish to sell on-line require that a patient questionnaire or survey is filled out so that potential allergies can be ascertained prior to any of those manufacturerer's products being shipped to a customer. I'm guessing that a solution is that a manufacturer scenario is added to the shopping_cart.php page so that "if manufaturer id=x, redirect to questionaire.php" else procede to checkout or login pages as per normal. If the product maufacturer=x, then, on completion of questionaire.php, I want to receive an email via a regular CGI script and the customer would procede to checkout.php or login.php The database does not need to determine the content of the questionaire as I can handle that manually prior to shipping: I'll match the CGI email to the customer order and if the product suits the customer, I'll ship it and if it does not suit, I'll notify the customer via manual email that they are not eligible. 1) My question is, what code should I insert into shopping_cart.php to achieve the above, and what line should it be placed on? ...and..how do I code the SUBMIT button on the proposed questionaire.php page so that it redirects to the checkout or login page as per normal. 2) Does this sound like an easy fix; or is there a better solution? If there is a PHP guru that knows what I need and can tell me I'm on the right track - thanks in advance - I look forward to some advice

Data from 1 site is populating another. This is the 2nd site on the same server that is getting product data from the first site. It only happens in the CATEGORY BOX. The database's have different usernames and passwords so how did this happen??

Hey Luke What you've done sounds good -- are you able to add price breaks to customer groups with your modification? Cheers, Dean

Separate pricing per customer is a really useful contribution. I've been trying to use it together with price-break...but's it's getting pretty complicated combining multiple pricing for a product as well as for multiple customer groups. Has anyone else tried this out?