"import"

The Ultimate Guide to Shopify Import

March 19, 2024 - Our extensions, Shopify

Shopify import products, customers, inventory, orders

Every decent e-commerce platform offers built-in import and export tools. However, they are usually far from being an omnipotent solution that can cope with any business requirement. Because of this, agencies create third-party solutions that close the existing gaps between the platform’s objective reality and the merchants’ subjective needs. What about Shopify? What data transfer solutions does it offer? What reliable alternatives are currently available in the ecosystem?

In this Shopify import guide, you will find out what import functionality is hidden behind the platform and how to enhance it in the most user-friendly and, at the same time, powerful way. Let’s explore the system’s native capabilities first and then proceed to the most powerful third-party solution that copes with any data transfer challenges and enables any Shopify import customizations – the Import & Export Tool for Shopify.

Below, you will learn about the basic data transfer capabilities of Shopify: product import, inventory import, customer import, etc. You will learn how to transfer products to your e-commerce website using the platform’s built-in functionality. The article examines two different cases: importing products from another website and reimporting them within the borders of your store. In addition to that, we provide a CSV file structure required for this process. Next, we explore how to import inventory, customers, and orders to Shopify. After that, you will learn how our Import & Export Tool enhances the default data transfers. Also, don’t forget to check our Ultimate Guide to Shopify Export.
Continue Reading

How to Import Database in Magento 2

March 19, 2024 - Fire development, Magento 2

magento 2 import database command line

Recently, we’ve spotted a question on StackExchange regarding the Magento 2 database import. David Duong faced problems while transferring a database on Magento 2.3.3. Below, we shed light on the issue and the provided solution for Magento 2 to import a database via the command line. However, it is quite a complex process since the system doesn’t let you transfer a database to Magento 2 directly. You always need to create an output file that contains a particular entity. If your file incorporates several types of data (e.g., products and orders), it is necessary to split it into two separate tables.

Furthermore, you always have to edit attributes in the imported file to make them suitable for the Magento 2 requirements. Otherwise, the Magento import of a database becomes questionable. It is impossible to automate regular data transfers from a remote database to your e-commerce website. However, there is a tool that solves all these issues. After we describe a method provided in the StackExchange discussion, you will find out how to achieve the missing functionality with the help of the Improved Import & Export Magento 2 extension. For more tips and advice, read our Cookbook. Continue Reading

Guide to Magento 2 Search Terms & Search Synonyms: Management, Import & Export Recomendations

February 27, 2024 - E-Commerce, Magento 2, Our extensions

Today, we are going to explore two tightly connected topics – Magento 2 search terms and Magento 2 search synonyms. The platform lets you optimize customer search queries by composing lists of search terms and search synonyms. While it is possible to manage them manually in your admin, you cannot import Magento search terms. And there is no way to import search synonyms to Magento 2 with the help of the platform’s built-in instruments. This limitation may negatively impact the productivity of backend administrators since they need to spend a considerable amount of time updating Magento 2 search terms and synonyms instead of transferring the necessary data within a few clicks.

However, there is a tool that unlocks the missing functionality. Meet the Improved Import & Export extension. This module empowers you to import and export search terms and search synonyms to Magento 2. Below, we explain how to use the tool to transfer the corresponding entities to and from your e-commerce website. You will learn how import and export processes work and what attributes are involved in the import and export of search terms and search synonyms. But before going any further, let’s see what Magento 2 search terms and search synonyms are.
Continue Reading

Improved Import, Export & Mass Actions app for Shopware 6 user manual

February 26, 2024 - E-Commerce, Our extensions, Shopware

Improved Import, Export & Mass Actions is a powerful Shopware 6 app that you can install on your store to streamline the process of importing and exporting products and other entities. It allows you to efficiently transfer data in and out of your e-commerce website, ensuring that all necessary values are accurately handled. Whether you’re managing large inventories or complex data sets, this app simplifies the process, saving you time and reducing the risk of errors. Below, we explain how to use the tool for both import and export processes, working with different entities and types of data.

Magento 2 Tax Configuration: How to Add Tax Classes, Rules & Rates, Tax Rates Import & Export

February 20, 2024 - E-Commerce, Magento 2

Magento 2 Tax Configuration

Today, we’d like to draw your attention to the Magento 2 tax configuration. You will learn what the Magento 2 estimate shipping and tax feature is and how it works. Next, we move to the Magento 2 tax class configuration. You will learn how to add new tax classes. Besides, this section describes Magento 2 tax rules and rates. You will learn how to add them.

After that, we proceed to the Magento 2 tax rate export and import. You will learn how to compose a CSV with tax rates suitable for Magento 2. Importing taxes can save time when moving to another store, or migrating from Magento 1. We also shed light on a third-party tool that can help you automate this process.

FPT Tax: How to Add and Import Fixed Product Tax in Magento 2

