"Improved Import"

Guide to Magento 2 Static Blocks

- E-Commerce, Magento 2, Our extensions

Magento 2 Static Blocks: create, import, and export

Below, we are going to discuss Magento 2 static blocks. It is hard to overestimate the importance of Magento 2 CMS pages for an average e-commerce website. They play a pivotal role in creating a unique and attractive storefront. Homepage, news blocks, promotions, and other store sections may incorporate CMS pages to deliver a more abundant shopping experience. Also, pages composed within the Magento 2 Page Builder are always associated with various CMS elements. Despite such frequent appearances, Magento 2 doesn’t let you import-export CMS elements: pages, blocks, and widgets. However, you can do that with the Improved Import and Export extension. In this Magento static blocks tutorial, you will learn how to import CMS blocks. We focus on such aspects as a proper import table and an import job that simplifies your daily chores.

Along with the step-by-step instructions, the article provides explanations of every static block attribute. Also, you will find sample files that you can use as a reference for your Magento 2 static block imports. We describe prerequisites for importing/exporting statics blocks in Magento 2. After that, you will learn how to transfer CMS blocks between Magento 2 websites. Additionally, we touch upon the topic of composing and editing static block tables.

Continue Reading

Magento 2 Advanced Pricing Import: Special Prices, Group Prices, Tier Prices & MAP

- E-Commerce, Magento 2

Magento 2 Advanced Pricing Import

Today, we are going to talk about the Magento 2 advanced pricing import. In this guide, we explain for types of advanced pricing in Magento 2: Special Price, Group Price, Tier Price, and MAP. You will find out how to get a sample Magento 2 advanced pricing CSV. Next, we describe attributes associated with advanced pricing in Magento 2. After that, you will learn how to import advanced pricing to Magento 2. We will explore two different use cases. Firstly, we will teach you how to import tier prices to Magento 2 as a separate entity via the default Magento 2 import. Next, you will master the Magento 2 advanced pricing import as a part of a product import procedure based on the Improved Import & Export extension.

Unfortunately, the default Magento 2 import tools only let you import products and advanced prices separately. It means that you need to upload one file with product data except for four types of advanced pricing provided via different spreadsheets. You must admit that it is not very convenient, especially when you move the entire catalog. To address this issue, we describe another procedure, involving the Improved Import and Export extension. With this tool, you can import both products and their advanced prices in a single file.

Continue Reading

How to disable products not available in an import file for specific Magento 2 websites

- Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

We’ve already explained how to update Magento 2 products that are not available in an import file. Today, we explain a more specific case: you will learn how to disable products that are not available in an import file. Moreover, there is a possibility to disable the on specific Magento 2 websites. Of course, you won’t be able to do that with the default Magento 2 import tool. You will need the Improved Import & Export extension to transfer the update as intended.  Continue Reading

Improved Import / Export Magento 2 Extension Manual

- Magento 2, Our extensions

In this article, we’d like to draw your attention to the Improved Import & Export Magento 2 extensions. The following blog post contains all the information about the data transfer module. Below, you will find the Improved Import & Export Extension manual that sheds light upon all the key aspects associated with the plugin. We describe its installation, configuration, and import/export transfers, teach you how to add a new import and export job, talk about import and export processes associated with different entities. You will also discover various nuances of running data transfers via CLI, automating processes, using extension customization endpoints, and performing troubleshooting. Various use cases and specific features are also described in the manual.

Improved Import and Export extension allows importing and exporting CSV/XML/JSON files with product data and product images to Magento 2. The files can be imported from a remote FTP/SFTP server, Dropbox, direct URL of a source CSV fileGoogle Sheets, etc.  In addition, the extension offers a dedicated category import from CSV files, import of attribute values and new attributes on the fly, import job scheduling with cron jobs, and other features.

Besides, you get advanced export capabilities, including order export and export jobs, with attribute and table field mapping.

Continue Reading

How to Import Data via SOAP API into Magento 2

Magento 2 SOAP API Data Import

Below, we shed light on how to enable Magento 2 SOAP API import. Unfortunately, this functionality is not possible by default, but you can add the missing feature to your e-commerce store with the help of a third-party extension. The following article sheds light on SOAP, compares it with REST, and offers a reliable tool for enabling the corresponding functionality for Magento 2. You can leverage the Magento 2 SOAP API import and export processes with the Improved Import & Export Magento 2 module

The following article sheds light on how to import data into Magento 2 via SOAP API with the help of our extension. We discuss how to enable the Magento 2 SOAP API import and what extra benefits you can get. If you are not familiar with what SOAP API is, we’ve also prepared a chapter that describes this standard. Besides, there is an FAQ section that provides answers to frequently asked questions about SOAP and Magento 2 import/export processes.
Continue Reading

How to Import Compressed Data (ZIP, TAR, TGZ) to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Compressed Data ZIP TAR TGZ Import

