How to import attributes?

[Dariush]

Hi Dears

I many searched, but not found any solution...

How can I import features for products from CSV?

Each of my products have 3 features.

I have tried creating 3 new columns, named as Feature: Year, another column named Feature: Size, another named Feature: Medium

when i try to point them all to Feature (Name:Value:Position:Customized) it gives the following error:

"Two columns cannot have the same type of values"

 

So now I am thinking that they are not meant to have 1 column for each feature.

 

How is this done then?

each product will have the following?

Feature (Name:Value:Position:Customized)

(Year:Value:0:1986)(Size:Value:1:21" x 43")(Medium:Oil on Canvas:3:Customized)

 

 

NB: Year and Size have Customized values and Medium had Predefined Value

Please Help me!

[PrestaShark]

Hello Dariush

I can suggest You great module for that

http://www.prestashop.com/forums/topic/56689-module-fast-csv-or-xml-import-of-thousands-products-in-a-few-seconds/

Its not cheap but makes CSV import very easy and quick

 

[Dariush]

Dear PrestaShark

Thanks for your response.

Is there another way?

I have a 20.000 Product... (in excell and all is ok)

And I'm just waiting to solve this problem.

PrestaShop have not any solution?

Please Help me!

Thanks

[PrestaShark]

Hi, Here is example CSV file template for use with Prestashop CSV Import module.

http://www.prestashop.com/forums/topic/275497-complete-csv-example-to-import-product-combinations-in-ps-15/?do=findComment&comment=1382310

 

Please provide me via PM a part of Your file. I try to help You with

[Branoo]

There is a template in PS 1.6. It didn't work properly for me.

 

You might play with it, import/export and export import with few items only.

Just be careful when importing as you can easily (VERY EASILY) duplicate your content.

 

I'm still working on my stock and was suggested to use"storemanager"

Oh my... No wonder there is 30 day trial. Doubled my Category, there is a biiiig learning curve. Very big one.

 

I would do few tests in and out be before the full upload.

[Dariush]

Is the best solution, downgrade 1.6->1.5?

Because I've seen on the some forums in 1.5 is possible.

 

[Branoo]

Still playing with the Import/Export.

 

But i can tell you that it works (in a way*). But the template must be saved as UTF-8 then modified to your needs.

Good start is to read this http://doc.prestashop.com/display/PS16/CSV+Import+Parameters then you have to experiment with the template or you can make one your own.

 

* in a way = sometimes i didn't have some fields updated, still working on it, as it can be my fault.

 

Why would you downgrade because of import?

[Dariush]

Dear Branoo

My Template is ready and I can convert every thing Except Futures fields...

In your link Nothing about this issue.

This fields is necessary for me.

If the downgrade is a solution, it will do.

[Branoo]

Ok Darius,
 
I had a play with these imports. I think its working this way or at least for me.
 
Feature Fields Import:
Name - Name of the feature. eg. Length, Thick, Small, Old ect
Value -  This is a set value, not customizable - depends on the feature eg, 10, A, XX, XL ect
Position - position in the list of features eg. 1, 2, 3,  20 ect - Hower, this didnt work for me, yet.
Customized - value for this is 0 or 1
 
There are two ways, depends on your needs;
 

Option 1. 

• Your heading in first line is:
  Feature (Name:Value:Position:Customized)
   
• The 2nd line is with the string:
  Length:10:2:0

[ID];Reference;Feature(Name:Value:Position:Custom)
1;demo_1;Length:10:2:0

We "told" prestashop, to import - Feature, with a name Length of 10 on position 2 and not customized.

You must have that in that order !!

 

 

 

Option 2.

• Your heading in first line is:
  Feature (Name:Value:Position:Customized)
   
• The 2nd line is with the string:
  Length:10:2:1

[ID];Reference;Feature(Name:Value:Position:Custom)
1;demo_1;Length:10:2:1

We "told" prestashop, to import - Feature, with a name Length of 10 on position 2 and customized.

So, what happened here?

Nothing much, only that this feature is PER specific product.

 

Option 3. (What? yes...)

 

Just found out this, when you do;

[ID];Reference;Feature(Name:Value:Position:Custom)
1;demo_1;Length:20,Compositions:Cotton,Styles:Rock

It updates the product with features from existing values;

Length:20

Compositions:Cotton

Styles:Rock

 

 

And guess what?

 

Option 4.

[ID];Reference;(Name:Value:Position:Custom)
1;demo_1;Length:55,Compositions:Jupiter,Styles:Hippie,Fresh?:Yes

I dont care about position anymore (at least for now)

With the above, we just updated and added to the list, the following;

 

Length:55

Compositions:Jupiter

Styles:Hippie

Fresh?:Yes

 

When I do all my imports, they are based on Reference No (and [iD], but I ignore that in import).

Then, I select YES on "Use product reference as key" - because I want to use my ref no as reference to a product. - Leave in NO if you importing new products.

and YES "Force all ID numbers" - Leave in NO if you importing new products.

 

And last thing, all csv files MUST be UTF-8.

 

 

Hop this helps.... to some one.

Test Import.csv.txt

Edited September 4, 2014 by Branoo (see edit history)

[Dariush]

Thank you very much Brano,

My problem was solved.

[lahouce]

if it help some one, this way works for me

 

i have the same problem;

to solve it, i have added the field "Name"; and it's work

 

 

