How to migrate from a custom database into WordPress

[@panworldmemes]

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

[@Toolset]

Thank you very much! :)

[@ESAMALMITHALI]

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

[@haimanpop]

very good thank you very much

[@TJKhara]

Great video

[@josephlivengood4508]

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.

[@Toolset]

Hello Joseph, in theory, you join more than two tables using MySQL (the more tables you want to join the trickest it becomes, you can google "mysql join 3(4, ...) tables". Another option is to separate your custom tables into set of tables independent from each other and repeat the process for each set. This video covers simple cases because later on in Toolset the relationship you create are also simple - you create a relationship between two post types. If your database is more complex, you might want to consider hiring a developer who will write a dedicated script to handle the migration.

[@Jc0293]

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?

[@gregmeskil3077]

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?

[@Toolset]

HI! Can you please submit your question through our Free consultation form? toolset.com/toolset-free-consultation/ Our technical team will assist you there with your question. Thanks!

[@HaifengZhu-pn3uq]

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

[@Toolset]

Hello, you should be able to access our site normally now. Can you please confirm? If you still need help please contact us at [e-mail]

[@soumyajitdas3162]

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?

[@Toolset]

Hi! Well, that question is way out of the scope of this tutorial and Toolset in general (honestly, we prefer people to migrate TO WordPress and WooCommerce, not away from them :) ). But in general, nobody can give you a specific answer or tutorial for migrating a WooCommerce store to "your custom website". What do you mean by "custom"? Will it still be powered by WordPress? What will power your webshop if you don't use WooCommerce (will you build your own custom shop application or use something like Shopify)? And so on... There are so many possibilities in what you describe as a "custom website" that it's impossible to answer. However, the principle should be similar, and it comes down to mapping all the product information in your new site's database and matching it with what you have in WooCommerce.

[@soumyajitdas3162]

@@Toolset ok in future I want to build my own website with html css and javascript or i simply use flutter to develop a website .can I use my previous data inside that coded website?

[@soumyajitdas3162]

@@Toolset Another thing is my database will be also custom database like we will create our own database so can I migrate all my woocommerce data to my custom database?

[@Toolset]

@@soumyajitdas3162 yes, of course, you can migrate your WooCommerce data to your custom database. Just make sure that your custom database structure features all the information you need on your new site (e.g. product id, product name, product category, order ID, order date, and so on). Then, you need a way to import the old database into the new one. There are a lot of ways to do this, from running custom SQL scripts to using 3rd-party solutions, but again, it all depends on what technologies your new store will be built upon (for example, I have no experience with Flutter so I cannot comment on that).

[@soumyajitdas3162]

@@Toolset this is quite helpful thank you and lot of love from India 🇮🇳

[@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

[@Toolset]

Hi! Can you please redirect your question here? toolset.com/toolset-free-consultation/ The tech team qill be able to help you from there. Thanks

[@jernanemf]

@@Toolset tks!

[@catalina3873]

ths， so beautiful🐹

[@muhammadfarooqi]

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

[@agnesbury9056]

I don't know how to work around it but maybe the authors of the WP All Import plugins will know www.wpallimport.com/toolset-types-import-csv-xml/

[@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.

[@Toolset]

Hi, the WP All Import plugin can handle images as well.

[@Toolset]

Hi, the WP All Import plugin can handle images as well.

[@curandero]

Toolset - WordPress Development for Non-Coders oh I didn’t realise...seems to be a very useful and powerful plugin. I will look into this more for sure! Thanks

[@Toolset]

Thank you! If you have any additional questions, feel free to ask here or via this form: toolset.com/toolset-free-consultation/ Agnes Bury

[@Toolset]

Thank you! If you have any additional questions, feel free to ask here or via this form: toolset.com/toolset-free-consultation/ Agnes Bury

[@benjaminteir6485]

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

[@Toolset]

Can you ask in our tech forum? The support team will assist you toolset.com/forums/forum/professional-support/

[@TheAshish456]

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

[@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!

[@Toolset]

Hi Casey! Please send your question here and our tech team will get back to you toolset.com/toolset-free-consultation/

[@rohitbajaj5665]

😀👍

[@asiscarpio]

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