"magento 2"

Magento 2 Mass Product Update: Bulk Price & Stock Update via Import & Export

- E-Commerce, Import / Export Cookbook, Magento 2, Our extensions

magento 2 mass product update

Running an e-commerce website is associated with regular updates: prices often change, you receive new items, stock levels vary, etc. You may spend considerable time altering all these indexes manually. However, it is possible to facilitate the common methodology most merchants rely upon. Below, we’d like to introduce you to the Magento 2 mass stock update. It’s a process that can help you optimize regular data updates that take place on your e-commerce website.  Below, we focus on two aspects: prices and stock levels. You will discover what the Magento bulk price update is. At the same time, the article will teach you to update Magento stock in bulk. We use the Improved Import & Export Magento 2 extension to mass update Magento 2 product prices and quantity (stock).

Continue Reading

Magento Marketplace Integration: How To Synchronize Magento 2 With Any Online Marketplace To Import/Export Product Data

- E-Commerce, Magento 2

Magento marketplace integration

Magento 2 is a reliable platform for building online storefronts and a fully-featured tool for connecting multiple branches of your business. However, a few manipulations are required to use your e-commerce website as a hub for omnichannel retail. This Magento marketplace integration tutorial explains how to make the multi-channel approach more affordable, using marketplaces like eBay, Amazon, and others in sync with your storefront. The following article sheds light on Magento 2 integrations with both online marketplaces and drop shipping platforms and price comparison engines.

First, we explore common issues associated with Magento 2 feed export extensions. After that, you will learn how the Improved Import & Export extension solves them and covers multiple Magento marketplace integration needs. This tool offers broad data feed management features and rich integration opportunities. 
Continue Reading

How to Import Images From an External URL in Magento 2

- Magento 2

Magento 2 Development; Magento 2 tutorial

The following article explains how to import images from an external URL in Magento 2. You cannot imagine an e-commerce website without product pictures. Uploading visual content elements, however, may be challenging. The more products you have, the more work should be done, especially when you upload each image manually.

Luckily, importing product images to Magento 2 with product data introduces a better way to fill your catalog with content. Instead of uploading pictures to your server and then providing their names during the import process, Magento 2 lets you import images from external URLs. Although this functionality is possible by default, there are several alternative ways to do so.

Below, we focus on the default approach and one of the alternatives. Let’s see how to import product images to Magento 2 using external URLs.  Check other useful tips here: Magento 2 Cookbook. Continue Reading

How to Get Attribute Values & Map Them During Import in Magento 2

- E-Commerce, Magento 2, Our extensions

magento 2 get product attribute value and map them

This Magento 2 tutorial explains how to get a product attribute value and map it to the one used in your website’s admin. You might have already faced numerous problems caused by attributes and attribute values that don’t follow the Magento requirements. By default, it is impossible to import them to Magento 2. It often happens when you migrate from Magento 1 to Magento 2 or import data from external systems.

Different systems have unique requirements regarding how information is stored in their databases. Therefore, you cannot transfer data between them directly. It is always necessary to apply changes to the output created beyond Magento 2 to run a successful import to your e-commerce website. This process is usually time-consuming: The more unsupported values your data file contains the more work has to be done. 

However, there is a user-friendly way of editing third-party data. Meet the Improved Import & Export Magento 2 extension. The module lets you get attribute values in Magento 2 and automate the attribute editing processes, freely importing data from external platforms to Magento 2. Below, we shed light on how to match third-party attributes and attribute values to the corresponding Magento 2 values during import. You will find a guide for the default Magento 2 import tool. After that, we provide a description of our approach that saves tons of time and lets you automate further data updates.
Continue Reading

How To Import Customer Passwords To Magento 2

- E-Commerce, Fire development, Magento 2

magento 2 change customer password in database

What if you need to transfer customer data to Magento 2 or change the customer password in a database? For instance, for the sake of data migration from Magento 1 to 2. You may try to use the default import tool to do that. However, it doesn’t let you move all the prospect-related information to your database. For instance, it is impossible to migrate customer passwords from external systems. Attempts to address this problem have been made utilizing numerous approaches. Below, we describe two of them. 

You will learn how to import passwords to Magento 2 from external systems by manually editing your data files. Alternatively, we describe how to import the existing customer data including passwords to your e-commerce website based on the Improved Import & Export extension. Thus, you will learn how to reset customer passwords in a database in Magento 2.

The problem is that the new platform version utilizes an updated algorithm for storing passwords. Hence, users claim that after migrating to Magento 2 from Magento 1, registered prospects have to re-enter their passwords on a new website. 

