Problem with multiple MANUFACTURERS!!

[markschaef]

Wo can help? its kinda urgent..

 

contrib link

 

i guess this one doesnt work...

thats because you have to add 2-4 tables for multiple manufacturers on one product.

now, what if there are 10 manufacturers in your list,

but every time you add a product related to 3-4 of them, you have to manuallly

add all off them once again in these new tables.. with all the additional information to this customer

 

AND: i need the product listed to each customer, if searched through customer-filtering,

but i cant add it several times, and add it to each manufacturer manually -> i'd have it too often in the list (as product)

 

isnt't there an easier way?

like ONE table containing the manufacturers, ONE the products and

new: ONE containing manufacturers-product-links!

example below...

 

 

OLD:

CREATE TABLE `manufacturers2` ( 
 `manufacturers2_id` int(11) NOT NULL auto_increment, 
 `manufacturers2_name` varchar(32) NOT NULL default '', 
 `manufacturers2_image` varchar(64) default NULL, 
 `date_added` datetime default NULL, 
 `last_modified` datetime default NULL, 
 PRIMARY KEY  (`manufacturers2_id`), 
 KEY `IDX_MANUFACTURERS2_NAME` (`manufacturers2_name`) 
) TYPE=MyISAM AUTO_INCREMENT=12 ; 


ALTER TABLE `products` ADD `manufacturers2_id` int(11) default NULL

CREATE TABLE `manufacturers2_info` (
 `manufacturers2_id` int(11) NOT NULL default '0',
 `languages_id` int(11) NOT NULL default '0',
 `manufacturers2_url` varchar(255) NOT NULL default '',
 `url_clicked` int(5) NOT NULL default '0',
 `date_last_click` datetime default NULL,
 PRIMARY KEY  (`manufacturers2_id`,`languages_id`)
) TYPE=MyISAM;


NEW:
(NO creating of new manufacturer-tables!!! big problem!!!)

CREATE TABLE `manufacturer_listing` ( 
`manufact_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL default '0',	//referring to the manufacturer
`manufacturers_id` int(11) NOT NULL default '0',	//referring to the manufacturer
......
......
)


LOOKS LIKE THIS:

1	->	12	->	4
2	->	12	->	6
3	->	11	->	5
4	->	12	->	8

MEANS: 3 customers can easily be added to the same product 
without setting them up again as NEW in a 2./3./4.table


ideas to:
[email protected]

thx

[Guest]

I'm sorry could you be more clear?

 

Just add all your MANUFACTURERS in the admin side and select one when you add a product.

[markschaef]

I'm sorry could you be more clear?

 

Just add all your MANUFACTURERS in the admin side and select one when you add a product.

 

I'm sorry, if i didn't make myself clear.

its about adding SEVERAL MANUFACTURERS (2-4) to ONE Product.

 

you can only add ONE at a time.

with the contrib (above) you may add several ones to this product,

at the cost of not beeing able to handle your manufactures anymore...

-> they are spread over tables (manufacturers, manufacturers2, manufacturers3....)

including the infotable (manufacturers_info,manufacturers_info2,manufacturers_info3...)

 

but i need to have only ONE manufacturers table

because they need to be listed only once in the sidebar..

 

and thats the reason i was asking you - how we can chance this

with a new table that manages the linking..

[Guest]

have a look for multi-vendors related contributions. Should be possible to do it.

[markschaef]

have a look for multi-vendors related contributions. Should be possible to do it.

 

hey, i did!!

but theres nothing

 

the other one i linked above, is not the right thing to use..

[Guest]

here is one

http://www.oscommerce.com/community/contributions,1864

[markschaef]

here is one

http://www.oscommerce.com/community/contributions,1864

 

well thx

i didnt try them all out i guess

 

-> manufacturer

-> vendor

-> ...

 

:) isnt always so easy

i hope it works for my version of osCommerce - its from 2003

AND a lot of contribs in it..

[Guest]

well thx

i didnt try them all out i guess

 

-> manufacturer

-> vendor

-> ...

 

:) isnt always so easy

i hope it works for my version of osCommerce - its from 2003

AND a lot of contribs in it..

backup your files and database before using contributions in general.

[markschaef]

backup your files and database before using contributions in general.

 

im not afraid of that as of not having found the right thing :)

well, we will se

i will add it tomorrow

[markschaef]

oh oh oh...

i tried to insert this contrib. and it seems to work for now - in the admin area

(limited to the admin area like it says)

but the thing is, that i really need to have the customer beeing able to SEE all

the manufacturers listed to the product. so we are back at the beginning.

 

the customers have to be able to filter by "manufacturers" and the products

that have several ones should be listed (including the info about ALL the manufacturers linked to that one)

as well as they have to be able to sort by product and the products appear as well

including the same info.

 

so the only table that is useful (and the same way build my initial idea was):

 

DROP TABLE IF EXISTS `products_to_vendors`;

CREATE TABLE IF NOT EXISTS `products_to_vendors` (

`products_id` int(11) NOT NULL default '0',

`vendors_id` int(11) NOT NULL default '0',

`vendors_model` varchar(24) default NULL,

`vendors_name` varchar(32) default NULL,

`vendors_cost` decimal(15,4) NOT NULL default '0.0000',

PRIMARY KEY (`products_id`,`vendors_id`)

) TYPE=MyISAM;

 

it just needs to be fitted in the whole thing.. and i dont know how much needs to be done here.. :(

[hcamelion]

Thats not a problem!!! The mod is not to have multiple manufacturers for one product its to relate additional data to products such as for a music store media type, artist or genre. It's to copy the manufacturers part of oscommerce not modify it. You want to modify it. There is nothing wrong with that mod and the file you added to the contributions page is useless.

 

All you have to do is change the original manufactures drop down on the admin product page to a multi select box. Create a table with product id and manufacturer id. Have the admin product page add every selected product to that table as separate entries with the same appropriate product id that is being edited/created. Then on the front end product display page get every manufacturer from that table with the product id being viewed and print them out. I did something similar for my store but not the same. I do have a function to output a multi select box.