In the following article, we explain how to update customizable options of simple products in Magento 2 using import processes. Although this process is quite complicated when it comes to the default means, the Improved Import & Export extension offers 100% support for customizable product options during Magento 2 import. You only need to enable the corresponding feature. We provide all the details below. Check our Magento 2 Developer’s Cookbook for more information. Continue Reading
If some of the imported products or categories are duplicated it may negatively affect your administrative routine, SEO, and customer experience. However, there is a possibility to address these issues even before they impact anyone. Meet the Improved Import & Export Magento 2 extension. We’ve already explained how to use the module to create SEO-friendly product URL patterns. However, it also includes another handy instrument that addresses the duplicate issue. The extension can generate unique URLs if it finds out that the imported products or categories have duplicated addresses. Go to our Magento 2 Developer’s Cookbook for more tips.Continue Reading
Chances are, you need to create unique URLs while importing products to your Magento 2 website to enhance SEO and reach more potential buyers. The default import process doesn’t let you apply changes to product data of this kind. You only need to create new SEO-friendly URLs manually or use an SEO tool that can help you replace the existing product addresses. However, there is a more user-friendly approach. The Improved Import & Export Magento 2 extension lets you create new product URLs after import due to the “Enable Product Url Pattern” parameter. In the following article, we explore the corresponding functionality. Go to our Magento 2 Developer’s Cookbook for more recommendations on how to improve your daily data transfers and other routine processes.Continue Reading
We’ve already described how to import 100,000 products to Magento 2 in less than an hour. However, you can speed up the import process even more by caching imported product files and using the cached data for further updates. Note that this functionality is available only in the Improved Import & Export Magento 2 extension. In the following article, we describe how this feature works. Next, you will learn how to cache imported product files in Magento 2 to speed up product updates. Follow our Magento 2 Developer’s Cookbook for more recommendations on how to improve your daily data transfers and other routine processes.Continue Reading
Imagine a situation when you need to upload a file provided by your supplier with the quantity of the products sent to your store. By default, Magento 2 will replace the existing quantity with the one specified in the import table. However, you need to ADD the provided new QTY value to the existing product stock. In the following article, we explain how to do that with the help of the Improved Import & Export extension. You will learn how to add product quantity to the existing value during Magento 2 product import instead of replacing it. Follow our Magento 2 Developer’s Cookbook for more useful tips.Continue Reading
In the following article, we shed light on how to import only mapped attributes to Magento 2 when you transfer a data update to your e-commerce website. By default, Magento 2 imports all the fields from the data file that follow the internal platform’s requirements. However, you can easily reduce the number of imported fields, transferring those matched to the internal Magento 2 records. This functionality is associated with the Improved Import & Export Magento 2 extension and its import jobs. Below, you will learn how to use the module to import only mapped fields to Magento 2. You will discover more tips like this one in ourMagento 2 Developer’s Cookbook.
In the following article, we explore how to resize product images in Magento 2 in the most user-friendly way. If you still reduce the size of high-resolution product photos manually before uploading them to your e-commerce website, you’ve come to the right place. We will teach you how to automate this process. Spoiler: you will need to install the Improved Import & Export extension and Imagick for Magento 2. If for some reason you still use product pictures as they are, you will find out why it is crucial to resize images in Magento 2. You can find more tips like this one in ourMagento 2 Developer’s Cookbook.Continue Reading
You’ve probably been in a situation when the Magento 2 directory gets full of unnecessary product images. Therefore, it is necessary to clear them manually from time to time. If there are several unnecessary files in the directory, it’s not a big deal. However, if you regularly import hundreds of products, deleting the corresponding images may consume much time. And, unfortunately, we don’t know any instrument that can clear your Magento 2 directory automatically. But you can harness advanced import processes to keep it clear. In the following article, we shed light on how to automatically remove product images from the Magento 2 directory after every import. For more tips like that, follow our Magento 2 Developer’s Cookbook.Continue Reading
Customer address duplication is not a major problem but if you update customer data frequently, it can clutter up your admin. However, you can use several tactics to avoid it. Below, we explain how to avoid customer address duplication during Magento 2 import by using Increment ID. For more tips like that, follow our Magento 2 Developer’s Cookbook.Continue Reading
In this article, we continue our exploration of the Shopify Excel integration. This time, you will learn the nuances of the Shopify to Excel export. At the same time, we explain another important topic – the Shopify export of orders. By default, this functionality is available in your admin but it’s fairly limited. However, you can easily extend it with the help of third-party apps, such as our . We explain how to export orders in Shopify below. Note that this is only one topic covered.
When it comes to the various file types, Shopify’s preferences are rather limited: CSVor CSV. You are restricted to this format and its modification. But what if you need to store exported data in the XLSX format? Fortunately, our Import & Export Tool for Shopify introduces a more streamlined solution. In addition to the default CSV imports and exports, it also supports a variety of other file formats, including XLSX. It means that you can easily create an output with Shopify customer, product, or order data suitable for Excel.
Below, you will discover how to export Shopify orders to Excel. We describe this transfer since it illustrates the integration opportunities associated with our module. But let us delve into the nuanced disparities between CSV and XLSX first. For further information on how to enhance your e-commerce routine, follow our Shopify Cookbook. So, how do you export XLSX from Shopify? Let’s find out!Continue Reading
