"E-Commerce"

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 export Magento 2 data to Google Sheets

- E-Commerce, Magento 2, Our extensions

Transferring data between Magento 2 and Google Sheets seems a very efficient and time-saving way of synchronizing your e-commerce website with external platforms and other online storefronts. However, Magento 2 doesn’t let you do that if you rely on its default tools. If you need to import data, it is possible to create a CSV output of a corresponding Google Sheets table and then import it to your store. For the export purposes, you need to generate the output from your website and then open it in Google Sheets. Thus, instead of spending less time on daily duties, you have to perform a time-consuming routine. Luckily, there is a better way of synchronizing Magento 2 and Google Sheets.

FireBear keeps building up Improved Import and Export with powerful updates. Stay focused as with version 3.3.0 of the extension we introduce a long-awaited export of Magento 2 data to Google Sheets. The feature implementation marks the completion of the full-cycle Magento 2 and Google Sheets synchronization project. Now you are able to both import and export files from the source and arrange a highly manageable workflow.

How to do so? Follow this guide to learn more. Below, you will find an overview of the Magento 2 Google Sheets integration project as well as the most frequent use cases. Next, we describe Google API configuration, including such aspects as API library installation, API connection establishment, enabling Google Drive API, generating a Service Account Key, configuring a Service Account, and sharing the corresponding Google Drive folder. After that, we proceed to the Magento 2 Google Sheets export procedure. Continue Reading

Inforca – A Magento 2 Agency with A Potential Of A Killer Whale

- E-Commerce, Magento 2

Let us introduce you to Inforca, a digital agency aimed at making the future of e-commerce beautiful and thriving. Although it is a relatively small company with 30+ clients served, Inforca has a portfolio full of nice and inspiring projects located mostly in Australia but also worldwide. Today, we announce our partnership with this digital agency. The company will rely on our Improved Import & Export extension as well as other tools and services to satisfy the business needs of e-commerce merchants all over the globe. Let’s say a few more words about Inforca. Continue Reading

Magento 2 Gift Card Extensions Comparison (Amasty, Aheadworks, Mageworx, Magestore, and M-Connect)

- E-Commerce, Magento 2

Magento 2 Gift Card Extensions Comparison

In our blog, you can find reviews on the five best Magento 2 gift voucher extensions. Below, we make their comparison. All reviewed Magento 2 modules – Amasty Gift Card, Aheadworks Gift Card, MageWorx Gift Cards, Magestore Gift Card, and M-Connect Gift Card – provide the ability to add a new product type to your ecommerce store – a gift card. Is the difference between the Magento 2 extensions that share similar functionality essential? You will find the answer below. Continue Reading

Amasty Custom Reports Magento 2 Extension

- E-Commerce, Magento 2

Magento 2 Custom Report Builder by Amasty

Collecting data related to store performance and customer behavior is very important for any ecommerce site. By analyzing information about your store visitors and their interactions with your website, you can better understand how to improve your products or services and where to reach your potential customers. If you run your business on Magento 2, the default reports available with the platform might not be enough for having a complete view of the efficiency of your operations.

Amasty offers a robust solution for complementing the missing features of basic reports – the Magento 2 Custom Reports extension. The Amasty module allows building various types of reports based on essential data and using them for comprehensive store performance analytics. Below, we provide an overview of the core features of the Amasty Magento 2 Custom Reports Builder.
Continue Reading

Magento 2 Gift Card Extensions

- E-Commerce, Magento 2

Magento 2 Gift Card Modules

In the following post, you will find the best Magento 2 gift card extensions available in the ecosystem. Many vendors are offering this functionality in their modules. Below, you can check the most reliable tools. For each Magento gift certificates solution, we provide an overview of core features. For further information, check the full review or proceed right to the official extensions’ pages. Continue Reading

MageWorx Gift Cards Extension for Magento 2 and 1

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

MageWorx Magento 2 Gift Card Extension

Offering gift cards on an online store is a great marketing solution that helps increase customer engagement and promote an ecommerce brand. Allowing online shoppers to buy and use gift cards and certificates will certainly generate extra profits, particularly during the holiday season.

With the help of the MageWorx Gift Cards Extension, you can make the gift-giving process more comfortable by introducing the ability to purchase gift cards right on your ecommerce website. The extension supports physical and online gift card types (we will describe them below), provides flexible pricing schemes & values, and offers full backend control. You can create an optimized and user-friendly gift-giving process on your Magento store by providing a wide choice of gift cards and pricing options.

The whole section of this post is dedicated to the module’s admin interface and sheds light on Magento 2 gift card configuration, but let’s have a look at the tool’s features first.

Continue Reading

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

- E-Commerce, Magento 2, Our extensions

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

How to fix the “URL key for specified store already exists” issue on Magento 2 import

- E-Commerce, Magento 2

Magento 2 export CLI

Let’s suppose that you need to import a product CSV file, that follows the Magento 2 requirements, to a new installation. What could go wrong? Unfortunately, several errors may occur when you do that, including “URL key for specified store already exists”. In the following article, we explore the issue on the example provided in a StackExchange discussion, where Zed Blackbeard argues that it is impossible to import products to Magento 2 due to the general system exception. Magento informs its administrator who runs the update that the URL key for the specified store already exists. After that, the system breaks the import. 

Below, you will discover the conditions that cause the problem. After that, the article provides several possible resolutions. To be more specific, we provide recommendations from the appropriate StackExchange discussion as well as deliver our approach that incorporates the Improved Import & Export extension. If you face other issues while using your Magento installation, you may try to find them described in this blog post: Magento 2 Cookbook.
Continue Reading