# How to use the Import/Export CSV in Shopware 6.1.5 ?

**URL:** <https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076>\
**Category:** General Questions (EN)\
**Created:** [6. April 2020 um 10:29 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076 "2020-04-06T10:29:34Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![davit\_sargsyan](https://avatars.discourse-cdn.com/v4/letter/d/7ba0ec/32.png) [@davit\_sargsyan](https://forum.shopware.com/u/davit_sargsyan)\
**Post date:** [6. April 2020 um 10:29 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/1 "2020-04-06T10:29:34Z")

</div>

Despite all of my attempts, I was unable to import categories/products/media from my one Shopware 6 to another one.

I receive such errors shown bellow. Even when I have no errors and when it shows that the import succedded, still no products are being imported as it shows that there are 0 records.

 ![](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/c/c214ceaf2dc0250f9b1b6246f67489907e69b288.png)

 ![](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/2X/6/647614bce7edb0f177228d685a67ae252bc11c92.png)

---

<div class="post-metadata">

**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\
**Post date:** [6. April 2020 um 10:59 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/2 "2020-04-06T10:59:10Z")

</div>

You are using the default profiles or custom profiles?

---

<div class="post-metadata">

**Author:** ![davit\_sargsyan](https://avatars.discourse-cdn.com/v4/letter/d/7ba0ec/32.png) [@davit\_sargsyan](https://forum.shopware.com/u/davit_sargsyan)\
**Post date:** [6. April 2020 um 11:29 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/3 "2020-04-06T11:29:21Z")

</div>

The default Ones,

I am exporting from 6.1.5 version and trying to import to another 6.1.5.

I tried with categories/media and products as well.

---

<div class="post-metadata">

**Author:** ![davit\_sargsyan](https://avatars.discourse-cdn.com/v4/letter/d/7ba0ec/32.png) [@davit\_sargsyan](https://forum.shopware.com/u/davit_sargsyan)\
**Post date:** [7. April 2020 um 13:01 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/4 "2020-04-07T13:01:23Z")

</div>

[@Moritz Naczenski]([http://forum.shopware.com/profile/14574/Moritz](http://forum.shopware.com/profile/14574/Moritz) Naczenski “Moritz Naczenski”)‍ Is the feature still in beta mode? Do you know what changes can we do so it will work?

---

<div class="post-metadata">

**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\
**Post date:** [7. April 2020 um 13:11 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/5 "2020-04-07T13:11:20Z")

</div>

It works fine for me - so I don’t know where your issue comes from.

Perhaps you can share your csvs here and we can test it.

&nbsp;

---

<div class="post-metadata">

**Author:** ![davit\_sargsyan](https://avatars.discourse-cdn.com/v4/letter/d/7ba0ec/32.png) [@davit\_sargsyan](https://forum.shopware.com/u/davit_sargsyan)\
**Post date:** [7. April 2020 um 13:19 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/6 "2020-04-07T13:19:59Z")

</div>

Can you give me an email so I can send you the csv files as well as the failed csv file&nbsp;&nbsp;[@Moritz Naczenski]([http://forum.shopware.com/profile/14574/Moritz](http://forum.shopware.com/profile/14574/Moritz) Naczenski “Moritz Naczenski”)‍ ?

---

<div class="post-metadata">

**Author:** ![davit\_sargsyan](https://avatars.discourse-cdn.com/v4/letter/d/7ba0ec/32.png) [@davit\_sargsyan](https://forum.shopware.com/u/davit_sargsyan)\
**Post date:** [7. April 2020 um 13:28 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/7 "2020-04-07T13:28:20Z")

</div>

Actually here is a link for the files&nbsp;[csv - Google Drive](https://drive.google.com/drive/folders/1t2SWiHq_RgJ5BhjxPTeeKmNWx5UrxdH3?usp=sharing)

---

<div class="post-metadata">

**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\
**Post date:** [7. April 2020 um 16:53 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/8 "2020-04-07T16:53:38Z")

</div>

This is an already imported file, not the original one, because the error-column is already there.

Please share a newly exported one.

&nbsp;

---

<div class="post-metadata">

**Author:** ![davit\_sargsyan](https://avatars.discourse-cdn.com/v4/letter/d/7ba0ec/32.png) [@davit\_sargsyan](https://forum.shopware.com/u/davit_sargsyan)\
**Post date:** [8. April 2020 um 07:59 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/9 "2020-04-08T07:59:55Z")

</div>

[@Moritz Naczenski]([http://forum.shopware.com/profile/14574/Moritz](http://forum.shopware.com/profile/14574/Moritz) Naczenski „Moritz Naczenski“)‍ I shared both of the files in the link, there are 2 imported files with the errors and 2 not imported ones

---

<div class="post-metadata">

**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\
**Post date:** [8. April 2020 um 08:24 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/10 "2020-04-08T08:24:27Z")

</div>

The CSV is using some uuids (e.g. for taxes, sales-channel) did you change those IDs to the IDs of the target system?&nbsp;

When opening the CSV some of the mandatory fields are empty (like name, price, …) and those products can’t be imported. The current version of 6.1.5 does not support variants.

To get your CSV working, you need to do:

- change the uuids to the uuids of the target system

- remove all variants of the csv

---

<div class="post-metadata">

**Author:** ![davit\_sargsyan](https://avatars.discourse-cdn.com/v4/letter/d/7ba0ec/32.png) [@davit\_sargsyan](https://forum.shopware.com/u/davit_sargsyan)\
**Post date:** [8. April 2020 um 08:32 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/11 "2020-04-08T08:32:35Z")

</div>

Thank you for the clarification, but when will the variant import also be available?

---

<div class="post-metadata">

**Author:** ![os333](https://avatars.discourse-cdn.com/v4/letter/o/a9adbd/32.png) [@os333](https://forum.shopware.com/u/os333)\
**Post date:** [8. April 2020 um 12:40 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/12 "2020-04-08T12:40:53Z")

</div>

hey [@Moritz Naczenski]([http://forum.shopware.com/profile/14574/Moritz](http://forum.shopware.com/profile/14574/Moritz) Naczenski “Moritz Naczenski”)‍ we have this csv file and just cant get it to work -can you give us some direction?

> **[price-list-de.csv](https://drive.google.com/file/d/1goLrTYdWH-NJbZvhelxtBPu3EUVUJhmp/view)**
>
> Google Drive file.

&nbsp;

thanks!

---

<div class="post-metadata">

**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\
**Post date:** [8. April 2020 um 12:51 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/13 "2020-04-08T12:51:21Z")

</div>

You need to create an own profile for products and map your columns to the shopware fields.

What have you tried so far?

---

<div class="post-metadata">

**Author:** ![os333](https://avatars.discourse-cdn.com/v4/letter/o/a9adbd/32.png) [@os333](https://forum.shopware.com/u/os333)\
**Post date:** [8. April 2020 um 13:20 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/14 "2020-04-08T13:20:00Z")

</div>

thats what we did but it doesn’t generate a product without binary ID column…

---

<div class="post-metadata">

**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\
**Post date:** [8. April 2020 um 13:42 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/15 "2020-04-08T13:42:24Z")

</div>

To create a product the uuid can stay empty, you only need a product number.

---

<div class="post-metadata">

**Author:** ![os333](https://avatars.discourse-cdn.com/v4/letter/o/a9adbd/32.png) [@os333](https://forum.shopware.com/u/os333)\
**Post date:** [8. April 2020 um 20:56 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/16 "2020-04-08T20:56:48Z")

</div>

i uploaded it and mapped the fileds i needed (price, describtion and Kategorie)

but it didnt work. why?

the mapping is fairly easy, but it didnt work…

is there ANY sample file you can provide so i can just copy my content to your sample CSV and import that?

that would be great and i’m happy to pay for it if needed thanks!! 🙂

---

<div class="post-metadata">

**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\
**Post date:** [9. April 2020 um 10:19 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/17 "2020-04-09T10:19:36Z")

</div>

You can create a sample file by your own: just create a product in the administration, export the default profile for products, change the product number to a non-existing one and remove the id column.&nbsp;

---

<div class="post-metadata">

**Author:** ![davit\_sargsyan](https://avatars.discourse-cdn.com/v4/letter/d/7ba0ec/32.png) [@davit\_sargsyan](https://forum.shopware.com/u/davit_sargsyan)\
**Post date:** [10. April 2020 um 09:42 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/18 "2020-04-10T09:42:16Z")

</div>

I will also try to see if that works

---

<div class="post-metadata">

**Author:** ![davit\_sargsyan](https://avatars.discourse-cdn.com/v4/letter/d/7ba0ec/32.png) [@davit\_sargsyan](https://forum.shopware.com/u/davit_sargsyan)\
**Post date:** [20. April 2020 um 12:21 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/19 "2020-04-20T12:21:41Z")

</div>

[@Moritz Naczenski]([http://forum.shopware.com/profile/14574/Moritz](http://forum.shopware.com/profile/14574/Moritz) Naczenski „Moritz Naczenski“)‍ and how to import the custom fields for a product ? And how to import the properties of a product ?

---

<div class="post-metadata">

**Author:** ![davit\_sargsyan](https://avatars.discourse-cdn.com/v4/letter/d/7ba0ec/32.png) [@davit\_sargsyan](https://forum.shopware.com/u/davit_sargsyan)\
**Post date:** [20. April 2020 um 12:32 UTC](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076/20 "2020-04-20T12:32:28Z")

</div>

[@Moritz Naczenski]([http://forum.shopware.com/profile/14574/Moritz](http://forum.shopware.com/profile/14574/Moritz) Naczenski “Moritz Naczenski”)‍ it seems that the whole import exmport is not working at all.

I am exporting some products,

deleting the variants and id column,

changing the article id’s

and then trying&nbsp;to import the csv file.

It shows a successful import, however the number of imported records is shown as 0 and no new products appear in the product list.

[Nächste Seite](https://forum.shopware.com/t/how-to-use-the-import-export-csv-in-shopware-6-1-5/66076.md?page=2)
