SQL to WordPress

SQL SQL
WordPress WordPress

Seamlessly import products, customers, orders, coupons, and blog posts from SQL database to WordPress with ease

How to import SQL to WordPress

  • data files

    1. Submit SQL Files

    Submit a ticket with your online store credentials, specific requirements, and the SQL files you want to import.

  • custom tasks

    2. Set up File Migration

    Our technicians will receive your request and configure a file migration process tailored to your needs.

  • perform migration

    3. Import SQL Files

    Data in your SQL files will be imported into your WordPress store through our file migration system. All possible issues will be solved until you are pleased with the results.

What you get

Superior Benefits

  • Free additional options
  • Background migration
  • Unlimited re-migration
  • Unlimited recent data migration
  • 1-Year of use & support
Migrate your online store to WordPress in 3 simple steps - WordPress Migration Tool

What Next-Cart migration tool supports

Supported Versions
SQL SQL (source)
  • Database File Formats: SQL
  • Database Management Systems: MySQL, MariaDB, PostgreSQL, SQLite, MongoDB, Microsoft SQL, Oracle, etc.
WordPress WordPress (target)
  • WordPress 1.0 - 6.7
  • *Support e-commerce plugins: WooCommerce
  • *Support multilingual plugins: WPML and Polylang
Supported Entities The supported entities include all types of data available on WordPress, except for third-party module data.
Posts
  • Post Information: Title, Content, Short Description, Tags, Meta Title, Meta Keywords, Meta Description, URL Path, SEO URLs (301 Redirects or Rewrite), Structured data of Yoast SEO and Rank Math, etc.
  • Post Images: Featured Image, Images in Content, Alt Text, Title.
  • Post Categories.
  • Post Comments.
  • *Multi-language Post Information: Title, Content, Short Description, Meta Title, Meta Keywords, Meta Description, URL Path, etc.
Pages
  • Page Information: Title, Content, Tags, Meta Title, Meta Keywords, Meta Description, URL Path, SEO URLs (301 Redirects or Rewrite), Structured data of Yoast SEO and Rank Math, etc.
  • Page Images: Featured Image, Images in Content, Alt Text, Title.
  • Page Parents, Sort Order.
  • *Multi-language Page Information: Title, Content, Meta Title, Meta Keywords, Meta Description, URL Path, etc.
Users
  • User Information: First Name, Last Name, Email, etc.
  • User Addresses: First Name, Last Name, Street Addresses, City, Province, Country, Zip Code, Phone, Fax, Company.
  • User Newsletter.
The supported entities below are for WooCommerce
Products
  • Product Types: Simple Product, Variable Product, Grouped Product, Virtual Product, Downloadable Product.
  • Product Information: Name, SKU, Weight, Length/Depth, Width, Height, Description, Short Description, Price, Special Price, Meta Title, Meta Keywords, Meta Description, URL Path, SEO URLs (301 Redirects or Rewrite), Structured data of Yoast SEO and Rank Math, etc.
  • Product Options and Product Variants/Variations: Price, Special Price, SKU, Weight, Length/Depth, Width, Height, etc.
  • Product Images: Main Image, Gallery Images, Variant Images, Images in Description, Alt Text, Title.
  • Product Inventory: Available Stock Quantity of Products and Variations.
  • External Links: Categories, Tax, Manufacturer/Brand, Downloads, Related Products, Up-sells and Cross-sells Products, Child Products.
  • Product Attributes.
  • Product Downloads: Download Links, Download Limit, Download Expiry.
  • *Multi-language Product Information: Title, Description, Short Description, Meta Title, Meta Keywords, Meta Description, Attributes, URL Path, etc.
Product Categories
  • Category Information: Name, Description, Meta Title, Meta Keywords, Meta Description, URL Path, SEO URLs (301 Redirects or Rewrite), Structured data of Yoast SEO and Rank Math, etc.
  • Category Images: Main Image, Images in Description, Alt Text, Title.
  • Parent Categories, Sub Categories.
  • Category Sort Order.
  • *Multi-language Category Information: Title, Description, Meta Title, Meta Keywords, Meta Description, URL Path, etc.
