SkydiveUK24

Hello, I have just recently changed suppliers and unfortunately the new supplier does not offer an image pack of their products to download. They do, however have a dedicated image server which they say I can link to - or if I can find a way of downloading them myself, I can do that also. I do not want to link to their images for several reasons and downloading over 4000 images manually - well say no more! Basically what I am trying to ask is, does anybody know of a simple script or something that will fetch the images from their servers and save to mine? The images are linked as follows: supplierswebsite.com/images/product/productsku100/image.gif supplierswebsite.com/images/product/productsku200/image.gif supplierswebsite.com/images/product/productsku300/image.gif and so on... I have an excel file containing all product image links. Any help would be greatly appreciated.

Thank-you Mike, I added that to the line and it has imported everything. I am a very happy man indeed!

Hello, Up until a few weeks ago my site was running great with this script, then it decided to stop working. It is a perl script which grabs data from my suppliers XML feed and imports it into my database. It used to import 2,000 products, update their stock level, add the category, image, price etc etc. I can't see a reason why it has stopped working, could it be because of possible Perl updates on the server? I setup a cronjob to run the script, which starts fine but when checking the log file it throws the following error: Done fetching feeds Not an ARRAY reference at line 100 Append Descriptions Starting foreach now Line 100 and just after is this below: elsif ( ref($PuckerLabRef) ) { foreach ( @$PuckerLabRef ) { if ( $_ ne '' ) { $_ =~ s/\s+$//; $$args{options_labels} .= "$_~"; } } } &log($code, "(options: $$args{options_labels})") if $$args{options_labels} ne ''; Any idea what could be wrong? I contact the helpdesk here, but were unable to help and referred me to this forum. Any help would be greatly appreciated. Regards, Dale

Thanks Rob, but I have done that and received no replies. I am finding it very difficult to find programmers in this field, yet I have heard that it is not 'that' complex if you know what your doing.

I'd probably do better finding a programmer willing to create a custom script or something, anyone know of a programmer familiar with OSC and XML feeds?

I'm just thinking, if this works it's a one off install to the DB and to update current stock levels etc I would have to manually upload again? I am generally looking for a daily automated update of prices, stock level etc. I have heard that cron jobs are what would do this kind of thing, but am not sure. Any ideas about this kind of thing? It shouldn't be that hard once I understand the basics of live XML feeds to an oSCommerce store. Again any help, much appreciated.

Excellent, thanks for the reply I will try these.

Hello, I have an XML data feed available from my supplier to update my site as needed with new products, prices, etc and was wondering how I go about setting this up with my oSCommerce store? Anyone have any idea how it would work? Any help is greatly appreciated.

Thanks for the reply. I wasn't happy with the database queries, so I uninstalled the STS and found a template that doesn't use it. Looking much better now: Parse Time: 0.082s with 33 queries. Original osCommerce demo products and categories. Now all I have to do is find a way of converting my CubeCart database to osCommerce, which I think is impossible

Or not Don.. lol Extra Info: I have all of these enabled and working: Category counts off Added Indexes Turned on cache in oscommerce admin Added Config cache Added new get_tax_rate The live support chat here told me that there is no limit on number of queries per hour like some hosts, so perhaps this is not so much of a problem? Site seems fast enough, I just thought lots of queries put a strain on the server with shared hosting? Any info would be appreciated.

I am having a go with oscommerce and have just installed a template, it's using STS. It had 377 queries to load the index page! So I ran some optimization contributions and got it down to Parse Time: 0.115s with 43 queries However when I click on a category (this is without any products in) Parse Time is 0.161s with 179 queries. Still seems high to me, but then again I dont know that much about oscommerce - what do you guys think?

Hmm... it's still not working correctly. I think this may be a problem with CubeCarts software. I have been thinking about moving over to OSC. Does anyone know of a CubeCart to OSC database conversion script? Or something that will enable me to put my CubeCart databse into OSC - I don't fancy starting again, adding all the products

Hello, I think I have fixed it simply by making sure the Server SECURE Root Directory is: /home/mycpanelusername/public_html (as I installed CubeCart in the root directory). I now have to access my CubeCart Admin via https://servername.totalchoisthosting.com/~...sername/myadmin will this be ok? Dale -- Accessorik

Hello, Can anyone help me setup the free Shared SSL with CubeCart please? This is what I have to enter in the Admin>Settings: Absolute SECURE URL to store: I assume this will be https://servername.totalchoicehosting.com/~cpanelusername as for the rest of the options, any help is much appreciated. Root SECURE Public HTML Folder to store: (Include Trailing Slash) Server SECURE Root Directory: e.g. /path/to/your/secure/webstore Dale -- Acccessorik