Jump to content

Edit History

JoeSchiaffi

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

JoeSchiaffi

JoeSchiaffi

hi there,

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

×
×
  • Create New...