Taxes
  • Tax Class, Tax Zones and Rates.
Manufacturers
  • Manufacturer/Brand Name.
  • *Support migrating Manufacturer Information to all Brand plugins.
Customers
  • Customer Information: First Name, Last Name, Email, etc.
  • Customer Addresses: First Name, Last Name, Street Addresses, City, Province, Country, Zip Code, Phone, Fax, Company.
  • Customer Order History.
  • Customer Newsletter.
Orders
  • Order Information: Status, Currency, Total, Sub Total, Tax, Shipping, Tracking Number, Discount, History, Notes, Date, etc.
  • Products Details: Name, SKU, Quantity, Price, Tax, Options and Variations, etc.
  • Customer Details: First Name, Last Name, Phone, Email, Billing/Payment and Shipping Addresses.
  • External Links: Products, Customer.
Coupons
  • Coupon Information: Coupon Code, Description, Discount Type, Discount Amount, Expiry Date.
  • Usage Restrictions: Minimum Spend, Maximum Spend, Allowed Products, Allowed Categories, Allowed Customers.
  • Usage Limits: Usage Limit per Coupon, Usage Limit per User, Limit Usage to X Items.
Reviews
  • Review Details: Author, Email, Comment, Rating, Status, Date.
  • External Links: Product, Customer.
Additional Options
Migrate recent entities on Source Store (Free)
Clear current data on Target Store (Free)
Strip HTML tags from category and product names (Free)
Transfer images from description of categories, posts and pages to Target Store (Free)
Migrate SEO URLs (301 Redirects or Rewrite) (Free)
Preserve Product IDs and Category IDs on Target Store
Preserve Orders IDs and Customer IDs on Target Store (Free)
Migrate Customers Passwords (Free)
Migrate Custom Fields
Migrate data from/to third-party modules (extensions)
Free Extra Features
Re-Migration You can re-run migrations as often as needed within one year of purchase. Our technicians will provide support during each migration to ensure everything is successfully transferred and your new site is fully operational.
Recent Data Migration After your initial migration, your Source Store continues to operate and collect new data such as products, customers, and orders. This feature allows you to migrate any new data to the Target Store while maintaining the connections to the previously migrated data. You can use this feature multiple times to keep your Target Store up-to-date.
Configurable Migration This feature allows you to choose specific data types to migrate, such as products, orders, customers, or blog posts. Additionally, you can map languages, customer groups, order statuses, and more between the Source Store and the Target Store, giving you full control over the migration process.
    Number of Custom Jobs
  • Free additional options
  • 30-day money back guarantee
  • 12-month of use and technical support
  • 12-month of re-migration and recent data migration

There are many database types you can use for the migration such as MySQL, PostgreSQL, SQLite, MSSQL, etc. We will design the migration tool based on your SQL database and requirements. Please be advised that the migration tool will only support the original SQL database you choose; you will need to purchase another migration tool if you want to import data from a different SQL database.

Next-Cart is a comprehensive shopping cart migration service that enables you to seamlessly transfer products, customers, orders, blogs, and other essential data from your current online store to a new eCommerce platform. Our team of experts provides full support throughout the migration process, ensuring everything runs smoothly as you manage the tool. Additionally, we provide a variety of free supplementary options to accommodate the unique needs of e-merchants.

To start using Next-Cart's migration tools and services, you'll need a registered account. Once that's set up, you can choose one of two methods to migrate your online store to a new eCommerce platform:

  • You can use our migration tool to handle the process with support from our experienced technicians.
  • If you'd prefer a professional to carry out the migration according to your specific requirements, you can opt for our VIP Support Service.

For more details, please refer to the following instructions: https://next-cart.com/faq/how-to-start-working-with-next-cart-service/

VIP Support Service is a service that our experts will take care of the entire migration and necessary configuration to give you the most efficient result. It's very useful if you are not tech-savvy or you don't get enough time to operate and check on the migration process.

Here are some outstanding features of the VIP Support Service:

  • Experts take care of the whole migration process
  • Customize the migration tool to your requirements
  • Install the Target Store and necessary extensions
  • Point the domain name to your Target Store
  • Premium Support*

