How to Perform WooCommerce Excel Import
Managing your WooCommerce store you might need to import Excel file to WooCommerce. But WooCommerce accepts only .csv files by default. So you either have to convert your Excel file to .csv format or use an external solution that allows importing Excel files to WooCommerce directly. One of such solutions is Store Manager for WooCommerce.
Store Manager for WooCommerce is a downloadable application that enhances the default WooCommerce functionality with tools for bulk edits, advanced import/export, database backup, data generation, and others.
If you don’t have Store Manager yet, download a free trial and install it on your computer. Connect the application to your store database and enjoy the simplicity of your store administration.
Below you'll find a step-by-step instruction to upload products to WooCommerce from an Excel file.
Steps to Import WooCommerce Products From Excel
- Launch Import Wizard from Store Manager for WooCommerce. For that go to Catalog > Products > Import.
- Select an import source and choose the Excel file you want to import.
- Select the sheet to import and preview data.
- Select a field to identify products by and map database fields to the ones contained in your Excel file.
- Select product import method. To proceed with the Excel file upload, press Import.
You can save the import settings to a file by pressing the Save configuration button. Next time you need to import products with the same setting, you'll just upload the saved file.
Perform WooCommerce Excel Import for 14 days FREE
Try nowRelated Articles:
Import WooCommerce Products Preserving IDs
Learn how import products to a new instance of WooCommerce preserving product IDs.Read More...
Mass Changer: Detailed Tutorial
Perform bulk WooCommerce product updates via Mass Changer tool. Read More...
Merge Product Brand Name and Title Upon Import
How to add a brand name to a product title in WooCommerce via import. Read More...
Update WooCommerce Product Tags In Bulk
How to update WooCommerce product tags in mass using WooCommerce Product Tags Mass Changer.Read More...