Magento 2 Administration Extensions

  1. Home
  2. Docs
  3. Magento 2 Administration Extensions
  4. Magento 2 Import Export Extension Combo
  5. User Guide

User Guide

Magento 2 Import Export extension combo frees yourself from all default Magento limitations. Every Import and export features now stays in one place and you can enjoy speeding up adding or getting data on your website.

I. Import by BSS 

Navigate to System ⇒ Import by BSS and select an Entity Type from the drop-down list. 

1.Import CMS Page

import settings

1.1. In Import Behavior

  • Import Behavior: There are 3 options for you to select.

+ Add/Update: This option allows administrators to add new CMS Page of the website. In addition, it also updates CMS Pages if these pages already exist in the database and have the same URL keys (identifier) as data in the CSV file.

+ Replace: The module will delete old CMS pages and then add new ones.

+ Delete: This option allows the system to get CMS pages based on URL keys in the CSV file, then delete pages which are available in the database.

Next, you select one option from the drop-down list to determine how the system operates when there are errors in the import process.

+ Stop on Error: the system stops importing when there are errors.

+ Skip error entries: the system skips errors and continues to import.

  • Allowed Errors Count: This setting allows you to choose the allowed maximum number of errors when importing. If the number of errors happening in the import process exceeds the maximum number you fill in this field, the system will stop importing.

1.2. CSV File Preparation

Before you import CMS pages via a CSV file, you need to prepare the CSV file with enough necessary information. You can download this CSV sample file by clicking Download Sample File. Then you open this file and fill in fields:

csv file preparation

1.3. In File to Import

After you have finished the CSV file, tab Choose File button to select the file to import.

1.4. Check Data and Import

After you select the CSV file, you need to click Check Data button to validate data before importing.

  • If your CSV file is free from errors, there is a message to notify validation results and Import button now appears to click.

validate results You click Import button to start importing CMS pages in the CSV file into Magento 2 website. There is also a notification about results of the import process.

  • If your CSV file includes errors, the Import button cannot be displayed for you to click and there is a notification about these problems.

2. Import Categories

IMPORT SETTINGS

2.1. In Import Behavior

  • Import Behavior: There are 3 options for you to select.

+ Add/Update: This option allows administrators to add new categories of the website. In addition, it also updates categories if these categories already exist in the database and have the same category _id as data in the CSV file.

+ Replace: The module will delete old categories and then add new ones.

+ Delete: This option allows the system to load categories based on category_id in the CSV file, then delete these categories which are available in the database.

Next, you select one option from the drop-down list to determine how the system operates when there are errors in the import process.

+ Stop on Error: the system stops importing when there are errors.

+ Skip error entries: the system skips errors and continues to import.

  • Allowed Errors Count: This setting allows you to choose the allowed maximum number of errors when importing. If the number of errors happening in the import process exceeds the maximum number you fill in this field, the system will stop importing.

2.2. CSV File Preparation

Before you import categories via a CSV file, you need to prepare the CSV file with enough necessary information. You can download this CSV sample file by clicking Download Sample File.

Then you open this file and fill in fields:

CSV FILE PREPARATION

  • category_id: Complete category id which is saved in the database.

+ Value of category_id to enter is a Natural number.

+ If you leave it blank, a new category is added.

+ If you enter a value that exists, the module will update data to the category with corresponding ID.

  • store_id: Store Id which is available in the store.

+ Value of store_id to enter is a Natural number

+ If you leave it blank, store_id will get the value of 0 (store _id=0). You don’t need to fill store_id when adding a new category.

  • parent_id: is an ID of the existing category in the database

+ Value of parent_id to enter is a Natural number.

+ If you enter the ID which does not exist, the module will notify as an error in the Check data process.

* Note: If you are using 1.0.1 version: In case you have to import a new parent category and new children category in the same CSV, take some notices as below:

+ In parent category: enter new category_id.

