Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to use thumbnails for products pics


chfields

Recommended Posts

Posted

I created thumbnails of my products. Now I want them to display on my start page in the new products box(which I changed to just products). How do I do that???

I tried downloading an image resizeing contrib but there was an error in the header and wouldn't download. Is there a way I can just use the thumbnails I have??

Posted

The mopics contribution does this perfectly.

Follow the instructions to the letter and you can't go wrong (famous last words!) ...

 

Of course, you'll also really notice the decrease in page load-time if you're used to seeing the full size images being shrunk down by OsCommerce.

 

Ali

www.freelollies.co.uk

Posted

Is there a way to use the thumbnails I have?? Otherwise I need to delete them all and I have about 1200 of them

Posted

with the mopics contrib you will need those thumbnails you have so don't delete them.

It's a very simple mod to add, I added the first day I have ever seen Oscommerce or php.

Posted

I have never used phpmyadmin before and I'm concerned about editting the products table. The read me says Insert a new column into the products table - products_bimage.

(if you are using phpMyAdmin 2.2.3 you can simply paste the following into the SQL query window

 

- presuming that your database is 'catalog')

################################################################################

########################

### If anyone wants to give me the easy way to add all of these please send it to me. ###

### This is just the way I did it. ###

### #################################### ###

################################## ONLY DO THIS ONE LINE AT A TIME ####################################

#################################### #

ALTER TABLE `catalog`.`products` ADD `products_bimage` VARCHAR(64) AFTER `products_image` #

#

ALTER TABLE `catalog`.`products` ADD `products_subimage1` VARCHAR(64) AFTER `products_bimage` #

#

ALTER TABLE `catalog`.`products` ADD `products_bsubimage1` VARCHAR(64) AFTER `products_subimage1` #

#

ALTER TABLE `catalog`.`products` ADD `products_subimage2` VARCHAR(64) AFTER `products_bsubimage1` #

#

ALTER TABLE `catalog`.`products` ADD `products_bsubimage2` VARCHAR(64) AFTER `products_subimage2` #

#

ALTER TABLE `catalog`.`products` ADD `products_subimage3` VARCHAR(64) AFTER `products_bsubimage2` #

#

ALTER TABLE `catalog`.`products` ADD `products_bsubimage3` VARCHAR(64) AFTER `products_subimage3` #

#

ALTER TABLE `catalog`.`products` ADD `products_subimage4` VARCHAR(64) AFTER `products_bsubimage3` #

#

ALTER TABLE `catalog`.`products` ADD `products_bsubimage4` VARCHAR(64) AFTER `products_subimage4` #

#

ALTER TABLE `catalog`.`products` ADD `products_subimage5` VARCHAR(64) AFTER `products_bsubimage4` #

#

ALTER TABLE `catalog`.`products` ADD `products_bsubimage5` VARCHAR(64) AFTER `products_subimage5` #

#

ALTER TABLE `catalog`.`products` ADD `products_subimage6` VARCHAR(64) AFTER `products_bsubimage5` #

#

ALTER TABLE `catalog`.`products` ADD `products_bsubimage6` VARCHAR(64) AFTER `products_subimage6` #

#

################################## ONLY DO THIS ONE LINE AT A TIME ####################################

 

 

 

First says copy and paste it then says one line at a time. I'm confused....Also says 2 manual alterations but changing the database is the only manual alteration I see in the read me. You've done this, what do i need to do???

Posted

Not to further muddy the waters, but there is another contribution called Big Images that provides for 2 images for each product - a thumb and a larger image. You might want to give it a look:

 

http://www.oscommerce.com/community/contri...ions,614/page,2

... if you want to REALLY see something that doesn't set up right out of the box without some tweaking,

try being a Foster Parent!

Posted

I started all this. I was on his site and all of his pics were averaging 30 to 50k and he has 9 of them. I suggested sm, med, large pics, but the code is a little out of date and I don't have the coding skills to update it for newer snaps.

 

It looks like he is trying to install MO PICS. Which I don't think will do what he wants.

 

I also see that the SQL syntax is incorrect. I keep getting catalog.products table doesn't exsist. The only way I could get the query to run is alter the syntax to this:

 

 ALTER TABLE `products` ADD `products_bimage` VARCHAR(64) AFTER `products_image`

 

This should be done to all of the querys.

 

chfeild

 

To run the querys, just open PHPMyAdmin and click on the database in the left frame and a list of tables with appear in the right. Go to the botom and you will find a box that says "Run SQL Queries........." Just cut and paste the queries one by one and alter the catalog.products part to just products. And each query will look similer to the one above execpt the field names.

Steve

-------------------------

Posted

What I want to do is, use the thumbnails I created to replace the images I'm using now in my products page. Steve says my current pics are too big. Does anyone know if there is a contrib that will use them or if there is code I can change that will accomplish this?

Posted

Use the big images contrib, I think it would work best for you.

Posted

Sorry for the followup - can't figure out how to edit my previous post. Do either the mopics or big images contributions dynamically create the thumbnails or do we provide?