You can select VIP features within the VIP Support Service option when you purchase a migration package. If you have already purchased a migration package, you can additionally buy VIP features at: VIP Support Service.

A complete migration process at Next-Cart consists of 3 stages:

  1. Initially, we use the migration tool to transfer all data from the Source Store to the Target Store.
  2. Subsequently, you can inspect the results on the Target Store. If any issues arise, our technicians will address them and help you perform the migration again.
  3. Finally, when the Target Store is ready to go live, we use the migration tool to transfer new data (products, customers, orders, blog posts, etc.) that hasn't been previously migrated to the Target Store.

For more details, please refer to this article: https://next-cart.com/faq/what-are-the-stages-of-a-complete-migration-process-at-next-cart/

Firstly, you need to identify the amount of data for the migration. Particularly, you should be aware of what kind of data you want to migrate and how many of them. Therefore, we coined the term "Entity Limit" calculated based on the highest entity number among the count of products, orders, customers and blog posts.

All migration tools share the same price regarding the Entity Limit option. E.g. you want to migrate 900 products, 900 customers, 1,000 orders and other related data, your highest entity number would be 1,000, giving you an option of 1,000 Entity Limit to select from and the price would be 69 USD.

For more details, please refer to this guide: https://next-cart.com/faq/how-to-calculate-the-entity-limit-of-my-store/

At Next-Cart, we only count the number of products, customers, orders, and blog posts you want to migrate. For example, if you only want to move active products and orders since 2017, you will calculate the Entity Limit based on the number of those products and orders.

Any custom requests to filter entities for migration will be considered as one custom job, regardless of the criteria used.

However, please note that custom requests to limit entities must be made before the migration process begins. Once the migration has started, the IDs of the entities will be counted towards the Entity Limit and cannot be changed.

The Entity Limit only applies to products, customers, orders, and blog posts. Other supported data such as categories, taxes, reviews, etc., will be fully migrated during the migration process. For more details on all supported data types, please refer to the Supported Entities section on the migration tool page.

If you want to migrate data from third-party modules and extensions, our VIP Support Service (Migration Customization) will help you do that.

Yes, all relevant data connections between products, orders, customers, and other entities will be preserved on the new WordPress website if they are all migrated using our migration tool. Common links include:

  • Products and categories
  • Products and reviews
  • Customers and orders
  • Customers and reviews
  • Orders and products

*Note: If you'd like to link data migrated through our tool with existing data already set up on your new website (e.g., linking orders with pre-existing products), our team can customize the migration tool to accommodate this setup.

Data is imported in a specific order to ensure the proper relationships between entities. The order of import is as follows: Taxes > Manufacturers > Categories > Products > Customers > Orders > Reviews > Coupons > CMS Pages > Blog Posts. Depending on the source and target platforms, not all data types may be included, but the order remains the same.

Entities are migrated from the oldest (smallest ID) to the newest (largest ID). If new data is added after the migration begins, it will not be included in the current process, but you can perform a Recent Data Migration to transfer these additions.

For more details, please read the full article at: https://next-cart.com/faq/how-is-data-imported-during-the-migration-process/

Main images, gallery images, and images within the descriptions of products, categories, blog posts, and pages will be downloaded and saved to your new WordPress website.

You have purchased the migration tool, but you want to migrate more data. You can upgrade the migration tool's Entity Limit to a higher plan.

In order to do that, you just need to pay an amount equal to the price difference between your current plan and the next plan. For example: your current Entity Limit is 500 at $49, you are going to upgrade to 1,000 Entity Limit at $69. So the amount you need to pay is: 69 – 49 = 20 USD.

Please follow the steps below to perform the upgrade:

  1. Go to your Account Dashboard > Migrations.
  2. Locate the migration tool you want to upgrade. Click Upgrade.
  3. Select the new Entity Limit, then proceed to checkout.

Within 1 year from the date of purchase, you can use the migration tool to perform migrations or new data migrations between your two stores as many times as you wish. Additionally, our technicians will support you throughout this period until everything is completed.

Please note that each migration tool is restricted to migrating data from only 1 Source Store, and its Entity Limit applies to both previously migrated data and new data in subsequent migrations.

