Monday, June 25, 2018
opencart sql to update all the images with the model name
opencart sql to update all the images with the model name
UPDATE oc_product SET oc_product.image = CONCAT(image/catalog/yourfolder/, LCASE(TRIM(oc_product.model)), .jpg)
Change your folder accordingly and remember to use lower case chars for your file names otherwise remove LCASE.
