"improved import and export"

How to Create New Product URLs After Import in Magento 2

- Magento 2, Our extensions

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

How to Cache Imported Product Files in Magento 2

- Magento 2, Our extensions

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

How To Add Product Quantity To The Existing Value During Magento 2 Product Import

- Magento 2, Our extensions

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

How to Import Only Mapped Fields to Magento 2

- Magento 2, Our extensions

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 our Magento 2 Developer’s Cookbook.

Continue Reading

How to Resize Images after Import With Imagick (ImageMagick) for Magento 2

- Magento 2, Our extensions

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 our Magento 2 Developer’s Cookbook. Continue Reading

How to Remove Images From Magento 2 Directory After Import

- Magento 2, Our extensions

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

Advanced Shopify Export: How to Export Shopify Orders to Excel

- Our extensions, Shopify

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 Import & Export Tool for Shopify. 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: CSV or 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

How to Change Stock Status in Magento 2 Import When “is_in_stock” Is Missing

- Magento 2, Our extensions

You can easily change a product stock status in Magento 2 automatically by importing the update straight to your e-commerce website. But what if the “is_in_stock” column is missing or doesn’t contain any values? Use Improved Import & Export. Provide the update, and the extension will recreate “is_in_stock” values following the corresponding “qty” values automatically. So, when is_in_stock is missing in the import table, there is no need to create additional files or apply changes to the import table. Let’s see how to change a product stock status in Magento 2 when “is_in_stock” data is absent. Follow our Developer’s Cookbook for more useful tips on Magento 2. Continue Reading