WooCommerce Product Variation, Orders, Coupons and Refunds CSV import

July 31, 2015

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

  • Upload File
  • Upload using FTP
  • Upload from external link
  • Choose file in the server

Once the CSV file is uploaded press “import” or “update” button to continue. There are two mapping fields which are necessary for WooCommerce modules import. They are “Core Fields” and “eCommerce Meta fields”. Map the wp fields with the CSV headers. If the wp fields and CSV headers are same, then it was automatically mapped. After mapping click “Next” button.

The summary page will show you the summary of a total number of records, mapped and unmapped fields. Click “Proceed Import” to continue. In the next page, select “Import right away” to import immediately or select “Schedule now” to import later. “Detect duplicate post content” and “Detect duplicate post title” will detect duplicates and skip it from importing. Press “Next” button and then Click “Import Now” button to proceed.

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 product, then use “variation import” option.

Core fields:

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. In the “Variation ID” mention the variation Id if is known.

 

Woocommerce Product Variation, orders and refund csv import

 

eCommerce Meta fields:

Product type has four types: simple product, Grouped product, Eternal/Affiliate product and variable product. In the “Product Type” specify “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 values are separated by pipeline (|). Multiple values for each attribute are separated by a comma (,).

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 individual, 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”.

 

WooCommerce Orders Import:

Core Fields:

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

  • Pending Payment
  • 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.

 

eCommerce 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 Fist 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 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

Multiple values are separated by Comma (,). Shipping cost and shipping tax should be specified in the “shipment_cost” and “shipment_taxes” fields. Multiple values are separated by 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 code by using numerical, alphabet, and special character. “Description field” represents the description about the coupon. This field is optional. If you want to update the existing coupon then specify the “coupon id”.

WooCommerce coupon import

eCommerce 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 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

          Coupon amount represents the amount of 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 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 item otherwise specify “no” in the CSV file.   

  

WooCommerce Refund Import:

For importing process refer “common steps” that is explained above. Your CSV file should have the following fields

Reason for refund- specify the reason for 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 amount- specify the amount to refund

Refund Id- specify the refund id if you want to update.