+ In children category: enter parent_id which is the same as new category_id of the parent category. As a result, children categories will be imported to the right parent category. In addition, after importing, IDs of parent category and children category can be different from new category_id which is entered in the CSV file.

  • path: This is the path from the root category to the current category.

+ path is a string of characters.

+ When importing, you don’t need to enter data for this column.

  • name: Name of the category.

+ If you leave it blank, the module will notify as an error in the Check data process.

  • description: Detailed description about the category.
  • custom_design: Enter ID of the theme used in the category

+ Value of custom_design to enter is a Natural number.

  • category_products: Enter SKUs of products assigned to the category. For group products, bundle products, and configurable products, you need to enter SKUs of parent products.

+ If SKU is wrongly entered, the module will skip this SKU and continue to import other SKUs.

+ If SKU has existed in the category, the module will skip this SKU.

+ If the SKU has not yet existed, the module will add it as a new one.

+ category_products has a format as SKU1|SKU2|SKU3.

*Note: You just can add new SKUs to the category in this column, but cannot remove existed SKUs from the category.

  • attribute_set_id: ID of attribute set.

+ Value of attribute_set_id to enter is a Natural number.

+ If you leave it blank, the module will take ID of the default attribute set.

  • position: Postion of the category in the parent category.

+ Value of position to enter is a Natural number.

  • url_key: URL key of the category.

+ If you leave it blank, a new URL key for this category is created based on its name.

  • url_path: URL path of the category.
  • image_name: Name of image file of the category. Category image should be uploaded to pub/media/catalog/category folder of Magento folder.
  • is_active: Enable the category.

+ You enter 0 or 1 for this column. If you enter 1, it means the category status is enabled.

  • include_in_menu:

+ You enter 0 or 1 for this column. If you enter 1, the category will be displayed in the menu.

  • display_mode: display mode of the category.

+ You can choose one of these values to enter: PRODUCTS, PAGE, and PRODUCTS_AND_PAGE.

  • page_layout: choose layout for the category.

+ Values of layout include: 1column, 2columns-left, 2columns-right, 3columns và empty.

  • custom_design_from: Time when custom design begins.

+ Standard format is: yyyy-mm-dd or yyyy/mm/dd

  • custom_design_to: Time when custom design ends.

+ Standard format is: yyyy-mm-dd or yyyy/mm/dd

  • default_sort_by: Select how to sort products of the category on the frontend. For example: sort by name, position, and price.
  • available_sort_by: Sorting type can be allowed to use in the category. They can be name, position or name or you can combine all of them.

+ Standard format is: sort1|sort2|sort3

  • is_anchor: You can enter 0 or 1 in this column.
  • custom_use_parent_settings: Select whether applying parent category’s settings or not.
  • layered_navigation_price_step:

+ value of layered_navigation_price_step is a decimal number.

  • custom_apply_to_products: You can enter 0 or 1 in this column.
  • If you want to use exported categories to import into another website with Delete import behavior, you need to remove rows of system root category (ID=1) and store root category in the CSV file because default Magento doesn’t allow you to delete root category.
  • If you want to import the whole category tree, you need to arrange parent category and children categories to the right order in the CSV file. The first is the parent category, and the next are children categories.

2.3. In File to Import

After you have finished the CSV file, tab Choose File button to select the file to import.

2.4. Check Data and Import

After you select the CSV file, you need to click Check Data button to validate data before importing.

  • If your CSV file is free from errors, there is a message to notify validation results and Import button now appears to click.

CHECK DATA AND IMPORT You click Import button to start importing categories in the CSV file into Magento 2 website. There is also a notification about results of the import process.

  • If your CSV file includes errors, the Import button cannot be displayed for you to click and there is a notification about these problems.

3. Import Newsletter Subscribers

Import Newsletter Subscribers

3.1. In Import Behavior

  • Import Behavior: There are 3 options for you to select.

+ Add/Update: This option allows administrators to add new newsletter subscribers. In addition, it also updates newsletter subscribers if these subscribers already exist in the database.

+ Replace: The module will delete old newsletter subscribers and then add new ones.

