How to Import And Export Magento 2 Page Builder Data

- E-Commerce, Magento 2, Our extensions

Magento 2 Page Builder Data Import Export

In the following post, we shed light on what Magento 2 Page Builder is and how to import/export all the corresponding data. Unfortunately, you cannot transfer anything to/from the tool via default Magento 2 means. Thus, it is necessary to install a third-party extension. Below, we shed light on the most intuitive and easy to use solution, so you will discover how to import and export Page Builder-related information to and from Magento 2 most efficiently.

Magento 2 Page Builder

Since the 2.3 version, Magento 2 includes a powerful page builder. Being a part of the core code, it represents the standard functionality of the platform. With the help of the renewed CMS and Page Builder module, you can create and customize pages in the most intuitive way – no coding skills are required. You’ve been waiting for this feature so long, haven’t you?

Page Builder offers a vast variety of options providing you with the extended flexibility and multiple content types that can be modified. Customize everything from product pages to blog articles. And if you need to transfer the modified content to another system, continue reading this article – below, we shed light on how to do that in the most user-friendly manner, but let’s return to our mutton.

Let’s figure out why Page Builder is so crucial for your e-commerce storefront.

Drag and Drop Functionality

The first feature that dramatically simplifies the way you customize the frontend appearance of your store is the drag and drop functionality of Magento 2 Page Builder. Thus, the solution is much more oriented towards its users than the standard WYSIWYG editor.

Customize headers, images, products, and anything else within a few clicks using the intuitive drag and drop interface of Magento 2 Page Builder. With the release of 2.3, you get the ability to create more complex designs and better functionality without any help from third parties. Furthermore, neither your technical specialists and developers are necessary.

Grid System

A feature that is tightly combined with the drag and drop functionality is the grid system of Page Builder. It lets you divide any store page into various segments where you put content. You can customize the number and size of page cells applying any custom appearance for the frontend.

Visual Effects

Multiple visual effects are introduced in the admin section of Page Builder. It’s up to you to use them or leave disabled, but the tool provides several rich improvements to the way content is displayed on your website.

Flexible Integrations

Page Builder is wholly integrated with the standard Magento 2 functionality so that you can use the default features more intuitively. For instance, it lets you place images from the gallery within a few clicks selecting the best place on a page. Let’s see what other features are available at the moment.

Products

The ability to integrate products into other pages and elements is another essential addition to the standard functionality of Magento 2 introduced with Page Builder. As mentioned above, you no longer need neither technical specialists nor coding skills to improve the frontend appearance of your e-commerce website.

Blog posts and promotion pages offer features related to products integration. With the help of Page Builder, you only need to drag and drop products to the selected pages to provide store visitors with advanced shopping functionality. The need to write complex code to achieve the same goal is ultimately reduced.

Static Blocks

The static blocks integration represents the ability to add corresponding frontend elements to various store pages. As a result, the opportunity to apply any custom design to your website in the easiest and fastest way is at your disposal.

Third-Party Content

And products are not the only object of flexible integrations. Page Builder lets you embed an array of various third-party elements. For instance, you can effortlessly add YouTube and Vimeo videos or even Google Maps to product pages, categories, and blog posts. And there are multiple more elements to be explored.

Instant Preview and Schedules

When you’ve finished the backend configuration, Page Builder lets you preview the new appearance within one click. Hit the corresponding button to see how your customers will look at the changes. If something seems wrong at this stage, nobody can see it.

Furthermore, it is possible to schedule changes for a specific date. Going to create a new Halloween design in advance but want to apply the changes right on time? It is no longer a problem. Schedule the rebuild designed for October 31, and all the changes will be applied automatically.  

Conclusion

Does it mean that you should fire your technical specialist after 2.3 is released? We don’t think so since there are always some complicated tasks any drag and drop interface won’t be able to cope with. But for small and midsized merchants, Page Builder is a real budget and time-saver.

Technical Introduction To Magento Page Builder

If you are looking for a more in-depth exploration of Magento Page Builder, watch the following video. It describes various technical nuances of the tool.

Bluefoot CMS

Since Magento Page Builder is built on top of Bluefoot CMS, we should pay separate attention to this platform. By offering a powerful set of tools, Bluefoot helps you create and manage content on your e-commerce store. It covers a rich spectrum of content from product descriptions to blogs posts.

