Video Summary
In this video, I’ll be showing you how to import products into your WooCommerce store using a CSV spreadsheet. We’ll start with simple products, then move on to variable products and their different variations. I’ll guide you through my straightforward product import templates, and we’ll take a closer look at important columns like SKU, product name, and visibility settings. I’ll also touch on some optional fields, such as sale pricing and tax status, so you can customize your products just the way you want. Feel free to follow along and get your own CSV file ready for importing. By the end, you’ll have a clear understanding of how to make your product uploads quick and organized!
Video Outline
1: Download the Simple Product Import Template 0:15
2: Fill Out the Simple Product Details 0:33
3: Save and Import the Simple Product CSV 4:15
4: Confirm Import Settings 5:00
5: Verify Imported Product 6:02
6: Download the Variable Product Import Template 7:53
7: Fill Out the Variable Product Details 8:11
8: Save and Import the Variable Product CSV 9:48
9: Bulk Import Variations 10:43
10: Import Variations into WooCommerce 13:22
11: Review Variations on Product Page 14:03
12: Seek Help if Needed 15:08
Video Overview
Step 1: Download the Simple Product Import Template 0:15
Click the link to download the Simple Product Import Template CSV.
Fill in the necessary product information in the template.
Step 2: Fill Out the Simple Product Details 0:33
Type: Set to ‘simple’.
SKU: Assign a unique SKU for product identification.
Name: Enter the product name (e.g., ‘Jacket’).
Published: Set to ‘1’ for published or ‘0’ for draft.
Is Featured: Set to ‘1’ for featured or ‘0’ for not featured.
Visibility in Catalog: Set to ‘Visible’ or ‘Hidden’.
Short Description: Provide detailed information about the product.
Tax Status: Set to ‘taxable’ or ‘none’.
In Stock: Set to ‘1’ to manage stock.
Stock: Enter the quantity available (e.g., ’10’).
Backorders Allowed: Set to ‘1’ to allow backorders, or ‘0’ to disable
Weight and Dimensions: Fill in as necessary.
Price: Enter the product price (e.g., ’25’).
Categories: Assign categories (e.g., ‘Clothing, Clothing > Jackets’).
Images: Add image paths separated by commas.
Step 3: Save and Import the Simple Product CSV 4:15
Save the filled template as a CSV file.
Go to your WooCommerce store, navigate to the product screen, and click the import button.
Upload the CSV file.
Step 4: Confirm Import Settings 5:00
Ensure ‘Update existing products’ is unchecked if creating new products.
Click ‘Run the importer’ to start the import process.
Step 5: Verify Imported Product 6:02
Check the newly imported product to ensure all details are correct.
Step 6: Download the Variable Product Import Template 7:53
Click the link to download the Variable Product Import Template.
Step 7: Fill Out the Variable Product Details 8:11
Type: Set to ‘variable’.
Fill in SKU, name, short and long descriptions.
Set ‘In Stock’ to ‘1’ and leave stock levels blank.
Add weight, dimensions, categories, and images.
Define attributes (e.g., color and size) with their values.
Step 8: Save and Import the Variable Product CSV 9:48
Save the variable product details as a CSV.
Import the CSV into WooCommerce.
Step 9: Bulk Import Variations 10:43
Download the Variation Import Template.
Fill in details for each variation, ensuring unique SKUs and correct parent product SKU or ID.
Step 10: Import Variations into WooCommerce 13:22
Save the variations as a CSV.
Import the variations into WooCommerce and confirm successful import.
Step 11: Review Variations on Product Page 14:03
Check the product page to see the variations and ensure they display correctly.
Step 12: Seek Help if Needed 15:08
If you encounter issues, contact us at BeyondTheBrandMedia.com for assistance.