+ Delete: This option allows the system to get newsletter subscribers based on customer_ID in the CSV file, then delete items which are available in the database.

Next, you select one option from the drop-down list to determine how the system operates when there are errors in the import process.

+ Stop on Error: the system stops importing when there are errors.

+ Skip error entries: the system skips errors and continues to import.

  • Allowed Errors Count: This setting allows you to choose the allowed maximum number of errors when importing. If the number of errors happening in the import process exceeds the maximum number you fill in this field, the system will stop importing.

3.2. CSV File Preparation

Before you import newsletter subscribers via a CSV file, you need to prepare the CSV file with enough necessary information. You can download this CSV sample file by clicking Download Sample File.

Then you open this file and fill in fields:

CSV File

Field Format Meaning
ID Natural numbers ID number of the newsletter subscriber.
email Email Customer email – which is used to subscribe to newsletters.
type String Type of emails: customer or guest.
customer_first_name String The first name of the customer. For guests, enter “—“
customer_last_name String The last name of the customer. For Guests, enter “—“
status_id Natural numbers

+ Not Activated: Value = 2.

+ Subscribed: Value = 1.

+ Unsubscribed: Value = 3.

+ Unconfirmed: Value = 4.

(If you don’t enter the status or you enter the wrong value, the default value is 1).

change_status_at yyyy/m/d hh:mm:ss The time when customers subscribe to the newsletter.
web_site String Website where customers subscribe to the newsletter.
store String Store where customers subscribe to the newsletter.
store_view_code String Store view where customers subscribe to the newsletter. If you enter the wrong value, it is changed into Default.

3.3. In File to Import

After you finish the CSV file, tab Choose File button to select the file to import.

3.4. Check Data and Import

After you select the CSV file, you need to click Check Data button to validate data before importing.

  • If your CSV file is free from errors, there is a message to notify validation results and Import button now appears to click.

You click Import button to start importing newsletter subscribers in the CSV file into Magento 2 website. There is also a notification about results of the import process.

  • If your CSV file includes errors, Import button cannot be displayed for you to click and there is a notification about these problems.

4. Import Product Attributes

IN IMPORT SETTINGS

4.1. In Import Behavior

  • Import Behavior: There is 3 options for you to select.

+ Add/Update: This option allows administrators to add new attributes into the website. In addition, it also updates attributes if their attribute_codes exist.

+ Replace: This option allows administrators to add new attributes into the website. In case attribute _ codes in the import data match with attribute_codes of existing attributes, these attributes are deleted and new records are created using the CSV data.

+ Delete: This option allows administrators to remove attributes in case their attribute_codes exist.

Next, you select one option from the drop-down list to determine how the system operates when there are errors in the import process.

+ Stop on Error: the system stops importing when there are errors.

+ Skip error entries: the system skips errors and continues to import.

  • Allowed Errors Count: This setting allows you to choose the allowed maximum number of errors when importing. If the number of errors happening in the import process exceeds that maximum number you fill in this field, the system will stop importing.
  • Multiple value separator: Choose a character to separate data in a field column. In our CSV sample file, the vertical bar ( | ) is set up as default value.
  • Option value separator: separator between store view ID and values of attribute options.
  • Store view separator: separator between values of different store views.

For example:

a.png

4.2. CSV file preparation

Before you import product attributes via a CSV file, you need to prepare the CSV file with enough necessary information. You can download this CSV sample file by clicking Download Sample File.

Then you open this file and fill in fields:

csv file

Data Format Meaning
attribute_code A string of characters Required to enter data. Notify errors if you leave it blank.
attribute_set attribute_set1|attribute_set2…

+ When attribute_set of an attribute is left blank, this attribute is added as a new one which does not belong to any attribute sets or any attribute groups.

+ When attribute_set doesn’t exist in the database, a new attribute set is created.

attribute_group_name A string

The name of the attribute group to which the attribute is assigned after importing.

