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.
If you want to set or change variations for an existing product, then use “variation import” option.
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.
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:
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
- On Hold
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:
- Flat Rate
- Free shipping
- Local delivery
- Local pickup
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
“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”.
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 represents the amount of coupon. According to the Discount type please specify the coupon amount in the CSV file.
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.
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.
The expiry date will specify the coupon expiry date.
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.