Shopware Agency
Shopify Agency
JTL SHOP 5 Agency
Gambio Agency
Magento Agency
WooCommerce Agency
PrestaShop Agency
Xentral Service Partner Enterprice
VARIO Service Partner
Odoo Agency
eBay SEO
Otto SEO
Google SEO
Google Ads
Social Media
Facebook Ads Agency
Instagram Ads Agency
ChatGPT Agency
Link Building Agency
Ecommerce Tutorials
eCommerce Podcast
SEO Tools
AI Tools
eCommerce Facebook Group
Shopware 6 product data import
How to import and export data
With the help of the Shopware 6 product data import, you can quickly and easily edit a lot of product data.
But to ensure that everything runs smoothly during the re-import, there are a few things to bear in mind, which we discuss in this Shopware tutorial.
So it’s worth watching to the end.
Why the import/export module is so useful
Data import and export is one of the most important functions in your online store. You could for example. You can quickly create a test environment by exporting your data from the active store and importing it into your test store.
On the other hand, the CSV file generated during the export can also be used to make bulk edits, i.e. changes that change several product data in one step.
That’s exactly why we take a look at how this works in Shopware 6 in this video.
Shopware 6 product data import - using the right profile
But let’s jump straight into the topic and look for our Shopware 6 import/export module.
This can be found in the settings, in the “Shop” section, right here.
Ultimately, this is very clearly structured.
We have an import area, an export area and an area for the respective profiles.
First of all, it must be a CSV file so that Shopware can process the data correctly.
The profile determines what data is involved and how it is handled.
You can already see that ready-made standard profiles already exist for products, categories, customer data etc..
This means that you can use this module not only to import and export product data, as we will do in the video, but also to exchange other data.
To better understand how profiles work, let’s go to the “Profiles” tab and edit the standard profile for products.
The general information is more or less self-explanatory, but the assignment is important for us.
Here we can see which data must be present in the standard profile.
The ID is an identification number that is only assigned once.
This allows each product to be identified quickly and easily.
It also contains the product name, the category, the price, the tax rate and much more.
If you do not understand what a certain value stands for, please have a look at the Shopware Docs area, under Settings -> Shop and Import/Export all terms are explained.
Making changes to the CSV file
This means that the profile determines which values are processed, which values are mandatory, the order in which they are arranged, etc. For an even better understanding, let’s export the products contained in our store.
To do this, we go to the “Export” tab, select the product profile, can now also specify whether the variants should also be exported and click on Start export.
The result is displayed below.
We click on the three dots and download the CSV file.
This then looks as follows.
We have the ID just mentioned, which is individual for each product.
The product name, an indication of whether this product should be activated, a product description, etc.
To demonstrate that you can now make changes here that will then take effect in the store, let’s change the name of the main article to “Main article CHANGE”.
We save the whole thing and give the file a new name.
Shopware 6 product data import - How the re-import works
Now we switch to the Import tab in the store area, select our standard product profile again and upload our newly created CSV file.
Before we initiate the final import, we can always start a test run to check that everything is OK with the data.
The status is “Successful”, so we upload the file again and click on “Start import”
This was also successful.
Now let’s go to our product overview and see that the name of the product has also changed in the store.
This also shows how helpful this tool can be. For example, if you want to 100 products inactive at once, then you don’t have to go into each product individually and set it to inactive, but could export your product data and set the value within the table from 1 to 0 with just a few clicks.
This can of course be transferred to many other application examples.
How to check the CSV file for correctness
However, we now want to discuss another case, namely the case where the values in your CSV file differ from those in your store.
To do this, we have downloaded the standard profile template from the Shopware Docs area and checked it for consistency.
One source of error can be, for example
A source of error can be, for example, a mismatched tax ID if you want to transfer products from another store.
In the example file, the 7% tax rate has the following ID, so we remember the “46c4” at the end and go back to the store backend.
The tax settings can be found in the store settings area under “Taxes”.
To identify the ID for the 7% rate, we edit this category once and look in our URL bar.
The end of the URL is the tax ID, which in our case ends with 3423.
Therefore no match.
In order not to risk an error message during import, we would now have to copy the correct ID for our store and paste it into the CSV file.
Shopware 6 product data import - customize profiles
Finally, let’s assume that the default profile does not meet your expectations, so you want to customize it or create a new one.
To do this, go back to the profile tab and click on “Add new profile”.
We assign the name TEST and come up with a technical name.
It is important to select the correct type so that the correct parameters are displayed immediately.
In our case, this is “Product”.
You can then differentiate whether this is only intended for import or only for export or simply leave it for both.
You can leave the other settings as they are. Now we click on “Next”. We could now upload an example CSV file that defines the mapping.
However, we will leave this out in our case, as we want to configure this manually.
And we can already see all the values that must be included for a product as a minimum dimension, so the toggle switch cannot be changed here either.
We could now change the position in which the respective values are to be displayed in the CSV file.
One parameter that would not be included here would be the activity display, i.e. whether a product should be directly active in the store or not.
We now add this by adding a new mapping and setting the database entry to “active”.
We assign a new name, but can now decide whether this value should be required or not and could set a default value.
The default value always applies if virtually no value is specified.
So if this is missing, the default value is automatically added.
If we were to set this to 0, every new product would be inactive.
At the end, we can click on “Add profile” to create our own individual profile.
Shopware agency eBakery
Now nothing stands in the way of us successfully creating our test environment, adding new products from other stores or mass customizing product data via bulk edit.
However, if you still have any questions, please leave them in the comments.
Otherwise, as a certified Shopware agency, we at eBakery will be happy to help you with your request.
Do you have questions or need an individual offer? Do not hesitate to contact us.
