Import/Export improvements
We continuously work on improving import and export capabilities.
Please let us know in the comments what is still missing for you.
-
Jürgen Finger commented
The import is performing incredibly slowly! An article with around 10 media items that need to be fetched from an external media server takes an average of 10 minutes!
The import time for 150 articles is 10 hours. Sometimes I need to import 1,000 articles. On top of that, after the import, I have to export the data again just to retrieve the IDs, in order to import additional information like extended prices, cross-selling, etc. This process was dramatically better and faster in SW5.Why isn’t this possible in SW6????
-
Benjamin Hummel commented
Time and again, customers reach the limits of the export because it cannot be configured across different database tables. This quickly leads to the need to use an extension or the export is not possible.
Example:
Display of all products, including their sales with tax and any other details.This was much better and more comprehensive under Shopware 5.
Due to monthly exports to the tax office or the tax consultant, such cross-table information would be important and is requested again and again.
-
Stefan Stillrich commented
Preis Export in Spalten nach Verkaufskanal - nicht in Liste .
-----
Price export in columns by sales channel - not in list .(Edited by admin) -
Tim Sake commented
export values and not id's for properties
-
Raymond commented
Possibility to select at export: Export only active products/sku.
-
Lena Forlin commented
Own profile or extend capabilities of product profile to import/export product reviews
-
Raymond commented
Filter (inspiration from Shopware 5):
Export orders: order number from-to, date from-to, order status, payment status
Export customers: Creation date, last ordered from-to, sales from-to, country (when exporting customers in Shopware 5 there were customer streams)Especially for exports involving large shops (number of orders and customers), the export can take a very long time, although the export could be quick and accurate through previous filtering.
-
Lena Forlin commented
Customer feedback:
Export orders: Order number from-to, date from-to, order status, payment status
Export customers: Creation date or last ordered from-to, turnover from-to, country (when exporting customers in Shopware 5, this was e.g. solved through customer streams)
Additional benefit:
The export can take a very long time, especially for exports with large stores (number of orders and customers), although the export could be fast and accurate thanks to prior filtering. -
Lars Schröder commented
There should be filter options like in Shopware 5 to export only some entities like date range for orders, promotion related codes, etc.
-
Marc Cheng commented
Cross selling export/import right now for a product is limited to a list of id's. some of our customers complain about it and wish to have it with product_number and or product_name, at least for the export with name
-
Marc Cheng commented
we have "a lot" customers (translate that to almost every customer with more than a handful products in the store) that wish to export products filtered by category.
-
Tino Robeller commented
Please add the invoice number field so that you can download a csv in which the invoice numbers are also visible.
-
gigi balanel commented
I would like to have in SW6 import/export in JSON not only CSV.
to be: Select a CSV or JSON file to upload
-
User commented
Please enable product export for individual brands.
Provide a corresponding dropdown for this purpose.
If, for example, suppliers increase prices, this would enable targeted and therefore faster processing of relevant products. -
User commented
A reasonable error output is absolutely necessary. The line and field where the data import got stuck should be displayed.
Example: In a large import, I accidentally had a meta description for a product that was longer than 255 characters. However, the corresponding field in the database only allows 255 characters, which is correct from an SEO perspective, but it was simply an incorrect data record.
It took me hours to find it. With a reasonable error output, as I know it from other shop systems, the matter would have been resolved in a few minutes.In Shopware, unfortunately, the import simply hangs at line xy instead, but does not abort. The displayed line does not allow any conclusions to be drawn about the actual incorrect line, i.e. the error cannot even be localised.
-
Jonathan Klinnert commented
each attribute as a single column to fill values in clear names
-
Sergej Riewe commented
Support of dynamic product groups and rules for export
-
Markus Fischer commented
In Shopware 5 import / export there was an import of orders implemented. The import functionality of this was reduced to changing order states. Sometimes customers ask for this feature in Shopware 6, too.
-
Philip Schilling commented
The Settings > Import/Export feature in the Shopware backend does not fulfil my needs. Examples:
- I would like to export a list where I can see for which orders a promotion has been applied and what discount has been granted per order.
- I would like to export a list of promotional codes, how often they have been used and what the total discount value has been.
- I nwould like to export a list of all customers with registration date, number of orders and sum of order value. This list must also include customers that have not placed any order to understand our lost potential.This can be solved by updating the Import/Export module and / or add an export feature to any customizable data table in backend (46114087-more-fields-and-options-in-the-admin-grid).
-
Marcel Rector commented
It should be already great when the import/export is (functional) performing the same way as in Shopware 5. The Shopware 6 import-export module is a huge step back.
Skip the (required) UUID's or the need to buy a very expensive (and less user friendly) extension (€ 75 fee monthly) to establish something similar.