+ when you leave it blank, the attribute is added to the last attribute group of the assigned attribute set. + when attribute_group_name doesn’t exist in the database, a new one is auto created.

attribute_group_code   (not required): It is auto-created based on the attribute group name. If attribute_group_code is similar to attribute_group_code of an available group in the database, you will face an error.
is_global 0,1,2

0 ~ Store View

1 ~ Global

2 ~ Website If it is left blank or wrong, it auto turns 0.

is_user_defined 0, 1

0 ~ attribute is defined as system attribute.

1 ~ attribute is not system attribute. Admin can delete it.

is_filterable 0,1,2

Corresponding to the Use in Layered Navigation config in the StoreFront Properties tab of the attribute:

0 ~ No

1 ~ Filterable (with results)

2 ~ Filterable (no results) If you enter the wrong value, the config auto gets 0 after importing.

is_visible 0,1

Determines whether the attribute is visible in the grid or not:

0 ~ No

1 ~ Yes

is_required 0,1

Corresponding to the Value Required config of the attribute

0 ~ No

1 ~ Yes

is_visible_on_front 0,1

Corresponding to the Visible on Catalog Pages on Storefront config:

0 ~ No

1 ~ Yes

is_searchable 0,1

Corresponding to the Use in Search config:

0 ~ No

1 ~ Yes

is_unique 0,1

Corresponding to the Unique Value config:

0 ~ No

1 ~ Yes

frontend_class   Optional. Database value
is_visible_in_advanced_search 0,1

Determines whether the attribute is shown in advanced search or not:

0 ~ No

1 ~ Yes

is_comparable 0,1

Corresponding to the Comparable on Storefront config of the attribute

0 ~ No

1 ~ Yes

is_filterable_in_search 0,1 Corresponding to the Use in Search Results Layered Navigation config: 0 ~ No 1 ~ Yes
is_used_for_price_rules 0,1

Determines whether the attribute is used for price rules or not:

0 ~ No

1 ~ Yes

is_used_for_promo_rules 0,1

Corresponding to the Use for Promo Rule Conditions config:

0 ~ No

1 ~ Yes

sort_order Natural numbers Smaller value, higher priority
position Natural numbers The display position of the attribute in layered navigation.
frontend_input  

Corresponding to Catalog Input Type for Store Owner:

text – Text Field textarea – Text Area texteditor – Text Editor (from Magento 2.3) date – Date

boolean – Yes/No multiselect – Multiple Select

select – Dropdown, Visual or Text Swatch price – Price media_image– Media Image

wee – Fixed Product Tax (Notify errors and skip them when entering wrong values)

backend_type   Optional. Database value
backend_model   Optional. Database value
source_model   Optional. Database value
frontend_label label|store_code1:label|store_code2:label Label for the attribute, you can import label for many store views. (Notify errors and skip them when you leave it blank)
default_value String Default value for the attribute
apply_to simple|group|bundle|configurable|downloadable|virtual Determines product type which the attribute is used for
is_wysiwyg_enabled 0,1

Corresponding to the Enable WYSIWYG config:

0 ~ No

1 ~ Yes

is_required_in_admin_store 0,1

0 ~ No

1 ~ Yes

is_used_in_grid 0,1

Determines whether the attribute is used in the product grid or not: 0 ~ No

1 ~ Yes

is_visible_in_grid 0,1  
is_filterable_in_grid 0,1

Determines whether the attribute is used to filter in the product grid or not:

0 ~ No

1 ~ Yes

search_weight   Defines the weight of the attribute in search.
is_html_allowed_on_front 0,1

Corresponding to the Allow HTML Tags on Storefront config.

0 ~ No

1 ~ Yes

used_in_product_listing 0,1

Corresponding to the Used in Product Listing config:

0 ~ No

1 ~ Yes

used_for_sort_by  

Corresponding to the Used for Sorting in Product Listing config: 0 ~ No

1 ~ Yes

swatch_input_type Visual or text

Determines style of attribute having Catalog input type as select:

visual ~ attribute has visual swatch

