Скачать или смотреть WooCommerce CSV Import Tutorial – WP All Import To Import Products From Any XML or CSV wp all import

The Complete Written WooCommerce CSV Import Tutorial
1. Before You Start: Prepare Your CSV File
This is the most critical step. A well-prepared CSV file prevents 99% of import errors.
File Format: Save your file as a CSV (Comma Delimited) (*.csv).
Headers: The first row must contain headers (e.g., ID, SKU, Name, Price). These will be the fields you map inside WP All Import.
Required Fields: At a minimum, your CSV should have:

Name (Product Title)
Description or Short Description
Regular Price
Type (simple, variable, grouped, etc.)
Images: The best practice is to have image URLs in your CSV, not local file paths. Use a column like Images or Image 1, Image 2, Image 3. The URLs must be publicly accessible.
Variations: For variable products, you need a parent product row and then rows for each variation. The parent should have Type: variable, and variations should have Type: variation and a Parent column with the parent's SKU or ID.
Example of a simple CSV structure:
SKU
TSHIRT-RD
TSHIRT-BL
2. Installing and Setting Up WP All Import
1. Purchase and download the WP All Import plugin from their website. The free version is very limited; you need the premium version for WooCommerce.
2. In your WordPress admin, go to Plugins - Add New - Upload Plugin. Upload the .zip file you downloaded and activate it.
3. Go to All Import - New Import.
3. Running Your First Import: A Step-by-Step Walkthrough
Step 1: Select Your File
Click "Upload a file" and select your prepared CSV.
WP All Import will process it and show a preview.
Step 2: Configure Import Settings
What are you importing? Select "Products".
How do you want to import your products? For a new import, choose "New Items". For updating existing products, choose "Existing Items" and select a field to match by (like SKU or ID). Matching by SKU is highly recommended.
Step 3: Map Your CSV Columns to WooCommerce Fields (The Magic Part!)
This is where you tell the plugin what data goes where.
On the left, you see all WooCommerce fields (Title, Description, Price, etc.).
On the right, you select which column from your CSV corresponds to that field.

For Post Title, select your CSV's Name column.
For Content, select your Description column.
For Regular Price, select your Price column.
Advanced Mapping:

Images: Drag the "Images" section from the left into the mapping area. Select your Images column for the "Download image" field.
Custom Attributes: Drag the "Attributes" section into the mapping area. Choose "Custom Attributes" from the dropdown. For "Name", select your column for attribute name (e.g., "Color"). For "Value", select the column for the value (e.g., "Red").
Categories: You can map to existing categories or the import will create new ones automatically.
Step 4: Configure Your Import Settings (Advanced Tab)
Import Speed: Default is usually fine.
Post Status: Set new products to "Draft" first for a test run. Then change to "Published" for your final import.
Step 5: Confirm and Run the Import
Review your settings. Click "Confirm & Run Import".
The plugin will process each row. You'll see a log showing successes, warnings, or errors. Read the warnings! They often tell you about small issues like missing images.
4. Handling Variable Products and Variations
This is a powerful feature. Your CSV needs a specific structure.
1. Parent Product: One row with Type: variable. This row should have the parent's title, description, and general attributes (e.g., "Size: S, M, L").
2. Variation Products: Subsequent rows with Type: variation. These rows need a Parent column that matches the SKU or ID of the parent product. The variation rows should have the specific Price, SKU, Stock, and attributes for that variant (e.g., "Attribute 1 Value: M", "Attribute 2 Value: Blue").
In WP All Import, when it detects a variation type, it will automatically provide fields to map the variation-specific data to the correct parent product.
5. Pro Tips and Common Pitfalls
ALWAYS DO A TEST RUN: Import a few products into Draft status first to check if everything looks right.
Image URLs Must Be Correct: Broken image links are the most common issue. Double-check that your URLs are full, direct links to the image file (ending in .jpg, .png, etc.).
Use "Manage Stock" and "Stock Quantity": To import inventory levels, map your CSV's stock column to the "Stock Quantity" field and also drag down the "Manage Stock" element and set its value to "Yes".
Scheduling: The Pro version allows you to schedule imports to run automatically (e.g., daily, hourly). This is essential for syncing with supplier feeds for dropshipping.
Export First: Use the "Export" feature to see the exact format WP All Import uses for your existing products. This is a fantastic way to learn the correct structure for your import file.