All Products On Specials

[Guest]

Hi

 

I'm looking for an easy way to put all of my products on specials. I have searched for booth contribs and fixes.... but no luck just yet.

It would be nice if there was an easy way to give eg. 40% discount on all products.

Anyone outthere with a good idea? It would be most appreciated.

 

Kind Regards

Frank Johansen

www.borneborsen.dk

[Jack_mcs]

I don't think any of the specials contributions allow for a mass changing like that. You could just put a specials notice on the products page and then reduce all of the prices. That would have the same affect, I think.

 

Jack

[rrrhythm]

Hi

 

I'm looking for an easy way to put all of my products on specials. I have searched for booth contribs and fixes.... but no luck just yet.

It would be nice if there was an easy way to give eg. 40% discount on all products.

Anyone outthere with a good idea? It would be most appreciated.

 

Kind Regards

Frank Johansen

www.borneborsen.dk

 

as always, back-up your database before you do anything!

 

you could do what you want without too much pain using a spreadsheet and phpMyAdmin, the idea being to use the spreadsheet to generate the necessary sql statements (insert into 'specials'...) for each product in your catalog.

 

 

the sql to insert one special would look like this:

 

INSERT INTO `specials` (`specials_id`, `products_id`, `specials_new_products_price`, `specials_date_added`, `specials_last_modified`, `expires_date`, `date_status_change`, `status`) VALUES (NULL, 'valid product_id', 'new price', 'today's date', NULL, 'expiry date', NULL, '1');

 

replace the red text with valid values and run that query and you'll put one product on special.

 

you would just have to generate one of these queries for every product in your store. that's where the spreadsheet would come in. first use phpMyAdmin to generate a list of all your product_id numbers, and their current price, insert all that into a spreadsheet, then use the spreadsheet functions to generate the specials sql query for each product, with the new price being 40% of the original price.

 

you want to end up with multiple insert queries, seperated by a semi-colon: insert into ... ; insert into ... ; insert into ... ;

 

then run that query, which should put everything on special.

 

again, be sure to back up first!

 

cheers,

rj