SQL - Make 4000 products available for all languages

Hans Ravnsfjall

Posted on 13/10/2021 17:41:29

I want to make 4000 products available in all languages, and was trying to find the correct SQL table to alter this, but I cant find the table/column. Can someone guide me to the correct table? I don´t want to activate them one-by-one, as that would take way to long.

/Hans

Replies

Imar Spaanjaars

Posted on 13/10/2021 19:08:59

This post has been marked as an answer

You want to copy the rows in the EcomProducts table. You could do something like:

INSERT INTO EcomProducts

SELECT ProductId, ProductVariantId, 'LANG2', ProductNumber, etc etc etc, FROM EcomProducts

This copies all rows and columns except the product language (which I have hardcoded here as LANG2). If needed, both your INSERT and SELECT statement could select specific columns only.

Alternatively, and probably easier, use Data Integration to export all products to a file, replace the language ID with the new ID and then import them again.

Hope this helps,

Imar

Votes for this answer: 1

Hans Ravnsfjall

Posted on 14/10/2021 19:37:11

Thank you Imar

I´ll try the export/Import route

/Hans

You must be logged in to post in the forum

Developer forum

SQL - Make 4000 products available for all languages

Replies