Import and export both products and variations, ninja style
Mass import hundreds, even thousands of Products into your WooCommerce store with the CSV Import suite. CSV Import suite lets you import all types of products, even product variations!
This user-friendly importer, with clear step-by-step instructions helps you import Categories, Tags, Products and other Product details into WooCommerce. CSV Import suite supports:
Importing text based product data – prices, descriptions, images etc
Import custom fields (meta), taxonomies, attributes and more
Importing product variations
Merging products – useful for adding more information to existing products
Exporting products and variations – the exported CSV is even re-importable!
The main screen
After uploading your CSVs you will have a chance to remap your fields for extra flexibility:
The mapping screen
The Product CSV Import Suite extension for WooCommerce allows you to export and import products using only one file. This extension gives you the ability to move your products from one website to another and to back up your products when the need arises. In this blog post, I’ll show you how to use this extension through a real life case study.
How the Product CSV Import Suite extension works
LightSpeed sells a tourism website solution called Bootstrap Tourism. This solution offers website packages to travel agents, tour operators and accommodation suppliers. The accommodation website package includes online bookings. We use WooCommerce Bookings to offer this functionality to our customers, but we needed a way to export and import bookable products. To accomplish this, we decided to use the Product CSV Import Suite extension.
To begin with, we decided to export a set of bookable products for “hotel rooms”. Before importing a bookable product, we decided to try and export one successfully. We navigated to WooCommerce>>CSV Import Suite and selected the Export Products tab. Here, users have a number of export options:
Limit: set the maximum number of products that you wish to export.
Offset: the product row number at which you wish to start the export.
Columns: allows you to choose which CSV columns you’d like to export.
To illustrate what the above bullet points mean, I included a picture below. Imagine working in an excel document. Each row has a number and there is a product in the numbered rows. Product number 1 is in row 1. In other words, the row number is equal to the product number.
Now let’s say you set a limit of 100 and an offset of 200, you’ll export products 200-300 to your CSV file. This means that you told the exporter that you would only like to export 100 products (limit). And you would like to start exporting from product number 200 onwards (offset).
Furthermore, you can choose to export products by column names. Imagine the excel document again. In an excel document you have an infinite number of columns which are named alphabetically. We’re going to call column A “post_title” and column D is going to be called “post_content”. You’ve told the Product CSV Import Suite that you would like it to export rows 200-300, and now you want to tell it that you don’t want to export all the columns in the rows. You only want “post_title” (column A) and “post_content” (column D). Therefore, you insert both names in the Columns section.
For our export test, however, we set Offset to “2” and Limit to “1”, because we wanted to try exporting a single product. We also kept the default selection for Columns, which is “All Columns”.
After exporting the test product and viewing the CSV file, we found that all the standard product information had exported perfectly. “Post_title” (column A), “post_name” (column B), “post_content” (column D),” images” (column G), “tax: product type (column H)” were there with the relevant product information.
However, we found that additional information which specifically related to a bookable product as opposed to, for example, a simple product, hadn’t been exported. Because we chose to export “All Columns”, we thought that it would have exported all the product data. We hadn’t realised that we needed to tick the include hidden meta data box. This option ensures that any additional product information is included in the CSV file.
Once we completed the exporting test successfully, we moved on to importing the CSV file. We navigated to WooCommerce>>CSV Import Suite and selected the Import Products tab. Once there, we directly clicked on the Import Products button, because we didn’t need to import product variations. If you’d like to learn more about importing product variations
At this point, we were given the option to upload the CSV file from the computer. After uploading the file, it directed us to the Map Fields page. Here, you can ensure that your column headers (for example “post_name” and “images”) are mapped to the correct fields before you import everything.
After making sure that the column headers were mapped to the correct fields, we submitted the CSV file. This completed the import and we found the newly imported product listed with the other existing products on the WooCommerceProducts page.
Conclusion
The Product CSV Import Suite extension allows you to mass import and export all types of products, including bookable products. It saves you time by removing the need to upload products manually when you’re moving them from one website to another.
0 Comments:
Post a Comment
Note: only a member of this blog may post a comment.
Subscribe to Post Comments [Atom]
<< Home