text  ~ attribute has text swatch

attribute_options admin:Label;store_code1:Label1|admin:Label2 Example: admin:Hike;default:Hike default;test:Hike New|admin:Outdoor;test:Outdoor Test

Enters labels for the attributes with select type:

+ Admin ~ required

+ Store_code ~ not required.   (‘|’ is corresponding to the Multiple value separator. ‘:’ is corresponding to the Option Value Separator.)

attribute_options_swatchvisual admin:value1:type;store_code1:value2:type|store_code2:value3:type Example: admin:#000000:1|admin:#1857f7:1|admin:#945454:1|

+ Value: is the value of swatch (it can be the image link or color code).

+ Type: is specified in the database. 1 is corresponding to visual color type and 2 is corresponding to visual image type. For example:

+Visual color type: 0:#000000:1

+ Visual image type: 0:a/_/a.jpg:2

attribute_options_swatchtext admin:value1:type;store_code1:value2:type;store_code2:value3:type Example: admin:Swa:0;default:Swa1:0;test:Swa2:0|admin:Swa3:0;default:Swa4:0;test:Swa4:0|

+ admin: required to enter.

+ store_code1, store_code2: not required

+ Value: is the value of swatch.

+ Type: is always 0.

For example: 1:S:0;2:Small:0  

*Notes:

  • Your CSV file must include enough the number of columns like the sample file so that you can successfully import. (If the number of columns is greater or fewer than those in the sample file, the system will notify you about errors).
  • You can assign 1 attribute for many attribute sets in only 1 row in the CSV file. The format of the attribute set column is attributeSet1|attributeSet2|…
  • If you enter the wrong product type in the “apply_to” column, the value of this column is changed into NULL.
  • For columns with values as 0 or 1: if you enter the wrong value, the system will change into default value as 0.
  • For columns including multiple values, you need to add multiple separators in the end. For example: 0:KBowl1;2:Elongated;1:Allong|
  • You mustn’t leave backend_type column empty:

+ if backend_type is static, you need to create a column in the catalog_product_entity. If you don’t do this one, you cannot save attribute’s value when saving the product. However, it’s better that you shouldn’t select backend_type as static.

+ If backend_type is varchar, int, decimal, text, or data time, you can definitely save attribute’s value.

  • If your CSV file includes special characters that belong to your own language (in case you do not use English), you need to convert your CSV file to UTF-8 format. You can read the instruction HERE.

4.3. In File to Import

FILE TO IMPORT

After you finish the CSV file, tab Choose File button to select the file to import.

4.4. Check Data and Import

After you select the CSV file, you need to click Check Data button to validate data before importing.

  • If you CSV file is free from errors, there is a message to notify validation results and Import button now appears to click.

CHECK DATA AND IMPORT You click Import button to start importing product attributes in the CSV file into Magento 2 website. To check these imported attributes, you navigate to Stores → Products Attributes to see them in a grid view:

Products Attributes

  • If your CSV file includes errors, Import button cannot be displayed for you to click and there is notification about these problems.

*NOTE: You had better take a notice about these following issues in the CSV file which affect data checking.

  • Errors in the CSV file make you not successfully import:

+ Leave attribute_code as blank.

+ Enter the wrong Entity Type ID.

+ Enter a number of columns which are greater or less than those in the sample CSV file. (Please follow the sample file we provide you and don’t add more columns or remove).

+ Enter the wrong value in the”is_global” column. (Please remember the standard values just includes 1,2 and 3).

  • However, there some specific errors in your CSV file, but the system will skip and continue to import as well as still notifies you about problems. Let’s check these skipped errors as below:

+ Enter the wrong backend_type or frontend_input.

+ Enter the wrong attribute_code when you choose Import behavior as Delete.

+ Enter the different multiple value separator from the one set up in the backend.

+ Enter the wrong fomat in the “attribute_option” or “attribute_option_swatch” columns. When you are in this situation, your CSV file is still imported but it contains errors. Therefore, thank to notification about these errors, you can edit the file and also do it better for the next time.

