Wordpresswoocommerce jobs

Hi, I need someone to help me with Wordpress Website. I would like to change the footer, similiar to this page: And Add Hot Wellness Element to Category pages:

site a - non wordpress site site b - WordPressWooCommerce site a page 1 set php variable "Category Name' connect to site b mysql wordpress/woocommerce database query all product names, product id in site b woocommerce database php code to bullet list all product names returned in Category Name query link each product name to page 2 and pass url variables page 2 connect to site b mysql wordpress/woocommerce database query site b mysql wordpress/woocommerce database to select product name, image, short description for product name/id passed from link on page 1 php code to display product image,name, short description and link to site b woocommerce product page No page theme required