CSV import products in category and in root

  • Posts: 60
  • Thank you received: 0
  • Hikashop Essential
2 years 6 months ago #341322

-- url of the page with the problem -- : swib.nl/J4
-- HikaShop version -- : Essential 4.5.1
-- Joomla version -- : 4.1.2
-- PHP version -- : 8.0.7
-- Browser(s) name and version -- : Chrome

When I import a csv product file, the products are in the https://swib.nl/J4/index.php/cursusprogrammaroot and in the category. What do i wrong?
I only want them in the categories.
Thank you in advance

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 6 months ago #341330

Hi,

Hard to say without a copy of the CSV file.
Could you provide that ?

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

  • Posts: 60
  • Thank you received: 0
  • Hikashop Essential
2 years 6 months ago #341426

File Attachment:

File Name: 2022voorjaar.csv
File Size:22 KB

File Attachment:

File Name: 2022voorjaar.csv
File Size:22 KB

Attachments:

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

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
2 years 6 months ago #341430

Hello,

You have enter the id (number) in your column categories, you have to enter the category name, and you have forget the parent_category (if there are parent category) column,see my screenshot for more details :

alt


If you have already some products, you can create a CSV as an example by clicking on the Export button.
Or you can create and set some categories or sub categories in your products in order to guide you.

Regards

Last edit: 2 years 6 months ago by Philip.
The following user(s) said Thank You: levelup

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

  • Posts: 60
  • Thank you received: 0
  • Hikashop Essential
2 years 6 months ago #341433

Thank you.... but it doesn't work yet. I made a product and it also appears in and after the categories. swib.nl/J4/index.php/cursusprogramma
I changed the CSV file as you told me, enclosed.

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 6 months ago #341468

Hi,

I think that we've looked at it from the wrong angle.
I don't think that you have a problem with the CSV import.
It's just that under the "products options" tab of your menu item with the alias "cursusprogramma", you've configured the "sub element filter" to "all sub elements" instead of "direct sub elements". And thus, on the main category page, you see the products of the sub categories and you don't want that.
So just go in the joomla menu manager, edit that menu item and change that "sub element filter" setting and it should work like you want it to.

The following user(s) said Thank You: Swib

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

  • Posts: 60
  • Thank you received: 0
  • Hikashop Essential
2 years 6 months ago #341475

Thanks a lot!!!! It works!!

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

Time to create page: 0.073 seconds
Powered by Kunena Forum