Jump to content
Sign in to follow this  
king_of_comedy

[Contribution] Different Supplier / Vendor prices for each Product

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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;

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Other problem with this contrib:

Supplier Admin Area Contribution

 

They share the same database names. i dont know what to do.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×