No, our migration tool is designed to copy data from your SQL to the new WordPress store without affecting the operation of either. Both stores will continue to run normally throughout the migration process.

Additionally, you can develop your new WordPress store while the data is being migrated. However, we recommend not adding, editing, or deleting any data being transferred on the new WordPress store to avoid any discrepancies in the data.

If you get any errors or need any help with the migration, please follow the steps below to get your problems solved:

  1. Pause/stop the migration.
  2. Log in and submit a ticket from your Account Dashboard.
  3. One of our technicians will be assigned to your ticket. They will support you throughout the migration until you are satisfied with the results.

Kitconnect is a package that enables our migration tool to connect with self-hosted websites running on open-source shopping carts. To upload it to your store, please follow these steps:

  1. Download the Kitconnect package ZIP file from your migration tool.
  2. Unzip the file and upload the entire Kitconnect folder (including the Kitconnect folder and the files inside it) into your store's root folder.
  3. Copy your website URL into the migration tool and click on the Kitconnect URL to test the connection. If the Kitconnect package is uploaded successfully, you will see a "Hi! I am Kitconnect" message.

For more detailed instructions, please refer to this guide: https://next-cart.com/faq/what-is-kitconnect-package/

If you use our migration tool and encounter an error message related to Kitconnect, you might be experiencing one of the common errors listed below:

  • You may have entered the wrong URL of your online store.
  • You have selected the wrong Source Cart Type or Target Cart Type.
  • You forgot to upload the Kitconnect package to your website.
  • You uploaded the file kitconnect.php without its parent folder kitconnect_xxx.
  • You uploaded the Kitconnect package into a wrong folder. The store's root folder is the folder that contains index.php file.
  • The kitconnect package has wrong permissions. Please correct the permissions of the kitconnect file and folder according to this guide: Kitconnect does not work after it has been uploaded.

Other technical issues: Common errors with Kitconnect.

If you are having trouble with this problem, please submit a ticket or contact us via Live Chat for the fastest support.

Yes, with our paid plans, you can transfer the migration process to the background. This allows you to close your browser or shut down your computer without interrupting the migration. You can check the status at any time through your account dashboard.

*Note: This feature is not available in the Demo version. Consider upgrading to a paid plan for background migration and optimized migration speed.

The time frame for completing a migration process depends on several factors:

  • The amount of data being migrated.
  • The speed of the connection between your stores and our migration system.
  • The server configuration of your WordPress store.

On average, our system can migrate around 3,000 simple products per hour from SQL to WordPress under normal conditions.

To make the process faster and smoother, you may consider using the background migration feature and upgrading your stores.

If images are missing after the migration, you might be facing one of the following issues:

  • The size of the images exceeds the limit set by the WordPress store.
  • If you're using a CDN service on your Source Cart (e.g., Cloudflare), check if it's configured to block image downloads.
  • If you moved the image folder to a custom location different from the default path, our kitconnect might not recognize it.
  • The image format is not supported on the WordPress store. Common image formats include JPEG, JPG, PNG, WebP, GIF, BMP, and SVG. Among these, WebP, GIF, BMP, and SVG are only supported on certain eCommerce platforms.
  • If the PHP directive allow_url_fopen on the WordPress store's web server is being set to Off, please enable it by following these steps:

    1. Create/Open php.ini file under the main folder of your website.
    2. Add the following line to that file:
      allow_url_fopen = On

If you encounter this issue and are unable to resolve it on your own, please submit a ticket from your dashboard. Our technicians will help you address the problem and assist with re-running the migration.

What our customers say about us

4.9

