SQL query to fill EAN 13 field with te Reference Number value

[JoeSchiaffi]

hi there,

I'm using PrestaShop 1.7.8.7 and I've 13.000 and more products and I use the Reference Number field (that I fill with the EAN code of the products) in order to search products in the back office and disable them on the fly when I sell them inside my physical shop.

My problem is that since I have all the 13.000 products with the EAN 13 field empty (this value is inside the Reference Number field, as I mentioned before) Google Shopping doesn't allow me to export products with the Google PS official module, so I need a way to copy the value in Reference Number into the EAN 13 field ad once for all products, and not doing it manually for all the 13.000 and more products.

Is there a way? Could I do this with a SQL query?

Thanks in advance, guys

Edited December 14, 2022 by JoeSchiaffi (see edit history)

[ps8modules]

UPDATE ps_product SET ean13 = reference

SQL query