"E-Commerce"

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

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

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

How To Import Customer Passwords To 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

Firebear Improved Import, Export & Mass Actions for Shopware 6

- E-Commerce, Our extensions

shopware import export plugin by FirebearBelow, we’d like to introduce you to our Shopware import plugin. Meet the Improved Import, Export & Mass Actions for Shopware 6. It is one of the ecosystem’s most fully featured and powerful data transfer solutions that offers lots of enhancements to the default import and export processes. Our Shopware import export plugin provides a straightforward way to connect your e-commerce website with different external platforms within and around the ecosystem, automating various routine processes. It introduces numerous integrations with other e-commerce platforms, tools, and service providers, including ERPs, CRMs, accounting, etc.

In the article below, we briefly describe the plugin’s key features. We explore import and export jobs, data transfer automation, mapping, and extended connectivity options of our Shopware 6 import & export plugin. After that, you will find a small description of the existing import & export solutions available in the Shopware marketplace along with the default data transfer capabilities of the platform.

Continue Reading

Shopware SAP Integration: SAP Business One Shopware 6 Connector by Firebear

Shopware sap business one connector

What do you know about the Shopware SAP integration? Probably, you are familiar with the fact that you cannot just take your Shopware 6 website and connect it to a random SAP product. However, we know the most user-friendly and intuitive way to create the SAP Business One Shopware integration.  

The Shopware 6 ecosystem of apps and tools is gradually expanding, introducing such handy solutions as SAP Business One Integration for Shopware 6 by Firebear Studio. In the following article, you will learn how to leverage the SAP Business One Shopware tandem with the help of this plugin. We are going to introduce you to the basic principles and features the SAP Shopware connector incorporates and illustrate its functionality. After that, we will focus on several common use cases for the SAP B1  Shopware 6 integration.  

Continue Reading

Shopify Sap Business One Integration Defined

Below, we’d like to draw your attention to the Shopify SAP integration. These days, many useful tools can help you simplify e-commerce duties, including various ERP systems, CRM platforms, accounting tools, etc. SAP Business One, of course, is on the list of the most powerful solutions. The Shopify SAP Business One integration, however, is not built into your admin by default. Therefore, you need to look for a reliable third-party solution. 

In this article, we are going to introduce you to one of the possible Shopify SAP B1 integrations, so that you can achieve your goals of connecting the data of these two platforms and improving the performance of your business operations. With the Firebear team and its Import & Export Tool for Shopify, you can carry out this process quickly and painlessly. Let’s go over all the integration features (both implemented and planned)

Continue Reading