CSV Import in SW 6.1 - lots of issues

Hi all, hoping I can get help here.

I have a CSV which I have created, I have created a profile to match.

Below is the CSV sample I am trying with:

id,en_gb_name,name,description,productNumber,price_net,price_gross,stock,taxId,createdAt,updatedAt 71f895b6b6f144c690f3716ac19d0cc1,Test,Test,Test,TEST123,0,0,0,5c4478aef64e49debe3f456e8b0b58dc,2017-03-28T15:21:30+00:00,2020-04-27T16:06:53+00:00

When I upload this through System > Import / Export, I see a 400 Bad Request error in the Network tab of Developer Tools. The response body is as follows:

{"errors":[{"status":"400","code":"FRAMEWORK__INVALID_UUID","title":"Bad Request","detail":"Value is not a valid UUID: en-GB","meta":{"parameters":{"input":"en-GB"}}}]}

I’m a little lost here, I don’t see an invalid UUID and I’ve googled this error with no success. Has anyone encountered this before?

Does it work without the translation?

@Moritz Naczenski schrieb:

Does it work without the translation?

Hi Moritz, thanks for the reply.

Unfortunately it does not, I get the error below:

[/0/translations/2fbb5fe2e29a4d70aa5854ce7ce3e20b/name] This value should not be blank.

I believe I have worked around this, (it isnt fixed), for future people who come across this issue. (Googlers etc)

When importing, use translations.DEFAULT.name, not translations.en-GB.name (Basically, do not use a locale code, use DEFAULT).

My end resulting CSV looks as follows:

metaTitle,metaDescription,manufacturerId,en_gb_name,name,description,productNumber,price_net,price_gross,stock,taxId,createdAt,updatedAt "test","test description",df7a775cb522409e8eb59e425c566d2f,"test name","test name","test",0001,0,0,999,0974262fee9449e692df6180ea7d76b1,2017-03-28T15:21:30+00:00,2020-04-27T16:06:53+00:00

Note, the manufacturerId and taxId values MUST be values already present in Shopware.

Shopware will not create new items for these if you simply pass it a random UUID.

The UUID is a UUID4 generated using

 (new Ramsey\Uuid\Uuid)-\>Uuid4()-\>toHex()-\>toString();

Profile is as follows:

 

This appears to be the minimum amount of information to be able to import a product into Shopware using the Import/Export functionality.

In the default profile name is mapped to “translations.DEFAULT.name” and you need to provide a name for the default translation.

Just try to use the mapping from the default profile

1 Like

Thanks Moritz, seems our posts collided. I came to the same conclusion!

Hello everyone. I have a different problem. I have translated versions of the meta information. Now, I use the translations.DEFAULT.name and I alsi use the translations.de-AT.name, and it sends me the error. The funny thing is, it manages to export, but it cannot import. It’s 6.2.0

Thanks

Hi,

I was encountering same issue. reading the solution by not using the local language would in the end block you if you want to translate the shop. 

I had the same error message coming up for a German translation and what I figured out is the import couldn’t handle the special German chararcters like ä,ö,ü. When I used a regular a, then the upload worked fine. 

Best regards

Hey, 

did someone find a solution? 
I get this error: 

FRAMEWORK__INVALID_UUID: Value is not a valid UUID: fr-FR

while trying to import the French translation of the product information.
I imported the main language (which is German) using the DEFAULT option. That means everything is imported as translations.DEFAULT.name to show the german infos, but now I’m trying to get French into it using translations.fr-FR.name and there happens to problem. 

 

Any solutions? Because I need a shop which works with 3 languages (for now)

Best regards.

Same here…

Any solution in sight? Any news on the problem? Is there already an issue report?
A lot of questions I know… :wink:
We really need a solution for this as soon as possible.

Best Regards

I have the same issue and can’t solve it (my default language is German):

I export my products and the prfoile contains i.e.

  • translations.en-GB.description

- translations.DEFAULT.description

If I change / edit data in my csv for translations.DEFAULT.description and re-import the file, the changesedits get applied. If I make changesedits to translations.en-GB.description, those changes get not applied during import. I do NOT get any error message. 

 

This prevents me from translating my shop. I am stuck …

 

I export my products with German and English translation of product description. If I change the English details in the export csv. and same 

I have the same problem as Schwob2.