how to configure Products (compatible or replacement products) with same product id

[iamneverlate]

question 1

I am new to OSCOMMERCE and looking to open a e commerce website. Therefore i need several options like multiple product upload, edit, order management i.e export new orders, payment option like googlecheckout.

 

It looks i have to install so many add-on. Can any recommend good add-on.

 

question 2

Further i have a problem with similar or compatible products listing. I have see this on other website but i don't know which add-on or option to use.

 

For example, We have a product that is compatible or replaceable with 200 other products or part numbers.

 

We want to have only one product_id assigned to all these products

 

product 3401

http://www.domain.com/product_info.php/products_id/3401.html

 

and other compatible products have link like

 

* dBATBL50L (http://www.domain.com/product_info.php/products_id/3401/mname/dBATBL50L.html)

* Asire 103 (http://www.domain.com/product_info.php/products_id/3401/mname/Apire%20103.html)

 

Any body help me which module or add-on or option to use it.

 

Regards

Mysha