Hi David,
Is there a mod available to loop through product names the product table, and then loop through the alternatives in productsmap, and produce a list of products without alternatives?
Thanks,
Matt
Yes, that's it.
A list of products in the products table, which do not appear in the 'productsmap' table.
Hi Matthew,
Can you give me some idea of approximately how many products are in your products table, and how many entries you have in product mapping?
That will influence the style of SQL and code required to do this...
Cheers,
David.
Thanks Matt - i'm wondering if i've not understood the requirement properly; as with that many products Vs only 200 in product mapping; you're looking a list of the overwhelming majority of your database (88,800 or so products)... is that what you're after?
Cheers,
David.
Ah, yes, I see what you mean...
It's a mobile comparison site, with approx. 200 models [but multiple offers from vendors].
Each time there is a an update with a new model, it would be helpful to know that there's a new model with no alternatives.
I hope that helps?!
MAtt
Hi Matt,
Just to clarify, do you mean a list of products for which there is no Product Mapping set-up? Values in the alternatives list will not be in the products table as they will have been imported with the mapped name...
Cheers,
David.