Bluefoot is perfect for all categories of Magento users: merchants, retailers, agencies, and developers. Its only aim is to empower Magento users to create fantastic content quickly and easily when you can completely avoid the need for other third-party platforms, systems, and specialists.

Design and create web pages the way you want them with the help of the following features:

  • Drag & Drop. You can completely replace the standard Magento WYSIWYG editor with a more user-friendly and powerful tool. BlueFoot incorporates a simple, intuitive drag and drop system developed to create complex designs and functionality without the need for technical expertise. You no longer have to be limited by the standard tool or the inability to afford third-party specialist: all the necessary improvements can be applied in a new and intuitive manner.
  • Extensibility. And you can achieve even more power due to the advanced extensibility of Bluefoot. If the tool lacks some features vital for your particular business case, any competent Magento developer can easily implement them. The same is about Magento Page Builder!  All code within Bluefoot is unencrypted, so feel free to apply any changes to its functionality.

Now, when you know what Magento 2 Page builder is and how it works, we can proceed to the main topic of this post:

How to Import And Export Data to/from Magento 2 Page Builder

Magento 2 mysql data import

As mentioned above, you need a third-party module to extend the default functionality of Magento to import/export Page Builder data. What tool do we recommend?

It is hard to find a reliable import/export solution that satisfies all business needs. The lack of a fully-featured extension motivated us to create our own solution, so meet the Improved Import & Export Magento 2 extension – your number one time saver when it comes to all possible data transfers. We will describe its features in more detail later, so let’s take a look at how to import and export Page Builder data.

The Improved Import & Export extension lets you transfer most Magento 2 entities including Page Builder data. If you don’t want to spend time on recreating all the customizations applied to your current store on a new one, give our module a try.

To import Magento 2 Page Builder data, follow these steps:

  • Go to System -> Improved Import / Export -> Import Jobs and hit the Add New Job button.

  • Configure General Settings and proceed to the Import Settings section. Here, you can select Page Builder data in the Entity drop-down.
  • When the job is configured, save it and run the update.

As for the Magento 2 Page Builder data export, the process is absolutely the same. You can configure it under  System -> Improved Import / Export -> Export Jobs.

Get Improved Import & Export Magento 2 Extension

Improved Import & Export Magento 2 Extension Features

Magento 2 oracle import

Now, let’s explore the Improved Import & Export extension and the way it simplifies the Magento 2 Page Builder data transfers. Let’s start with the automation of data transfers.

Automated Import & Export Processes

The Improved Import & Export extension offers two ways of automation. You can either create an update schedule or specify an event that is considered a trigger and launches a corresponding import or export process. Both features have a slightly different impact and implementation, so you can always choose one that is more suitable for your needs.

Schedules

The Improved Import & Export Magento 2 extension supports cron allowing you to create any custom update schedule on its basis. It is only necessary to apply its default syntax, but the option is not mandatory. If you don’t want to do that, there is an alternative solution. Select one of the predefined intervals, which are fully customizable as well.

Alternatively, our module allows creating profiles that have no schedules. If you don’t need frequent updates or a single data transfer is required, use this feature. Besides, you can leverage it for asynchronous updates.

At the same time, every profile can be launched manually despite any automation whenever you want. Thus, if a data update is provided with a delay, import it manually reducing the negative consequences caused by a too long wait.

Below, you can see how to create a schedule:

Events

As for another way of automation – events – the Improved Import & Export extension also offers several handy improvements. You can either select one of the system events or specify a custom one. After choosing a trigger, create conditions to make its work more precise and efficient. For further information about the feature, follow this link: How to Run Magento 2 Import or Export After Specific System Event or Process.

Advanced Mapping Features

Now, it is necessary to describe the core mapping features of our module. While the synchronization between Magento 2 stores is always seamless, the connection to external systems may be prevented by different attribute standards. Below, we shed light on how our module solves the problem.

Mapping Presets

The Improved Import & Export Magento 2 extension provides the ability to fix the issue within just a few clicks. To solve the problem of different attribute standards, you need to select and apply a preset related to your integration. Next, the plugin will analyze the input data matching all third-party attributes to the corresponding ones used internally.

