Importing WooCommerce Product with Variation, categories

Importing all WooCommerce products, variations, orders, coupons in the WordPress is a tough process. WP Ultimate CSV Importer is a cutting-edge WordPress importer plugin. That makes it very easy to bulk import all the product fields present in the WooCommerce at a go such as Product Title, SKU, Catalog Visibility, Featured Products, Description, Short description of the product, Product Image, Gallery Images, Stock, Quantity, Regular Price, Sale Price, Shipping Type, Weight, Attributes & more default Product Meta Fields. With WP Ultimate CSV Importer, you can achieve seamless import of all your WooCommerce data with just a few clicks.
woocommerce and more product 2

Functions Well With WooCommerce Variable Products

You can import more than 10,000 WooCommerce products at a time, whether it is a simple or variable product. You can as well edit the WooCommerce products data and update the products information with CSV Importer plugin. You can undo the last bulk import operation entirely with the rollback option.

How WP Ultimate CSV Importer Plugin Saves Time?

Can you save time and edit bulk products at the same time? Editing several products can be exhausting and stressful. For example, if you have many products in your store, with variations, this plugin is really helpful to keep your store updated. Or have various attributes of the products, you can modify in a few clicks.

We understand that time is money running an online store. Imagine the time it takes having to change the price of one product to 1000 products one by one. That would be tedious. In addition, once you are done, you would probably have to start over again and complete the process for each product. You have to consider the time spent doing this that you could have used doing other more productive things. Whether it is a small store or a large e-commerce site, issues in product modification are always the same.

Get CSV Importer and other premium plugins in discount offer now.

How to Import With Confidence?

With WP Ultimate CSV Importer you can change all your product fields with exciting freedom. WP Ultimate CSV Importer plugin puts an end to all toils and can help you, making your life easier and the importing of your products quicker.

We introduced a powerful tool that will let you save hours and hours of precious time by letting you import and export products in a CSV file immediately!. The power of WooCommerce is that in utilizing the precise plugin that allows you to automate almost any process, reducing your workload and possibly possible expenses for the staff that needs to look into this kind of work. That is the reason, we developed WP Ultimate CSV Importer to eliminate loads of working hours in just a few clicks. Giving you the choice to import any kind of information you have for your products. Right from the price to their description, to the creation of custom fields for each one of your products.

WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.

WooCommerce Product Variation, Orders, Coupons and Refunds CSV import

There are four options to upload the CSV file. You can choose any one of the following options to upload the required CSV file:

  • Upload File
  • By using FTP/SFTP
  • From External URL
  • Choose file from server

Once you upload the CSV file. Choose the post type value from the ‘Import each record as’ dropdown. Choose ‘New item’ if you’re importing as new, otherwise if you want to update the existing data select ‘Existing Items’. Press the “Continue” button to continue.

choose woocommerce products 1

There are two essential mapping fields which are necessary for WooCommerce modules import. They are “Core Fields” and “Product Meta fields”. Map the WP fields with the CSV headers. If the WP fields and CSV headers are the same, then it will get mapped automatically. After mapping, click the “Continue” button.

Enable the media handling section if you have any external images to import, otherwise continue to proceed further. Click the “Import” button in the ‘Import Configuration Section’ to import data immediately on WordPress. You can also schedule via Google sheets or FTP/SFTP server to make the import and update an automated process. . There is an option to detect duplicates and skip it from importing. Enable the rollback option for revert back the import if in case any problems arise while importing.

Finally “Import completed successfully” message will be displayed. That means your CSV file was successfully imported.

WooCommerce Product Variations Import

If you want to set or change variations for an existing variable product, use the “WooCommerce Product Variations” option from the drop down after you upload the CSV file.

core field

In the “Product Id” specify the existing product’s Id that you want to set or change variation. Specify the existing product’s SKU in the “Parent Sku”. In the “variation Sku” field specify the variation SKU.

Woocommerce Product Variation orders and refund csv import e1438178164193 4

Woocommerce Product Meta fields

