magento 2 Magestandard

Four Simple Steps to Complete Import Data in Magento 2

Import Data in Magento 2 allows users to add the data of product, customer, customer address, and product image into the store under three supports of import in Magento 2: Add/Update, Replace Existing Complex Data and Delete Objects. To learn exactly the way to import a CSV file in Magento 2, please take attendance on fours simple steps that we show below.

Step 1: Arrange the Data

Open the admin homepage, click System on slidebar. Then choose Import under Data Transfer field.
After that, Import Settings field firstly comes out , choose one of five options including Advanced Pricing, Products, Customers and Address, Customers Main File and Customer Addresses for Entity Type.

After that, click Download Sample File and open it. The Sample file recommends structure of a standard import file.
Prepare your CSV import file, make sure that it meets requirements following the sample file and it’s size does not exceed the limit shown in the message.
When you desire to add links to product into the import data, you might upload the image files to the correct location. By default, location on the Magento server is: pub/media/import.

If the image locate on an external server, ensure to give the full URL to the directory including the images.

Step 2: Set the Import Behavior

Select Import Behavior you want with one of the following:

Add/Update
Replace Existing Complex Data
Delete Entities

Fill number of errors to halt import process in Allow Errors Count field
Accept the default value of a comma (,) for Field separation and Multiple value separator. Because, in a CSV file, a comma is fixed as a default separator. If you are in need of using another character, the data in the CSV file must match the character that you designate.

Step 3: Identify the Import File

Click Choose File button to select the file to import.
Select CSV file you want to import and tap Open
If the import data contains links to product images, fill the link to the uploaded images on the Magento server or the full URL to the images on another server on Images file Dictionary field.

Step 4: Check the Import Data

Click Check Data button in the upper right corner.
The validation process takes a few minutes to complete. Then, you will see import success message if the import data is valid.
Tap Import to continue if the file is valid or correct all errors with description in the messages and try to import file again.
The import process works till the end of the data. If an error message comes out in the Validation Results, try to fix and import again.

A message appears when the import is totally completed.

After finishing data import into the store, all of the information about import process will be fully maintained in Import History field with the start date and time, user, execution time and a link to the import file.

To view the import history, please open Admin homepage, click System on slide bar, then under Data Transfer, choose Import History and the record of data will display after that.

If you find it helpful for you, please Like, Share and Subscribe to keep updating for more upcoming blogs!

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:

Attributes

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.

Separators

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 Import Message

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

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.

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.

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

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

On the external server, upload the images which are chosen to be imported to the specified folder
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: http://example.com/images/image.jpg

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!

Quote Lifetime for Your Product Price in Magento 2

It is common that the Product Price can vary relatively after a period of time. For example, it may cost more money to buy a swimsuit in summer than it does in winter, because of higher demand. Therefore, online store owners need to set a fixed number of days (or months) for an item’s price. How long a price is valid can be set by using Quote Lifetime setting in Magento 2.

To use Quote Lifetime in Magento 2, do as the following:

Go to the backend mode, click Stores on the Admin sidebar.
Choose Configuration under Settings.
On the left panel, expand Sales row. Click Check out after that.
Next, scroll down to the Shopping cart section. Set the Quote Lifetime as your preference.

The unit used here is days. Magento 2 set it to 30 as default.
You may need to clear the Use System Value checkbox before setting to a new period of time that your quote price is valid.

When you finish, click Save Config to save the change.
Configure Quote Lifetime

Now, let’s look at some more details about the example about swimsuit above. You may think that because July is the hottest month in the summer, the demand for swimming is extremely high, so that you want to raise the price a bit higher (about $20 per item) for this month. After 30 days, you may reset the price to adjust to the changing demand.

In order to set a lifetime of 30 days for the new price, you need to follow the steps above.

In the Quote Lifetime field, enter 30 to the box.
Or you can just mark the Use System Value checkbox to take the default number.
Lastly, save your change and go to your homepage to test the setting.

In short, here are all the details and reviews of Quote Lifetime for Product Price in Magento 2 we want to share with you. For the Magento developers, it’s our pleasure to receive your comment and recommendation on our FAQ extension list. If you want to add or erase any item in this FAQ list, feel free to contact us. Don’t forget to Like, Share, and Subscribe to Magestandard for more informative Magento extension review articles.

Better Manage Cart Sidebar in Magento 2 – Better Care for Your Customers!

The cart is put at the last step of a purchase, and it has a comparative impact on your customer’ buying decision. Properly configuring shopping cart sidebar can significantly make your customers be consistent with their purchases. In this article, you will learn how to manage the Cart Sidebar and offer assistance to your customers.

As a customer, you can see Cart Sidebar, or “mini cart”, by clicking on the cart icon in the upper right of the screen. It indicates a summary of items that you have bought, including product’s thumbnail image, unit price, and other information. By looking at this, you can manage your buying activities. In addition, it is especially useful in keeping you away from emptying your wallet, thanks to Subtotal index provided.

As an admin, you can configure Cart Sidebar to your preferences:

In the backend mode, select Stores on the left sidebar.

Next, choose Configuration below Settings.

Now you are in Cart configuration space. Expand Sales and pick up Check out to go to Cart Sidebar set up.

Rolling downward until you find Shopping Cart Sidebar. Here you have two tools to manage your Shopping Cart Sidebar:

Display Shopping Cart Sidebar: You can choose to display the “mini cart” to your customer view: unfill the Use system value box, then select Yes option. Or, you can hide the cart summary by tapping No option.
Maximum Display Recently Added: Allow the maximum amount of items that currently added by customers to be present. You can set this number as you like.

Click Save Configuration to save changes that you have made.

Now go to your online stores and show customers how thorough you care to them!

We have presented about Managing Cart Sidebar in Magento 2. We hope that this article can show you useful information to select the appropriate extension for your online shop. For the Magento developers, it’s our pleasure to receive your comment and recommendation on our FAQ extension list. If you want to add or erase any item in this FAQ list, feel free to contact us. Don’t forget to Like, Share, and Subscribe to Magestandard for more informative Magento extension review articles.