Database query

[warrenerjm]

Hi

 

I have a couple of database questions as I do not play with that much!

 

What command do I use to make all the products a special at 25%? i.e. 25% off everything promotion

 

How do I get it back too :) Only want it at 25% for a week

 

I have some products at 50% at the moment so will all these change to 25% or is there a way of excluding the already discounted specials?

 

Would it be best to delete these specials first before I put the command into the database?

 

Thanks for your help :)

 

Julie

[Guest]

Hi

 

I have a couple of database questions as I do not play with that much!

 

What command do I use to make all the products a special at 25%? i.e. 25% off everything promotion

 

How do I get it back too :) Only want it at 25% for a week

 

I have some products at 50% at the moment so will all these change to 25% or is there a way of excluding the already discounted specials?

 

Would it be best to delete these specials first before I put the command into the database?

 

Thanks for your help :)

 

Julie

 

 

What u mean by make all the products a special at 25%

 

Do u mean make all product 25% cheaper?

 

if so u need to do this:

 

1) go to your mysqladmin

2) execute this command:

update products set products_price = (products_price * 1.25)

[warrenerjm]

What u mean by make all the products a special at 25%

 

Do u mean make all product 25% cheaper?

 

if so u need to do this:

 

1) go to your mysqladmin

2) execute this command:

update products set products_price = (products_price * 1.25)

:) sorry I mean I want all the prices to show as a special with a 25% discount. i.e. I don't want/can't due to numbers go through all the products seperately & make them a special price (sale) of 25%.

 

I need to be able to put them all back to the original price in the same manner too.

 

Am I making more sence now?

[Guest]

:) sorry I mean I want all the prices to show as a special with a 25% discount. i.e. I don't want/can't due to numbers go through all the products seperately & make them a special price (sale) of 25%.

 

I need to be able to put them all back to the original price in the same manner too.

 

Am I making more sence now?

 

 

It`s not possible need to make each price as special and then u can make all your products special!

[warrenerjm]

It`s not possible need to make each price as special and then u can make all your products special!

:huh: not sure what you mean?

So I change all the prices to the new 25% off value & then make them all specials? Won't that just show them all as the same price? i.e. not the original 100% & the new special price in red? Plus how do you make them all as specials?

 

Any suggestions to create a store wide discount?

[Guest]

:huh: not sure what you mean?

So I change all the prices to the new 25% off value & then make them all specials? Won't that just show them all as the same price? i.e. not the original 100% & the new special price in red? Plus how do you make them all as specials?

 

Any suggestions to create a store wide discount?

 

 

U don`t need to make this command:

 

update products set products_price = (products_price * 1.25)

 

But u need to add your products to specials!

[♥mdtaylorlrim]

I would probably look into a contribution that does what you want already.

 

http://addons.oscommerce.com/info/5760

 

It may have to be altered just a little.

[warrenerjm]

I would probably look into a contribution that does what you want already.

 

http://addons.oscommerce.com/info/5760

 

It may have to be altered just a little.

Thanks Mark

 

This add-on sounds like what I want i.e. set a site wide 25% discount for 1 week :)

It doesn't say whether it will show them all as a special, or just reduce all the prices by 25% which can be done in the database? There isn't a .sql so not sure how the .php file code will achieve this?

 

When you say it may have to be altered just a little, what do you mean please?

 

Silly me was thinking I could manipulate the database to add all the products to the specials table at the discount rate! duh!! I have looked at the discount contributions, but I don't want anything too complicated, coupons or discount codes etc.

 

Thanks again

[burt]

A coupon code would be the simplest way to do this, linked to the display->price to show the discounted amount.

[warrenerjm]

A coupon code would be the simplest way to do this, linked to the display->price to show the discounted amount.

:( been searching these & haven't found an easy one? Could you point me to it please?

 

Just wondering if the best (easiest) way would be to use the database to reduce all the original prices by 25% & put a BIG notice on the front page that the prices shown include the discount????

 

Having said that my card option clearly states for UK only & still I get international orders using it! :angry:

 

How would I get the prices reduced by 25% & how would I get them back to the original price too please?

 

I have the Points & Rewards contribution, but would have to turn it off during the sale as I don't want to give points too! That is why I was hoping they would show as a Special product as these can be excluded from points.

 

I think I have called the thread wrong so I'm hoping I'll still be able to get some help on this? :)

[warrenerjm]

I would probably look into a contribution that does what you want already.

 

http://addons.oscommerce.com/info/5760

 

It may have to be altered just a little.

:D :D :D

 

That works ... apart from a small coding error in one of the files!!

 

Hope it works with live customers :-"

 

Thanks