XML feed for Google Merchant Center

It is necessary to create an XML feed for Google Merchant Center.

 The XML feed must be constantly available at a URL.

The feed should be updated once a day. Products that have been added to the site must be automatically added to the feed, and products removed from the site must update their status to out of stock.

To do this, it is necessary to set up its daily generation from the site's database into a file.

Fields that must be in the file:

• id (identifier) – a unique product number in the database.
• title (name) – the name of the product. On the site, it is indicated in two languages, in the database each language is in separate fields. It is necessary to combine them into one line with a separator /.
• description (description) – the description of the product. Just like the name, it is indicated in two languages in different fields of the database. It needs to be combined into one line with a separator /.
• link (link) – URL that leads to the product page.
• image_link (image link) – URL of the product image.
• condition (condition) – the condition of the product, possible value: used (static value).
• availability (availability) – the availability of the product in the store, possible values: in stock, out of stock.
• price (price) – the price of the product.
• google product category (Google product category) – the product category according to Google's classification (static value).
• product_type (Product type) – the type of product.
• identifier exists – (static value).

The site operates on a modified WordPress CMS for its own needs. There are currently about 100 products on the site, but more are planned to be added.

If possible, please indicate the cost of work per hour. A more detailed technical specification and a link to the site will be provided after agreeing on cooperation.