Related products bulk selection?

[Cases By Source]

Now that ive figured out how to use this....
Is it possible to bulk select a group of products instead of having to go one by one selecting each product?
-Paul

[DesignExtend-MSI]

There is an import module available for bulk importing. It will let you import via a flat file that contains the original product code and related product codes.

http://www.designextend.com/page/miva/PROD/relprdim

[Vic - WolfPaw Computers]

Bulk select products to be assigned as related items? Sure, under the edit product screen, click the related items tab. At the bottom change the number from 10 to a larger number and update.

Similar to assigning products to cagetories, you can select multiple items that are to be related to the product you are editing.

[Ashish]

I faced this problem once.. and replied this solution to mailing list.. so i am coping - pasting here.
---------------------------------------------------------

By curiosity i was checking mysql db tables where it stores relation
b/w product and related products .. and i was able to buld upload .csv
file directly to db..

these r steps
1. table name is s01_RelatedProducts
2. it has two cols.. product_id and relprod_id .. both points to
internal product id created by miva whenever u add product. (not Code
which u specify)
3. so first i downloaded a master product file from s01_Products
having product_id, code, name and weight..
4. then using above file, i created new csv file in excel, showing
relations b/w product_ids ..
5. then i uploaded this file and viola.. i was done

some considerations
1. of course u need some skills to use mysql interface.. for me it is
intuitive enough. I know sql.
2. again.. it is product_id not product code
3. u can use diff text file formats.. but making file in excel and
saving as csv was easy process for me.


Yes.. empioriumplus product is very cheap and straightforward. And
it's definitely worth buying it.. if u looking in more simple steps..
I did it DB way.. because i could do it and wanted to do it. I still
recommend buying module.. just 15 bucks..

----------------------------------------------
another email reply
--------------------------------------------
Ashish Jain wrote:
> 1. can u give me sample line(s) how my file will hav to look like?

Example is in the install doc at
http://www.emporiumplus.com/v5/relprdim.htm

ABC123|XYZ123
ABC123|XYZ456
ABC456|CPC123

A variation that is allowed is

ABC123|XYZ123^XYZ456^CPC123

> 2. can i update existing related products.. (how it works.. it
> overwrites or add)?

It just adds to them.

> 3. can i use delimiter like TAB?

| as in example.

[Cases By Source]

Thank you
The upload module it is

Thanks again.