Create filters from csv import

  • Posts: 80
  • Thank you received: 8
  • Hikashop Business
4 years 2 months ago #324120

Hi
I have received a huge e-commerce csv file with over 30 filter options in separate columns of the file. Some filters have over 250 options (relevant only to certain sub categories of product)
How can I import the file and auto create the filters in hikashop?
There is too much work to have to manually create each filter and every single option to select...
Look forward to your reply.

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
4 years 2 months ago #324131

Hi,

You'll first need to create the custom fields of the table "product" via the menu Display>Custom fields.
That way, in your custom field you can use the same column name as the column in your CSV and when you import the CSV, it will fill the custom field for the product automatically.

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

  • Posts: 80
  • Thank you received: 8
  • Hikashop Business
4 years 2 months ago #324158

Thanks I did that and the values are added to the product.

table "product" via the menu Display>Custom fields >
Field Type: Single Dropdown,
Restrictions : Selected my relevant Categories.


However when I add a Display>Filter plus Module >Hikashop Filter module and select e.g checkbox there are no values for the user to filter in the frontend.
How do I show the uploaded Custom field values in a filter module?
Should the values uploaded via CSV not show in the Custom Fields "Values" Panel?

Thanks

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

  • Posts: 80
  • Thank you received: 8
  • Hikashop Business
4 years 2 months ago #324171

Hi
I can confirm that the field_values are empty in #__hikashop_field.
Should my data not be populated here when i csv import? What am I doing wrong please?
tinyurl.com/y34j9dcc

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

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
4 years 2 months ago #324177

Hi,

The import won't fill the "values" list of the custom field. You need to do that manually.
It will however fill the custom field in each product with the value from the CSV.

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

  • Posts: 80
  • Thank you received: 8
  • Hikashop Business
4 years 2 months ago #324193

Ok that is a real shame as it is very manual to have to do this.
For anyone requiring this function you can populate the field_values using this method:
Make 3 col spreadsheet i use openoffice

ColA "Value1" ColB "=A1" ColC "=CONCATENATE(A1;"::";B1;"::";0)"

The result looks like this in ColC
value1::value1::0
value2::value2::0
value3::value3::0

etc

Copy and paste all the colC data to your field_values entry in the table via phpMyAdmin

Last edit: 4 years 2 months ago by huwhuw.
The following user(s) said Thank You: nicolas

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

Time to create page: 0.068 seconds
Powered by Kunena Forum