Monthly Archives: July 2021

How to Import Disabled Products to Magento 2

- Fire development, Magento 2

Magento 2 import export debug log

If you cannot import disabled products to Magento 2, you’ve come to the right place. We will probably help you with that. Below, you will find two possible solutions. As usual, one of them is proposed by a StackExchange user, while another one is developed by Firebear specialists. In both cases, we deal with products that have the “disabled” status. As for the corresponding import file. It doesn’t contain the “status” column. If you add it, nothing changes. So, how to import disabled products to Magento 2? You will find the answer below. We also provide recommendations on how to import disabled products to Magento 2 automatically and via various file formats using Improved Import & Export. For more tips, proceed to our Magento 2 Cookbook.
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 Export Products from Magento 2 via CLI

- E-Commerce, Magento 2

Magento 2 export CLI

Although most Magento 2 administrators prefer working with their e-commerce website strength in the admin area, there are still many people who require the same management opportunities to be implemented with the command line interface. However, the default data transfer solutions of Magento 2 don’t let you do that. Both import and export tools are useful only for basic purposes. If you want to export products from Magento 2 using the command-line interface, you need a third-party solution. In the following material, we describe how to transfer data via CLI from your e-commerce website with the help of Improved Import & Export. Besides, we shed light upon the corresponding data import processes. You can find more tips on how to work with Magento 2 in our Cookbook. To make the long story short, let’s focus on how to import and export products and other entities in Magento 2 via CLI.

Continue Reading

SAP Business One In-Depth Review: How to Use the Wizard to Execute an MRP Run in SAP Business One

- E-Commerce

sap business one tutorial

In the previous two articles about SAP Business One, we explain what MRP is and how to prepare for a new MRP run in SAP B1. With an accurate model of your business in place, you can leverage the potent tool to figure out how to get the materials you need, making or selling products in time. In the following article, we shed light on how to use the Wizard to execute an MRP run in SAP Business One and how to work with the provided data.  

The blog post describes a basic MRP run in SAP Business One for a multilevel bill of materials. It focuses on the core steps of this process: selecting a scenario for your MRP run, choosing items, specifying inventory data sources, providing documents, executing the MRP run, and taking action. Besides, you will find out what consuming forecast and order consolidation are.

Continue Reading

Amasty Export Orders Extension for Magento 2 and 1

- E-Commerce, Magento 2, Magento tips & tricks

Amasty Magento 2 Order Export module review

If you are looking for the most powerful migration tool for Magento 2 or Magento 1, check out our Improved Import Magento 2 Extension and Improved Import Magento Module.

The Magento marketplace also offers alternative solutions for improving the default Magento import/export process. In this post, we shed light on the Magento 2 Export Orders extension by Amasty. This tool offers only export features but does everything quite well. Also, note that we’ve compared the Amasty Magento 2 export orders module with other similar extensions here: Magento 2 Order Export Extensions Comparison.

The best Magento 2 extensions | The best Magento extensions

Continue Reading

How to export custom SKU column from Magento 2 with all content

- E-Commerce, Magento 2

Magento 2 export CLI

How often do you face export processes that the default Magento 2 instruments cannot cope with? We regularly witness the inability to run even the most basic tasks, not to mention unique use cases that require additional customizations. For instance, we’ve come across a situation when the default export solution of Magento 2 wasn’t enough to transfer a custom SKU column. What’s the story behind this use case?

 Paras Sakariya has added a custom SKU column to a sales order grid. While the corresponding records appear on the backend side, no data is displayed in exported files. Below, explore this situation, providing possible resolutions. Firstly, we focus on the origins of the issue, describing the newly created custom conditions. After that, you will find a solution proposed on StackExchange. However, it is quite complicated and requires lots of technical knowledge. Therefore, we provide our own way to export a custom SKU column from Magento 2 that incorporates the Improved Import & Export Magento 2 extension. You can find more similar issues described in our Cookbook.
Continue Reading

How to import data from external MySQL database to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 mysql data import

Often it is necessary to import products, customers, orders, or other data types to Magento 2 from a third-party MySQL database. However, Magento 2 doesn’t let you do that. Although the default tools don’t support such file sources as external databases, there are several ways to synchronize Magento 2 with external databases. 

In the following post, we shed light on how to achieve this goal in two different ways. Firstly, we describe a common approach that involves the default Magento 2 import solution. It requires tons of manual work and cannot be automated. You need to run a CSV export from your MySQL database, match third-party attributes to ones used in Magento 2, and import your MySQL table into your e-commerce website.

On the contrary, you will find out how to avoid numerous unnecessary chores while importing data to Magento 2 from a MySQL database. This approach involves the Improved Import & Export extension. The module combines MySQL database connection and other data import activities within a single interface right in your Magento 2 admin.

After that, we shed light on several MySQL facts as well as describe the core features of the Improved Import & Export extension. To make the long story short, let’s see how to import data from an external MySQL database to Magento 2.
Continue Reading

Amasty Magento 2 RMA Extension Review

- E-Commerce, Magento 2

Amasty RMA Magento 2 Extension Review; Amasty RMA Magento 2 Module Overview

We’ve already reviewed RMA modules for Magento 2 by Mirasvit and aheadWorks. Today, we will draw your attention to the corresponding solution by Amasty – Magento 2 RMA extension. The module provides merchants with advanced settings that enable them to create a return policy in line with their business requirements. The Amasty solution significantly improves customer experience on an online store by making the product return process faster and more comfortable. At the same time, it reduces the workload for store managers by automating the RMA procedures. Below, we explore the core features and configuration of the Magento 2 returns management module in closer detail. Continue Reading

SAP Business One In-Depth Review: How to Prepare for an MRP Run in SAP B1

- Uncategorized

sap business one tutorial

In the following article, we continue our exploration of the SAP Business One MRP. Recently, we’ve defined the material requirements planning of SAP B1. Below, we describe how to prepare for the corresponding processes that take place in the ERP system. As you’ve probably guessed already, much of the preparations for an MRP run in SAP Business One take place through the normal routine of using the system. Initially, you need to prepare master data for such areas and entities as items, inventory, purchase orders, production orders, sales orders, bills of material, forecasts, etc. Next, keep all the related information up to date, and MRP will gift you with an accurate view of your requirements. Continue Reading

Magento 2 Admin Permissions Extension by Mageplaza 

- E-Commerce, Magento 2

magento 2 admin permissions extension

To support store management, Mageplaza has launched Magento 2 Admin Permissions extension that assists in assigning permissions for different store admins suitably. 

When admin roles are separated, the risks and problems related to store management will be mitigated. Moreover, each admin can concentrate on their permission and allowed actions, which help them focus on and complete their tasks better.  Continue Reading