News:

Looking for documentation? Take a look on our wiki

Main Menu

How to backtrack related products assignment

Started by brsi, September 13, 2013, 16:12:23 PM

Previous topic - Next topic

brsi

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

jenkinhill

I think that can be done only manually in the database with phpMyAdmin
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Maxim Pishnyak

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?
You can support Community by voting for Project on the JED
https://extensions.joomla.org/extension/virtuemart/#reviews
Join us at
https://twitter.com/virtuemart

brsi

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.

Maxim Pishnyak

CSVI Improved and some pure CSV techniques (OpenOffice) is the answer for you.
You can support Community by voting for Project on the JED
https://extensions.joomla.org/extension/virtuemart/#reviews
Join us at
https://twitter.com/virtuemart