Set up automatic product feed export for advertising platforms

We run an online store, and right now our advertising catalog is updated by hand: someone exports the product list, checks prices and stock, cleans up the file and uploads it whenever the assortment changes. It takes hours every week, and mistakes still slip through — items go live with an old price, or stay in ads after they are already sold out.

The task is to build a feed generator that reads product data from our store — names, descriptions, categories, prices, stock status, images and identifiers — and formats it according to the requirements of an advertising catalog: correct field names, proper encoding, all required attributes filled in, no duplicate or broken entries. The feed needs to refresh on a schedule so that a price change or a sold-out item is reflected in ads within a reasonable time, without anyone touching a file manually.

We would like the export to run unattended, keep a simple log of each run so we can confirm it finished correctly, and handle messy cases — a missing image, a strange character in a title, a product with no price — without failing the whole feed.

What matters most:
— correct field mapping and formatting for the destination catalog
— automatic regeneration on a schedule, not a manual export button
— a log we can check after each run
— graceful handling of incomplete or invalid product records