External data import to database

[anv]

I had an old stock system that exports data to DBF files, and an old web store that has the info of the products including extra descriptions and photos in mysql.

 

I want to create an automatic import program. What I need to know is what tables I must write. Where to put the images and where to put the data of each product.

 

Can you please point me which records I must insert in the database for creating a new product?

[tomerg3]

you should look into the PS import feature (or webservices), there are many tables that need to be updated, it's much better to use the built in functions rather than trying to do it manually.