WP Smart Import Pro provides a powerful, specialized import engine built specifically for WooCommerce stores. Whether you have a catalog of simple items or complex multi-attribute variable products with dozens of variation combinations, this guide walks you through every step to import and synchronize your products seamlessly.
⚡ Key Features Highlight:
- Supports Simple Products, Variable Products, and Product Variations in a single CSV/XML/JSON feed.
- Automatic Parent-Child Resolution: Connect variations to parent products via Parent SKU, Parent ID, or Title matching.
- Dynamic Attributes Mapping: Map Colors, Sizes, Materials, and custom taxonomies with auto-detection for variations.
- Smart Inventory Normalization: Intelligently handles stock quantities, backorders, and In Stock / Out of Stock statuses.
- Full HPOS & Lookup Table Sync: Keeps
wc_product_meta_lookupand WooCommerce High-Performance Order Storage fully synced for instant catalog display and Add to Cart availability.
Prerequisites
- WordPress 5.8 or higher.
- WooCommerce installed and activated.
- WP Smart Import (Free) and WP Smart Import Pro activated.
- Your product data source ready in CSV, XML, JSON, or a live Google Sheets link.
Step 1: Start a New WooCommerce Import
To begin, navigate to your WordPress dashboard and click on WP Smart Import → WooCommerce Import (or go to New Import and select WooCommerce Products as the import type).
Choose your file source using one of the three convenient options:
- Upload from Computer: Upload your CSV, XML, or JSON product spreadsheet directly from your desktop.
- Download from URL / Google Sheets: Paste a direct download link, Google Sheets link, Google Drive link, or Dropbox URL.
- Select Existing File: Choose a previously uploaded file from your media/files library.
Click Continue to Step 2 once your file is uploaded or downloaded.
Step 2: Preview & Filter Product Elements
In Step 2, WP Smart Import parses your file structure and displays an interactive preview tree. You can inspect individual product nodes, verify that columns and tags match your data, and set up optional filtering rules (such as importing only products where Price > 0 or Stock > 0).
When you have verified the preview, click Continue to Step 3 to configure your product template.
Step 3: Map Product Fields in the Template Builder
The visual drag-and-drop template builder lets you map columns from your data feed into the corresponding WooCommerce product fields. The right sidebar shows all available elements from your file—simply drag and drop or type {tag_name} directly into any input field.
1. Product Title & Description
Map your product name and description in the main content section:
- Product Title: Drag your title element (e.g.,
{Title},{Name}, or{post_title}). - Product Description: Map your long HTML or text description (e.g.,
{Description}). - Short Description: Map the product excerpt/summary field (e.g.,
{Short_Description}).
2. WooCommerce Product Data Tab
Scroll down to the WooCommerce Product Data accordion. This panel mirrors the native WooCommerce product settings:
| Setting Tab | Recommended Mapping | Description |
|---|---|---|
| Product Type | Set to Variable Product, Simple Product, or map dynamic tag {Type} | Determines if product is standard or has variations. |
| General → SKU | {SKU} | Unique item identifier, essential for inventory and parent matching. |
| General → Regular Price | {Regular_price} or {Price} | Base product selling price. |
| General → Sale Price | {Sale_price} (Optional) | Discounted sale price. |
| Inventory → Manage Stock | Auto or {Manage_stock} | Set to Yes if tracking exact inventory quantities. |
| Inventory → Stock Status | {In_stock?} or {Stock_status} | Accepts 1, 0, instock, outofstock, or onbackorder. |
| Inventory → Stock Quantity | {Stock} or {Quantity} | Numeric available quantity. |
3. Setting Up Variable Products & Variations
If your CSV contains parent products and child variation rows (e.g. T-Shirt with sizes Small, Medium, Large):
- Parent Identifier: In the Variations section, select how child variations identify their parent:
- By Parent SKU: Child rows contain a column like
Parent_SKUmatching the main product’s SKU. - By Parent ID / Group ID: Child rows contain a shared group number or parent ID.
- By Parent Title: Child rows reference the main product title.
- By Parent SKU: Child rows contain a column like
- Attributes Configuration: In the Attributes tab, configure your variation attributes (e.g., Color, Size). Ensure “Used for variations” and “Visible on product page” are enabled.
- Featured Image: Drag the primary image URL (e.g.
{Images}). WP Smart Import downloads the image into your WordPress Media Library, generates all responsive thumbnails, and attaches it as the Featured Product Image. - Product Gallery: If your product has multiple photos, separate URLs with a comma (e.g.
{Image_1}, {Image_2}). - Avoid Duplicates: Enable the option “Search media library for existing images” to reuse existing files and save server disk space.
- Parent variable products are created first with their complete attribute terms.
- Child variation records are created, linked to their parent, and assigned prices, stock, and thumbnail images.
- The parent product price range (e.g. $19.99 – $29.99) and overall stock status are automatically calculated and updated in the WooCommerce lookup cache.
4. Product Images & Gallery
Inside the Images tab, drag your image URL or multiple comma-separated image URLs:
Step 4: Execute & Verify Your Import
Once you finish mapping your template, click Continue to Step 4. Review your import summary settings (such as batch processing size) and click Confirm & Run Import.
The import engine runs with real-time AJAX progress tracking:
Fast SKU Sync Mode (Stock & Price Only)
For recurring inventory updates where product descriptions, titles, and images don’t change, WP Smart Import Pro includes an Ultra-Fast SKU Sync mode.
In this mode, the importer bypasses heavy post processing and updates only _regular_price, _sale_price, _stock, and _stock_status directly in both postmeta and the wc_product_meta_lookup table, processing thousands of products in seconds.
Frequently Asked Questions & Troubleshooting
Q: Why are my imported products showing as “Out of stock”?
A: If Manage Stock is set to “Yes”, WooCommerce requires a valid numeric quantity (e.g. 10). If your stock quantity is blank or 0, WooCommerce forces the item to Out of Stock. WP Smart Import automatically sets Manage Stock = No when quantity is left empty, ensuring products with In stock? = 1 stay properly in stock.
Q: Can I import variable products from Google Sheets on an automatic schedule?
A: Yes! Simply paste your public Google Sheets link in Step 1, map your WooCommerce template, and set up an automated Cron Schedule in WP Smart Import Pro. Every time the schedule runs, fresh stock and pricing from your Google Sheet will be automatically updated.