this is an example

 

[iD];Reference #;Name #;Feature(Name: Value: Position:Customized)

37;78;000presta0;Brand:GRETA:1

[husein522]

On 9/4/2014 at 6:43 PM, Branoo said:

Ok Darius,
 
I had a play with these imports. I think its working this way or at least for me.
 
Feature Fields Import:
Name - Name of the feature. eg. Length, Thick, Small, Old ect
Value -  This is a set value, not customizable - depends on the feature eg, 10, A, XX, XL ect
Position - position in the list of features eg. 1, 2, 3,  20 ect - Hower, this didnt work for me, yet.
Customized - value for this is 0 or 1
 
There are two ways, depends on your needs;
 

Option 1. 

• Your heading in first line is:
  Feature (Name:Value:Position:Customized)
   
• The 2nd line is with the string:
  Length:10:2:0

[ID];Reference;Feature(Name:Value:Position:Custom)
1;demo_1;Length:10:2:0

We "told" prestashop, to import - Feature, with a name Length of 10 on position 2 and not customized.

You must have that in that order !!

 

 

 

Option 2.

• Your heading in first line is:
  Feature (Name:Value:Position:Customized)
   
• The 2nd line is with the string:
  Length:10:2:1

[ID];Reference;Feature(Name:Value:Position:Custom)
1;demo_1;Length:10:2:1

We "told" prestashop, to import - Feature, with a name Length of 10 on position 2 and customized.

So, what happened here?

Nothing much, only that this feature is PER specific product.

 

Option 3. (What? yes...)

 

Just found out this, when you do;

[ID];Reference;Feature(Name:Value:Position:Custom)
1;demo_1;Length:20,Compositions:Cotton,Styles:Rock

It updates the product with features from existing values;

Length:20

Compositions:Cotton

Styles:Rock

 

 

And guess what?

 

Option 4.

[ID];Reference;(Name:Value:Position:Custom)
1;demo_1;Length:55,Compositions:Jupiter,Styles:Hippie,Fresh?:Yes

I dont care about position anymore (at least for now)

With the above, we just updated and added to the list, the following;

 

Length:55

Compositions:Jupiter

Styles:Hippie

Fresh?:Yes

 

When I do all my imports, they are based on Reference No (and [iD], but I ignore that in import).

Then, I select YES on "Use product reference as key" - because I want to use my ref no as reference to a product. - Leave in NO if you importing new products.

and YES "Force all ID numbers" - Leave in NO if you importing new products.

 

And last thing, all csv files MUST be UTF-8.

 

 

Hop this helps.... to some one.

Test Import.csv.txt

Hi,

Can you please help me with the attached product CSV file. The product features takes me to error page I have done lot of research but no solution

products_import _b.csv

[presta.show]

Hi,

Try module below. It support prodcuts, features, attributes, combinations and many others import options. You could upload and test your file in fully functional demo shop at demo.prestashow.pl

 

Edited November 3, 2017 by prestashow.pl (see edit history)

[olya]

 

Good afternoon.

Help with importing functions.

In the column Feature (Name: Value: Position)

if I enter 1 function in the format

Style: Casual: 2

import is successful.

 

For example, I have a format with several characteristics 

Style: Casual: 2, Style: Business: 3

I have 16 product characteristics.

If in a column I introduce several characteristics through , import does not pass.

The only option that I found is to make 16 import files with different characteristics. But this is a very long way. How in one file to bring all 16 characteristics and import one file?

[eightman]

[ID];Reference;(Name:Value:Position:Custom)
1;demo_1;Length:55,Compositions:Jupiter,Styles:Hippie,Fresh?:Yes

this worked well for me, only problem is for one feature called scale: value is 1:4 or 1:8 so the ":" makes problem...

[bellini13]

put those values inside quotes

1;demo_1;"Length:55","Compositions:Jupiter","Styles:Hippie","Fresh?:Yes"

[eightman]

Il y a 21 heures, bellini13 a dit :

put those values inside quotes

1;demo_1;"Length:55","Compositions:Jupiter","Styles:Hippie","Fresh?:Yes"

I tryed this but don't work for me. it just add " to feature name and value.

I decided to use 1/4 scale instead of 1:4 scale

[bellini13]

what options are you using when you import the file?  Take a screen shot of those options

[Oleg]

Prestashop allows to import Excel file with products.

How to specify attributes in this Excel file correct import? I have created some products attributes in Presta. It has own unique id.

Thank you!

I made mistake, instead attributes I meant characteristics

Edited April 5, 2018 by Oleg (see edit history)

[Oleg]

So, what about different languages? When value has another languages, which one to set? Can I use just existing id of attribute?

[selectshop.at]

@Oleg - You can import multiple languages, as long as you do it one at a time. Select on import the language of your file: http://doc.prestashop.com/display/PS16/CSV+Import+Parameters

More comfort you will have by importing with Presta Store Manager (free use for 30 days). There you don't need to split eac language into one file. The module you will find on your back-office on module list, or at addons site.

Tutorial: https://www.prestashopmanager.com/useful-articles/how-to/how-to-import-multi-lingual-product-details-to-prestashop/

 

[Oleg]

Can you help me, I filled Excel file like this:

Where: Мощность is Power

6000 BTU is value

1 is position

0 - customize

 

When I try import this it return me error:

Two columns can not have the same type.

What I do wrong?