If editing passwords manually fixes the problem caused by Magento version discrepancy, Improved Import & Export dramatically extends the application sphere for customer data import. The module lets you transfer information about registered buyers from any external platform automatically with any number of unsupported attributes, including new customer passwords and the existing hash values of customer account passwords. For further useful tips, check our Cookbook. Continue Reading

How To Import Configurable Products To Magento 2

- E-Commerce, Magento 2

improved import and export - Magento 2 extension

It is not a problem to import a single product to Magento 2, since you have all the necessary tools under System -> Export. But if you need to move Magento 2 configurable product data from the old site, it may take a lot of time and effort, since in this situation the import procedure is much more sophisticated. However, it is still possible to import a configurable product with its simple products to Magento 2, and below we shed light on what is necessary for a successful import. Note that the following article only briefly describes the process. For further information on how to import configurable products to Magento 2, read this guide: The Complete Guide to Magento 2 Configurable Products.
Continue Reading

How to Import & Export Newsletter Subscribers in Magento 2

- E-Commerce, Magento 2, Our extensions

magento 2 import export newsletter subscribers

Today, we’d like to introduce you to the Magento 2 import export of newsletter subscribers. Suppose you run an online business with multiple newsletter subscribers but want to move to a brand new Magento 2 website (read about data migration from Magento 2 to 1). Of course, you would like to migrate all the existing newsletter subscribers to the new storefront. Magento 2, however, doesn’t let you do that with the help of its default import and export tools. Luckily, there is a solution that enables the desired functionality. Meet the Improved Import & Export extension. With its help, you will freely import and export newsletter subscribers in Magento 2.

In the following article, we focus on transferring newsletter subscribers to and from Magento 2. You will discover the conditions for importing subscriber data to your e-commerce website. Besides, we provide attributes associated with newsletter subscribers in Magento 2. And of course, there is a guide on how to import newsletter subscribers from Magento 1 to Magento 2. If you are going to migrate from your old e-commerce website to a brand-new one, you’ve come to the right place. The general details about Magento 2 newsletter subscribers’ import and export are also gathered below.
Continue Reading

How to Import & Export Data Between Magento 2 & Google Drive

- E-Commerce, Magento 2, Our extensions

Magento 2 Google Drive Import Export

Today, we are going to introduce you to the Magento 2 Google Drive integration. The following article sheds light on how to import and export entities between Magento 2 and Google Drive with the help of the Improved Import & Export extension. It explains how to synchronize Magento 2 and Google Drive. After that, we shed light on the general facts related to transferring data between our favorite e-commerce platform and the popular file storage.  Next, the material proceeds to the core steps of the integration preparation. You will discover how to install Google API libraries and get Google Drive API credentials.

After that, the article focuses on establishing the connection between Magento 2 and Google Drive. You will learn to configure a Service Account and share a Google Drive folder. The last chapters are dedicated to configuring import and export jobs for Magento 2 and Google Sheets integration and exploring use cases. Since the integration incorporates Improved Import & Export, you will also find its features described below.

Continue Reading

How to Run Magento 2 Import if Required Columns Are Missing

- E-Commerce, Magento 2, Our extensions

Magento 2 Import without Required Columns

Welcome to our guide on how to import data to Magento 2 if something is missing in a table. Below, we shed light on a very important aspect of every import process – columns (attributes) of an import file. What if your data table doesn’t contain one? By default, you face the inability to transfer the update to your Magento 2 website. Many different entities can be transferred into Magento 2, so you have to deal with various data depending on your particular business case. However, the absence of the smallest detail can ruin all your data transfer efforts. Especially if you use the default data transfer solutions. 

Luckily, we know how to prevent such issues. Meet the Improved Import & Export Magento 2 extension. With the help of this plugin, you can import data to Magento 2 if some required columns are missed. The following article describes this process. You can either manually add the necessary columns or automate the missed data addition using the module’s functionality. Besides, you will discover the required CSV file structure as well as core features of the Improved Import & Export Magento 2 extension
Continue Reading

Value For Status Attribute Contains Incorrect Value: How To Fix Error During Magento 2 Import

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

When you try to manage a standard import process in Magento 2, you may face lots of issues and inconveniences caused by the platform’s requirements and limitations. For instance, we’ve already described how to fix the ‘General System Exception Happened’ Error and eliminate it as fast as possible and with minimum effort. Today, we’d like to draw your attention to another problem that often occurs during Magento 2 import. Meet the ‘Value For Status Attribute Contains Incorrect Value’ error. The following article sheds light on how to fix it, prevent multiple import issues, and make data transfers more user-friendly. Note that we use the Improved Import & Export Magento 2 extension to solve the problem and prevent other inconveniences. Therefore, you will also find its features described in the following material. Continue Reading