What if your partner provides a vital data update in a compressed file? Prior to importing it to Magento 2, you need to unpack the archive. Next, if a file stored there is not CSV, you need to run the conversion. Furthermore, if it contains unsupported attributes, you need to replace them with the ones used in Magento 2. All these actions consume tons of time. However, it is possible to automate them. 

The following article discusses two ways of importing compressed data to Magento 2. Firstly, we shed light on a common approach that slightly simplifies the algorithm described above. Secondly, you will discover an alternative solution that dramatically improves the corresponding admin experience. It not only enables the import of archives to Magento 2 but also supports many more file types and enables the import of third-party data to Magento 2. Below, you will find out how to import ZIP and TAR to Magento 2 with the help of the Improved Import & Export extension.

Continue Reading

How to import data from SAP ASE (Sybase) database to Magento 2

Magento 2 SAP ASE Sybase Data Import

What if a vital data update is stored within the SAP Adaptive Server database but you need to transfer it to your Magento 2 website? The default tools built into your e-commerce store are useless if you need to create a direct connection. The same is about most third-party tools. So, how to move the crucial information to your e-commerce store most efficiently? Below, you will find the answer. We describe a common way of importing SAP ASE bases into Magento 2 and then compare it with a more user-friendly approach.

The common way of moving SAP ASE tables into Magento 2 is a complex procedure that consists of several steps. First of all, you need to perform a CSV export from the Sybase SQL server. We describe this process in the dedicated step-by-step guide below. Next, you need to map third-party attributes to Magento 2 records. After that, it is possible to import an SAP ASE table into Magento 2. You will find the pros and cons of this approach below.

As for the easy way of moving Sybase SQL server bases into Magento 2, it is way more straightforward since it involves Improved Import & Export. You provide the connection parameters and configure other aspects of your data transfer. That’s it! Let’s explore each step of both procedures in more detail and compare two approaches side by side.
Continue Reading

Magento 2 Order Export Extensions Comparison (Amasty, Xtento, Wyomind, Commerce Extensions)

- E-Commerce, Magento 2

Magento 2 Order Export Extensions Comparison (Amasty, Xtento, Wyomind, Commerce Extensions)

Chances are, you are going to connect your Magento 2 store to an external platform that works with order data. It can be any service that simplifies the default ecommerce routine or adds some new possibilities. ERPs, CRMs, warehouses, dropshipping systems, or carriers may require this information. Unfortunately, it is hard to provide it unless you use a third-party Magento 2 module. Below, we compare four different Magento 2 order export extensions: Amasty Export Orders, Xtento Order Export, Wyomind Mass Order Export, and Commerce Extensions Import Export Bulk Orders. Besides, you can check our Improved Import Export for Magento 2, which also helps to achieve the same goal and provides dozens of features that are not available with the solutions mentioned above. Continue Reading

How to Import & Export Data from Office 365 Excel Online to Magento 2

Magento 2 Import Export Office 365 Excel Online

Do you use Office 365? Perhaps, your e-commerce partners do that? Anyhow, we have some good news for you: it is possible to connect Magento 2 to Office 365 Excel Online directly. By default, Magento 2 doesn’t provide this opportunity. Furthermore, it doesn’t offer support for native Excel files, but we know a reliable solution that enables the data import and export from Office 365 Excel Online in Magento 2.

In the following article, we briefly describe what Microsoft Office 365 Excel is. Consider it a reliable alternative to Google Sheets! After that, you will learn how to import and export data from Office 365 Excel Online into Magento 2. We describe the features of the Magento 2 Office 365 Excel integration and provide a step-by-step guide on how to import data from the popular service into your e-commerce website. In addition, there is a chapter that describes the benefits of this integration. 

The last section of the article is dedicated to the Improved Import & Export extension since it is the foundation of the integration. We describe such features as cron-based automation, mapping, supported file formats, and sources, as well as alternative ways to exchange data between Magento 2 and other systems.
Continue Reading

The Ultimate Guide to the Future of E-Commerce

ecommerce trends; digital sales; online shopping

E-commerce has seen steady growth for years, but after COVID-19 hit the world, online retails faced both new challenges and possibilities in developing their business. As a year after the start of the pandemic passed, the online sales landscape has changed dramatically. The avoidance of face-to-face contacts, store closures, and numerous coronavirus-related restrictions has forever changed customer behavior patterns. While the economy and society are undergoing a crucial shift, e-commerce merchants need to adjust their business strategy according to the new requirements.

Since more consumers turn to online shopping, digital transformation becomes inevitable for sellers who want to keep their business going and meet new customer demands. By adopting the latest technologies, implementing personalization techniques into the marketing strategy, and switching to more efficient supply chain practices, companies can achieve success in the upcoming years. To help you better understand in which direction to move and which activities to focus on, we’ve compiled a list of emerging e-commerce trends that are changing the business environment in 2021 and are expected to stay for the years to come. By understanding the expectations of a modern buyer and taking appropriate strategic actions a few steps ahead, it is possible to turn crisis times into an opportunity and ensure consistent business growth.

Continue Reading