In the following article, we shed light on what Magento 2 Page Builder is and how to import/export all Page Builder data. Since you cannot transfer anything to/from the tool via default Magento 2 instruments, it is necessary to install a third-party extension. Below, we shed light on the most intuitive and easy-to-use solution aimed at recreating the missing functionality. Meet the Improved Import & Export extension. With its help, you will be able to import and export Page Builder-related information to and from Magento 2 most efficiently.
As for the blog post below, it unveils the most important facts about Magento 2 Page Builder. You will learn about its drag and drop functionality, grid system, visual effects, flexible integrations, products, instant previews, schedules, etc. Besides, there is a technical introduction to the tool and a brief description of Bluefoot CMS as the foundation of Magento 2 Page Builder. After that, the article focuses on how to import and export data to/from Magento 2 Page Builder. Since the process incorporates the Improved Import & Export extension, you will also find its features described in the blog post.
Table of contents
- 1 Magento 2 Page Builder
- 2 Technical Introduction To Magento Page Builder
- 3 Bluefoot CMS
- 4 How to Import And Export Data to/from Magento 2 Page Builder
- 5 Improved Import & Export Magento 2 Extension Features
- 5.1 Automated Import & Export Processes
- 5.2 Advanced Mapping Features
- 5.3 Extended Connectivity Options
- 6 Final Words
- 7 Magento 2 Page Builder Data Import & Export FAQ
- 7.1 How to import and export Page Builder data to Magento 2 automatically?
- 7.2 How to import Page Builder data with third-party attributes to Magento 2?
- 7.3 How to import and export Page Builder data to Magento 2 via API?
- 7.4 How to import and export Page Builder data to Magento 2 via ODS files?
- 7.5 How to import and export Page Builder data to Magento 2 via XLSX files?
- 7.6 How to import and export Page Builder data to Magento 2 via JSON files?
- 7.7 How to import data to Magento 2 via compressed files?
- 7.8 How to import data to Magento 2 from Google Sheets?
- 7.9 How to import and export Page Builder data to Magento 2 from Dropbox?
- 7.10 How to import and export Page Builder data to Magento 2 from Google Drive?
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 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.
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.
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.
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.
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.
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.
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.
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.
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
Page Builder is used in CMS pages and CMS blocks for composing content. As mentioned above, you need a third-party module to extend the default functionality of Magento to import/export Page Builder data, precisely CMS blocks and pages. 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 static blocks and static pages that have been build using Magento 2 Page Builder. If you don’t want to spend time on recreating all the customizations applied to your current store on a new one, give Firebear 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 ‘CMS blocks’ or ‘CMS pages’ from 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.
REMEMBER: Improved Import and Export extension supports import and export of the CMS blocks and CMS pages composed with Page Builder. There are no limitations or prerequisites to such processes. Every block or page composed with page builder will preserve every element during the export process, and will import the data back to Magento 2 during import.
Improved Import & Export Magento 2 Extension Features
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.
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:
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.
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:
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.
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:
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:
Watch the following video to see the extension in action:
As you can see, the only possible way to import and export Page builder data, CMS blocks and CMS pages, 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:
Magento 2 Page Builder Data Import & Export FAQ
Let’s take a look at other nuances of importing and exporting Page Builder data in Magento 2 with the help of the Improved Import & Export Magento 2 extension.
How to import and export Page Builder data to Magento 2 automatically?
If you need to import or export Page Builder data between Magento 2 and third-parties or other Magento 2 websites on a regular basis, it is necessary to install an additional tool. We recommend you use the Improved Import & Export extension since it utilizes a cron scheduler for automating data transfers. Thus, you get the ability to import and export Page Builder data between Magento 2 and external destinations automatically. You create a schedule of updates. Next, the module does everything for you importing and exporting data at a specified time.
How to import Page Builder data with third-party attributes to Magento 2?
While the default import mechanism blocks the import of third-party data that doesn’t follow the Magento 2 requirements, the Improved Import & Export extension can easily do that. It lets you create a mapping scheme where you match third-party attributes and their values to ones used within the system. As a result, any external data is easily adapted to the native standards of your e-commerce website. Note that you can also apply mapping to export processes to generate the output your partners require.
How to import and export Page Builder data to Magento 2 via API?
The Improved Import & Export Magento 2 extension provides the ability to create API connections to transfer not only Page Builder data but all other entities. Thus, you can freely move information between Magento 2 and any external system. The module’s import/export jobs provide an interface where you can specify the parameters necessary to sync the two systems. Note that it is possible to create a bi-directional API connection with our module. As for transferring unsupported attributes, the plugin lets you leverage its mapping functionality for API connections.
How to import and export Page Builder data to Magento 2 via ODS files?
Improved Import & Export lets you move Page Builder data via ODS files. You no longer need to convert them to CSV to fit the Magento 2 requirements. You can also export data using this file format.
How to import and export Page Builder data to Magento 2 via XLSX files?
In addition to ODS, Improved Import & Export lets you move Page Builder data via XLSX files. You no longer need to convert them to CSV to fit the Magento 2 requirements. You can also export data using this file format.
How to import and export Page Builder data to Magento 2 via JSON files?
If data is stored in a JSON file and you don’t want to create an API connection, you no longer need to convert it to a CSV file to fit the Magento 2 requirements. With the Improved Import & Export Magento 2 extension, it is possible to import JSON files to your ecommerce website without any necessity to run the conversion. You can also export data using this file format, transferring Page Builder content in both directions.
How to import data to Magento 2 via compressed files?
If your files with Page Builder data are compressed, you can also transfer them to Magento 2 with the help of the Improved Import & Export extension. However, there is a requirement to follow: your file archive should be in a ZIP or TAR format. In addition to JSON, our module also supports compressed CSV, XML, ODS, and XLSX files.
How to import data to Magento 2 from Google Sheets?
If Page Builder data is stored in Google Sheets, it is no longer a problem. There is no need to export it from the service and then transfer the output to Magento 2. The Improved Import & Export lets you move the corresponding information straight from Google Sheets to your e-commerce website. It is only necessary to specify the address of the corresponding data table.
How to import and export Page Builder data to Magento 2 from Dropbox?
In addition to Google Sheets, the Improved Import & Export module lets you transfer data to Magento 2 from Dropbox. This time, you can store Page Builder data there. It is possible to work with CSV, JSON, XML, ODS, or XLSX standards. If it is a compressed file, it should be in a ZIP or TAR format. You can use this file storage as your export destination.
How to import and export Page Builder data to Magento 2 from Google Drive?
In addition to Google Sheets and Dropbox, the Improved Import & Export module lets you leverage Google Drive to transfer Page Builder data to Magento 2. You can use this file storage for CSV, JSON, XML, ODS, and XLSX files that can be compressed in a ZIP or TAR format. It is also possible to use it as your export destination.