*Tips

You can quickly import attributes with many options using source_model of attributes.

+ Create a source file in the module: Bss_ProductAttributesImportExport – this source file can be similar as the following file:

tải xuống.png The path is Bss\ProductAttributesImportExport\Model\Attribute\Source\Label. Enter this path to the source_model of the CSV file.

5.  Import Product Reviews

magento-2-import-export-product-reviews.png

Before you import product reviews via CSV file, you need to prepare a CSV file with enough necessary information. You can download this CSV sample file by clicking Download Sample File.

Then you open this file and fill in fields:

file-csv-magento-2-import-export-product-review.png

There are required data fields for you to complete such as review titles, review details, status, customer nicknames, product SKU and rating options.

If you don’t finish this information, you cannot import product reviews at all.

For Date: Follow the right format “dd/MM/yyyy HH:mm:ss“.

For Status: Enter Approved/ Disapproved. If you don’t enter the right format, status is automatically Disapproved after being imported.

For Rating options: fill in ratings for products with the format: “rating_code1:number, rating_code2: number, rating_code3: number”. For example: “Quality:5, Price:4, Service:4”.

(*Note: In case you enter a new rating code that is not available in Ratings section of the backend, you can still import reviews and this rating type is automatically created in the backend.)

For Type: there are 3 types – Admin, Customer, and Guest. If you don’t enter the right format, the module will change customer type into Guest or the review is created by a Guest.

For Customer ID: If you don’t enter customer ID or enter the wrong format, the module will change customer type into Guest.

For Store View Code: Fill in store view code.

*Note: If you want to import product reviews for multiple store views, just separate them by character | For example: default|eng

For Review ID:

  • You cannot import reviews if you enter the wrong format.
  • In case you leave Review ID of a review blank and all of its remaining data is not similar to those of the available reviews shown in the frontend, the module will add this review with a new Review ID. (If there are some similar data to those of available reviews, the module still adds this review with a new Review ID).
  • In case you leave Review ID of a review blank and all of its remaining data is the same as those of available reviews, the module will take it as an existing row.
  • In case you enter a Review ID that is similar to an existed Review ID, the module will automatically update the product review based on one review ID.
  • If Review ID is greater than the maximum review ID in the database, the module will atill add this new review.

For Store View Code: you enter the code of store view you want to add reviews into. If you enter the wrong format, the module will change into Default Store View.

*Note: The CSV file size does not exceed 2MB. When you finish the CSV file, just select it and click Import Product Reviews to import them into Magento 2 sites.

After you import the CSV file, there are messages to notify:

  • Successfully import with the number of inserted rows
  • The number of existing rows or invalid rows

After importing, you can manage these added reviews in:

  • Admin → Product page →Product reviews
  • Admin → Customer page → Product reviews
  • Admin → Marketing → User content → Reviews
  • Admin → Report → Reviews

*NOTE: You can also import product reviews by using this following method:

  • Upload the CSV file to “var/import/reviews” folder
  • Run this command in Magento root folder:

php bin/magento bss:reviews:import import/reviews/sample.csv

6. Import URL Rewrites

IMPORT SETTINGS

6.1. In Import Behavior

  • Import Behavior: There is 3 options for you to select.

+ Add/Update: This option allows administrators to add new URL rewrites into the website. In addition, it also updates URL rewrites if their request_paths already exist in the database.

+ Replace: If the request_path does not exist in the database, you are notified about this non-existence and the module will add a new URL rewrite. If the request_path already exists in the database, the module will delete old URL and add a new URL rewrite.

+ Delete: This option allows administrators to remove URL rewrite according to the request_path.

Next, you select one option from the drop-down list to determine how the system operates when there are errors in the import process.

+ Stop on Error: the system stops importing when there are errors.

+ Skip error entries: the system skips errors and continues to import.

  • Allowed Errors Count: This setting allows you to choose the allowed maximum number of errors when importing. If the number of errors happening in the import process exceeds that maximum number you fill in this field, the system will stop importing.

