Category Options not Showing

  • Posts: 5
  • Thank you received: 0
13 years 5 months ago #21338

When I import products via cvs, and then go to edit them in Joomla, the categories options, related products, and characteristics boxes are missing. However, if I create a product manually, these boxes do appear when editing. I've set up my cvs as the documentation says (I'm pretty confident at least). I'm not sure if there's a problem with the cvs or if there's something in Joomla or Hikashop I need to do?

I took two different screen shots to show the differences (attached).


Any help would be greatly appreciated. I really don't want to have to manually enter 600+ products.

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

  • Posts: 83050
  • Thank you received: 13410
  • MODERATOR
13 years 5 months ago #21344

If you don't see these parts of the screen, it means that you imported variants of product and not products. Which means that there is a problem in your CSV. Please give the first few lines so that we can see what is the problem.

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

  • Posts: 5
  • Thank you received: 0
13 years 5 months ago #21349

Thank you! That does make sense, although I'm not sure why it's doing that.

I've attached my CSV file (I'm using excel, but saving it as a csv, could that be a problem?). I only have three products listed as examples so I can play with it before trying to upload the full product set.

J

File Attachment:

File Name: DM_Product...List.csv
File Size:2 KB

Attachments:

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

  • Posts: 5
  • Thank you received: 0
13 years 5 months ago #21354

Thank you for the help! Once you said it was a problem with the variant, I was able to figure it out. I was misunderstanding what product_parent_id meant (confusing it with the category_id).

Thanks again! :cheer:

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

  • Posts: 83050
  • Thank you received: 13410
  • MODERATOR
13 years 5 months ago #21355

First, you have too much double quotes on your columns name. I openned your CSV with openoffice and all the columns name had quotes around them. For example, if you open your CSV with notepad you will see that it starts with :
"""product_id""","""product_parent_id"""

However, it should be:
"product_id","product_parent_id"

I don't understand why you have an integer in the product_parent_id column ? This column is to be filled only for variants. Since your products are not variants, that column should be empty on your CSV. That's why the system considered your products as variants. If you empty that column and import your CSV again, you will see the category/related/options, etc areas.
That's also why your products were not displayed as they were in fact variants and not products for the system.

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

Time to create page: 0.058 seconds
Powered by Kunena Forum