If this is your first visit, check our documentation. To post, register or login.
Forums / Setting Up Specials and SaleMaker / Nothing happened when I started a Holiday Sale

Nothing happened when I started a Holiday Sale

Locked

Started by roverdrover on 21 Dec 2008, 5:30 PM · Views: 2,242

Results 1 to 10 of 10
This thread is locked. New replies are disabled.
21 Dec 2008, 5:30 PM
#1
roverdrover avatar

roverdrover

New Zenner

Join Date:
Feb 2008
Location:
East Texas -- woods -- near Louisiana
Posts:
6
Plugin Contributions:
0

Nothing happened when I started a Holiday Sale

**** Last night I used SaleMaker to set up a 10% off sale on everything that cost between $0 and $9,999, starting immediately and running til January 6th.

It shows just fine on the Admin Home Page. But nothing's happened on the website. There's no change in prices on the site, and I ran a trial purchase of a test product, and there was no change in the price anywhere through the checkout procedure.

Checked the manual, and I did everything just the way it said to do it.

Thanks.

21 Dec 2008, 9:44 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Nothing happened when I started a Holiday Sale

Check, via phpMyAdmin the products table and confirm that all products have a master_categories_id in them and that none are 0 ...

If they do not, do you use Linked Products?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

22 Dec 2008, 6:27 AM
#3
roverdrover avatar

roverdrover

New Zenner

Join Date:
Feb 2008
Location:
East Texas -- woods -- near Louisiana
Posts:
6
Plugin Contributions:
0

Re: Nothing happened when I started a Holiday Sale

Thanks -- I'll check for the Master Category ID numbers. I know there are a few Linked Products too -- can't remember which at the moment, but they're products linked within the same Master Category.

22 Dec 2008, 3:28 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Nothing happened when I started a Holiday Sale

Check the Known Bug Fixes for v1.3.8 ...
http://www.zen-cart.com/forum/showthread.php?p=659717#post659717

And see if the fix for #28 solves the pricing problems with a Sale created with SaleMaker ...

NOTE: The other bug fixes would also be a good idea ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

23 Dec 2008, 1:12 AM
#5
roverdrover avatar

roverdrover

New Zenner

Join Date:
Feb 2008
Location:
East Texas -- woods -- near Louisiana
Posts:
6
Plugin Contributions:
0

Re: Nothing happened when I started a Holiday Sale

Linda, I've checked. Every product has a Master Category ID# and none are set to 0. And there are no linked products -- everything's green or red. There are a couple of categories that are disabled at the moment, and one has a product in that's disabled too, obviously.

Thanks for the help.

23 Dec 2008, 2:04 AM
#6
mamasylvia avatar

mamasylvia

Zen Follower

Join Date:
Feb 2008
Posts:
379
Plugin Contributions:
0

Re: Nothing happened when I started a Holiday Sale

I'm going to assume you're not a Zen guru and ask the same questions I had to muddle through ... please don't be offended.

What did you set as the deduction? What as the type?

You've already specified the price range -- do you actually have products costing over $10K or did you just think you had to put something in there? If the latter, try resetting the price range from 0 to 0. (I have a SaleMaker sale working right now, so I'm looking at my settings as I type.)

Did you either check the "entire catalog" box, or one or more categories under the "OR check the categories to which this sale applies" list? If neither, I suspect that's the problem. I've found SaleMaker rather quirky and tend to use the Specials option instead. But it is very nice when it does work.

Sylvia
PM at your own risk, I don't check in regularly!
MamaSylvia.com My ZenCart tutorial

23 Dec 2008, 2:49 AM
#7
roverdrover avatar

roverdrover

New Zenner

Join Date:
Feb 2008
Location:
East Texas -- woods -- near Louisiana
Posts:
6
Plugin Contributions:
0

Re: Nothing happened when I started a Holiday Sale

Oh, Sylvia, I could KISS you!!! (Except, you prolly wouldn't want me to ...)

Yes, I'm totally new at this, and trying to learn as I go along. I'd sent the top price because I thought I had to, and it was above our highest-priced object. And I thought I'd had the 10% apply to the whole catalogue, but it wasn't checked when I went back in to edit.

You just made me look good, and I'll give you all the credit! Thanks again, and happy holidays,
Kate Morningstar

23 Dec 2008, 3:02 AM
#8
mamasylvia avatar

mamasylvia

Zen Follower

Join Date:
Feb 2008
Posts:
379
Plugin Contributions:
0

Re: Nothing happened when I started a Holiday Sale

Glad to help, and glad you got it working! Just remember SaleMaker is a bit quirky and don't get discouraged if you don't get it right the first time. One thing I've learned is that it's often the obvious things I get wrong!

Sylvia
PM at your own risk, I don't check in regularly!
MamaSylvia.com My ZenCart tutorial

23 Mar 2009, 8:38 PM
#9
mrspiffy avatar

mrspiffy

New Zenner

Join Date:
Mar 2009
Posts:
29
Plugin Contributions:
1

Re: Nothing happened when I started a Holiday Sale

RoverDrover:

**** Last night I used SaleMaker to set up a 10% off sale on everything that cost between $0 and $9,999, starting immediately and running til January 6th.

It shows just fine on the Admin Home Page. But nothing's happened on the website. There's no change in prices on the site, and I ran a trial purchase of a test product, and there was no change in the price anywhere through the checkout procedure.

Checked the manual, and I did everything just the way it said to do it.

Thanks.

I too had the above problem and found myself here. In my case, I had noticed that when I touched(but not modify) an item in the product price manager, I saw that the sale suddenly worked for those items. So I knew some field was being set somewhere and then I saw this little gem

Check, via phpMyAdmin the products table and confirm that all products have a master_categories_id in them and that none are 0

and sure enough, the majority of my products in the products table had a master_category_id field set to 0, the exception being those items I had touched via product price manager.

Now, Ive been loading my products with the easy populate tool (1.2.5.4) and this tool does not set the master_categories_id in the products table. This issue came up in a SEO thread and the solution recommended was to visit TOOLS -> Store Manager and hit the "Reset ALL Products Master Categories ID" button.

I did this and now my sale is working properly. How that reset would affect any linked products is unknown to me(and Id like to know), so Id definitely would make a DB backup before trying this solution.

I figured someone was going to be in the same boat as I was and just thought I would share a solution.

24 Mar 2009, 2:52 PM
#10
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Nothing happened when I started a Holiday Sale

The problem is ... most import programs do not address the master_categories_id ...

The Reset in the Store Manager will set the master_categories_id ... however, be aware that it will set it to the first categories_id it finds in the products_to_categories table ... which is most likely the "lowest valued" categories_id which may or may not be correct ...

Also note, there is a tool in the Copy Product ... in the Multiple Categories Link Manager on the bottom right panel when you click Copy ...

On the bottom of the screen are some options to pick a Category and set all of its Products to use it as their master_categories_id ...

SaleMaker uses the master_categories_id for the Sales ...

NOTE: see the Known Bug Fixes v1.3.8 for updates related to this as well as other Bugs that you will want to apply ...
http://www.zen-cart.com/forum/showthread.php?t=81696

Note: other updates for for USPS:
http://www.zen-cart.com/forum/showthread.php?t=97461

Note: Security Alerts
http://www.zen-cart.com/forum/showthread.php?t=108428

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!