How to Import XLSX Files to Shopware 6

- Our extensions, Shopware

Shopware 6 uses CSV files to import data by default. But what if your update has been provided in the form of an XLSX file? You must first convert it to CSV and then run the import. There is, however, a more straightforward approach to updating your Shopware 6 website that does not require this conversion. Meet the Improved Import, Export, and Mass Actions app for Shopware 6. This plugin completely supports the import and export of XLSX files. The following tutorial will teach you how to import XLSX files to Shopware 6. But first, let’s look at what the difference between CSV and XLSX is. Also, don’t forget to go over our Shopware Cookbook for more helpful suggestions.

CSV vs. XLSX

CSV states for comma-separated values. It’s a text file where commas separate different blocks of data.

An XLSX file, in turn, is a ZIP-compressed, XML-based spreadsheet file that belongs to the family of Microsoft Excel Spreadsheet files. Since it is an Open XML Format file, it introduces a more complex approach to storing and transferring data. You can read more about XML files here: How to Import XML to Shopware 6. 

The difference between CSV and XLSX file formats is that CSV format is a plain text format in which values are separated by commas (Comma Separated Values), while XLSX uses the SpreadsheetML markup language and schema to represent a spreadsheet “document” that consists of values and formulas placed in a rectangular grid of cells. Such a document comprises one or more worksheets in a workbook. 

CSV is highly convenient and requires fewer technical skills. Additionally, it is significantly smaller than XLSX, meaning that less processing power and other resources are required. 

XLSX, in turn, is a more flexible and extensible format suitable for storing and exchanging complex, structured data. 

How to import XLSX files using the default Shopware 6 tools

As we’ve already mentioned, Shopware 6 doesn’t work with XLSX files. There is only one way to import XLSX to your e-commerce website via the default Shopware 6 tools: convert XLSX to CSV. Luckily, you don’t need any third-party software because Excel lets you save XLSX files as CSV files: 

  • Open your XLSX file and switch to the target worksheet in your workbook since only the active sheet will be converted.
  • Click Save As on the File tab. 
  • Pick the desired CSV format from the Save as type drop-down menu in the Save As dialog box: choose CSV UTF-8.

Note that you will need to create multiple CSV files if your XLSX file consists of several different tables. 

Next, export a sample CSV file from your Shopware 6 website and compare it with the converted one. If there are any inaccuracies in the converted CSV file, fix them. Otherwise, you won’t be able to import the necessary data to your e-commerce website.

How to import XLSX into Shopware 6 without conversion

However, there is another way to import XLSX files to Shopware 6. You need the Improved Import, Export & Mass Actions app. The latest release of this tool adds support for XLSX file import. And it requires no additional actions. Go to Extensions -> Improved Import, Export & Mass Actions -> Product Import. Click the New Profile button.

shopware 6 xml import

The Select file screen is where you choose XLSX as your file format. Follow these steps to make Shopeare 6 XLSX import possible: 

how to import xlsx to shopware 6

  1. Specify your profile’s name; 
  2. Select an entity you want to import (e.g., products or customers);
  3. Create a schedule of updates if applicable;
  4. Configure email notifications if necessary;
  5. Select XLSX as your file format (alternatively, you can choose CSV or XML);
  6. Choose your import source: file, URL, FTP, Google Drive, or Google Sheets;
  7. Configure advanced settings: URL rewrite behavior, media replacement behavior, and stock increment strategy. 

Next, proceed to the mapping screen. Specify which columns from the imported XLSX file match the properties of the products from your Shopware 6 store. 

Note that the app lets you preview how products will look before you import them. When you click the Import button at the bottom of the Preview result page, the extension imports your XLSX file.

You can read more about the enhanced Shopware 6 import in our Improved Import, Export & Mass Actions Manual. 

Other Features

The Improved Import, Export & Mass Actions app addresses the most common issues that Shopware 6 store owners face upon import and export processes, such as product bulk editing via a single page. Unlike the default procedure, the app exports all product attributes in the same file instead of multiple separate files for different properties. Some other core features include:

  • Full product import and export including custom properties (attributes);
  • Customer import and export including addresses;
  • Orders export;
  • Full support for product variants with a full set of attributes;
  • Product properties mapping and mapping presets;
  • Import and export schedules;
  • Support for CSV, XLSX, and XLSX file types;
  • Direct file uploads;
  • FTP/FTPS uploads;

You can find more information about the product here: 

 

Post Tags: