An Overview of Data Validation in Magento 2

What is Data Validation in Magento 2?

Data validation which can be understood as the checking process for all data before importing into store is completed to assure that the values are appropriate with the system database. To start Data Validation, in the admin homepage, click System, choose Import under Data Transfer, after that, Import field appears with Check Data button in upper-right corner, tap on that button and Validation is begun. During the process, all objects in the import file have to undergo five following checking factors:


The value of particular attribute have to be suitable with all of the requirements of the data type and column header match the equivalent attributes in the system database.

Complex Data

Verify values contained in a set, such as multiple select input or drop-down  type to ensure that all of them are defined.

Service Data

In service data columns, the values have to be persistent with standard in the system database.

Required Values

As for new objects, Data Validation does check the existence of required attribute values in the file but does not need to do with existing entities.


Data values in a CSV file are decided by comma, and text values are putted inside double-quotes. Verify separators and sets of quotes that insert character series to make sure that  all of them are correctly formatted .

Validation Result

After checking process, the result appears with three information below:

  • The number of objects verified
  • The number of invalid rows
  • The number of errors found

If the data is valid, you will see  “Import Success” message displays.

If the data is not valid, the description of each error comes out, please read and fix the problem in import file to reach a valid database.

Apperance of Data Validation Messages in Magento 2

Success Message

Success Import Message

Data Validation Data Validation Data Validation Data Validation

Some errors in import file 

In short, here are all the details and reviews about  Data Validation we want to share with you. If you find it helpful for you, please Like, Share and Subscribe to keep updating for more upcoming blogs!

A Basic Guide to Importing Product Images in Magento 2

An introduction of Importing Product Images

In Magento 2, users can upload a large amount of product images which are associated with specific product as know as Importing Product Images.  Each product image owns particular link and file name to easy to be entered in the CSV file and the image files are uploaded to the equivalent link on the Magento server or external server.

The directory structure of product images is created and arranged alphabetically. When you export product data including images that already exist in the system to a CSV file, you can see the file name of each image comes out with alphabetized link. Nevertheless, if you import new images into CSV files, Magento will create the directory structure automatically so you do not need to designate a link for each image yourself.

In order to  upload images, firstly, you have to login confirmations and right authorizations to connect to the Magento folder on the server. Moreover, you can use any SFTP service to upload the files from your computer to the server as long as the attestations are all accurate.

Before trying to import a large quantity of images, you should check all the steps in the import way that you intend to use and run through the process with some sample products . After you check and confirm that everything is fine, continue to import a large amount of images.

Below there are two methods to import image into Magento 2: import images from the Local Server and import images from External Server.

Method 1: Importing Product Images from the Local Server

  1. Firstly,  upload the image files to the default folder for importing product images on the Magento server: /pub/media/import.

Furthermore, you also can use another folder to upload images on the Magento server with warranty that during the import process, the link to the folder is totally specified.

  1. In the CSV data, enter the name of each image file which is designed to be imported on the right row by SKU and in the right column according to image type such as base_image. small_image, thumbnail_image and additional_images.

Remember that do not insert the link before the filename in the CSV data for images in the default import folder (/pub/media/import) and the CSV file compulsorily contains the SKU column and the related image column.

Importing Product Images

  1. Select the file to import and enter the relative link following Image File Directory: /pub/media/import

Importing Product Images

If you want to import more than one image for an individual SKU, you need to add an empty row under the SKU and enter the additional image file’s names in the suitable columns. The additional rows are considered to belong to the parent SKU.

Method 2: Importing Product Images from External Server

  1. On the external server, upload the images which are chosen to be imported to the specified folder
  2. In the CSV data, fully input each image file’s URL in the exact column by image type including base_image, small_image, thumbnail_image and additional_images.

For example:

  1. Follow the guidance to finish importing data.

So, that is all the knowledge of Importing Product Images we want to share. If you find it helpful for you, please Like, Share and Subscribe to keep updating for more upcoming blogs!

10 Things about Admin Sidebar in Magento 2

The sidebar is designed for both desktop and mobile devices for the purpose of navigating and managing the store. In this paper, we will take a closer look at components of Admin Sidebar in Magento 2.

The Admin sidebar is located on the left of the page and known as the main menu of your store’s admin. This flyout menu helps you control and operate your store effectively on a daily basis.

1. Dashboard

When you sign in to the Admin, the first page you can see is the dashboard giving the overall view of sale and customer activity. The dashboard is the default first page for the admin but you can also alter the configuration to present another page when logging in.


2. Sales

In Sales menu, there are selections as different steps in the cycle of an order consisting of orders, invoices, shipments, credit memos, billing agreements and transactions so that the admin can manage them at any time.


3. Products

The Products menu supports admin in product creation, category and inventory management along with tools to control the content of catalog.


4. Customers

You can manage customer accounts and view who is currently online in your store with the Customers menu. Choosing All Customers if you want to have detail information about clients or selecting Now Online if you need to know customers who are online.  


5. Marketing

The Marketing menu allows you to manage markerting tools including promotions, communications, SEO & search or user content.


6. Content

With the Content menu, you can manage the content elements and design of the store. It consists of creating pages, blocks and frontend apps or controlling your store display.


7. Reports

In the Reports menu, you will have insight into aspects of your stores comprising marketing, sales, customers, reviews and products. About marketing, you can view products in cart, search terms, abandoned carts or newsletter problem reports in detail. Moreover, orders, tax, invoice, shipping and more can be supervised in sales as well as order and new accounts report are listed in customers section so that you can manage them effectively. In terms of products, you can see reviews and other necessary information about products such as view or bestsellers.


8. Stores

The Stores menu helps you manage the store hierarchy, configuration, sales and order settings, tax and currency, product attributes, product review ratings, and customer groups.


9. System

The System menu supports you in importing and exporting data via data transfer, setting up extensions, managing system caches and indexes, permissions, backups, system notifications or custom variables.


10. Find Partners & Extensions

This Magento marketplace allows you to have knowledge of platinum partners of Magento or search other partners by visiting the Magento Partner Directory. You can also find solutions for your store with extensions and themes which are essential components of the Magento Ecosystem.


We hope that you have collected helpful information by reading this article. If you have any question, please feel free to contact us.