Import features from CSV

[chris201]

Hello,

 

I have a shop under developement and I need to import 1500 books. Each book has features like ISBN, author, no of pages, etc.. I created the features in admin panel and I have the csv from the Publisher but I don't know how to map each feature from csv with the fields from admin when the products are imported..

 

If someone has a solution, please help me.

 

 

Thank you!

[NemoPS]

You should be able to do it by simply using the very same feature value name (case sensitive). Then, when importing, assign the feature "name" to that column

[FoodSourceDirect]

You should be able to do it by simply using the very same feature value name (case sensitive). Then, when importing, assign the feature "name" to that column

I am a new PrestaShop 1.6 user. I have many products (thousands) to upload to my site with pictures. Therefore, adding products to the store one by one is too time consuming.  The share number of products and pictures to upload is a challenge enough for me; but, the main problem is that I have quite a few custom features for each product. For example Ingredients, Safety Information, Product Information, Label Directions, Suggested Uses, etc. (These are food and supplement products.)  And I just can't figure out how to get the PrestaShop CSV import feature to recognize the custom feature fields that I have created. When I try to import some products, I get the following error message: "Columns cannot have the same value type."

 

Does this error have anything to do with the way PrestaShop 1.6 handles custom feature fields? Or is my CSV product file incorrectly formatted? Or is there some other reason?

 

Now, I know that I "can" plop down US$349 for eMagic One's StoreManager or US$100 for the Dataco Import Fast module. However, I am not ready for that just yet. I need to understand how to correctly reformat vendor provided data and get that data into PrestaShop.  

 

Can you P-L-E-A-S-E take a look at the formatting to see if it's ok? And also, can you explain to me how I can import the data contained in my custom feature fields in my csv product file? It appears that the steps / procedure for importing data from custom feature fields may have change from one PrestaShop version to another. What are the steps or procedure in PrestaShop 1.6? Is the procedure different from PrestaShop 1.5 or 1.4? For example I found the following instructions from the following link:  http://www.tokyowebd...le#.U7GzU_kQC-0

 

But when I tried the steps outlined in that link with my PrestaShop 1.6 store (I mean store-in-progress) well, it was a no go. 

 

Here is a part of my sample product CSV file the shows the features fields that I have created.

 

Feature (Case Size) Feature (Brand) Feature (Origin) Feature (Kosher) Feature (Organic) Feature (Botanical Name) Feature (Ingredients) Feature (Label Directions) Feature (Suggested Uses) Feature (Safety Information) Feature (Product Information) Feature (UOM) Feature(UOMPEREA) 4 Allways Organic United States Kosher Organic   Water, Organic Alcohol, Glycerin, Natural Bitter Almond Oil.       Perfectly pure organic extract for deliciously clean, delectable taste and heavenly aroma. FO 2 12 FoodSource Grenada   Organic   Water, Organic Alcohol, Glycerin, Natural Bitter Almond Oil.       Perfectly pure organic extract for deliciously clean, delectable taste and heavenly aroma. FO 4 6 Kraft USA Kosher Organic   Organic Sunflower Oil, Organic Lemon Oil.       Full lemon flavor made with premium quality, organic ingredients. FO 2 24 Sowa UK Kosher Organic hjhj j hfsh ajk hjdfklsf hdjf Organic Sunflower Oil, Organic Orange Oil.       Fresh orange flavor made with premium quality, organic ingredients. FO 2 6 Gobi USA   Organic   Organic Sunflower Oil, Organic Peppermint Oil.       Made with premium quality, organic ingredients for fresh minty flavor. FO 2 10 Calabash Uganda Kosher Organic   Organic Vanilla Bean Extractives in Water, Organic Alcohol.   Premium Ugandan vanilla perfectly complements baking goods - including cookies, cakes, frostings, French toast batter and vanilla soda.   Premium, organic vanilla extract from Ugandan vanilla beans for depth of flavor and aroma. FO 2 6 Pina Ghana Kosher Organic   Organic Vanilla Bean Extractives in Water, Organic Alcohol.   Premium Ugandan vanilla perfectly complements baking goods - including cookies, cakes, frostings, French toast batter and vanilla soda.   Premium, organic vanilla extract from Ugandan vanilla beans for depth of flavor and aroma. FO 4