Yearly Archives: 2021

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

How to Import Multiselect Attribute Values to Magento 2

- E-Commerce, Fire development, Magento 2

Magento 2 import export debug log

The default data transfer capabilities of Magento 2 still need various improvements, especially if you use the Open Source version of the platform. However, numerous community-based initiatives that tend to improve the basic functionality are at your service. They vary between coding tricks and standalone extensions. Depending on the complexity of your business, your technical skills, or the faced issues, you can select one that perfectly suits your needs.  What to do if you cannot find the solutions? Ask the community for support. 

Recently, we came across an interesting issue on Stackexchange. The author was wondering whether it was possible to create values for a multiselect attribute when uploading a CSV file. Below, we share two solutions: the community-based algorithm of addressing the problem and the Firebear-proposed tool. While the first one requires additional coding experience and is almost unreal to implement for non-technical users, the extension we offer is admin-friendly and intuitive so that anyone can use it to cope with the difficulties described below. 

To make a long story short, let’s explore the issue and describe how to import multiselect attribute values to Magento 2. More tips are available here: Magento 2 Cookbook.
Continue Reading

Magento 2 SecurePay extension by Mageplaza 

- E-Commerce, Magento 2

 

Magento 2 SecurePay extension

SecurePay is a widely-used gateway in Australia since 1999. Customers are provided with an additional payment way for their purchases. SecurePay supports popular card types in the world, such as American Express, Diners Club, Visa, Mastercard, JCB, and Bankcard. Hence, customers across the globe will feel convenient when using this payment gateway. 

Do you want to integrate SecurePay into your Magento 2 store? Mageplaza can help you. Now let us dive deeper into details to explore the SecurePay extension from the Mageplaza team.  Continue Reading