king_of_comedy Posted August 14, 2009 Share Posted August 14, 2009 This is the support thread for Different Supplier prices for each Product http://addons.oscommerce.com/info/2801 About this Contrib: I was looking for a contrib to enter multiple vendors and their Informations for each Product. All other contribs didn´t fit my needs an so i tried to bild this one. For every of your Vendor / Supplier you can add Informations like: - Price - Model No. - Minimum order Qty - Qty Blocks - direct URL for the Product at your vendors Homepage - Comment for each Product seperatly. This contrib is based on SPPC and New Improved OrderList. Both can still be used beside this contrib. CHANGELOG V2.2a Fixed some bugs (categories & language files) V2.2 Updated suppliers.php to enter more Informations from your Vendor (Adress, Tel, Fax, mail, etc) V 2.1 Changed New Improved OrderList to build a Report like Supplier / Vendor Orderlist. English language added. Screenshot included. To Do - Feature to add checkboxes and Qty Input fields to the orderlist to select the vender you will order The Products from. - At the end it should generate for each Vendor a Orderlist (txt or PDF). - For Products without a supplier there should be a vendor selection dropdown with qty input to order them manualy. Quote Link to comment Share on other sites More sharing options...
Schorre Posted August 19, 2009 Share Posted August 19, 2009 Hi Chris, I tried to implement your latest contribution, but trying to update the "suppliers_products_groups" by the adminatration panel, it seems to delete the appropiate line instead of updating or adding one. Any idea what might be the reason? Thx, Schorre Quote Link to comment Share on other sites More sharing options...
bhbilbao Posted December 27, 2009 Share Posted December 27, 2009 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. Quote Link to comment Share on other sites More sharing options...
bhbilbao Posted December 27, 2009 Share Posted December 27, 2009 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; Quote Link to comment Share on other sites More sharing options...
bhbilbao Posted December 28, 2009 Share Posted December 28, 2009 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 Quote Link to comment Share on other sites More sharing options...
bhbilbao Posted December 28, 2009 Share Posted December 28, 2009 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. Quote Link to comment Share on other sites More sharing options...
bhbilbao Posted January 24, 2010 Share Posted January 24, 2010 Other problem with this contrib: Supplier Admin Area Contribution They share the same database names. i dont know what to do. Quote Link to comment Share on other sites More sharing options...
bhbilbao Posted January 30, 2010 Share Posted January 30, 2010 Finally moded to work with MVS. I upload soon. One question. Is ther any form to add a table with all prices when editing a product in categories.php???? The TABS system is right but I loose time changing betwen the tabs looking for the best price. Thanks. Quote Link to comment Share on other sites More sharing options...
nikosgreece Posted September 12, 2010 Share Posted September 12, 2010 Hi after install this contribution i have a problem. The suppliers page works. The supplier product list works. But the supplier orderlist is not working.The page open but when i give data to search the orders etc it sent me to the loggin page. After logging again ,it returns to the orderlist page but the data is again at the default settings,so when i give data again, the problem happens again and again and it not works.. Anyone has any idea what i can do for this? Thank you very much in advance Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.