Featured products?

[gandhi]

hi

 

my shop

 

www.brewrecords.net/shop

 

I stock my labels records aswell as my friends labels records in our distro section

 

however the way my shop is set out at the moment, my records are not the prominent feature. They should be though!

 

I was thinking of having a section just above my 'new for may' section, kind of a featured record section for my new releases and things relating to my label.

 

any ideas on how i would do this?

 

thanks!

[burt]

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

 

Would only take a small amount of extra code to make an EXTRA box above "new products for".

[gandhi]

I've tried installing that.

 

but how do i install the sql file?

 

heres what it looks like:

 

ALTER TABLE `products` ADD `products_featured` TINYINT( 1 ) NOT NULL AFTER `products_status`;

 

at the moment without the sql i'm getting the following error on the admin > catalog > Categories/products

 

Categories / Products Status Featured Action  
Releases	   
Distro	   
1054 - Unknown column 'p.products_featured' in 'field list'

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_featured from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

[TEP STOP]

[Guest]

To run the SQL command you will need to login to your Database Program which will be something like PHPMyAdmin and there will be a link to either import or to run the SQL command, do that and it will get rid of the error.

[burt]

And if Richards advice makes little sense, perhaps a video will help ?

 

http://www.clubosc.com/how-to-use-phpmyadm...o-load-sql.html

[gandhi]

i did it, no more errors

 

but when i'm in admin and click on the green button to set it as a featured product it does nothing :(

 

doresn't move to the top left or anything

 

both the i concur 7" and brew vol.1 are still at the bottom of new products for may :( even though the green light is on them both :(

 

www.brewrecords.net/shop

[burt]

Then you have not installed properly.

[gandhi]

in what way, it is installed and i can see the buttons, they just dont work...

[Guest]

Did you upload the general.php file?

To be fair it should be bullet proof, all you do is upload the files in replacement and then run the SQL file...

[gandhi]

i think i did the sql on the wrong osc

 

however i tried running it on the right one and got this

 

SQL query: 

ALTER TABLE `products` ADD `products_featured` TINYINT( 1 ) NOT NULL AFTER `products_status` 

MySQL said:  

#1060 - Duplicate column name 'products_featured'

:(

[Guest]

That error means that you have already ran the SQL command and it has done what it needed to do.

 

Try reuploading the files, if that doesn't work then put your original files back in and email me, I've got instructions on how to manually do it.

 

Do you want the instructions to add to the contribution Burt?

[gandhi]

BINGO, forgot to upload includes/modules/new_products.php

 

works great

 

thanks guys, sorry about all this my bad

 

wooosh!

 

now onto the next one! Ace!

[gandhi]

actually my newest release for our label is I Concur - Lucky Jack 7"

 

how do i make it no1 featured product? i.e - ahead of Brew Vol.1, they are both set as featured products but I Concur remains in the number 2 spot...

[Guest]

I think the featured products either work by the date added or the ID number, either way you will need to go in to your database program and alter the date or ID for that product, I would go with the date first because am sure I read some where it was the date. (could have been on Bert's website)