background img
Jul 2, 2019
0 0

How to Import WooCommerce Products Using WebToffee Plugin

Written by

Import WooCommerce Products Using WebToffee Importing and exporting products to similarly any e-commerce store can be a huge job where thousands of products are being sold. For example, Products are images, products, metadata that need to be exported to meet the entire product import process. When it comes to WooCommerce, you can handover these tedious tasks to an import plugin.

For example, there are many product import plug-ins to help you with it. Products Export-Import Plugin of the Webtop with WooCommerce 40,000+ active installs is one of them. With this plugin, you can easily import products into your store. This plugin for available in both free and premium versions.

In this article, after downloading this plugin in your store, you will take a closer look at the free version of this plugin, with an explanation of all its features, In brief, to simplify the import process.

Import WooCommerce Products Using WebToffee

  • Using this plugin you can import products when migrating from your store. Bulk import of products is required in the new store for migration. It has to be done with the help of the WooCommerce extension because it includes various product data and images.
  • Then keep a backup of your products for future use in the event of a site crash. Site crashes are more often than you think. In this way, you need to keep a backup of your store’s products in order to avoid losing any data and re-creating it from scratch.
  • To update product updates such as stock, pictures, etc. in bulk, product import, product name, id, product images, stock details, etc. are included. Because this plugin makes it easy to make bulk updates of data in your WooCommerce store.
  • How to Import WooCommerce Products Using WebToffee Plugin

Features of the Product Import WooCommerce Products Using WebToffee

  • Update Products when present: This feature enables updates to products that are already present in your store during import. Unchecked products will not be updated during the import if you have left this box.
  • Delimitation: This is the column separator for the exported CSV file. You can choose the delimiter to match the file being imported at your WooCommerce store.
  • Merge Blank Cells: If this option is checked, then empty attributes will be added to non-priced products. If you are not sure about this option you can leave it unchecked.

Installation of product import plugin

How to Import WooCommerce Products Using WebToffee Plugin To download and install this plugin on your WooCommerce store, go to your WordPress Dashboard and go to the Plugins menu and then click Add New. From the opening window, search the Product Import Export Plugin by WebTop. Then click Install and Activate.

How to Import WooCommerce

Configure Product Import Export for WooCommerce

Once activated is successful, a new sub-menu appears under the WooCommerce section in the WordPress Sidebar menu.

 WooCommerce Products Using WebToffee Plugin

You can navigate to the Product Import and Export settings in two ways:

1- WooCommerce → Import-Export Products from WordPress Dashboard

How to Import WooCommerce Products Using WebToffee Plugin

2- Plugins → Installed Plugins → Product CSV Import and Export-Import and Export

You must have a CSV file to get started. You can make one or export the product to get a CSV format. Or you can download product WooCommerce sample CSV (column headers are similar to WooCommerce fields) and product commercial sample CSV (column headers are user-defined).

WooCommerce Product Import Export Plugin takes a CSV file (comma-separated values) as input. You must create a CSV (UTF-8 encoded) file and enter the product details in the structured format. This is to match every area of ​​the CSV file in the area of ​​a particular product that otherwise requires input from the manual.

For example, the post_title field is mapped to the name of the product and the regular_price field is mapped to the regular value of the product. For the plugin to work correctly, you must correctly map the header of all the columns and you will need to make sure that all the fields you have entered are in the correct format. A structured format that you should follow to enter product details in CSV, as shown below.

How to Import WooCommerce Products Using WebToffee Plugin

column heading


Approved cost or format

