Products not displaying in category.

  • Posts: 5
  • Thank you received: 0
14 years 5 months ago #5492

Modules published as well and we're using the stock Joomla template. Been through the tutorial, step by step. Still messed up with zero products showing. Tried all different display positions, menus, recreating the categories and products. Fresh install too.

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

  • Posts: 84102
  • Thank you received: 13638
  • MODERATOR
14 years 5 months ago #5493

Then, could you give a link to the page where you don't see your products ?

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

  • Posts: 5
  • Thank you received: 0
14 years 5 months ago #5496

No, I created the categories the way the tutorial said to, through the Hikashop options. No products show at all. We've been trying everything for the last several hours.


nicolas wrote:

Hi,

I suppose that you create a categories listing menu via the joomla manager, right ?
You need to click on the "hikashop options" link of the menu options. That will display the hikashop options of the menu. There, save the options. A message will appear that you don't have an associated module for it. You can click on the link provide to generate it. That associated module will handle the listing of products for the listing of categories menu.

You can read more about it on that tutorial:
www.hikashop.com/support/documentation/6...html#categories_menu

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

  • Posts: 84102
  • Thank you received: 13638
  • MODERATOR
14 years 5 months ago #5498

You are replying "no" to my question "I suppose that you create a categories listing menu via the joomla manager, right ?" ?
Because that's what is written in the tutorial.

It should be straight forward. You must be missing something at some point.

Did you try to create a listing of products ? That doesn't require any associated module... Just to create a menu via joomla and set the parent category in the hikashop options. Does it work ?

Again, could you give the URL of the page ? That would enable us to see more precisely what you're missing.

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

  • Posts: 5
  • Thank you received: 0
14 years 5 months ago #5520

I followed the tutorial for creating categories and products. The products just don't show up on the home page using the module.

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

  • Posts: 5
  • Thank you received: 0
14 years 5 months ago #5522

Sorry guys. This is WAY too unstable for us to use. Off to review this on the Joomla Extensions site then look for something that will actually show products in a category.

Thanks

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

  • Posts: 84102
  • Thank you received: 13638
  • MODERATOR
14 years 5 months ago #5528

I understand your frustration, but you don't answer to our questions. I asked you several times the URL of the page where you have the problem in order to see what is the problem, but you never gave it to me :/
Please understand that we can't solve problems we can't reproduce without information about the problems.

I hope your find an extension that better suits you.

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

  • Posts: 5
  • Thank you received: 0
12 years 9 months ago #70481

I know this thread is an old one, but I've also experienced the same (similar) problem importing products.

It seems to work fine with a small sample of products with short, simple names, but fails to allocate a category for each product when there are a lot of entries and longer product names. For example:

"product_name";"price_value";"price_currency_id";"categories"
"Sample Level 2 Award for Excellence - This is a longer product name [Text]";"0";"GBP";"12"

All the products follow a similar structure as above, and out of 50 entries only two or three entries are created in the "jos_hikashop_product_category" table (I fixed it by manually creating an SQL to add those entries.

However, there appear to be two issues:

1. Something in the import routine is failing to add entries in the product category table and crucially not reporting that back to the user and/or attempting to do anything about it
2. There is no way of viewing products that have, for whatever reason, been orphaned from a category, so it appears that although the import routine thinks it's successfully imported the products, they are not visible to the end user anywhere on the site (front or back-end).

As a programmer, I can see that there are many possible solutions, but the most useful one that I can think of (that would also be a good feature generally in my opinion): to add a filter for *all* products regardless of category, and a way to multi-select and (un)assign them a new category.

I'm not as pessimistic about HikaShop though, and overall it seems to be well structured and the responses to questions/problems I have seen have been swift and well considered, so I think this may be just an oversight.

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

  • Posts: 84102
  • Thank you received: 13638
  • MODERATOR
12 years 9 months ago #70604

In the example CSV you put here, you use "12" in the categories column.
It means that the system will attach the product to the category with the id 12.
That category has to already exists in HikaShop since you didn't specify a category name but a category id.
If that category does not exists, HikaShop will link the product to a category id which doesn't exist and thus you won't see the product.

The length of the product name should not go over 255 characters as it's the limit of that field in the database.
If you go over it, and that you don't specify a product_code, the system will use the name as the product_code. And since the system uses the product_code as the unique identifier of the product, if it is truncated, the system can potentially not assign the product categories and other things properly during the import. In such cases, you would have to change the types of the fields product_name and product_code from VARCHAR to TEXT in the product table before importing your CSV.

Note that this old thread was related to the display of categories/products listing menus. Since then, we greatly improved the system and now default categories/products listings are created when you install HikaShop so it got really easier to configure HikaShop and users don't have anymore such issue where products are not displayed because something is not configured properly.

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

  • Posts: 5
  • Thank you received: 0
12 years 9 months ago #70649

nicolas wrote: In the example CSV you put here, you use "12" in the categories column.
It means that the system will attach the product to the category with the id 12.
That category has to already exists in HikaShop since you didn't specify a category name but a category id.
If that category does not exists, HikaShop will link the product to a category id which doesn't exist and thus you won't see the product.

The length of the product name should not go over 255 characters [...] if it is truncated, the system can potentially not assign the product categories and other things properly during the import. In such cases, you would have to change the types of the fields product_name and product_code from VARCHAR to TEXT in the product table before importing your CSV.

[...] we greatly improved the system and now default categories/products listings are created when you install HikaShop so it got really easier to configure HikaShop and users don't have anymore such issue where products are not displayed because something is not configured properly.


Thanks for the reply, and I am aware that it's an old thread. I have a few points:
  1. I have a new version of HikaShop.
  2. All product names are 150 characters or less.
  3. Category 12 works for SOME (one or two) entries; the label of the category also fails in the same way.
  4. If product imports were to fail for any reason and the process fail as you describe, there should be an error reported back to the user, and orphaned products should never be created. That is a bug.
  5. There should either be a way to see orphaned products, or some housekeeping routine that checks for potential problems with the data, ESPECIALLY because it's failing silently in some cases. Or ensure that silent fails do not happen (which is an insidious problem as many people may not notice anything going wrong).

I appreciate your comment, but I am a new user of HikaShop, and yes, I do have an issue where products are not displayed.

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

  • Posts: 84102
  • Thank you received: 13638
  • MODERATOR
12 years 8 months ago #70984

You say it fails silently and orphan products are created, but that's not the case on our end. If I import that CSV you put in your previous message

"product_name";"price_value";"price_currency_id";"categories"
"Sample Level 2 Award for Excellence - This is a longer product name [Text]";"0";"GBP";"12"
it imports the product properly and I can see it on my front end.
Please give a CSV with which we can reproduce the issue and then we can look at improving the CSV import and/or tell you what's wrong with your CSV.

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

  • Posts: 5
  • Thank you received: 0
12 years 8 months ago #70988

Unfortunately I can't send an actual CSV (there are also more than 200 records. not just one or two), as it contains commercially sensitive data.

Last edit: 12 years 8 months ago by muso. Reason: Re-read the reply.

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

Time to create page: 0.085 seconds
Powered by Kunena Forum