overall star rating
Based on 471 verified reviews on
Showing our latest reviews on Trustpilot
star rating
by Nathan
2024-12-15T01:12:16.000Z
Awesome and professional support!
The support team responded quickly and was very clear about what they needed to get to the root of the issue. Once that was provided, they quickly identified and resolved the issue. The communication was thorough and the explanation was complete. All of this was while I was on a free trial. I immediately purchased the migration tool.
Read more
star rating
by Alex Witter
2024-12-05T17:52:10.000Z
Nice Tool
Nice Tool, excellent support, easy to use
Read more
star rating
by KOUKOUSELIS Aris
2024-12-05T17:46:07.000Z
Great professionals
Great professionals, fast and on point!
Read more
star rating
by Giorgos Grispos
2024-11-30T03:27:53.000Z
Excellent service and after sales support
Still working on that as I have many custom jobs. Service is awesome, we have exchanged many emails so far in order to have a perfect migration and I really appreciate their help. I recommend them even for complicate projects.
Read more
star rating
by Gianluca
2024-11-29T11:25:28.000Z
Absolutely perfect!
Absolutely perfect!I had to migrate an old and full of products ZenCart e-commerce (over 2,000 products!) to a new WooCommerce.I purchased the VIP Assistance package and they took care of EVERYTHING!In a few hours they migrated my old website, with all my products, orders, customers, product images and so on... EVERYTHING!The staff is kind and patient and provides answers to all the information requested.The price list for the service is transparent and there are no surprises.If you need to transfer an old e-commerce to a new platform, next-cart.com is definitely the best solution.Absolutely recommended
Read more
star rating
by René Mulder
2024-11-23T16:16:57.000Z
Great tools, great service, low price!
Tools works flawless, and they respond very fast if you have any questions. I needed a custom query, this was done within several hours.Highly recommend
Read more
star rating
by Andy
2024-11-19T12:51:36.000Z
This made migrating e-commerce data…
This made migrating e-commerce data from one platform to another very easy and incredibly intuitive.
Read more
star rating
by Lucas Larripa
2024-11-06T20:21:05.000Z
I could not be happier!
I could not be happier. We migrated a shop from Prestashop to Shopify and it worked perfectly. And also customer support was always there when I needed them. Congrats to the team!
Read more
star rating
by Brian C
2024-11-03T15:29:34.000Z
Terrific
Their products and support are exceptional. I used them to transfer data from one POS to another and it worked perfectly. I had many questions and their support responded quickly and accurately on every question. I wish both POS vendors, the one I currently have and the one I was looking at switching to, had even 10% as good customer service as Next-Cart.
Read more
star rating
by Seth Goyes
2024-10-23T18:26:36.000Z
Incredible experience
Incredible experience! OpenCart to Shopify, 2000+ products, customers, order history, discounts, and more in under 1 hour.The support was quick to respond. VERY happy with the experience.
Read more

Why migrate with Next-Cart

Next-Cart is capable of conducting all kind of services offered by other shopping cart migration providers and beyond. It is our devotion, safety, flexibility, and reasonable pricing that are what you can find in us. If you need more information, contact our 24/7 support team to get help (we also work on holidays). It is our pleasure to serve you.

no downtime

No Downtime

The migration does not affect the speed and the performance of your sites. They will function as normal during the migration.

no tech skills required

No Tech Skill Required

It takes just a few clicks to get the migration done. No technical skills needed. No installation required.

professional support

Professional Support

You will get 1:1 tech support throughout migration, until you are happy with the results. We support via Helpdesk, Live Chat, Email 24/7/365 including holidays.

customizable migration

Customizable Migration

Customize the migration process according to your requirements. Migrate custom fields and extension data with ease.

SEO rankings preservation

SEO Rankings Preservation

The migration tool is designed to keep the old URLs and meta data on the new store to ensure your site doesn't drop any SEO ranking.

one year support

1-Year Migration Assurance

All migration services include 1-year of use and support. That ensures a seamless migration and compatibility with your website development.

cheap pricing

Cheap Pricing

We always try to be the cheapest. If you see any cheaper, please let us know, we are willing to offer the best price with the matching service.

money back guarantee

30-Day Money Back Guarantee

To guarantee the quality of the service and the trust from customers, we offer a 30-day money back guarantee on all migration tools.

data security

Highest Data Security

The migration takes place securely on Cloud Servers located in the US, the UK and Singapore. No information is stored except your site URLs.

Want an all-in-one migration service?

No more worries about the hassle of the migration process or your time bank. With the VIP Support Service, sit back and let our experts execute the migration, review the data, install the necessary modules, and give you the most efficient results.