How to load products in OpenCart directly from DB to DB?

Question

MySQL

The database is periodically replenished with goods, where the product is a row in one flat table, 5 columns - name, article, price, category number (coincides with the id of already existing categories in the second database), an array of pictures (a text field where the addresses of the pictures are separated commas). Well, the 6th column - id autoincrement.
What is the best way, with minimal human intervention, to periodically transfer these products to another database - on which Opencart runs? As you know, there the goods are stored in aggregate in more than one table.
OpenCart version - 1.5.5.1.2
This is - https://stackoverflow.com/questions/17122752/how-t... - read while chewing...

Answer 1

Look at the object, at the input of the addProduct($data) method in the ModelCatalogProduct admin model.
You need to bring the data from the first database to this form and simply pass it to this method.