Magento 2 XLSX Export: Magento Export of Products to Excel Explained

- E-Commerce, Magento 2

Magento 2 export CLI

Below, we shed light on the Magento 2 Excel export. You will learn how to run Magento 2 XLSX data transfers although this file format is not supported by default. The default import and export capabilities of Magento 2 are fairly limited. Depending on the platform’s editions, they vary a bit but neither of the existing versions lets you work with Excel and its XLSX files. However, you can implement the missing functionality with the help of the Improved Import & Export extension. The following article depicts the Magento export of products to Excel using the XLSX format. 

Continue Reading

How To Import/Export Categories to Magento 2

Magento 2 Development

Below, you will find a brief description of how to import/export categories between two Magento 2 websites. Unfortunately, this functionality is not available by default. Magento 2 leaves you alone with a huge category tree. You either need to recreate it manually or rely on third parties. So, welcome to our Magento 2 categories import tutorial. We know for sure how to import and export Magento 2 categories most efficiently.

The Magento StackExchange discussion inspired this post: question by Rafael Corrêa Gomes; answer by KAndy. However, it is only a partial overview of the Magento 2 category import and export. A full-featured guide on how to import and export categories, with all attributes explained can be found here: Magento 2 Categories Import Guide. Continue Reading

Magento 2 Import: Basic Functionality, Drawbacks & Best Replacement

- Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

Managing your Magento 2 store’s products, customers, and other entities can be challenging. One essential feature that can help you cope with large volumes of data efficiently is the Magento 2 import. This guide will walk you through the basics of the Magento import, highlighting its key features and downsides. You will also find a step-by-step tutorial on how to import any supported entity to Magento 2 below. 

To make your import routine more feature-rich and potent, we propose an alternative to the default Magento 2 importer. The second part of our Magento 2 import guide compares the default import capabilities with the powerful Improved Import & Export Extension, introducing a way to address the downsides of the built-in tool. Continue Reading

Shopware 6 CLI: General Recommendations & Important Commands

- E-Commerce, Shopware

You can dramatically simplify your interaction with Shopware via the console by applying Shopware 6 CLI commands. The platform provides the ability to execute numerous functions with the help of commands. In some situations, such as the necessity to process large amounts of data, their use is the only suitable option.

In this Shopware CLI guide, we provide general recommendations on how to use the command-line interface with the platform. You will find a list of the most important Shopware 6 CLI commands explained and divided into groups. Other Shopware 6 tutorials and guides are available in our cookbook. Continue Reading

Magento 2 Shopping Cart Guide: Management Essentials

Magento Shopping Cart

The Magento shopping cart functionality has been updated multiple times. Every new version introduced vital improvements for both customers and store administrators. In the following post, we shed light on new Magento 2 shopping cart features, discuss the updated functionality, and provide hints on how to import and export Magento 2 shopping carts and all the related data within just a few clicks.

As a store administrator, you get the ability to manage the shopping carts of customers who are now online – a new feature that is explained below. Besides, it is possible to access the Magento 2 persistent shopping cart – a new term used to call abandoned carts – of a shopper who is not currently logged in.

In both cases, you can add and remove products, transfer items from customer activities, and create orders. As for the respective import and export processes, they are available via third-party software. In this article, we use the Improved Import & Export Magento 2 extension to show how to import Magento 2 shopping carts. Continue Reading

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

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 URLsAlthough 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

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