I have about 20 vendor libraries with productID, price, additional fields. I can't combined the document libraries into one because it will get really big (20-30k). All I need is to have productID from all the libraries into a list.
Yes, I know I can create a list and populate it product id from various libraries. But How do I keep this list in sync with libraries.
Any thoughts on this?