6.2. CSV file preparation

Before you import URL rewrites via a CSV file, you need to prepare the CSV file with enough necessary information. You can download this CSV sample file by clicking Download Sample File. Then you open this file and fill in fields:

the csv file

*NOTES:

  • Your CSV file must include enough the number of columns like the sample file so that you can successfully import. (If the number of column is greater or less than those in the sample file, the system will notify you about errors occurring).
  • It is unnecessary to enter target_path if entity_type is product, category or cms-page because target_path in these cases are automatically generated according to corresponding ID.
  • When you enter entity_type into the CSV file:

+ if entity_type is product: enter product_ID with category_ID that includes this product or you also don’t need to enter category_ID for the product.

+ if entity_type is category: enter category_ID.

+ if entity_type is cms-page: enter cms_page_ID. + if entity_type is custom: no need to enter ID but you have to enter target_path to redirect.

  • For current_request_path:  enter the current path of the product or category or you can enter a new path if you want to add a new URL
  • For new_request_path: enter the new path which replaces the current_request_path.
  • For target_path: enter the internal path that is used by the system to point to the destination of the redirect
  • For redirect_type: enter 0, 301 or 302. In case you enter the wrong redirect_type, it will be automatically changed into 0.

6.3. In File to Import

After you finish the CSV file, tab Choose File button to select the file to import.

6.4. Check Data and Import

After you select the CSV file, you need to click Check Data button to validate data before importing.

  • If your CSV file is free from errors, there is a message to notify validation results and Import button now appears to click.

validation results You click Import button to start importing URL rewrites in the CSV file into Magento 2 website. There is also a notification about results of the import process.

  • If your CSV file includes errors, the Import button cannot be displayed for you to click and there is a notification about these problems.

validation errors

7. Import Wishlist Item

magento-2-import-export-wishlist-item-import-settings.png

7.1. In Import Behavior

  • Import Behavior: There is 3 options for you to select.

+ Add/Update: This option allows administrators to add new items to wishlist of the website. In addition, it also updates wishlist products if these products already exist in the database and have the same user_email and product_sku as data in the CSV file.

For Configurable product: If configurable_product_info in the CSV file is the same as the configurable_product_info of an available wishlist item in the database, this wishlist item will be updated.

If user_email and product_sku in the CSV file are similar to user_email and product_sku in the database, but the configurable_product_info does not exist in the database, this item is still added as a new one into the wishlist.

For Grouped product and Bundle product: If user_email and product_sku of parent products in the CSV file are the same as these in the database, the group and bundle product in the wishlist will be updated.

+ Replace: The module will delete old wishlist items and then add new ones. + Delete: This option allows the system to get wishlist items based on user_email and product_sku in the CSV file, then delete items which are available in the database.

*Note: In case, you are using Multiple Wishlists, this option also allows the system to get wishlist items based on user_email, product_sku, and wishlist_name of each wishlist product.

Next, you select one option from the drop-down list to determine how the system operates when there are errors in the import process.

+ Stop on Error: the system stops importing when there are errors.

+ Skip error entries: the system skips errors and continues to import.

  • Allowed Errors Count: This setting allows you to choose the allowed maximum number of errors when importing. If the number of errors happening in the import process exceeds the maximum number you fill in this field, the system will stop importing.

7.2. CSV File Preparation

Before you import products to wishlist via a CSV file, you need to prepare the CSV file with enough necessary information. You can download this CSV sample file by clicking Download Sample File. Then you open this file and fill in fields:

magento-2-import-export-wishlist-item-csv-file.png

In the following image, you can know data fields in the CSV file and also their meanings.

2017-12-28_113834.png

*Note:

  • Your CSV file must include enough number of columns like the sample file so that you can successfully import. (If the number of columns is greater or less than those in the sample file, the system will notify you about errors occurring).
  • For Configurable products: the format of configurable_product_info is attribute1:value1|attribute2:value2.

