How to migrate from a custom database into WordPress

Guide on how to migrate from a custom database design with different tables into WordPress.

Topics covered:
- how to migrate from a custom database and keep the exact same content structure in WordPress
- how to create custom post types, custom fields, post relationships (one-to-many relationships)
- exporting and Importing custom tables Into WordPress
- exporting tables into CSV (comma separated value) files
- importing the data from the CSV files into WordPress
- designing the front-end display for your custom content (WordPress templates)

Text version:

Plugins used:

[panworldmemes]

You have a great voice.. I wish you upload more and more videos on WordPress tutorial

[ESAMALMITHALI]

The is the best explain that i saw about exporting and importing , Thank 🌹

[josephlivengood]

completely lost me at 7:20 because my db has several separate tables that I need to make as one, this is for cars, the other developer for some reason put the car, features, specs, images and history as separate tables. I want to put them all as one but I'm not sure how to do it, with this step, it lost me.

[Jc]

hello, great video!! but i have a question


its the plugin creating new tables on the database when i import the tables or somehow the plugin put all this information on the premade wordpress database?

[gregmeskil]

This plugin and video does everything that i need with the exception of adding a search bar where a user could type in a machine number and it query the dataset and show a result. Do you know if this software has this built in and you just did not cover it?

[erichepperlewp]

7:15 - #SQLJoin machine table with manufacturer table

[jernanemf]

Hi there,
Can I do that with tables are not in the WP but in the same database? Only for consulting

[soumyajitdas]

Hello there I want know the opposite method..! Suppose I have an woocommerce WordPress website how can I migrate all my data to my custom website?

[HaifengZhu-pnuq]

I cannot access Toolset official website when using VPN, I think there is something wrong with the setting of your website, restricted people to access your website

[caseykittel]

Hi! does this plugin allow the site user to sort columns? for example: if a user clicks on the top of a column of names will it sort in alphabetical order or reverse alphabetical order? will it sort a column of numbers from least to most or most to least? or does this only available in the back end? thanks!

[benjaminteir]

8:58 When I press the "Field group for ..." Checkbox. Nothing shows up

[curandero]

Great video! How would you include importing images eg of machinery, or manufacturer logo in above example as from what little I know..the csv files don’t export images. Is it a case of including additional columns (before exporting csv) specifying the url, let’s say you want to use it as a featured image or product image?

Also Once this data is moved across how easy is your above example to integrate with woocommerce, let’s say you’ve found your machine and wish to buy it.

I have an upcoming project, and your video is helpful / closely related with what I have coming up. I will need to create a list and then ideally database of vehicle parts, maybe 500 or so..with several own custom fields which will contain at least one image of each part. Then export from excel in csv into MySQL/phpmyadmin to then integrate with toolset and woocommerce. I have quite little experience with all of this so am looking for the best approach.

[TheAshish]

Can this be exported to a host server from localhost with same db structure.

[muhammadfarooqi]

what if in there are two manufacturures with same name.... we've totally changed IDs with Manufacturere name ..?

[asiscarpio]

OMG!!! easy as shit!!! - asiscarpio.com