Hi Dear Provider,
I'm really interested on this project. My understanding is that you need a list of your affiliates to be derived by your product list.
My team and myself we are doing often such operational tasks and this enters right in our core business. We are very detail oriented and strive for perfection.
As action plan I need to see a sample of the product list and check what could be automated. If not available my assumptions are that you will provide the raw file, after that we will need to formalize, normalize and to derive the affiliates. I suspect that there could be hidden some web scrapping to fill some blanks... I think that it would be best if we clarify better this grey zone, I'm not restricted on communication only via freelancer. If need please send me a pm to find other options for communication.
I would like to read you soon, please do not hesitate to contact me!
Regards,
Viktor Batalski.