As you might have seen in the above post I have now got the synch working, using the SQL statement below:
REPLACE INTO rtdtest.products (
ID,
title,
price,
category,
available)
SELECT
product.Product_Code,
product.Product_Description,
product.Price,
product.Category_Name...