Help me to intergrate product database to WordPress

I have solved my problem and want to share it with anyone who has problems like me.

First, you should find out about a few simple SQL commands to make it easier to manipulate the database. I learned them at https://www.w3schools.com/sql/

My idea is that I will export all the data I need into a single .csv file. In order to do this you will need to work right in the SQL Server command line with commands like INNER JOIN, LEFT JOIN … and save all the data you already have on a table and export it to a .csv file only.

After you have created the .csv file with the desired data, you will compare what you need to add to WordPress, in my case, I will create 1 custom taxonomy for Product Type to manage the author. of books. I also use the Advandced Custom Field plugin to create some additional fields needed for my product data.

Finally I use WP All Import plugin of Soflyy to import all my data into Woocommerce.
That’s all I did to switch my database, I know it may be very lengthy and not quick, but I still want to share it to help people.

Thank you for reading my article. 🙂