Skip to main content

Products not showing on categories.

More
15 years 7 months ago #7027 by JWeb5
I m losing products. It;'s happened once before and i dropped tables and readded them, but it is happening again, and dropping them isn;t correcting the issue.

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7028 by JWeb5
front end or back end.

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7029 by nicolas
What do you mean by you're "loosing them" ?

Do you see them on the front end listing ?
Do you see them on the back end listing ?
Do you see them in the hikashop_product table if you look in the database ? If yes, please note their product_id value and look at the table hikashop_product_category. Can you find them referenced in that table (their product_id value being in the product_id column of that table) ?
If yes, what is the corresponding value of the category_id column ?

That's really strange because no one else has that problem...

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7031 by JWeb5
They are refeerenced have correctly. Example Categorie 17 has 30 products none are showing up in front or backend. Categorie 21(anthias) has mutiple products and only one is showing in front and back end. Is it just a SQL problem? can you offer adviceto fix it?

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7032 by nicolas
You're the first one with such a problem. Could you give us an access to your website backend so that we can look at your settings ?

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7033 by JWeb5
i have 1206 in Hika_products, but only 1160 in Hika_categories

I'm not sure what you mean byProduct_id value

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7034 by JWeb5
Product_Id has a numeric value in Hika_products, and the smae "relative value" is indicated under product_category uer the PRoduct_id field....

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago - 15 years 7 months ago #7035 by JWeb5
deleted by author
Last edit: 15 years 7 months ago by JWeb5.

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7036 by nicolas
I went on your website back end and front end and I could clearly see the 38 fishes for the angels category (id 17).

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7037 by JWeb5
Yeah i dropped and reloaded everything again. it's still missing close to 1000 products though, and this isn;t the first time it had the same behavior. Is there something I can do to stop it from happening? All of the softwares used are new to me, so I am sort of on a learning curve.

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7038 by nicolas
Well, if you put back everything before we got the chance to analyze the problem, we can't tell you any solution since we don't know what causes the problem...

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7039 by JWeb5
aquatic-exotics.net/index.php?option=com...2&category_pathway=0


I am still missing 1,000 products, i just don't know which ones.

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7040 by nicolas
Could you find just one example so that we can look at it ?

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7044 by JWeb5
The butterflies Category. Iamshowing one product,on the front end and I have 35 listed under that category(#20)

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7045 by JWeb5
the link above was a new error showing on front end regaring images. I checkedthe file path of the image,but thats notthe problem.

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7046 by nicolas
Could you activate the debug mode option in the configuration of your website ?

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7047 by JWeb5
it's activenow,

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7048 by JWeb5
can you look at it again and post please, I'm alone at the shop until 9 and can't stay online.

thankyou!

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7049 by nicolas
I looked at your data. In the butterflies category, there is only one product listed in the database, which is why it displays only one product.
In the table hikashop_product_category, if you search for the the category_id 20, there is only one result which is the link between that category and the Reef product you have.

So, could you precisely name a product of that category ? That way, I would be able to check the other way around...To see if that product exists without a link to the category.

How do you add the products ? Do you use the import of a CSV file ?

Please Log in or Create an account to join the conversation.

More
15 years 7 months ago #7116 by JWeb5
Atlantic
Aureo Fasciatus
Brown Heniochus
Auriga
Black Banded
Black Finned
Brown Heniochus
Chaetodon Multicintus
Citron Butterfly
Collare
Copperband
Double Saddle
Four Eye
Melon Butterfly
Moorish Idol
Punctato
Bennetti
Racoon
Red Sea
Vagabond
White Face
Brown Heniochus
Yellow Longnose
B &W Henniochus
Monocerus
Pearlscale
Black Pearlscale
Raflessi
Pakistani
SemiLavaratus
Saddlebacks
Punctato
Kleini
Pyramid
Reef
These are all of the products that are supposed to be listed in category 20. The show that they are imported in Hika_products via CSV, and I have verified that they are in the table, but they are not showing in Products_category in the DB.

Please Log in or Create an account to join the conversation.

Time to create page: 0.328 seconds
Powered by Kunena Forum