Prestashop 1.7.6.7 SQL update for selected features
Budget: £10 – £20 GBP
We use Prestashop 1.7.6.7.
We want certain feature values of all products written to another table/part of the database so they can be used by another module.
We have approximately 15000 products and the features 1,2,3,4,5 are required to be written elsewhere in that database.
I would like to have it so that I can also run the SQL in the future to do the same task.
For the future, we would like it so that when we click save on a product, it will again copy the features 1,2,3,4,5 and again write them to another place within the DB. Possibly using a trigger within the DB.
Attached are images that will possibly make more sense.
We want certain feature values of all products written to another table/part of the database so they can be used by another module.
We have approximately 15000 products and the features 1,2,3,4,5 are required to be written elsewhere in that database.
I would like to have it so that I can also run the SQL in the future to do the same task.
For the future, we would like it so that when we click save on a product, it will again copy the features 1,2,3,4,5 and again write them to another place within the DB. Possibly using a trigger within the DB.
Attached are images that will possibly make more sense.