Zen Cart Logo
Forums / Setting Up Specials and SaleMaker / Have sale but not show it

Have sale but not show it

Locked

Views: 1,461

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
24 Jun 2008, 3:24 PM
#1
lizar5 avatar

lizar5

Zen Follower

Join Date:
Sep 2007
Posts:
116
Plugin Contributions:
0

Have sale but not show it

Id like to lower all my product prices 10% without the customer actually seeing the original price or even knowing that theres a sale for that matter. How do i accomplish this?

24 Jun 2008, 7:04 PM
#2
justmetoo avatar

justmetoo

Zen Follower

Join Date:
Jun 2006
Posts:
31
Plugin Contributions:
0

Re: Have sale but not show it

You could either update the database table for products with the new prices with a global command to replace the existing price with 10 percent less.

To be safe and eliminate rounding issues or problem, you could add a new field, such as, products_price_original and first put all of the existing prices in that field and then reduce the original products_price by 10 percent.

If you have attribute prices then you would also need to update the products_attributes table.

24 Jun 2008, 8:04 PM
#3
lizar5 avatar

lizar5

Zen Follower

Join Date:
Sep 2007
Posts:
116
Plugin Contributions:
0

Re: Have sale but not show it

Justmetoo:

You could either update the database table for products with the new prices with a global command to replace the existing price with 10 percent less.

To be safe and eliminate rounding issues or problem, you could add a new field, such as, products_price_original and first put all of the existing prices in that field and then reduce the original products_price by 10 percent.

If you have attribute prices then you would also need to update the products_attributes table.

haha ok, im trying to figure out my easy populate atm so when that happens i guess i can move on to this eh? Thanks for the tip :)