WooCommerce: Importing Products with Categories

If you’re running a WooCommerce store and have a ton of products to upload, manually entering them one by one can be tedious. Thankfully, WooCommerce makes it easy to import products in bulk, complete with categories, using a CSV file. This tutorial will walk you through the entire process of importing products and mapping them to categories.

---

What You’ll Need

1. A WooCommerce store set up and ready.
2. A CSV file containing your product data. (Don’t worry, we’ll show you how to structure it!)
3. Some basic familiarity with spreadsheets like Excel or Google Sheets.

---

Step 1: Prepare Your CSV File

CSV File Basics

• A CSV file (Comma-Separated Values) is like a simple spreadsheet where data is separated by commas.
• Your CSV should include the product details, like names, prices, descriptions, and most importantly, categories.

Essential Columns for Your CSV

Here’s an example of what your columns might look like:

SKU	Name	Price	Description	Categories
101	Running Shoes	50.00	High-quality shoes.	Shoes, Running Shoes
102	Leather Wallet	25.00	Durable leather wallet.	Accessories, Wallets
103	Laptop Backpack	70.00	Perfect for travel.	Bags, Backpacks

Key Points About the Categories Column

• Separate multiple categories with commas (e.g., Shoes, Running Shoes).
• Ensure the categories in your CSV match the ones in WooCommerce. If the categories don’t exist, WooCommerce will create them during the import.

---

Step 2: Import Your Products

Using the Built-in WooCommerce Product Importer

1. Navigate to the Importer:

   • Go to your WordPress dashboard.
   • Navigate to Products > All Products.
   • Click the Import button at the top of the page.

2. Upload Your CSV File:

   • Click Choose File and select your CSV file.
   • Click Continue to proceed.

3. Map Your Columns:

   • WooCommerce will try to automatically map the columns in your CSV to the correct product fields.
   • Double-check the mapping. For example:
     • Name → Product Name
     • Categories → Categories
   • If any fields are mismatched, manually adjust them using the dropdowns.

4. Run the Import:

   • Once the mapping looks good, click Run the Importer.
   • Wait for WooCommerce to finish importing. You’ll see a confirmation message once it’s done.

---

Step 3: Verify the Categories

After the import:

1. Go to Products > Categories to see the updated list of categories.
2. Check if new categories (from the CSV) were added and if products are correctly assigned.

---

Advanced Tips for Importing Products with Categories

1. Hierarchical Categories

If your categories have a parent-child relationship, use > to define the hierarchy. For example:

• Use Shoes > Running Shoes for Running Shoes as a subcategory of Shoes.

2. Handling Large Imports

For large imports (e.g., 1,000+ products), consider:

• Splitting your CSV into smaller files.
• Using a plugin like WP All Import for better performance and advanced features.

3. Updating Existing Products

If you’re updating products, include the SKU column. WooCommerce will match existing products by SKU and update their details instead of creating duplicates.

---

Useful Plugins for Enhanced Imports

1. WP All Import:

   • A powerful plugin for importing products with complex data (like custom fields).
   • Includes features like drag-and-drop mapping.

2. Product Import Export for WooCommerce:

   • Offers advanced options for bulk imports and exports, including scheduling.

3. WooCommerce CSV Import Suite:

   • Ideal for stores with complex product types like grouped or variable products.

---

FAQs

1. What happens if I assign a product to a non-existent category?
WooCommerce will automatically create the category during import.

2. Can I import products with images?
Yes! Include an Image URL column in your CSV with links to your product images.

3. What if my import fails?
Common issues include:

• Incorrect column mapping.
• CSV formatting errors.
  Double-check your file and re-run the import.

---

Conclusion

Importing products with categories in WooCommerce can save you loads of time and effort. With a well-prepared CSV file and a little practice, you’ll have your store stocked and organized in no time. 🚀