Posted

I beleive you need to have 2 pics. One small one big to use big images contrib. Thats why it seems to be good for me

Posted
Sorry for the followup - can't figure out how to edit my previous post.  Do either the mopics or big images contributions dynamically create the thumbnails or do we provide?

 

You can't edit your post, something to do with this forum being posted to a news group.

 

Neither contrib creates thumbnails. But, I do believe there is a contrib that does.

 

Mo Pics has the abililty for you to add multiple images per product.

 

Big pics is so you can creat a small pic for your catalog and the you can still have a big pic for your popups.

Steve

-------------------------

Posted

Hi, Thank for writng this Mod. I downloaded your file. However You have all the

files, could you please let me know what changes did you do to the mod? If I

want to manually hack into the code, how do I do that?

 

The reason I'm saying, it is because I already installed this Mod.

http://www.oscommerce.com/community/contributions,1032

 

If I just upload the files You gave to me, I will mess up the current Mod I

have.

 

Thank you so much for your Time!

Posted
Hi, Thank for writng this Mod. I downloaded your file. However You have all the  

files, could you please let me know what changes did you do to the mod? If I  

want to manually hack into the code, how do I do that?

 

The reason I'm saying, it is because I already installed this Mod.

http://www.oscommerce.com/community/contributions,1032

 

If I just upload the files You gave to me, I will mess up the current Mod I  

have.

 

Thank you so much for your Time!

 

You need to contact the author of the contrib. He should be able to answer your questions.

Steve

-------------------------

Posted

Hi, I have added several contributions and now I am worried adding any contributions that use a "file replacement" method will mess up other contributions.

 

Most of the contributions have step by step edits to perform - I like this method as it preserves other previously contributed code.

 

Doing a file replace, as in the big images contribution, could potentially erase previous pieces of other contributions..

 

So I am curious, howm any contributions out there supply files to replace versus step by step edits?

 

I wish all contributions would have step by step edits..

 

That's my mini rant. If anyone has a big images step by step guid with no file replacement I will appreciate it.

 

Thanks

 

John M

Posted
Hi, I have added several contributions and now I am worried adding any contributions that use a "file replacement" method will mess up other contributions.

 

Most of the contributions have step by step edits to perform - I like this method as it preserves other previously contributed code.

 

Doing a file replace, as in the big images contribution, could potentially erase previous pieces of other contributions..

 

So I am curious, howm any contributions out there supply files to replace versus step by step edits?

 

I wish all contributions would have step by step edits..

 

That's my mini rant. If anyone has a big images step by step guid with no file replacement I will appreciate it.

 

Thanks

 

John M

 

I agree. but the only other option, if the author is unwilling, go and get a program called "Beyond Compare" Makes it easy to compare files.

Steve

-------------------------

Posted

Making it whatever size we please

 

ie:thumbnail image is say 75*75 and we want the product page image to be 100*100 / 200 *200 /300*300without resizing the thumbs and sttill keeping you image pop up to the origenal size (lets say 400*400 / 600*600)

 

So we only have to upload on image per product and control the product images size.

 

Because there is a simple way to do this

 

Let me know if this is what we are talking about and i'll post how to do it

 

If you are talking something differant (i missed the idea you were getting at.

Posted
Making it whatever size we please

 

ie:thumbnail image is say 75*75 and we want the product page image to be 100*100 / 200 *200 /300*300without resizing the thumbs and sttill keeping you image pop up to the origenal size (lets say 400*400 / 600*600)

 

So we only have to upload on image per product and control the product images size.

 

Because there is a simple way to do this

 

Let me know if this is what we are talking about and i'll post how to do it

 

If you are talking something differant (i missed the idea you were getting at.

 

There is one problem with this idea. And that is download time. If you use a large image, lets say 50k, and resize it to 100x100. And put 6 of these on one page you have a 300k image to download. Not good for dial up. Ok, on the other end. If we have an image, lets say 5k, and use it for popup it will only size to it's default size, which would be probably 75x75 pix size and if you use it on your product page and size it to 200x200 it will be distorted. And this is where big pics comes in. You have your large image for popup and you can do a creative balance for your thumbs and product pic and keep the file size small.

Steve

-------------------------

Posted

you make but for a store that the file size is small it's an easy solution for someone with lets say 200*200 at 5k and resizing them to the thumb 50*50 and having your product page picture at 150*150 it is a quick solution to do in one shot.

 

In two lines of code

 

But i will take a look into the image contribution that you guys are talking about.

 

thanks_bubba30

Posted
you make but for a store that the file size is small it's an easy solution for someone with lets say 200*200 at 5k and resizing them to the thumb 50*50 and having your product page picture at 150*150 it is a quick solution to do in one shot.

 

In two lines of code

 

But i will take a look into the image contribution that you guys are talking about.

 

thanks_bubba30

 

But 5k 200px image would be pretty grainy.

 

Take a look at MO Pics. This is what I am using. It works great.

Steve

-------------------------

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...