VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: brsi on September 13, 2013, 16:12:23 PM

Title: How to backtrack related products assignment
Post by: brsi on September 13, 2013, 16:12:23 PM
Hi, as I am using the related product feature extensively, I'd like to be able to trace back all products that use a particular product in their related product field (If I make myself clear).
This for instance would enable to check whether unpublished products have been specified in the related product field.
Thanks.
VM 2.0.22c/ J2.5.14
Title: Re: How to backtrack related products assignment
Post by: jenkinhill on September 13, 2013, 16:43:21 PM
I think that can be done only manually in the database with phpMyAdmin
Title: Re: How to backtrack related products assignment
Post by: Maxim Pishnyak on September 13, 2013, 20:00:27 PM
Quote from: brsi on September 13, 2013, 16:12:23 PM
Hi, as I am using the related product feature extensively, I'd like to be able to trace back all products that use a particular product in their related product field (If I make myself clear).
This for instance would enable to check whether unpublished products have been specified in the related product field.
Thanks.
VM 2.0.22c/ J2.5.14
What is your final goal?
Title: Re: How to backtrack related products assignment
Post by: brsi on September 14, 2013, 11:34:08 AM
Quote from: Maxim Pishnyak on September 13, 2013, 20:00:27 PM
Quote from: brsi on September 13, 2013, 16:12:23 PM
Hi, as I am using the related product feature extensively, I'd like to be able to trace back all products that use a particular product in their related product field (If I make myself clear).
This for instance would enable to check whether unpublished products have been specified in the related product field.
Thanks.
VM 2.0.22c/ J2.5.14
What is your final goal?
Well, there are different uses to such a feature, f.i.:
- have stats on which products are most used as related items
- verify whether related products are still available (especially for unique references)
- check whether related products are published or not
- and so on...
Thanks.
Title: Re: How to backtrack related products assignment
Post by: Maxim Pishnyak on September 15, 2013, 20:01:39 PM
CSVI Improved and some pure CSV techniques (OpenOffice) is the answer for you.