Jump to content

bhbilbao

Members
  • Content count

    308
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by bhbilbao

  1. bhbilbao

    Coupons by Ingo

    stupid thing. fixed. the language file has code. Replaced and working ref: define('MODULE_ORDER_TOTAL_COUPON_TITLE', 'Coupon'); define('MODULE_ORDER_TOTAL_COUPON_DESCRIPTION', 'Coupon'); define('MODULE_ORDER_TOTAL_COUPON_ERROR_MIN_ORDER', 'Mindestauftrag den aktiven Coupon einzulösen');
  2. bhbilbao

    Coupons by Ingo

    In admin>modules>totalization Fatal error: Cannot redeclare class ot_coupon in */includes/modules/order_total/ot_coupon.php on line 13 I edited ot_coupon.php to this: tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Reihenfolge', 'MODULE_ORDER_TOTAL_COUPON_SORT_ORDER', '2', 'Reihenfolge der Anzeige<br><br><center><span style=\"border:1px solid #000;\"> © <a href=\"http://forums.oscommerce.de/index.php?showuser=36\" target=\"_blank\"><b>Ingo</b></a> </span></center>', '6', '0', now())");
  3. bhbilbao

    Bundled Products

    new checkout_confirmation.php changed to: if ($bundle_status['products_bundle'] == "yes") { $bundle_stock_query = tep_db_query("SELECT pb.subproduct_id, p.products_quantity, pd.products_name from " . TABLE_PRODUCTS_BUNDLES . " pb LEFT JOIN products p on p.products_id=pb.subproduct_id LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id=pd.products_id where pb.bundle_id = '" . tep_get_prid($order->products[$i]['id']) . "' and pd.language_id = '" . (int)$languages_id . "'"); while ($bundle_stock = tep_db_fetch_array($bundle_stock_query)) { if ($bundle_stock['products_quantity'] <= 0 && STOCK_ALLOW_CHECKOUT != true) { echo '<br><b><font color="red">' . $bundle_stock['products_name'] . ' is out of stock</font></b>' ; $any_out_of_stock = true; } else if ($bundle_stock['products_quantity'] <= 0 && STOCK_ALLOW_CHECKOUT == true) { echo '<br>' . $bundle_stock['products_name'] . '<br><font color="red">' . TEXT_EXTRA_TIME . '</font>' ; } } In includes/languages/*/checkout_confirmation.php add define('TEXT_EXTRA_TIME', '(Sin stock. 2 dias más para el envio)'); or define('TEXT_EXTRA_TIME', '(No stock. Extra 2 days delivery.)');
  4. bhbilbao

    Bundled Products

    semi-solved: $bundle_stock_query = tep_db_query("SELECT pb.subproduct_id, p.products_quantity, pd.products_name from " . TABLE_PRODUCTS_BUNDLES . " pb LEFT JOIN products p on p.products_id=pb.subproduct_id LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id=pd.products_id where pb.bundle_id = '" . tep_get_prid($order->products[$i]['id']) . "' and pd.language_id = '1'"); pd.language_id = '1' by default it tekas only one language. '<br>Extra 2 days delivery for item ' Should be defined as . TEXT_EXTRA_TIME . on *language/checkout_confirmation.php
  5. bhbilbao

    Bundled Products

    On more thing: in checkout_confirmation.php ref: } else if ($bundle_stock['products_quantity'] <= 0 && STOCK_ALLOW_CHECKOUT == true) { echo '<br>Extra 2 days delivery for item ' . $bundle_stock['products_name']; } What in the meaning of "Extra 2 days delivery for item"????? Also some descriptions are white in the chackout_confirmation.php ref:
  6. bhbilbao

    Bundled Products

    Working! except some bugs ¿? In admin/categories.php There is only 3 lines to add a product. If you click on add a line, it added. Then you save the changes. But when you come again there is only 3 lines. If you added 4, 5 , 6 or more products these dont appear in the lines (but they appear right in catalog). Is there any form to order the product list by name and not by products_id (they appear disordered). ref: echo "\n" . '<option name="' . $products_values['products_id'] . '" value="' . $products_values['products_id'] . '">' . $products_values['products_id'] . ' - - - ' . $products_values['products_name'] . " (" . $products_values['products_model'] . ')</option>';
  7. Working. But how to show flash .swf files.???????????
  8. bhbilbao

    [contribution] Tracking Module

    I have little problems with this contribution. When a customer see his order history: the always says "Whithout Tracking ID" Looking for the database tables the data is right: Looking for the code of account_history_info.php is this: ' <td class="main" align="center" valign="top">' . $tracking->display_tracking_link($statuses['tracking_id'], TRACKING_LINK_LABEL) . '</td>' . "\n" . Why dont appear the tracking ID to the customers comments.??? In admin/orders is right, but the code is different: ' <td class="smallText" align="center">' . $tracking->display_tracking_link($orders_history['tracking_id']) . '</td></tr>' . "\n"; Also, sometimes in admin/orders.php gets this error when updating: Warning: Cannot modify header information - headers already sent by (output started at */htdocs/includes/languages/espanol/tracking_module.php:61) in */htdocs/admin/includes/functions/general.php on line 89
  9. bhbilbao

    RMA Returns error for 2.2 MS2

    need help with account_history_info.php PHP 5.2, 2.2RC2, + MVS This is my code, can anyone modify it or said how to modify.??? <?php } else { ?> <tr> <td class="main" bgcolor="#ace92e" colspan="3"><b><?php echo HEADING_PRODUCTS; ?></b></td> </tr> <?php } for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { if ($order->products[$i]['model'] == "Custom"){ echo ' <tr>' . "\n" . ' <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . 'x</td>' . "\n" . ' <td class="main" valign="top">' . $order->products[$i]['name'] . '<small><i>' . $order->products[$i]['description'] . '</small></i>'; }else{ echo ' <tr>' . ' <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . 'x</td>' . "\n" . ' <td class="main" valign="top">' . $order->products[$i]['name']; } if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) { for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i></small></nobr>'; } } echo '</td>' . "\n"; if (sizeof($order->info['tax_groups']) > 1) { echo ' <td class="main" valign="top" align="right">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n"; } echo ' <td class="price" align="right" valign="top">' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "\n" . ' </tr>' . "\n"; } //MVS } ?> </table></td> </tr> </table></td> </tr> <tr> <td> <table border="1" width="100%" cellspacing="1" cellpadding="2"> <tr> <td width="70%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php for ($i=0, $n=sizeof($order->totals); $i<$n; $i++) { echo ' <tr>' . "\n" . ' <td class="main" align="right" width="100%">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td class="price" align="right">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </tr> </table> </td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo HEADING_ORDER_HISTORY; ?></b></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' and os.public_flag = '1' order by osh.date_added"); while ($statuses = tep_db_fetch_array($statuses_query)) { echo ' <tr>' . "\n" . ' <td class="main" valign="top" width="70">' . tep_date_short($statuses['date_added']) . '</td>' . "\n" . ' <td class="main" valign="top" width="70">' . $statuses['orders_status_name'] . '</td>' . "\n" . ' <td class="main" valign="top">' . (empty($statuses['comments']) ? ' ' : nl2br(tep_output_string_protected($statuses['comments']))) . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table></td> </tr> I donr understand the instructions: ref:
  10. bhbilbao

    Simply Hide Products (SHP)

    In my categories table: categories_id categories_image parent_id sort_order date_added last_modified 920 null 0 20 08/12/2009 0:43 08/12/2009 0:50 240 null 924 240 08/12/2009 0:43 08/12/2009 0:50 ....etc In my categories_description table: categories_id language_id categories_name 920 2 PDA 920 3 PDA 920 1 PDA 240 2 CD/DVD 240 3 CD/DVD 240 1 CD/DVD ....etc All cetegories are right.
  11. bhbilbao

    Simply Hide Products (SHP)

    in catalog/includes/column_left.php ref: if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_categories_box(); } else { include(DIR_WS_BOXES . 'categories.php'); // include(DIR_WS_BOXES . 'ul_categories.php'); } if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_manufacturers_box(); } else { include(DIR_WS_BOXES . 'manufacturers.php'); } Should be categories.php. I tried diferent fixes to fix the error. Disablig other contrib RESTRICTED CATEGORIES from application_top.php ref: /* START restricted category */ $restricted_category = 925; # Change number to your restricted category - look at the bottom of your browser for ...?cPath="number" if ($cPath_array[0] == $restricted_category) { if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); # redirect to login } } /* END restricted category */ For error 1064 these ones from other posts: See if using the older query line works in your case. You should have in your advanced_search_result.php this code: $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id"; $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; You need to change $this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page; to $this->sql_query .= " limit " . max($offset,0) . ", " . $this->number_of_rows_per_page; so ... just download the first release of Total B2B and upload the sql file of this package The fact is that the new package is for Mysql5.xxx++++ fuck 1and1 ... Para mi la solucion a ese error fue editar la base de datos en mysql. 1. Entre a "mysql" mediante "phpadmin" 2. Click en "manufacturers" 3. Click en el tab que dise "insert" 4. En "manufacturers_id" puse (1) y en "manufacturers_name" puse una letra (a) 5. y eso fue todo... luego fui al panel de administracion de oscommerce y edite la informacion del manufacturero. Esto tambien funciona si usted borro todas las categorias en el panel de administracion de oscommerce y le sale este error. (1064 - You have an error in your SQL syntax). Añadir valor en la base de datos produce que oscommerce pueda leer de la base de datos y no produsca un error. In admin/includes/classes find split_page_results.php and - BACK IT UP then find the lines $offset = ($max_rows_per_page * ($current_page_number - 1)); $sql_query .= " limit " . $offset . ", " . $max_rows_per_page; change to $offset = ($max_rows_per_page * ($current_page_number - 1)); if ($offset < 0) { $offset = 0 ; } $sql_query .= " limit " . $offset . ", " . $max_rows_per_page; See, My link No one of the above solutions worked for me. The contrib is now installed but if I restrict only one product or category it gets the 1064 error on the main page.
  12. bhbilbao

    Simply Hide Products (SHP)

    The contrib seems to work fine except for two errors. The product edit page (categories.php) takes long to load if you have more than 1000 customers. After good instalation in the catalog index frontpage gives an error. The message log is in the categories box on the column_left. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where categories_id not in(924, 240, 241, 242, 243, 244, 245, 249, 248, 246)' at line 1 describe categories status where categories_id not in(924, 240, 241, 242, 243, 244, 245, 249, 248, 246) [TEP STOP]
  13. bhbilbao

    [contribution] Send_order_html_email

    Now all works fine except the emails that receives my customers. The billing address is empty , without data. Ref: $html_email_order .= " <td width=\"300\" class=\"boxmail\">[b]$VarAddressbill[/b]</td>";
  14. bhbilbao

    Multi_Vendor_Shipping new thread

    SHIP_ESTIMATOR_BUTTON_PRODUCTS_INFO', 'false', 'Show the Shipping Estimator button on the Products Info page', 'SHIP_ESTIMATOR_BUTTON_SHOPPING_CART', 'false', 'Show the Shipping Estimator button on the Shopping Cart page', 'SHIP_ESTIMATOR_BUTTON_CART_BOX', 'false', 'Show the Shipping Estimator button in the Shopping Cart box', I have those options to false, because clicking the buttons gets the normal shipings. I only have a button on shopping_cart.php with this: <td align="right" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING2, '', 'SSL') . '">' . tep_image_button('button_checkout2.gif', IMAGE_BUTTON_CHECKOUT2) . '</a>'; ?></td> With the MVS- 12h-24H to arrive to my customer, but more money sure. With the Normal Ship - 2-3days to arrive, less money. For only one item, for example a 50" LCD Screen of 900€, to my customer will be interesting to select the MVS option. But if select a blank dvds(12€) for one vendor, the dvd-writer(29€) from other vendor, and for example a 160GB hard disk(36€) from the third one, probably will be the ruin for him. He should pay 3 x shippings methods and of courde he never buy.
  15. bhbilbao

    Multi_Vendor_Shipping new thread

    Now is working. I have two buttons on shopping_cart.php. At Bottom of shopping_cart page is the shiping_estimator contrib(for the standard shipping) A customer can click the MVS button and look forward for the prices (checkout_shiping2.php) and then come back to the shopping_cart page and select the normal method (checkout_shiping.php), or delete products of some vendors to reduce the total shippings. I dont know if using this mod could be dangerous to the security. The code of all files is the same , except in some cases changing some words , for example -tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL')); - for -tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT2, '', 'SSL')); The objetive is to finish right the order without errors. I have on application_top this set: // set the level of error reporting // error_reporting(E_ALL & ~E_NOTICE); Yes, that works fine and for that this contrib is incredible for me. A 10/10 for you kymation. :thumbsup: For the moment is no problem . Im triyng with other contrib. Order_manufacturer_pdf by Audioshop. the problem this is send all items in pdf to only one vendor. For the standard shipping im using Jim´s contrib Suppliers v22 I have this on my admin/catalog/edit product. On top Manufacturers and product name then Jim Suppliers V2 then MVS Select Box finally the rest. First I look for the cheapest price in the Suppliers Vendors Tab and then change the Vendor in the MVS Box. All is working well except as I said before, the options of the product orders_products_attributes dont appear on the email taht receive my customer. Also in admin/orders are blank. This only ocurred with MVS. Using the standard shipping there is no problem.
  16. bhbilbao

    Multi_Vendor_Shipping new thread

    Thanks for the replay Kymation. You can only have one checkout_shipping.php No, im working with two checkout_shipings and working. shopping_cart.php---> [bUTTOM NORMAL SHIPPING-STANDARD]----> checkout_shiping.php ---> checkout_payment.php ---> checkout_confirmation.php --->*checkout_process.php ----> checkout_success.php [bUTTOM URGENT SHIPPING-MVS]---------> checkout_shiping2.php ---> checkout_payment2.php ---> checkout_confirmation2.php --->*checkout_process2.php ----> checkout_success.php Modified same files and renamed to *2.php and then in includes/filenames.php // BOF Normal Ship + CCC + Html EmailV2 define('FILENAME_CHECKOUT_SHIPPING', 'checkout_shipping.php'); define('FILENAME_CHECKOUT_PAYMENT', 'checkout_payment.php'); define('FILENAME_CHECKOUT_CONFIRMATION', 'checkout_confirmation.php'); define('FILENAME_CHECKOUT_PROCESS', 'checkout_process.php'); define('FILENAME_CHECKOUT_SUCCESS', 'checkout_success.php'); // EOF Normal Ship + CCC + Html EmailV2 // BOF MVS Ship + CCC + Html EmailV2 define('FILENAME_CHECKOUT_SHIPPING2', 'checkout_shipping2.php'); define('FILENAME_CHECKOUT_PAYMENT2', 'checkout_payment2.php'); define('FILENAME_CHECKOUT_CONFIRMATION2', 'checkout_confirmation2.php'); define('FILENAME_CHECKOUT_PROCESS2', 'checkout_process2.php'); define('FILENAME_CHECKOUT_SUCCESS2', 'checkout_success2.php'); // EOF MVS Ship + CCC + Html EmailV2 In configuration: Shiping/packaging> Enable Multi-Vendor shipping-(true/false) = FALSE Finally in checkout_shipping2.php change the conditions to: if (SELECT_VENDOR_SHIPPING == 'false') { ref: There is an HTML vendor email option available for MVS... The orders customers made arrives right to my vendors, and the order confirmation to my customers. If you are referring to admin/vendor_email_send.php?&vID=6&oID=179&vOS=no that doesnt work for me. I fill the textarea but when clincking on "SEND" gets an error that says Contact on red on the top. This will confuse and irritate your customers. Is that your goal? Yeah, Im was thinking on create or modify a shipping module to all the vendors. "Wait to send all items from the Central Store", except for my fisical shop and add an option to this "Send all items from this Store" (by default the contribution identifies your shop as other vendor .... INSERT INTO `vendors` VALUES (1, 'Store Owner', 'My Store', ....) How are you going to ship all items in one package when they are coming from different locations? My idea is to have 2 shippings methods. Using MSV is very fast, and if a customer makes an order at night my vendor have the order at first time afternoon. When i arrive at work i have the order half-made. Here is a problem, that using diferent shipping methods the final price is higher to my customers and they fly away to other shops on the net. For that, I suggest to maintain the clasical shipping method as an alternative, when customers select this the vendors send the products to my shop(not to the customers) and then i send all the products to my customers in only one shipping. Also some vendors dont ships to final customers, they only work with distributors. Do you understand what im trying?
  17. bhbilbao

    Multi_Vendor_Shipping new thread

    // MVS Start if (SELECT_VENDOR_SHIPPING == 'true') { ?> function selectRowEffect(object, buttonSelect, vendor) { var test='defaultSelected_' + vendor;//set aside defaultSelected_' . $vendor_id . ' var el=document.getElementsByTagName('tr');//all the tr elements for(var i=0;i<el.length;i++){ var p=el[i].id.replace(test,'').replace(/\d/g,'');//strip the $radio_buttons value if(p=='_'){//the only thing left is an underscore el[i].className = "moduleRow";//make the matching elements normal } } object.className = "moduleRowSelected";//override el[i].className and highlight the clicked row var field = document.getElementById('shipping_radio_' + buttonSelect + '_' + vendor); if (document.getElementById) { var field = document.getElementById('shipping_radio_' + buttonSelect + '_' + vendor); } else { var field = document.all['shipping_radio_' + buttonSelect + '_' + vendor]; } } <?php } else { // MVS End ?> One more thing, when a customer arrives to checkout_shipping.php , it displays default shipping options. I want NOTHING SELECTED on the forms. Do anyone kwows how to modify the above code?? and add some type of button "All items in only one shipping"???
  18. bhbilbao

    Multi_Vendor_Shipping new thread

    Im trying to integrate it with other contributions Suppliers V2 and HTLM emailV2. Im using 2 types of checkout proceses. One (checkout_shipping.php) with the MVS contribution to process "urgent ships" from the vendor to the customer. And a second (checkout_shipping2.php) to process the "clasic metod" for orders sent from my fisical shop. But I have issues that i cant resolve. Using the checkout_shiping2.php "clasical" the email arrives to my customer white (without products), the total and delivered adreses are OK. Using "MVS" checckout_process.php all works fine. The email arrives to may vendor right. Except for my customer , all right except the product option atributes. There are not optiones, al blank. ¿? Im was changing ode on the checkout_process.php but i dont know were is the problem. Im thinking on remove the HTML emailV2 contrib. Other problem is with the Send "HTML email to the vendor" page. When click to send , nothing happens and error line on top with "Contact" word appears on top. ¿can anyone help me?
  19. Tne contribution works fine 100%. Except with application_top.php I have an extrange issue on line 70. // Set the level of error reporting error_reporting(E_ALL & ~E_NOTICE); If I change that to: // Set the level of error reporting // error_reporting(E_ALL & ~E_NOTICE); The contribution gives extrange errors (..also defined, etc) when clicking on change password box. I dont know why disabling the reporting gives error reportings, and enabling it dont give errors. ¿?
  20. One more thing, in table suppliers_products_groups it would be interesting to add one more field at the end: products_model I use third party software to update fields an with keys product_id and suppliers_group_id is more difficult. Thanks.
  21. How to change the default >Select Status< for Pending by default in suppliers_orderlist.php??? ref: <?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_SELECT_STATUS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?> <?php What is the utility of the products categories.php checkbox??? (On default all suppliers are checked with or without data on it ¿?) Ref: echo tep_draw_checkbox_field('spoption[' . $SupGroupID . ']', 'spoption[' . $SupGroupID . ']', (isset($pInfo->spoption[$SupGroupID])) ? 1: 0); } else { echo tep_draw_checkbox_field('spoption[' . $SupGroupID . ']', 'spoption[' . $SupGroupID . ']', true); More, suppliers_productlist.php takes too long to load all data. It would be more interesting to makes some filterlist boxes by categories. P.d: could you please recode this contribution changing table suppliers for vendors, and suppliers_info for vendor_info but maintaining the table suppliers_products_groups
  22. Same bug that the other one. Adding suppliers dont show they data. For other side: Tables from Suppilers contrib (suppliers): suppliers_group_id suppliers_group_name suppliers_image suppliers_contact1 suppliers_contact2 suppliers_contact3 suppliers_contact4 suppliers_contact5 suppliers_contact6 suppliers_own_customer_number suppliers_contact_tel suppliers_contact_fax suppliers_contact_mail date_added last_modified Tables from MSV (vendors): vendors_id vendors_contact vendors_name vendors_phone1 vendors_phone2 vendors_fax vendors_email vendors_url vendors_comments date_added last_modified vendors_image vendors_send_email vendors_status_send vendors_zipcode vendor_street vendor_add2 vendor_city vendor_state vendor_country vendor_add_info account_number handling_charge handling_per_box tare_weight max_box_weight percent_tare_weight zones My idea is to modify the contrib to take the data from the vendors table, not the suppliers table. Some like this: CREATE TABLE IF NOT EXISTS `vendors` ( `vendors_id` smallint(5) unsigned NOT NULL auto_increment, `suppliers_group_name??????` varchar(64) default NULL, `vendors_image` varchar(64) default NULL, `vendors_name` varchar(64) default NULL, `vendor_street` varchar(64) default NULL, `vendors_zipcode` varchar(64) default NULL, `vendor_city` varchar(64) default NULL, `vendor_state` varchar(64) default NULL, `vendor_country` varchar(64) default NULL, `suppliers_own_customer_number????` varchar(64) default NULL, `vendors_phone1` varchar(64) default NULL, `vendors_fax` varchar(64) default NULL, `vendors_email` varchar(64) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, PRIMARY KEY (`suppliers_group_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `suppliers_info` ( `suppliers_group_id?????????` int(11) NOT NULL default '0', `languages_id??????` int(11) NOT NULL default '0', `vendors_url` varchar(255) NOT NULL default '', `url_clicked??????` int(5) NOT NULL default '0', `date_last_click?????????` datetime default NULL, PRIMARY KEY (`suppliers_group_id`,`languages_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ..next table corresponding to vendors_id in the products table: CREATE TABLE IF NOT EXISTS `suppliers_products_groups` ( `suppliers_group_id` smallint(5) unsigned NOT NULL default '0', `vendors_price` decimal(15,4) NOT NULL default '0.0000', `suppliers_ve????????` varchar(32) NOT NULL default '', `suppliers_min_order????????` varchar(32) default NULL, `vendors_model` varchar(32) default NULL, `suppliers_url??????` varchar(255) default NULL, `vendor_prod_comments` text, `products_id` int(11) NOT NULL default '0', `products_price` decimal(15,4) NOT NULL default '0.0000', PRIMARY KEY (`suppliers_group_id`,`products_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  23. Good contrib King! Im tring to integrate it with MVS. I have added it in the same box. There are problems with products customers bought with the MVS contribution. All appears empty in suppliers_orderlist.php page without qty/description with the tag -NO STOCK-. It would be interesting to take the queries of datababse from the MVS contribution, and take both integrated. (for example vendors_id, vendors_prod_id, vendors_prod_price, vendors_prod_comments, etc) Also, i don´t know the utility of the checkbox before the product. [ ]. What is the use of this checkbox??? (Print the page and mark after??) Im looking for search the low price of them, mark it and then autoemail to all vendors with the orders. I dont know if you can understand me.
  24. bhbilbao

    Newsletter products, HTML email

    All working! Except that there is no images at all. I tried modifing configure.php with diferent solutions of this thread: define('DIR_WS_CATALOG_IMAGES_O', DIR_WS_CATALOG .'images/'); define('HTTP_CATALOG_SERVER_EMAIL', 'http://www.myweb.com/'); define('DIR_WS_CATALOG_IMAGES_EMAIL', 'images/'); $html_content .= '</tr><tr><td align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $this->productsInfo[$i]['products_id']) . '" style="' . $cssLink . '">' . tep_image_newsletter(HTTP_CATALOG_SERVER_EMAIL . DIR_WS_CATALOG_IMAGES_EMAIL . $this->productsInfo[$i]['products_image'], $this->productsInfo[$i]['products_name'], 92, 92) . '<br>' . $this->productsInfo[$i]['products_name'] . '</a><br>'; $price = ($this->productsInfo[$i]['specials_price']) ? '<span style="'. $cssMarkdown . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span> <span style="' . $cssSale . '">' . $currencies->display_price($this->productsInfo[$i]['specials_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>' : '<span style="' . $cssPrice . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>'; $html_content .= $price . '</td>'; $col = 0; } else { $html_content .= '<td align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $this->productsInfo[$i]['products_id']) . '" style="' . $cssLink . '">' . tep_image_newsletter(HTTP_CATALOG_SERVER_EMAIL . DIR_WS_CATALOG_IMAGES_EMAIL . $this->productsInfo[$i]['products_image'], $this->productsInfo[$i]['products_name'], 92, 92) . '<br>' . $this->productsInfo[$i]['products_name'] . '</a><br>'; $price = ($this->productsInfo[$i]['specials_price']) ? '<span style="' . $cssMarkdown . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span> <span style="' . $cssSale . '">' . $currencies->display_price($this->productsInfo[$i]['specials_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>' : '<span style="' . $cssPrice . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>'; $html_content .= $price . '</td>'; } also this one. $html_content .= '</tr><tr><td align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $this->productsInfo[$i]['products_id']) . '" style="' . $cssLink . '">' . tep_image_newsletter(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES_O . $this->productsInfo[$i]['products_image'], $this->productsInfo[$i]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br>' . $this->productsInfo[$i]['products_name'] . '</a><br>'; $price = ($this->productsInfo[$i]['specials_price']) ? '<span style="'. $cssMarkdown . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span> <span style="' . $cssSale . '">' . $currencies->display_price($this->productsInfo[$i]['specials_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>' : '<span style="' . $cssPrice . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>'; $html_content .= $price . '</td>'; $col = 0; } else { $html_content .= '<td align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $this->productsInfo[$i]['products_id']) . '" style="' . $cssLink . '">' . tep_image_newsletter(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES_O . $this->productsInfo[$i]['products_image'], $this->productsInfo[$i]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br>' . $this->productsInfo[$i]['products_name'] . '</a><br>'; $price = ($this->productsInfo[$i]['specials_price']) ? '<span style="' . $cssMarkdown . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span> <span style="' . $cssSale . '">' . $currencies->display_price($this->productsInfo[$i]['specials_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>' : '<span style="' . $cssPrice . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>'; $html_content .= $price . '</td>'; I dont know whats going bad. My catalog/images folder is on the roor with CHMOD 755.
  25. bhbilbao

    NEW! Complete Order Editing Tool!

    <td valign="middle" class="dataTableContent"><input type="checkbox" name="shipping_same_as_billing"> <?php echo TEXT_SHIPPING_SAME_AS_BILLING; ?></td> <td colspan="4" valign="middle" class="dataTableContent"><input type="checkbox" name="billing_same_as_customer"> <?php echo TEXT_BILLING_SAME_AS_CUSTOMER; ?></td> anyone?
×