Import based on MySQL

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 2.5

Hi,

We have a seperate MySQL database with > 1000 products inside. Now, we would like to update/import changes made in this database into our Hikashop installation.

What would be the best way to accomplish this? Is there an example insert query available to properly populate all the right fields at once? How to insert the correct pricing, link to categories (based on e.g. custom field custom_category).

INSERT INTO jos_hikashop_product
(product_code, product_name, product_description,
product_created, product_type, product_published)
SELECT id, naam, omschrijving, UNIX_TIMESTAMP(), 'main', '1'
FROM `artikelenlijst`
ON DUPLICATE KEY UPDATE
product_code = VALUES(product_code),
product_name = VALUES(product_name),
product_description = VALUES(product_description),

Or is there a better approach?