Better SEO Images V1.0 for CRE Loaded

Category: Images

After looking at the "SEO images v0.99" which never worked for me at all, with too much code edits, and "TiM's better Image Upload" contribution which also didnt function correctly on my heavily modified store,
I decided to write my own, based loosly on Tims mod. When you upload a product image within the administration section, the image will be renamed like this:

ProductID - Product_Name - Model Number - File extension

Example:

you upload a file called "anything-you-like.gif" and your products id is "3" and product name is "Asus 2GB ATi Radeon HD 4870x2 PCI Express 2.0 Graphics Card Retail" and your products model is "EAH4870X2"

Your products image name will then be saved like this 3-Asus_2GB_ATi_Radeon_HD_4870x2_PCI_Express_2_0_Graphics_Card_Retail-EAH4870X2.gif

Consider buying me a beer if you find this useful :) https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=8115668 Cheers ;)

################################################################################
PLEASE NOTE: If you do use long image names like this you will need to alter the database with PHPmyAdmin or similar...

You need to allow more characters for both the "products_name" field in the "products_description" table, change VARCHAR from 64 to 255 and do the same for the "products_image" field in the "products" table.

for example:

ALTER TABLE `products_description` CHANGE `products_name` `products_name` VARCHAR( 255 )

and:

ALTER TABLE `products` CHANGE `products_image` `products_image` VARCHAR( 255 )
################################################################################

Based on a 2.2 RC1 installation, but should work fine on other versions.

This contribution has been found on osCommerce website, but you can ask us how much would it cost to get it working with CRE Loaded