+ attribute: is attribute_code of an option

+ value: is the corresponding value

For example: size:S|color Black (If one of the attribute codes is wrongly entered in the CSV file, you can still import and the system will skip this wrong attribute.)

  • For Grouped products: the format of grouped_product_info is product_sku1:qty1|product_sku2:qty2

+ product_sku: SKU of children product.

+ qty: quantity of the children product with corresponding SKU.

  • For Bundle products: the format of bundle_product_info is product_sku1:qty1|product_sku2:qty2

+ product_sku: SKU of children product.

+ qty: quantity of the children product with corresponding SKU.

7.3. In File to Import

After you have finished the CSV file, tab Choose File button to select the file to import.

7.4. Check Data and Import

After you select the CSV file, you need to click Check Data button to validate data before importing.

  • If your CSV file is free from errors, there is a message to notify validation results and Import button now appears to click.

Screenshot_1.png

You click Import button to start importing products in the CSV file into the wishlist of Magento 2 website. There is also a notification about results of the import process.

  • If your CSV file includes errors, the Import button cannot be displayed for you to click and there is a notification about these problems.

II. Export by BSS 

Navigate to System ⇒ Export by BSS and select an Entity Type.

You choose CSV in the Export File Format field.

1. Export CMS Page

In Filter Store: You choose Store or store view to export CMS pages.

In Exclude Entity Attributes: you can select which data to be excluded from the CSV file after exporting.

Export CMS Page

2. Export Categories

Export Categories

In Export Related SKUs: You choose Yes to export SKUs of products in the categories; otherwise, you choose No.

In Export By: You can select exporting all categories or export them by Store ID or Category ID.

3. Export Newsletter Subscribers

In Export By section: you can export all available newsletter subscribers by choosing All from the drop-down list or export them based on store IDs or Subscriber type.

Export Newsletter Subscribers

  • Export by Store ID:

Export by Store ID When exporting by Store ID, you need to select a store to export from.

  • Export by Subscriber type:

Export by Subscriber type

4. Export Product Attributes

Export Product Attributes

  • In Entity Attributes and Export

In Entity Type section: you can export all available product attributes by choosing All from the drop-down list or export each attribute set.

Then click Continue button to export chosen items in a CSV file.

*Note: The admin can export product attributes which are not assigned to any attribute sets. (Update from version 1.0.9).

5. In Export Product Reviews

Just click Export Product Reviews button to get a CSV file with all data of product reviews on the Magento 2 website.

6. Export URL Rewrites

export settings

In Export By section: you can export all available URL rewrites by choosing All from the drop-down list or export URL rewrites based on each attribute.

  • Export by Entity Type:

entity type export When exporting by Entity Type, you need to select all or which specific Entity type to export URL rewrites.

  • Export by Store View:

magento-2-import-export-url-rewrites-extension-export-store-view.png

When exporting by Store View, you need to select all or which specific Store view to export URL rewrites of this store view.

  • Export by Redirect Type:

export redirect types

When exporting by Redirect Type, you need to select all or which specific Redirect type to export URL rewrites.

Then click Continue button to export chosen items in a CSV file.

*NOTE: If your site includes more than 50,000 URL Rewrites, this extension will export into different CSV files and each file can contain a maximum number as 50,000 URL rewrites. Therefore, there are also many links for you to download.

7. Export Wishlist Items

In Export By section: you can export all available wishlist items by choosing All from the drop-down list or export them based on customer email or product SKU.

Screenshot_2.png

  • Export by Customer Email:

Screenshot_3.png

When exporting by Customer Email, you need to enter a specific email of a customer in Input Email.

  • Export by Product SKU:

Screenshot_5.png When exporting by Product SKU, you need to enter a specific SKU of a product in Input SKU. Then click Continue button to export wishlist items in a CSV file.

*Note: If you enter a customer email or a product SKU that is not available in the database, the system will export an empty CSV file. 

Was this article helpful to you? Yes No

How can we help?