POST_TITLEindicates the product name.Text (e.g., High Heel Shoe)
POST_NAMEindicates the slug name of the product.Text (e.g., heels)
post_statusindicates that the product is in the draft or published mode.Draft / Published
post_excerptindicates the product’s brief description.Text / HTML
POST_CONTENTindicates the product’s description.Text / HTML
post_parentindicates the father of grouped and variable products.parent id
post_passwordTo include a password for the personal post.text
SKUSKU (Stock Keeping Unit) is an identity, usually an alphanumeric of a particular product, which allows it to be tracked for inventory purposes.alpha-numeric characters
menu_orderIt determines the order of the products in the shop. Item = 0 with menu order is displayed 1, 2, 3 etc. Products with the same menu sequence number are then listed alphabetically. When you create a new product, it becomes the default for menu_order = 0numeric characters
downloadableAfter purchasing the product, the product can be downloaded or not.yes / no
VirtualIt does not physically exist to appear to do so but is made by the software.yes / no
VisibilityIndicates whether a product is available to buy or not.Show / Hide
stockThe number of total products available in the stock. You can use (+) or (-) signals with brackets to add or subtract the number of products in the stock.numeric characters
stock_statusThis indicates whether the product is in stock or not.In-stock / out of stock
backordersSpecify orders for out-of-stock products that can not be currently completed or sent, but are still requested to make the product available again.yes / no
manage_stockThis indicates whether the stock is managed by the store or not.yes / no
regular_priceindicates the original price of the product.numeric characters
sale_priceThis is the price of the product which is being given at the concessional rate.numeric characters
weightindicates the weight of the product.numeric characters
Lengthindicates the length of the product.numeric characters
widthindicates the width of the product.numeric characters
heightindicates the height of the product.numeric characters
imagesIndicate image URL or image name. | Supports multiple image URLs, separated by ‘URL Eg: Http: //url/filename1.png
tax_statusIndicates whether the product is taxable or not.taxable / any
tax_classThis represents the tax option for the product.Standard Rate / Low Rate / Zero Rate
Tax: product_typeindicates the type of product (simple or variable).Simple / Variable
Tax: product_catUsed when importing a product that points to the product’s category.text
Tax: product_tagUsed when importing the product that indicates the tag (s) used for the product.text
Tax: product_brandThis indicates the brand of the product.text
attribute: colorThis reflects the available color of the product.text
attribute_data: colorThis indicates metadata about the attribute color of the product.status | Visible | Variation (e.g. 0 | 1 | 1)
attribute: sizeThis indicates the available size of the product.East US 7 | US 8 US 9
attribute_data: sizeThis tells the metadata about the product’s size of the product.status | Visible | Variation (e.g., 1 | 1 | 1)
attribute: pa_unitThis unit lists the options.East 10 kg. 20 kg. 30 kgs
Meta: attribute_pa_unitThis shows the metadata about the product unit.East 10 kg
attribute_data: pa_unitThis situation defines visibility and whether it is used for variation or not.status | Visible | Variation (e.g. 4 | 1 | 1)
attribute_default: pa_unitThis is the default value of an entity attribute.East 10 kg

Properties of named Pa are local attributes and there are global properties without Pa.

You can create a CSV from scratch or export the product to get a CSV format. To create and modify a CSV file, you can use a spreadsheet application, such as LibreOffice, Microsoft Excel, OpenOffice, or Google Sheets. Save this file with the extension “.CSV”

After entering all the details about the products in the spreadsheet, you can import the product at your online store. Now, navigate to WooCommerce → Product Import Export from your store’s Dashboard. From the opening page, click on the Import tab for Product.

From here you can import products from an easily created CSV file. this plugin free version, only CSV import is supported. To configure additional import options such as importing from the FTP location or from the URL or to the scheduled import, you may need to upgrade to a premium version.

After selecting a file from your computer, upload it and click the Continue button on Import Mapping.

The premium version of product import-export for WooCommerce

Upgrading to Premium Edition, you will have access to many more useful features listed below,

  • Review the export product (Simple, Group, External, and Variations) and in the CSV file.
  • Import products (simple, group, external, and variations) and reviews in CSV format in WooCommerce stores.
  • WPML supported. French and German (Deutschland) languages ​​support outside of the box.
  • Scheduled import and export through FTP / SFTP using cron jobs.
  • Import the CSV file from the URL.

Click Here to find more Tips and Tricks

Article Categories:
Plugins · WordPress Tricks and Tips

Leave a Reply

Your email address will not be published. Required fields are marked *

The maximum upload file size: 300 MB.
You can upload: image, audio, video, document, text, other.
Links to YouTube, Facebook, Twitter and other services inserted in the comment text will be automatically embedded.