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.
Configure Product Import Export for WooCommerce
Once activated is successful, a new sub-menu appears under the WooCommerce section in the WordPress Sidebar menu.
You can navigate to the Product Import and Export settings in two ways:
1- WooCommerce → Import-Export Products from WordPress Dashboard
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
Approved cost or format
|POST_TITLE||indicates the product name.||Text (e.g., High Heel Shoe)|
|POST_NAME||indicates the slug name of the product.||Text (e.g., heels)|
|post_status||indicates that the product is in the draft or published mode.||Draft / Published|
|post_excerpt||indicates the product’s brief description.||Text / HTML|
|POST_CONTENT||indicates the product’s description.||Text / HTML|
|post_parent||indicates the father of grouped and variable products.||parent id|
|post_password||To include a password for the personal post.||text|
|SKU||SKU (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_order||It 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 = 0||numeric characters|
|downloadable||After purchasing the product, the product can be downloaded or not.||yes / no|
|Virtual||It does not physically exist to appear to do so but is made by the software.||yes / no|
|Visibility||Indicates whether a product is available to buy or not.||Show / Hide|
|stock||The 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_status||This indicates whether the product is in stock or not.||In-stock / out of stock|
|backorders||Specify 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_stock||This indicates whether the stock is managed by the store or not.||yes / no|
|regular_price||indicates the original price of the product.||numeric characters|
|sale_price||This is the price of the product which is being given at the concessional rate.||numeric characters|
|weight||indicates the weight of the product.||numeric characters|
|Length||indicates the length of the product.||numeric characters|
|width||indicates the width of the product.||numeric characters|
|height||indicates the height of the product.||numeric characters|
|images||Indicate image URL or image name. | Supports multiple image URLs, separated by ‘||URL Eg: Http: //url/filename1.png|
|tax_status||Indicates whether the product is taxable or not.||taxable / any|
|tax_class||This represents the tax option for the product.||Standard Rate / Low Rate / Zero Rate|
|Tax: product_type||indicates the type of product (simple or variable).||Simple / Variable|
|Tax: product_cat||Used when importing a product that points to the product’s category.||text|
|Tax: product_tag||Used when importing the product that indicates the tag (s) used for the product.||text|
|Tax: product_brand||This indicates the brand of the product.||text|
|attribute: color||This reflects the available color of the product.||text|
|attribute_data: color||This indicates metadata about the attribute color of the product.||status | Visible | Variation (e.g. 0 | 1 | 1)|
|attribute: size||This indicates the available size of the product.||East US 7 | US 8 US 9|
|attribute_data: size||This tells the metadata about the product’s size of the product.||status | Visible | Variation (e.g., 1 | 1 | 1)|
|attribute: pa_unit||This unit lists the options.||East 10 kg. 20 kg. 30 kgs|
|Meta: attribute_pa_unit||This shows the metadata about the product unit.||East 10 kg|
|attribute_data: pa_unit||This situation defines visibility and whether it is used for variation or not.||status | Visible | Variation (e.g. 4 | 1 | 1)|
|attribute_default: pa_unit||This is the default value of an entity attribute.||East 10 kg|
Note: 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.