In default Magento 2, Import and Export are 2 very essential functions which every store has to use when working with products or customers. However, because of bigger and bigger demand in the work of admin, a lot of smart solutions are come up with to widen advanced features for these import and export.
Some solutions you can take a look at as below:
- Magento 2 Import Export Product Attributes
- Magento 2 Import Export Product Reviews
- Magento 2 Import Export URL Rewrites
- Magento 2 Import Export Categories
In this blog post, we will introduce you an additional solution called Magento 2 Import Export Wishlist Item extension. As its name, this extension allows store admin to import multiples products to wishlist and also easily export all wishlist items into a CSV file.
How to Add Products to Wishlist in Default Magento 2
On the side of customers, when customers go shopping in your store, they will add interested products to their wishlists so that they can take a look again for making the purchase decision. On the side of store owners, when they move all stores to the new websites or simply receive much data about customer wishlists, it is very time-wasting to manually add these big data to the backend. Even this process seems much more complicated with Multiple wishlists in case store owners are using Magento 2 Enterprise. Therefore, Magento 2 Import Export Wishlist Item is a good extension to help stores to solve time, cost and effort issue if they are in this trouble.
How to Import Wishlist Items in Magento 2 (Magento 2 Import Products to Wishlists)
Prepare the standard CSV file
After installing Magento 2 Import Export Wishlist Item extension, the first thing, as well as the most important thing admin need to do, is to prepare a CSV file which includes all information about products, customers, wishlists and so on.
This sample file is conveniently downloaded in the configuration of Import settings.
Then, you make some configuration like these in the default Magento 2 such as Import Behaviors (Add/Update, Replace or Delete), Allowed Errors Count or Multi Value Separator.
Validate the CSV file for import
By uploading the CSV file and then click the Check Data button to validate data in the CSV file.
- If the CSV file is valid, the Import button appears for you to click and start the Import process. A successful message is also displayed to notify about import result.
- If the CSV file is invalid, the Import button cannot be shown, and the Magento 2 Import Export Wishlist Item extension gives the admin a list of invalid data to edit again.
To check imported wishlists as well as products, you navigate to Customer→All Customers and select customers who have imported wishlist and go to WIshlist section in Customer Information.
How to Export Wishlist Items in Magento 2
Importing Wishlist Items becomes much more simple than Import because admin just needs to choose the way to import based on your demand. There are 4 options for admin to export: Export all wishlist items available on websites, export by customer email, product SKUs and customer group.
The extension will export your wanted data in a CSV file also and automatically download to your computer right after you click Continue button.
How Magento 2 Import Export Wishlist Item Works with Multiple Wishlists of Magento Enterprise?
When using multiple wishlists of Enterprise or Multiple Wishlists extension of Community, admin still follows the above instructions to prepare the CSV file and do Import or Export. The difference is that you need to complete wishlist name in the CSV file which is dependent on each customer. Each of them can have one or more wishlists. Therefore, the admin will add wishlist names corresponding products customers already chose.
Magento 2 Import Export Wishlist Item extension is one of the best Magento 2 Import Export extensions developed by BSSCommerce. It contributes to helping store owners have a better experience when working with the backend and also bring more benefits for their business such as time, costs and human resources.