AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: ygalbrami on May 08, 2013, 04:59:36 PM

Title: Import & Export Tool
Post by: ygalbrami on May 08, 2013, 04:59:36 PM

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

Title: Re: Import & Export Tool
Post by: andrew.mikhailyk on May 10, 2013, 05:31:01 AM

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

Title: Re: Import & Export Tool
Post by: ygalbrami on May 10, 2013, 06:10:38 AM

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 (http://www.ismystore.com/products_original.csv)

Download - the edited file
http://www.ismystore.com/products_edited.csv (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

Title: Re: Import & Export Tool
Post by: abantecart on May 10, 2013, 12:17:59 PM

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.

Title: Re: Import & Export Tool
Post by: ygalbrami on May 10, 2013, 12:28:23 PM

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

Title: Re: Import & Export Tool
Post by: ygalbrami on May 10, 2013, 12:51:33 PM

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.

Title: Re: Import & Export Tool
Post by: ygalbrami on May 10, 2013, 12:55:59 PM

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

Thanks

Title: Re: Import & Export Tool
Post by: abantecart on May 12, 2013, 10:28:08 PM

Quote from: ygalbrami on May 10, 2013, 12:55:59 PM

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