Import & Export Tool

[ygalbrami]

hello
i have used the Import & Export tool
i have upload about 150 new items but after that i download the csv and i make some changes
when i uploaded the file i see that the title in some items was short

i make the change so the title will be "this is a test model number 0000 inch 4"
and i see in the website this: "this is a test model"

why i don't see the full title in the website?
it's happend on a lot of items

please help me to fix that
Thanks

[andrew.mikhailyk]

Hello.
Please provide us with fragment of CSV files (both - original and edited) and note what items are right and what are not.

[ygalbrami]

hello,

this in yellow = it's not the good title i was inserting.

i can't upload here the file - the file is more than 2.5 MB

so you can download the file from here:

Download - the original file
http://www.ismystore.com/products_original.csv

Download - the edited file
http://www.ismystore.com/products_edited.csv

see the row 32,33,35 in product_descriptions[0].name - the title is very short
see the edited file in same place you will see full title.

please help me with this big problem

Thanks again for your help

[abantecart]

There are 2 solutions to this problem.

1. You are using windows character (non ASCII) for ” and it should be "
You can edit this in your file and it will solve the problem.

2. We will look in to the code to identify, why this situation truncates the text.

[ygalbrami]

i have search for " in all the file but he don't find any of " only the regular "

please help me with that i don't know what to do.

thanks

[ygalbrami]

hello,
Thank you thank you so so much

i change the file to UTF-8 and it's work

now i see the full title of all items
1000 thanks

you realy help me with that.

[ygalbrami]

i need to know when i can find Product Tags and SEO Keyword in export tool?

Thanks

[abantecart]

i need to know when i can find Product Tags and SEO Keyword in export tool?

You need to use product_tags and product_descriptions tables.
In product_descriptions tables look for meta_keywords to set SEO Keyword