import-products-from-csv-file-to-woocommerce

That’s not a secret that WooCommerce is among leaders in eCommerce industry. This effective WordPress plugin powers over 28% of all world online stores. This fact claims that WooCommerce is constantly gaining customers from other shopping carts. If you are willing to start your new store with existing data you can import CSV to WooCommerce or transfer the whole store data from another platform. Sit tight, we are going to figure out the easiest ways to import products from CSV to WooCommerce and also show you how you can migrate all your current store’s data without converting to CSV. Interested now?

Let’s get started! And remember: there are always few ways - the choice is yours!

Ways to Import Products to WooCommerce

One of the most traditional ways to import products to WooCommerce is via CSV. They are bare texts that consist of numbers and letters and are commonly used to exchange information between various software. Almost all modern shopping carts support this file format. That’s why import products from CSV to WooCommerce is supposed-to-be a trivial procedure.

But sometimes it becomes pain in the neck. Yes, there’s lots of tutorials, detailed video demonstrations and documentations on how to import CSVs (XML, Excel, etc.) properly. Nevertheless, many users, mostly non-technical ones, fail to import product data without messing the fields up, losing some lines or getting data irritatingly duplicated.

Such issues may happen due to many reasons e.g., some shopping carts may give out CSV files with structure and MIME types that vary from those other carts use. Consequently, direct CSV import sometimes may lead to quite poor results. The alternative way will be use of 3-rd party plugins and addons that that will simplify the process of WooCommerce CSV product import, but they give no guarantees.

You can also ask developers help if you are not tech-savvy enough. But professional assistance costs lots of money, though mashing up with codes by yourself is not a better option. It’s time consuming and you’ll at risk to meet errors anywhere or lose important data suddenly.

So, what’s the alternative? How to eliminate risks of having your data imported incorrectly without digging deep into technical details?

Safe way to import CSV to WooCommerce

If you don’t want spend huge sum of money on developers and have no wish to perform code manipulations by yourself - the most secure and fast way to import WooCommerce products CSV is via Cart2Cart automated data migration service.

Cart2Cart is designed to migrate eCommerce data between platforms. It can transfer your entities not only products, but customers, orders, manufactures, reviews etc. to a desirable platform automatically within few hours. All you need to start data migration is to provide required credentials and click “Start Migration” button. The service will move your data without breaking relations between entities. You are offered a possibility to testify the quality of data transfer by performing Free Demo import to WooCommerce that will move a limited number of entities to your live WooCommerce store. After checking the results if you’re satisfied with the outcome you can proceed to full-scale migration.

Now we are going to show you how to utilize Cart2Cart service according to our purposes and perform a seamless  import of products from CSV to WooCommerce.

How to Import Products from CSV to WooCommerce

  • Register at Cart2Cart

Create new Cart2Cart account or or use your existing Facebook or Google account.

  • Setup Source Cart

Choose CSV File as Source Cart. Additionally, you can provide URL of the store from which the CSV was exported - that would enable the import of product images, which can’t be stored within a CSV file. Otherwise, type any URL, e.g. https://google.com - any will do to proceed.

If you want to migrate the whole store’s data from another platform, select your current solution from a drop-down list (instead of CSV as on the screenshot). Make sure your shopping cart is among 80 supported by Cart2Cart.

import-products-from-csv-file-to-woocommerce

  • Setup Target Cart

Select WooCommerce as Target Cart, paste its URL into a corresponding field. Next, download the Connection Bridge, , unzip and upload it to your WordPress root directory via any FTP manager, i.e. FileZilla. There’s nothing complicated - you’ll be given detailed instructions on how to do it.

  • Choose the entities you’d like to move and additional options, if needed.

import-products-from-csv-file-to-woocommerce

If you are migrating data from CSV - Upload your CSV file with products and the file with product attributes. The latter is optional if you don’t have one - it’s not a problem.

import-products-from-csv-file-to-woocommerce

  • Perform Smart Mapping

Match the fields of your CSV file with the corresponding ones on WooCommerce.

import-products-from-csv-file-to-woocommerce

  • Start a free Demo migration.

Demo import CSV to WooCommerce allows you to ensure everything is mapped and set correctly by importing a few entities to your WooCommerce. It can be restarted a countless number of times, don’t worry to change anything if you spotted any troubles. The Demo will move a limited number of entities to your live WooCommerce store up to 30 min.

  • Launch Full Migration.

If you satisfied with the Demo results, launch full-scale CSV import to WooCommerce. Click “Start Migration” button and data transfer will begin immediately. Data migration with Cart2Cart doesn’t require any user interaction, so come back to your deals with no worries. After the process will be over, you’ll get the notification email.

Make sure you don’t make any changes to your Target Cart during the import - it’s crucial to get a successful outcome.

That’s it. Within one-two hours, you’ll get a notification via email after it’s finished.

CSV Import Troubleshooting

No issues should occur if you’ve followed the instructions above carefully, if you do spot any, here’s a bit of help:

  • Some product images are missing? Check your mapping one more time, look if image fields are valid and their URLs are input. Ensure that file’s permissions are “777”.
  • If the SKUs are not defined and some paths are invalid, it can be caused by wrong characters of CSV file. Have another look at the description section.
  • Got product duplicates? It could happen if the SKUs are mismatched. Look if all the SKU fields are mapped properly.

Well, congratulations! You’re not ready to import products from CSV to WooCommerce: even a 40,000+ product CSV is not a challenge anymore. Feel confident enough? Then give it a try (a FREE try) and start with Demo import right away!