Products not displaying in category.

  • Posts: 79
  • Thank you received: 0
14 years 6 months ago #5466

I have 18 products under id 17,and only 11 are displaying. They were all displaying,I updated yesterday, cause of problem?

UPC(product_id) are different example: 205b for 11 of them and 205001 for the others.

What would cause the deletion of the other items? Import is succesful for 1100 products,some won't show in Front end or in product list?

Last edit: 14 years 6 months ago by JWeb5. Reason: typo

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

  • Posts: 84102
  • Thank you received: 13638
  • MODERATOR
14 years 6 months ago #5467

We fixed a lot of things on each release so it could be possible that we now do some check properly which was not the case previously.

If a product is not displayed on the front end, first, make sure that it is published, and attached to your category. If you use the Business edition, you can also check that the access level is ok.

If the product isn't displaying on the back end either, then maybe the problem comes from the category of the product ? Are you sure that your product is linked to a valid category ? Do you see it in the table hikashop_product in the database ? If so, do you see an entry in the table hikashop_product_category for your category and the product ? If not, try to create it. The product will appear in the back end listing under that category and you should be able to edit it to see if there is a problem.

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

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

None of my products are displaying

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

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

On the front end or the back end ?

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

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

Ids are linked correctly.

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

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

So, if your products are linked to the categories in the database, you should see them in the products listing in the back end.
Is that the case ?
If not, could you look at the filters on the right of the listing and make sure that you are displaying all products and all sub elements ?

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

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

Tables exist but the product that were there prior are gone.
I am going to try to import again and double check the delimeters.

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

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

HikaShop doesn't touch the data during updates.
The only reason would be that something else removed the hikashop tables from the database.

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

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

Still nothing. I have some but some are there,but some aren't.

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

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

They are not in the backend either.

They are displayed set to all sub elements.

After import ->1059 products found : 0 new products imported, 0 invalid product code, 1059 already existing products

but they are no longer showing in backend or front end.

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

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

Did you change your CSV ?
in the "categories" column in your CSV do you have the categories code or name ?
If you have the categories column in the CSV, but that you don't have the categories specified, the system will remove the products from the categories.

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

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

I did trytthe csvbut if i imported the csv wrong there may be extra left over data that is conflicting?
The csv was fine, it's the same file that I used to initially import the products.
I have these fields:
product_name price_value categories product_code product_weight product_weight_unit
What are the proper delimeters? ; and "?
All categories have ids and they were showing, but now more than half have disapeared.

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

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

Could it be that the initial import created a product_id, and the re-import does not contain the data?
Even though the CSV says already existing?

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

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

You can use commas or semicolons as delimiters.
You can also use double quotes to enclose your values.

When you import first, it creates the products and assign a product_id automatically to each product.
When you reimport, it will use the product_code to identify the product and update the information in the database using the information in the CSV for each product.

You say that even the categories disappeared ? That's really strange...
In your case, I would delete both the product, the product_category and the category tables. Then, reinstall HikaShop to put back all the default categories and then import again the CSV.

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

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

Categories are there, just products are missing.

Is there a functional limit to the quantity of products in one upload?

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

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

No. HikaShop doesn't have any limits.
However, if your hosting company apply some upload restrictions or small php execution timeout or small memory limit, HikaShop might hit that limit and would result in most cases in a blank page, error 500 or a fatal error.

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

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

Will the update cover the reinstall,or would you suggest the full version?

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

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

What do you mean ?
When you install the hikashop package over a previous version. Your data isn't changed. Only the HikaShop files are updated. However, if tables are missing, HikaShop will put them back along with the default data in it.
The version installed and the version of the package are not relevant.

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

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

Same problem here. Just installed HikaShop, created two categories, created products within those categories, all published, only the Categories show!

NONE of our products show on the Frontend.

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

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

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.

Time to create page: 0.090 seconds
Powered by Kunena Forum