How can I include vendor information for my products?

[cln]

Is there any contribution that includes vendor information. If I add a vendor table and add a vendor_id to the products table could that mess anything up? I've got a program that updates prices and adds new products but for it to work it needs to know which vendor the product is coming from. Any help would be very much appreciated.

Thanks,

Charity

[HyperJack]

can't you just use manufacturers?

[cln]

I already use my manufacturers. I have several vendors who supply products from the same manufacturer.

[Guest]

Shouldn't mess anything up, but i should first try it on a test DB (on you local pc) and see wath happens.

 

What seems more save to me create a new table called vendors, with for example the fields:

vendors_id

vendors_name.

 

And create another table called product_to_vendors, with for example the fields:

product_to_vendors_id,

product_id,

vendor_id,

vendor_sku_number,

vendor_price.

 

If you can get that to work with your program, and you can write an extension, you can than create a module, wich (if you want that) automaticly gets the vendors_price, puts a certain margin on it, and write's that to products_price.

[cln]

A vendors contribution was posted yesterday which resolves my problem. It can be found at http://www.oscommerce.com/community/contributions,1320

Thanks,

Charity

[osjunkie]

Has anyone modifed contrib 1320 to work with MileStone 2?

I tried installing it, but categories.php is so different it is very hard to see what to replace. vendors.php also has an error calling to some array...

 

I will PayPal the person $10.00CND if they can fix this for MS2.

 

Got vendors coming out of the YingYang, need this working bad. :)

 

Thanks,

 

Brad Thompson

[email protected]