I'm wanting to change the name of directory where I have my images.
the current folder name is "product images" (yes, with a space) so the image link looks like this:
http://www.example.com/image/cache/data/product images/taco.jpg
I want to change it to "product-image" (with no space)
http://www.example.com/image/cache/data/product-images/taco.jpg
When I renamed the folder to include the dash, using the built-in tool to upload or select images, the name of the older changes, but the links to my product images do not.
Any thoughts on how I can fix it without having to re-establish all my product image links so they include the "-" now?
I tried clearing out the cache under system/cache but that didn't work.
Thank you.
renaming to product images would render the url to looklike this:
product%20images due to the way your server and browser do handle a spave in a url.
you can try it with renaming the seo url of one off your products, replace your hypens with a space and check the url to that product.
product%20images due to the way your server and browser do handle a spave in a url.
you can try it with renaming the seo url of one off your products, replace your hypens with a space and check the url to that product.
Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com
I was hoping that there's a fast way I can change the folder name (I never should have made a folder name with a space), so it doesn't have a space any longer, but without me having to "reset" the URL's for the product images.
I assume this is handled somehow in the database
I assume this is handled somehow in the database
No that would be far to easy 
Image folders are defined bij absulute path in config.php files and the actual file to the images on your server.
at this moment the path to the images for your products is set in the database, so opencart knows whre to find them.
if you would relocate the image path, youre product would end up without any images, as path in databse is different to actual path on server.
Image folders are defined bij absulute path in config.php files and the actual file to the images on your server.
at this moment the path to the images for your products is set in the database, so opencart knows whre to find them.
if you would relocate the image path, youre product would end up without any images, as path in databse is different to actual path on server.
Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com
indeed change the folder name.
edit config.php in root and admin folder so it will point to your renamed image folder.
iether edit each product and reasign the corresponding picture to it, or much faster, edit your database and alter all image path in one go
edit config.php in root and admin folder so it will point to your renamed image folder.
iether edit each product and reasign the corresponding picture to it, or much faster, edit your database and alter all image path in one go
Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com
The thumbnail updates but the product images do not.. any thoughts on why changing the path in the database itself to the image does not fix it?
Does "assigning" it withing opencart do something different? If it did, wouldn't it be listed in the database?
Thanks.
Does "assigning" it withing opencart do something different? If it did, wouldn't it be listed in the database?
Thanks.
did you adapt the path to image in both your config files as well ?
Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com
Thanks for the help!
More information:
I found that the image URL's are located in 2 different tables in the database.
gtk_product
gtk_product_image
A question, I'm sure there's a way I can replace
data/product images/imagenamesthatvary.jpg
So it reads (with the dash):
data/product-images/imagenamesthatvary.jpg
Using some sort of command, like this in PHPAdmin?:
I stole the code from a post on updating wordpress, and figure it's probably similar or the same as updating a database for opencart?
Thoughts?
More information:
I found that the image URL's are located in 2 different tables in the database.
gtk_product
gtk_product_image
A question, I'm sure there's a way I can replace
data/product images/imagenamesthatvary.jpg
So it reads (with the dash):
data/product-images/imagenamesthatvary.jpg
Using some sort of command, like this in PHPAdmin?:
Code: Select all
update gtk_product set image = replace(image, 'data/product images/', 'data/product-images/');Thoughts?
indeed you found them.
its possible to update a database field with a sql comand as described, it will update all field at once, saving loads off time.
its possible to update a database field with a sql comand as described, it will update all field at once, saving loads off time.
Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com
Well, I made a backup of the 2 tables from my database, and then pulled the trigger.
Worked well, and the image URL's have changed from "data/product images/" to "data/product-images/" using the above referenced coding
Just in case someone needs this in the future... I went to the tables
gtk_product
gtk_product images
And changed the variables in red to match the table, fields that needed to be updated and what needed to be found and replaced with:
update gtk_product set image = replace(image, 'data/product images/', 'data/product-images/');
Thanks victorj for the help!
Worked well, and the image URL's have changed from "data/product images/" to "data/product-images/" using the above referenced coding
Just in case someone needs this in the future... I went to the tables
gtk_product
gtk_product images
And changed the variables in red to match the table, fields that needed to be updated and what needed to be found and replaced with:
update gtk_product set image = replace(image, 'data/product images/', 'data/product-images/');
Thanks victorj for the help!
Who is online
Users browsing this forum: No registered users and 85 guests
