Products not showing on categories.

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7027

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.

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7028

front end or back end.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7029

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.

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7031

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.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7032

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.

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7033

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.

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7034

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.

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7035

deleted by author

Last edit: 13 years 9 months ago by JWeb5.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7036

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.

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7037

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.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7038

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.

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7039

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.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7040

Could you find just one example so that we can look at it ?

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

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7044

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.

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7045

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.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7046

Could you activate the debug mode option in the configuration of your website ?

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

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7047

it's activenow,

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

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7048

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.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
13 years 9 months ago #7049

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.

  • Posts: 79
  • Thank you received: 0
13 years 9 months ago #7116

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.088 seconds
Powered by Kunena Forum