Import values in custom fields through csv

  • Posts: 79
  • Thank you received: 1
  • Hikashop Business
4 years 6 months ago #311747

Hi there
I need to add the material of my products (like alouminium, metal, etc) in product page. In csv i have a list of type of material of each one product.
I have created a custom field named material in field type cutom text. that display in product page as material:
All ok , my questions is can i add the above csv through import method and all the type of materials to add in custom text? like this example:
material:aluminium for product 1
material:metal for product2

What would be the column name in csv?
Thanks in advance

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

  • Posts: 12953
  • Thank you received: 1778
4 years 6 months ago #311760

Hello,

The solution can be to :
- Export your products using the Exports button via "HikaShop->Products"
- Fill the csv file with your values
- Import it again

Kind regards,
Mohamed Thelji.

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

  • Posts: 79
  • Thank you received: 1
  • Hikashop Business
4 years 6 months ago #311802

Hi Mohamed
You did n't answered me. Please i need the column name of custom text. I had fill the csv with values but not accepted.
(plese read carefully my topic)

Thanks

Last edit: 4 years 6 months ago by oxygenvisual.

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

  • Posts: 79
  • Thank you received: 1
  • Hikashop Business
4 years 6 months ago #311806

...also i attached a screen shot to see.
I follow exactly your guides. The Title of custom text is material the column name is "iliko"
In csv i fill in iliko column name all the values but the import can not accept.
If name "iliko" is not of list possible name which the name ??

Do you know how to fix it??

thanks

Attachments:
Last edit: 4 years 6 months ago by oxygenvisual.

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

  • Posts: 81476
  • Thank you received: 13059
  • MODERATOR
4 years 6 months ago #311805

Hi,

The problem is the type of your custom field.
The type "custom text" is a type which allows you to have text between other custom field inputs on forms.
So there is no column in the database corresponding to the custom field.
You need to delete it and recreate it with the type "text". Then, you'll be able to use the column name of the custom field in your CSV to import data into it.

The following user(s) said Thank You: oxygenvisual

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

Time to create page: 0.053 seconds
Powered by Kunena Forum