Transferring data to WP Database

I’m currently moving a client over to WordPress, using blog posts as various different CMS-type of things. Essentially, one of those things are products (not for sale, no ecommerce).

Their current database has the following tables Category, Product, related product, etc etc.

I am trying to write a script that will take the .sql exported file of this database and place the data in a wordpress database, where I would like it (ie, a Product is a Blog Post and its tag is its manufacture). Is this something simple, ans if so, could you provide and example I could build off of?

Thanks so much!