Specials

[klevans]

Hi

I tried to add some of my items to a special discount.

I added one for a test and it showed 3 of the same product in the main page went to specials page it only shows one I tried just the side box and it showed 2, dose anyone have any ideas on this?

[klevans]

Any one have any thoughts on this for me ?

[Ajeh]

What version of Zen Cart?

Clean install or an Upgrade?

What happens if you switch to the Classic Template to check if the problem is template oriented?

[klevans]

Hi

I am on v1.3.9h Clean Install and it dose it with the default template too.

I added one now if you want to have a look to see how it shows.

jazmin-books.co.uk

[stevesh]

Is that book inside a category ? You can't have both products and subcategories in a category. It looks like you put your test product in the Top category.

[klevans]

Hi

The product is only in the sub cat

Categories - Fiction > Media Tie-In >

The Tudors: King Takes Queen: Series Two Companion.

[stevesh]

There it is. Reason I asked is the URL for your specials shows the cpath (category id) as 0, when it should be 1117_1144. Someone else might know what that means.

[klevans]

That's Main cat is 1117 and the sub cat is 1144

Is if you entered the direct url

http://www.jazmin-books.co.uk/index....dex&cPath=1117

Takes you to the main cat and if you enter

http://www.jazmin-books.co.uk/index....dex&cPath=1144

It takes you to the sub cat direct

And the book url is

http://www.jazmin-books.co.uk/index....ducts_id=31538

Were it includes both sub and main

But I did not think that would mess around with the Product call from the Database to show multiple products for the same ID

I tried it with 5 products and some time's on a refresh it showed multiple of the different ones then it only showed 2 or 3 multiple ons but when you go to the specials pages it only shows the one.

http://www.jazmin-books.co.uk/index...._page=specials

Other than that I am still learning so any help is great

[Ajeh]

Go to phpMyAdmin and search the table:
specials

for the products_id 31538 ... how many are in there?

Go to the table:
products_to_categories

and search for the products_id 31538 ... does each row have a unique categories_id to it? Are any of the categories_id set to 0?

Go to the table:
products

and search for the products_id 31538 ... is there only 1?

Go to the table:
products_description

and search for the products_id 31538 ... is there only 1?

[klevans]

products_to_categories 1 Row

products 1 Row , master_categories_id = 0

products_description 1 row

specials 1 Row