WooCommerce Product has four types: Simple product, Grouped product, Eternal/Affiliate product, and Variable product. In the “Product Type” specify the value “4” in the CSV file, because you are importing a variable product. In the “Product attribute name” specify the name of the attribute and its value should be specified in the Product attribute value field. If you want to make the attribute visible on the product page then specify “1” otherwise specify “0”. Multiple attributes names are separated by pipeline (|). Multiple attribute values for each attribute name are separated by a comma (,). Check our Sample CSV file for more help.

In the “Featured” field, specify “yes” or “no” in the CSV file. If your product is a downloadable product means specify “yes” in the CSV file. Provide the URL of the downloadable file in the “Downloadable file” field. In the “Download limit” field mention the number (how many times the customer can able to download the file). Specify the number of days for the download to expire after purchase in the “Download Expiry”.

Specify the dates in the “Sales Price Date From” and “Sales Price Date To” fields. If you want the product to sell individually, then specify “yes” otherwise specify “no”. UpSells Id and CrossSells Id refers to other product ID which you want to recommend. If your product is a virtual product then specify “yes” in the CSV file otherwise specify “no”. In the stock status field specify “1” for “In-stock” or specify “2” for “Out of stock” in the CSV file. The quantity of stock should be specified in the “Stock Quantity” field. To enable the “manage stock” specify “yes” otherwise specify “no” in the CSV file. In the backorders field, specify “1” for “Do not allow”, mention “2” for “allow but notify customer” and mention “3” for “allow”.

Core Fields:

In the “Customer Note” field, specify the customer Note. In the “Post Status” field you can specify any one of the following six options:

Product Meta fields

  • Pending
  • Processing
  • On-hold
  • Completed
  • Cancelled
  • Refunded
  • Failed

If you want to update the existing order, then you should specify the existing order’s Id in the “Order Id” field.

Order Meta Fields

Specify the type of payment as “Direct Bank Transfer” or “Paypal” or
“cheque Payment” in the “Payment Method title” and “Payment Method”
fields. Billing address details are specified in the Billing First Name,
Billing Last Name, Billing Company, Billing Address1, Billing Address2,
Billing City, Billing postcode, Billing state, Billing country, Billing
Phone, Billing Email fields. Shipping address details are also
specified in the address fields.
Specify the currency in the “Order Currency” field.

Shipping tax
and tax details should be specified in the “Order Shipping Tax” and
“Order Tax” fields. Product name should be specified in the “item_name”
field and Product Id should be specified in the “item_product_id” field.
In the “item_type” specify “line_item”. Multiple item types can be
specified in a single column using Comma (,). Product variation Id
should be specified in the “item_variation_id”. In the “item_qty” field,
specify the quantity of the product.

“Shipment Name” and “Shipment method Id” should be specified as any of the following:

  • International
  • Flat Rate
  • Free shipping
  • Local delivery
  • Local pickup
  • Other
  • N/A

Separate multiple values using Comma (,). Shipping cost and shipping tax should be specified in the “shipment_cost” and “shipment_taxes” fields. Multiple values are separated using Comma or Pipe (|) symbol.

WooCommerce Coupon Import

Core fields

“Coupon code” is used to specify the code of the coupon in the CSV file. You can generate coupon codes by using numerical, alphabet, and special characters. “Description field” represents the description of the coupon. This field is optional. If you want to update the existing coupon then specify the “coupon id”.

woocommerce coupon import e1438341801863 3

Coupon Meta Fields

“Discount type” has four types

  • Cart Discount – Specify the cart discount name as fixed_cart in the CSV file.
  • Cart %Discount – Specify the cart % discount name as percent fixed_cart in the CSV file.
  • Product Discount – Specify the product discount name as fixed_product in the CSV file.
  • Product % Discount – Specify the product % discount name as percent_product in the CSV file.

Coupon Amount- The coupon amount represents the amount of the coupon. According to the Discount type please specify the coupon amount in the CSV file.

Individual Use- If the individual use needs to be in checked means please specify “yes” in the CSV file, otherwise, specify “no” in the CSV file.

Product Ids and Exclude Products- Product id represents the id of the products which you want to be discounted. Exclude represents which you don’t want to discount.

Products categories- Specify the category id of the product to be discounted.

Exclude Product categories- Specify the category id of the product not to be discounted.

Usage Limit Per User- Represents the number of times the coupon to be used by the user.

Expiry Date- The expiry date will specify the coupon expiry date.

Free Shipping- If you need to allow free shipping specify “yes” in the CSV file else specify “no” in the CSV file.

Exclude Sale Item- Specify “yes” if you need to allow exclude sale items, otherwise specify “no” in the CSV file.

WooCommerce Refund Import
For the importing process refer to the “common steps” that are explained above. Your CSV file should have the following fields:

  • Reason for refund- specify the reason for the refund in this field.
  • Post Status- Specify the post status as refunded.
  • Post parent- specify the order’s Id that you want to refund.
  • Refund Id- specify the refund id if you want to update.
  • Refund amount- specify the amount to refund.

What Are the Useful Cases that this Plugin Can Do?

1. Updating the regular or sale price of all simple and variation products.

2. Carry out bulk addition of products and/or update sales price and the regular price.

3. Add bulk sale prices at once to products that do not currently have sale prices active.

4. Ability to update the SKU and Stock of all simple products that have a particular price easily.

5. For those products starts/ends/contains a specific string in the title, you can update based on attributes/prices.

6. Update all dimensions for all bulk products except for a particular Category of Products (configured using Exclusion list) and many more.

What Are the Features of this Plugin?

Our WP Ultimate CSV Importer is delivered with the following features: Bulk Import WooCommerce Products Flexible import on at least four types of product variations by simply choosing the right product types. The available product types are, Simple Product, External Product, Variable Product (Parent) and Variable Product (Variations)

Add, оr Overwrite Product Attribute Values Completely

Thе plugin lеtѕ уоu tо include a nеw оr аn existing attribute & itѕ values, and utilize the configured attributes fоr thе purpose оf variation.

Apply Bulk Import tо Product Categories

Yоu саn bulk import category name, slug, description with the CSV Importer plugin. You can also update the category meta fields using the ID or slug name of the category.

Bulk Import Anу Custom Product Fields

After installing a third-party plugin like ACF, Toolset and Pods plugin, аnd wоuld likе tо update product fields оf thаt plugin, уоu саn simply upload and import the values in CSV with WP Ultimate CSV Importer plugin.

Update Product Image fоr a Lаrgе Numbеr оf Products

Thе flexibility of thiѕ plugin helps уоu add оr replace аn existing image bу a nеw imageby simply adding the image URL in CSV. Rаthеr thаn gоing thrоugh thе stress оf adding thе ѕаmе image intо a numbеr оf products individually, with juѕt a click, add it tо аll products. In addition, уоu саn apply full import оn Images in thе WooCommerce Product Gallery field.

Schedule Jobs

Thе bulk import саn bе scheduled bу simply setting uр a date & timе аnd аlѕо revert bасk thе update аt a specific programmed time. Yоu саn choose tо schedule based оn daily, weekly, оr monthly bulk update operation according to hоw уоu wаnt it.
If you wiѕh tо stop thе bulk operation аftеr a сеrtаin period, Yоu саn as well schedule thаt too!

wordpress scheduled import 5

Frequently Asked Question

1. what Can WP CSV Importer do for Me ?

Thiѕ CSV Importer lеtѕ уоu change, correct аnd update a variety оf product fields including:

  • Product Nаmе
  • Product Description
  • SKU
  • Regular Price
  • Sale Price
  • Manage Stock
  • Product Categories
  • Product Tags
  • Product Attributes
  • Features аnd status
  • Tax Status and Class
  • Stock Quantity
  • Allоw Backorders
  • Stock Status
  • Catalog Visibility

2. Whаt iѕ included with thе Prо version?

Thе Prо version соmеѕ with advanced features ѕuсh as

  • Edit and update information
  • Schedule import process
  • Advanced filter options to export data and more.
  • Save mapping Template option
  • Advanced Product image Handling
  • Image meta fields import and update
  • Order Import, Refund Import and Variations Import.
  • Custom taxonomies and it’s metadata import.

Wrapping Up

Have any queries, please don’t hesitate to contact us at [email protected]. We are eager to hear from you.