[Solved][1.7.5] Import features from CSV.

[szczur3k]

OK, it works. I selected the wrong column type in the import settings.

Hi.

I have a lot of data in my database and I would like using a CSV file to import to Presta a list of features and products with assigned features. But how, if at all possible?

In the CSV file I created a features column, format: name1:value1:0,name2,value2:1 etc. When importing I choose the correct type in my column and everything: description, name, images etc. is imported, but not features.

Sorry for my scary English BTW

Edited February 27, 2020 by szczur3k (see edit history)

[ballashop]

Hi this is the correct setting:

https://doc.prestashop.com/display/PS17/Import

featurename : value : position (1) : customizedvalue (1 show, 0 do nothing),

Width: 50cm: 1: 1, Weight: 1kg: 2: 1,

Ciao

[ur5zeb]

Hello, I don't have a feature field Presta 1.7.8.7

[hokat]

Hi,
Feature column is in the import products CSV file.
Your screenshot is from combinations.
See the attached screenshots.

 

[hokat]

Hi,

I have a situation.

I want to import Features, through CSV file, that contain values like this:

Name of feature: Antriebswelle
Value of feature: Kegel 1:5 Ø17 x 17

Name of feature: Antriebswelle
Value of feature: Aufsteuerverhältnis: 3,4:1

The problems is that they contain ":" and "," in their values.
And the import does not generate features correctly.

PS: I can replace 3,4 with 3.4 but what do I do with the ":"?
If I enter these values from BO it can be done! But not through CSV.
And I must use CSV because I have a lot of products with a lot of similar features like the ones in the example above.

Does anyone have a sollution? An workaround maybe?
Thanks.

[Nikolai]

I think that issue with wrong formatted csv file or with wrong csv parser,

there is no problem in importing values with : or ; inside...

As a test -  try to open this csv in openOffice or libre office ,

if it opens right