Hi I have managed to import over 1000 products from a suppliers spreadsheet.
within the spread sheet is the url for the product image e.g.:
http://suppliersite.com/images/productcode.jpg
where productcode images match the product code. i.e. product code 10256 has image http://suppliersite.com/images/10256.jpg
So is there a way I can use the image paths I have to either create/upload the images onto my server or use the url images.
Cheers
SteveW
If you download the images and upload 'em to your server, you possibly end up with a slower Page-Load, comparing with getting them from the Supplier's Server. It's a similar effect, when using an IMAGE SUBDOMAIN, beeing called, by default by a 'regular' HTTP - Link Call, as you have it by now.
It's, because a Browser is capable to, simultaneously, download data from different URL's, to create a Page.
This will 'ease' the Task, compared with, downloading a whole content from one URL only.
Here are more infos on this:
http://forum.opencart.com/viewtopic.php ... 05#p549205
http://forum.opencart.com/viewtopic.php ... 50#p547250
http://forum.opencart.com/viewtopic.php ... 11#p503211
Good Luck
Ernie
bigmax.ch/shop/
It's, because a Browser is capable to, simultaneously, download data from different URL's, to create a Page.
This will 'ease' the Task, compared with, downloading a whole content from one URL only.
Here are more infos on this:
http://forum.opencart.com/viewtopic.php ... 05#p549205
http://forum.opencart.com/viewtopic.php ... 50#p547250
http://forum.opencart.com/viewtopic.php ... 11#p503211
Good Luck
Ernie
bigmax.ch/shop/
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ 
Thanks!
Hi artcore,
thanks for the reply.
The documentation does not explain fully.
I presume I do the following once your xml is uploaded
Export my products.
Change the value of column image_name from catalog/demo/palm_treo_pro_1.jpg to http://www.supplier.com/images/12345.png
Browse the product changes
The images are then copied and processed as if I had added them manually.
Is this correct ?
Also is there any need to change the directory for the images ?
Cheers
SteveW
thanks for the reply.
The documentation does not explain fully.
I presume I do the following once your xml is uploaded
Export my products.
Change the value of column image_name from catalog/demo/palm_treo_pro_1.jpg to http://www.supplier.com/images/12345.png
Browse the product changes
The images are then copied and processed as if I had added them manually.
Is this correct ?
Also is there any need to change the directory for the images ?
Cheers
SteveW
You can use it without changes. The default folder used for downloading external images is image/catalog/reseller
The default 'no image' is different for OC2 compared to OC1, hence the option to manually change it in the xml.
If the database field for image contains a link, iow starts with http:// it will try to download it to the folder mentioned above else it will use the local image.
In short: import the feed and enjoy is all you do.
The default 'no image' is different for OC2 compared to OC1, hence the option to manually change it in the xml.
If the database field for image contains a link, iow starts with http:// it will try to download it to the folder mentioned above else it will use the local image.
In short: import the feed and enjoy is all you do.
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+
Thanks!
Hi,
I have installed vqmod (ver 2.4.10) and it say installed
I have an import / export extension I exported the data and changed the image_name for 10 items and reimported.
The import was successful.
However when I search on the 'socket set' to show the 10 changes item and some none changed items the items that I have changed just shows the text description where the image should be.
Any ideas ?
I have installed vqmod (ver 2.4.10) and it say installed
I have an import / export extension I exported the data and changed the image_name for 10 items and reimported.
The import was successful.
However when I search on the 'socket set' to show the 10 changes item and some none changed items the items that I have changed just shows the text description where the image should be.
Any ideas ?
I have also looked at the table and the image_name field contains the expected link i.e. http://www.bluespot.uk.com/images/01500.jpg
Is there anything in the error log for vqmod?
I haven't tested it on versions lower than 2.5.1 but should work.
So just trying to understand what you're doing;
You have products already in the shop, images and all. You export a couple, change the image field to an external file (http://...jpg), reimport and the images don't show up after browsing the frontend?
- vqmod/log :: check for errors
- does the image url work in a browser, iow is it publicly available?
- image/catalog/reseller :: does it exist and what are the contents
- system/log :: anything related in OC logs?
- database :: is the image field in the product table indeed like you imported it?
I wouldn't mind checking it for you. I'm using this mod on a live shop myself and installed it for a customer as well. Works very smoothly
I haven't tested it on versions lower than 2.5.1 but should work.
So just trying to understand what you're doing;
You have products already in the shop, images and all. You export a couple, change the image field to an external file (http://...jpg), reimport and the images don't show up after browsing the frontend?
- vqmod/log :: check for errors
- does the image url work in a browser, iow is it publicly available?
- image/catalog/reseller :: does it exist and what are the contents
- system/log :: anything related in OC logs?
- database :: is the image field in the product table indeed like you imported it?
I wouldn't mind checking it for you. I'm using this mod on a live shop myself and installed it for a customer as well. Works very smoothly
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+
Thanks!
Hi,
- vqmod/log :: check for errors - There is no log file in vqmod/log folder
- does the image url work in a browser, iow is it publicly available? - yes. http://www.bluespot.uk.com/images/01502.jpg
- image/catalog/reseller :: does it exist and what are the contents - image/catalog/reseller does not exist
- system/log :: anything related in OC logs? - No
- database :: is the image field in the product table indeed like you imported it? - yes. http://www.bluespot.uk.com/images/01502.jpg
cart is at www.toolfolks.com/cart
Cheers
SteveW
- vqmod/log :: check for errors - There is no log file in vqmod/log folder
- does the image url work in a browser, iow is it publicly available? - yes. http://www.bluespot.uk.com/images/01502.jpg
- image/catalog/reseller :: does it exist and what are the contents - image/catalog/reseller does not exist
- system/log :: anything related in OC logs? - No
- database :: is the image field in the product table indeed like you imported it? - yes. http://www.bluespot.uk.com/images/01502.jpg
cart is at www.toolfolks.com/cart
Cheers
SteveW
I see the problem.
Would you mind me checking on your host what could be the culprit? It's hard to debug this way.
For instance what's your DIR_IMAGE defines as?
Does your server have the module allow_url_fopen installed?
Would you mind me checking on your host what could be the culprit? It's hard to debug this way.
For instance what's your DIR_IMAGE defines as?
Does your server have the module allow_url_fopen installed?
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+
Thanks!
Hi,
define('DIR_IMAGE', '/home/wilseayd/public_html/toolfolks.com/cart/image/');
I have added phpinfo to **REMOVED** and it shows
allow_url_fopen ON.
Cheers
SteveW
define('DIR_IMAGE', '/home/wilseayd/public_html/toolfolks.com/cart/image/');
I have added phpinfo to **REMOVED** and it shows
allow_url_fopen ON.
Cheers
SteveW
Last edited by OSWorX on Fri May 08, 2015 7:18 pm, edited 1 time in total.
Reason: removing sensible data
Reason: removing sensible data
NEVER (!!) post such sensitive infos here!toolfolks wrote:Hi,
define('DIR_IMAGE', '/home/wilseayd/public_html/toolfolks.com/cart/image/');
I have added phpinfo to http://REMOVED** and it shows
allow_url_fopen ON.
Cheers
SteveW
If needed, do that per PM or email.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Indeed! Also remove the phpinfo file from your host.
Steve, I suggest I take a look on the host to get this solved. PM me if you want to.
Steve, I suggest I take a look on the host to get this solved. PM me if you want to.
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+
Thanks!
Or leave it, but rename it to somewhat (optinal move it to another folder with that name) and tell the person who need it the new name and folder to call.artcore wrote:Indeed! Also remove the phpinfo file from your host.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
As it turned out vQmod wasn't generating cache for any of the xmls. A vQmod update to 2.5 solved that.
I just got confirmation that all is working as aspected.
Lesson learned is to use at least vQmod 2.5 for OpenCart 2.x as also stated by Jay on Stack Overflow...
I just got confirmation that all is working as aspected.
Lesson learned is to use at least vQmod 2.5 for OpenCart 2.x as also stated by Jay on Stack Overflow...
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+
Thanks!
That is always the most important - and should be the first task: to read what the developer say.artcore wrote:Lesson learned is to use at least vQmod 2.5 for OpenCart 2.x as also stated by Jay on Stack Overflow...
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Hi artcore,
all looks okay now it seems to fail if theres a space in the filename e.g.
http://www.bluespot.uk.com/images/06160 - 1000 2.jpg
http://www.toolfolks.com/cart/index.php ... uct_id=805
Cheers
SteveW
all looks okay now it seems to fail if theres a space in the filename e.g.
http://www.bluespot.uk.com/images/06160 - 1000 2.jpg
http://www.toolfolks.com/cart/index.php ... uct_id=805
Cheers
SteveW
I'll add a fix for spaces tomorrow. Thanks for bringing it up.
@OSworkX I've updated the documentation now that I'm aware of this requirement.
Thanks for chipping in.
@OSworkX I've updated the documentation now that I'm aware of this requirement.
Thanks for chipping in.
Last edited by artcore on Sat May 09, 2015 4:40 am, edited 1 time in total.
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+
Thanks!
Maybe you should read this here: Never use in image and folder names
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Who is online
Users browsing this forum: No registered users and 9 guests