You don’t need to do anything else except selecting the preset. The process takes a few seconds only. If you run through the default way of attribute editing, it is necessary to transfer data using files and edit their content manually, which is an extremely time-consuming procedure. But the Improved Import & Export Magento 2 extension lets you forget about sleepless nights of editing. Check the following gif image to see how fast the process is if you use our module:

Matching Interface

If there is no preset for your particular integration, contact us, and we will try to provide it as fast as possible. Alternatively, you can map attributes manually within a convenient interface. Everything is straightforward: select a third-party designation and specify the corresponding internal one in front of it. That’s it! The process looks as follows:

And don’t miss the opportunity to determine hardcoded attribute values. As you might have noticed, the grid above consists of three columns. The third one allows setting an attribute value so that all items related to the attribute get the specified designation.

Attribute Values Mapping

Another feature that is worth mentioning here is attribute values mapping. Although third-party attribute values don’t prevent import processes (but there are some exceptions), they require a lot of time for editing after the update is transferred.

With the Improved Import & Export Magento 2 extension, it is no longer a problem. The process is based on the same logic as the attributes matching described above and requires minimum time. Of course, it is not as fast as selecting a preset, but a way more quickly than doing everything in a data file or your admin.

Select a third-party designation and specify the internal one in front of it. Repeat the process for all third-party attributes. That’s it. For further information about the feature, follow this link: Attribute Values Mapping.

Attribute Values Editing

To increase the efficiency of the process above, we’ve also introduced the ability to edit attribute values in bulk. Leverage the following rules:

  • Add a prefix to multiple attribute values;
  • Add a suffix to several attribute values simultaneously;
  • Split multiple attribute values if they a stored merged;
  • Merge values that are divided into several parts.

Note that you can combine these rules as well as create special conditions to make their use more precise. The following article explains attribute values editing in more detail: How to Modify Attribute Values During Import and Export in Magento 2.

Category Mapping

And if you need to move product data from an external system to your Magento 2 store, you may face lots of different catalogs and categories unrelated to yours. Instead of spending hours of time on editing the occasionally modified catalog, match the external categories to the ones used internally right during the import process. The following gif image illustrates the procedure:

At the same time, it is even possible to create new categories on the fly. The process consists of two steps: select a parent category and specifying the name of a new one. Both features are described here: Category Mapping.

Attributes On The Fly

If your data file lacks attributes, create them on the fly. With the Improved Import & Export Magento 2 extension, you can specify parameters necessary to do that via the following general form:

Attribute|attribute_property_name:attribute_property_value|…

The full process is described in this article: Product attributes import.

Extended Connectivity Options

Although the data synchronization between Magento 2 and other platforms is based on data files by default, there are several more way of integrating your e-commerce store with other platforms if you use Improved Import & Export.

Multiple File Standards

The extension essentially increases the number of supported file formats. Magento is bound to CSV only. In its turn, our tool adds support for XML, JSON, ODS, and Excel. You can freely import and export data in these formats applying all the extension’s features.

Multiple File Sources

Since we are talking about file transfers, let’s see what file sources the Improved Import & Export Magento 2 uses. First of all, you can rely on the FTP/SFTP connection which allows leveraging a local or remote server as a point of transfers. The same functionality is possible with a Dropbox account.

When you want to transfer data to your website, a direct URL is enough. Specify a file address, and the extension will import it. It is also worth mentioning that Improved Import & Export unpacks compressed data automatically, so you don’t have to do that manually.

Alternative Ways of Import & Export

Besides, the Improved Import & Export Magento 2 extension lets you establish a direct API connection between your e-commerce store and other systems. It leverages REST, SOAP, and GraphQL standards to synchronize your website with any third-party platforms.

But there is one more alternative way of data transfers. The Improved Import & Export extension allows using various online sheets to create a bridge between your Magento 2 website and external platforms. Google Sheets, Office 365 Excel, and Zoho Sheet are currently supported. The Google Sheets integration looks as follows:

Magento 2 Google Sheet import

Watch the following video to see the extension in action:

Final Words

As you can see, the only possible way to import and export Page builder data to and from Magento 2 is represented by our extension. The Improved Import & Export module lets you achieve this goal is the easiest manner. Besides, you can use the extension to connect your e-commerce website to all possible external systems and platforms. For further information, follow the link below and contact our support:

Get Improved Import & Export Magento 2 Extension