February 19, 2024 - E-Commerce, Magento 2

FPT tax in Magento 2: create, configure, import

Today, we are going to talk about the FPT tax. You will learn what FPT or Fixed Product Tax is and how it helps Magento 2 merchants sell products to different countries and different states adhering to local tax regulations. This tax is added in a bit of a peculiar way which may not be as obvious at first glance as it seems. In this post, we cover everything you need to know about the FPT tax and describe how to import fixed product tax to Magento 2.

Guide to Magento 2 Static Blocks

February 13, 2024 - E-Commerce, Magento 2, Our extensions

Magento 2 Static Blocks: create, import, and export

Below, we are going to discuss Magento 2 static blocks. It is hard to overestimate the importance of Magento 2 CMS pages for an average e-commerce website. They play a pivotal role in creating a unique and attractive storefront. Homepage, news blocks, promotions, and other store sections may incorporate CMS pages to deliver a more abundant shopping experience. Also, pages composed within the Magento 2 Page Builder are always associated with various CMS elements. Despite such frequent appearances, Magento 2 doesn’t let you import-export CMS elements: pages, blocks, and widgets. However, you can do that with the Improved Import and Export extension. In this Magento static blocks tutorial, you will learn how to import CMS blocks. We focus on such aspects as a proper import table and an import job that simplifies your daily chores.

Along with the step-by-step instructions, the article provides explanations of every static block attribute. Also, you will find sample files that you can use as a reference for your Magento 2 static block imports. We describe prerequisites for importing/exporting statics blocks in Magento 2. After that, you will learn how to transfer CMS blocks between Magento 2 websites. Additionally, we touch upon the topic of composing and editing static block tables.

How to Import & Export Product Attributes for Magento 2

February 7, 2024 - E-Commerce, Magento 2

import export product attributes for magento 2

Do you know how to import attributes in Magento 2? It’s a complex process that covers not only product attributes but also attribute groups and attribute sets. In the following article, you will learn how to import and export product attributes for Magento 2 in the most efficient way. We discuss how the attributes behave and which values from an import table Magento 2 understands. Why is this topic important?

Well, it would be much easier if you could just import products, moving all the corresponding data in a single CSV. However, Magento doesn’t even support product positions in a category within a product CSV. Transferring products to Magento 2 is impossible without product attributes. They dictate which values the products have and which options and variations exist. That’s why having the ability to import product attributes is a must.

Since Magento 2 doesn’t let you import product attributes by default, we use the Improved Import & Export extension to manage all the processes. Below, you will find how the module works when it comes to the Magento 2 product attribute import. Note that it also supports the Magento 2 import of custom attributes. Below, we provide a table with product attributes and their descriptions to help you understand what’s going on in a CSV with attributes. Also, you will find a step-by-step guide to the import of attributes in Magento 2.

Magento 2 Categories Import & Export Guide

February 6, 2024 - E-Commerce, Magento 2

Today, we are going to talk about Magento 2 categories import and export. Unfortunately, the platform doesn’t let you import and export categories by default. Although its capabilities associated with data transfers are fairly limited, you can address the existing issues with Improved Import & Export. This extension provides the ability to import and export categories to Magento 2.

In the following article, we shed light on how to transfer an existing category tree to/from your e-commerce website using the Improved Import & Export Magento 2 extension. After describing the Magento 2 category export, we peruse a sample category CSV file. Then, our attention is focused on specific Magento 2 category attributes: we explore use cases and attribute mapping to let you transfer categories to Magento 2 from any external platform. Next, there is a detailed step-by-step guide that depicts Magento 2 categories import. Also, you will find out how to import product positions in categories (a part of the Visual Merchandiser functionality of Magento 2) and import Magento 2 categories per different store views. Let’s go!

Magento 2 Advanced Pricing Import: Special Prices, Group Prices, Tier Prices & MAP

February 5, 2024 - E-Commerce, Magento 2

Magento 2 Advanced Pricing Import

Today, we are going to talk about the Magento 2 advanced pricing import. In this guide, we explain for types of advanced pricing in Magento 2: Special Price, Group Price, Tier Price, and MAP. You will find out how to get a sample Magento 2 advanced pricing CSV. Next, we describe attributes associated with advanced pricing in Magento 2. After that, you will learn how to import advanced pricing to Magento 2. We will explore two different use cases. Firstly, we will teach you how to import tier prices to Magento 2 as a separate entity via the default Magento 2 import. Next, you will master the Magento 2 advanced pricing import as a part of a product import procedure based on the Improved Import & Export extension.

Unfortunately, the default Magento 2 import tools only let you import products and advanced prices separately. It means that you need to upload one file with product data except for four types of advanced pricing provided via different spreadsheets. You must admit that it is not very convenient, especially when you move the entire catalog. To address this issue, we describe another procedure, involving the Improved Import and Export extension. With this tool, you can import both products and their advanced prices in a single file.