Import/Export cookbook: How to automate Magento 2 product catalog update from Google Sheets, FTP/SFTP, Google Drive, OneDrive, Dropbox

Working with suppliers requires you to regularly update your Magento 2 product catalog with new prices, stock updates, and sometimes other relevant attributes. Store managers can spend a lot of time manually going product by product, spending their time and going attribute by attribute.

With Improved Import & Export extension for Magento 2 you can automate product catalog update tasks with cron scheduler and recurring import jobs, that automatically fetch the file with supplier updates from the source, and upload it to your store.

In the article below, I will give you step by step instructions on how to do it.

Continue Reading

MageMojo – Magento Hosting of Your Dream

- Uncategorized

For over a decade, MageMojo delivers the best hosting services to Magento users all over the globe. The company provides merchants, developers, and agencies with the most powerful, reliable, and feature-rich services via Stratus – a modern cloud-hosting platform from MageMojo. Here at Firebear, we were always impressed with what the company does. And now, we are happy to announce our partnership with MageMojo. 

While most of our readers are probably familiar with Improved Import & Export, SAP connector, and other tools and services that we provide to our partners, let’s say a few more words about MageMojo and its Stratus. Continue Reading

Import/Export cookbook: How to update Magento 2 product prices during import quickly, without editing the CSV table

If you are a dropshipper or want to follow the inflation and increase product prices for your whole Magento 2 catalog or a part of it, you can do it quickly with the Improved Import & Export extension.

Export product catalog and import it back with the Price Rules – a quick filter that allows increasing and decreasing prices by a percent or a flat value.

Continue Reading

Import/Export cookbook: How to update Magento 2 product price and quantity using import and export. HINT: it’s fast and easy

Improved Import & Export Magento 2 extension documentation is huge! I know. It is aimed to cover every aspect of the extension.

However, you do not need to read it all, or understand each and every attribute of every entity. In this article, I will show you how to mass update Magento 2 product prices and quantity (stock) using import and export procedures.

Continue Reading

SAP Business One In-Depth Review: Getting Started with SAP B1 Sales Opportunities

- E-Commerce

sap business one tutorial

As an e-commerce store owner, you always have to think about turning leads into sales. Consider this process the lifeblood of your company’s revenue stream. And luckily, SAP Business One has something special to let you leverage this process. The system lets you monitor all potential buyers as a whole sales stream but treat each lead as your only sale. SAP Business One provides vital information for reporting and analysis to empower you to achieve this goal. Furthermore, you get the ability to streamline such daily chores as calendar appointments, meetings, and email sending. Due to a tight connection between SAP B1 and  Microsoft Outlook, these daily tasks can be managed in both systems.

In this article, we describe tools associated with the SAP Business One sales opportunities. You will find out how to move a lead through all the sales stages in SAP B1. Also, we shed light on exploring your sales pipeline for both individual salespeople and the company as a whole. The system’s powerful reporting functionality delivers a 360-degree view of leads and customers. It also delivers the ability to manage sales quotations in Microsoft Outlook. Below, we shed light on how to track marketing deals that become your revenue stream.  Continue Reading

Leverage Magento 2 and Reach New E-Commerce Heights with Lumao

- E-Commerce, Magento 2

Meet the team of developers from France called Lumao. It gathers the best developers specializing in Magento 2. Being a certified Magento partner, the agency delivers the best coding experiences associated with the platform. And we are happy to announce our partnership with Lumao. The agency streamlines our Improved Import & Export along with other tools to integrate Magento 2 websites with any external systems in the most efficient and seamless manner. If you’re looking for a team of experts, you’ve come to the right place. Continue Reading

Cipher – Digital Craftsmen from Bangkok

- Uncategorized

We are glad to announce another digital agency that relies on our products. Meet Cipher – one of the rapidly growing IT companies of Thailand. Our partner started as a software development agency and became a significant market player in its country and the surrounding region. Its primary goal is to provide IT services to other businesses in Bangkok and beyond. As for Firebear’s role, we offer our Improved Import & Export along with other extensions to help Cipher streamline multiple complex integrations, synchronizations, e-commerce migrations, and numerous other processes associated with data transfers. Continue Reading

How to Import & Export WSDL Data to/from Magento 2

Magento 2 Development; Magento 2 tutorial

In the following article, we shed light on how to import and export data between Magento 2 and other systems using WSDL. Below, we define what WSDL is and how to manage it. You will find out the background of the Magento 2 WSDL import & export with the Improved Import & Export extension. Besides, we shed light upon the WSDL structure and elements, including the WSDL message part and port type binding. The benefits of WSDL are also listed below. And since the article described various data transfer processes based on the Improved Import & Export module, we also highlight the most important features of the extension. 
Continue Reading

How to fix store ID-related issues on Magento 2 import

- E-Commerce, Magento 2

Magento 2 export CLI

StackExchange teems with interesting and useful tips related to Magento 2. This time, we’ve dug up a discussion where the author named Jackson complains about store ID-related issues that occur in Magento 2. Let’s take a look at the problem and provide several possible solutions. Jackson points to a particular script used to import data from a CSV file. However, the use of ->setStoreId(0) causes an issue – two values for the same field in the database table occur. As a result, it is necessary to delete second values to enable changes on the frontend but it often leads to the incorrect display. How to address the problem? You will find out how to fix store ID-related issues on Magento 2 import as it is portrayed in the discussion. At the same time, we provide a reliable alternative based on the Improved Import & Export. Also, you will discover other improvements associated with the module.
Continue Reading

How to Export Products, Orders, Customers, & Other Magento 2 Entities to Remote FTP & SFTP Server

- E-Commerce, Magento 2, Our extensions

Magento 2 Development; Magento 2 tutorial

Unfortunately, Magento 2 doesn’t provide any opportunities to export products, orders, customers, or other Magento 2 entities to a remote FTP or SFTP server. You have to run a standard export procedure instead and transfer the output manually. Besides, it is impossible to automate this process. The system leaves you in a situation when it is necessary to repeat all its steps manually every time an update is required. Luckily, there is a better way of achieving this goal. As you’ve probably guessed, it involves a third-party solution. In our example, we use the Improved Import & Export Magento 2 extension to export products, orders, customers, and other Magento 2 entities to a remote FTP/SFTP server. It also lets you import all entities from this file source. Continue Reading