Can't put items on sale

I seem to be having a problem putting items on sale or as featured products. Should be straight forward, I know, but when I go to specials I don't see any products that I can put on sale. The same appears when I try to setup featured products.

This is a new install, installed as 1.3.0.2, then upgraded up to 1.3.7. My store is setup as type 2, showcase with prices. I've tried changing that to normal store, but didn't make a difference either.

--max

Hey max, im having the exact same problem here, my version is 1.27.

I've been trying to solve this all day, If i find the solution, i'll be sure to let you know, if you could kindly do the same :)

Liam

Check that all of your products have master_categories_id in the products table ...

Then check that you can see the products in the Catalog ... Categories/Products ...

Then, edit a product and make sure that a Master Category is set ...

How did you do the upgrade? Did you run the /zc_install completely for all checked boxes?

Hi Linda,

Looking at the products table in the DB, the products do have a master category set.

The product also shows correctly in ZenCart admin.

I ran all the upgrade scripts in zc_install to bring the install up to the current version.

Any other suggestions that I could try out or check?

thanks again,
max

How many products do you have?

How many of these products are in the specials table in the database already?

How are you setting up your Sale Maker Sale?

How many products are in the featured table in the database already?

That's just it, I can't add products in Catalog/Specials or Catalog/Featured Products. The screen comes up with a blank selection for the product field.

I currently only have 27 products total while I'm sorting through this issue.

I haven't setup Sale Maker Sales as I'm looking for setting up specials and featured products on a per product basis. I have also tried with setting up a sale in sale maker but that did not make a difference into me being able to add products into specials or featured products.

--max

Hiya, to answer the same set of questions for my very similar situation.

All of my products have master_categories_id in the products table ...

I can see the products in the Catalog ... Categories/Products ...

After editing a product the Master Category is set ...

I havent ran the upgrade yet but this all seemed to work not too long ago.
One addition i should throw in here, I used to have specials, quit a few in fact, but after deciding to change them, i removed them all. I dont know if I could or couldnt add new specials immediately before or after the deletion. However i only deleted them last week.

I have 186 products, 0 in the specials table, and 0 in the featured table. Before now i hadnt even looked at the Sale Maker parts, the sale maker seems to be working fine but doesnt make any difference to the Specials/featured products.

any ideas would be much appreciated

liam

MaxK:

That's just it, I can't add products in Catalog/Specials or Catalog/Featured Products. The screen comes up with a blank selection for the product field.

I currently only have 27 products total while I'm sorting through this issue.

I haven't setup Sale Maker Sales as I'm looking for setting up specials and featured products on a per product basis. I have also tried with setting up a sale in sale maker but that did not make a difference into me being able to add products into specials or featured products.

--max

What are the products_type for your Products in the products table?

liamingram what products_type are your Products in the products table?

Have you an URL to your site where we can see these products?

all of my products seem to be using Product_Type = 1

a url for a product; http://www.monkseatoncomputers.co.uk/index.php?main_page=product_info&cPath=86_88&products_id=138

thanks for your efforts with this ajeh :)

That Product appears to be marked Call for Price ... as do many of your products ...

When you browse the products table what is in the products_price field?

NOTE: Products can be marked Call for Price and still show the Price, Special and Sale ... providing there is something to display ...

good morning :) i am needing a million cups of coffee today, i can feel it already!

Sorry yes I should have explained the purpose of my shop a little bit more!

In the long run I want my shop to not contain any prices unless the product is a special.

So to emulate this, ive set it up as a Showcase with prices, I have removed the prices from my products and set them up as "call for price".

Im at the point now of adding the specials and giving them A) a price and B) a special price. These products wont be set to "call for price".

So here is a link to a product that has a price http://www.monkseatoncomputers.co.uk/index.php?main_page=product_info&cPath=118_119&products_id=230 but obviously without a special price as i cant do that just yet.

To answer your questions.. in my database the products that are meant to have prices - have prices, and the ones that arent - have 0.0000

:o)

Thanks, Liam

Same here, all products are set as Product_Type=1

Similar to Liam, my store is setup as Showcase with Prices. I have a test price on all my products, yet still unable to see any products in either specials or featured products.

--max

liamingram ...

If you switch to Classic ... do things work differently?

NOTE: if all products are on Special ... there will be nothing in the scroll list on the
/admin/specials.php

as all are on Special so who are you going to add? :lamo:

Same holds true on Featured
/admin/featured.php

Yep, unfortunately, i get the exact same results when i switch to the classic template.

None of my products are on special as of yet! But boy i wish tey were :oP

Cheers again

Liam

liamingram, could you please PM me an URL and access to your Admin ... you have me totally baffled ... :lamo:

MaxK, With linda's help I have been informed that when the "Add Products to Cart" is switched off for a particular product type; the products of that type wont appear in the Specials Or Featured Pages.

So if you goto Catalog>Product Types> and set "Add products to cart" = true for the various product types. You will be then able to add the specials, and then turn it back off!

This resolved my problem, I hope it resolves yours.

Liam

NOTE: this works in this ancient version of Zen Cart ... this is not necessarily the only solution to this oddity but definitely worth looking into ... :cool: