CSV import problem

Store Builder Questions
1

Hello, I am trying to make a csv to upload massive products. I have made a test excel which I tried to attach but have not rights to.



I upload it and everything works right except photos, pdf and the word. Here is what I have: Image Pdf Word http://suppliersite.gr/images/photos/920-84-5MH00015.jpg http://suppliersite.gr/images/photos/920-84-5MH00015.pdf http://suppliersite.gr/product_details4.asp?productid=920-84-5MH00015 http://suppliersite.gr/images/photos/920-84-5MH00015B.jpg http://suppliersite.gr/images/photos/920-84-5MH00015B.pdf http://suppliersite.gr/product_details4.asp?productid=920-84-5MH00015B



The url is changed by me but the original url works just fine. It should load the photos as the manual says but it does not. Also save the pdf url and word also.



I plan to upload hundreds of products and need to do it at once. Any help?

2

I see in the admin panel the following:

[quote]Image import format%Image location%#%Alternative text%where,

%Image location% - can be absolute or relative path on server filesystem or URL,

%Alternative text% - Image alternative text

Example 1:

images/product_images/apples.jpg#ApplesExample 2:

Custom Application Development Software for Business - Salesforce.com

[/quote]

since I can use url as photo path why does it not work in action?

3

Hello geokir,



Thank you for your message.



I am sorry to hear that you have experienced this issue. Could you upload the imported .csv file somewhere so that I can download it and check the issue in detail?



Thank you.



—

Pavel Zyukin

CS-Cart Support team

4

Here is the csv

File Dropper - Online file sharing



thanks

5

Hello geokir,



Thank you for the provided file.



I have checked it and found out that incorrect field names are used in the file. There are no Image, Pdf and Word fields in standard CS-Cart. If you want to import detailed images for products, the imported .csv file should look as follows:



Product code;Category;Product name;Availability;Price;Description;Detailed image

“920-84-5MH00015”;“Cases-Peripherals///Combo”;“MS Wired Desktop 400 For Business Black”;“N”;“17.67”;“Demo decr”;“http://suppliersite.gr/images/photos/920-84-5MH00015.jpg”

“920-84-5MH00015B”;“Cases-Peripherals///Combo”;“MS WIRED DESKTOP 400 PLUS PC TOOLS”;“N”;“22.15”;“Demo scr”;“http://suppliersite.gr/images/photos/920-84-5MH00015B.jpg”



As regards .pdf and .doc files, if you want these files to be downloaded only after a customer purchases a downloadable product, then the imported .csv file should look as follows:



Product code;Category;Product name;Availability;Price;Description;Detailed image;Downloadable;Files

“920-84-5MH00015”;“Cases-Peripherals///Combo”;“MS Wired Desktop 400 For Business Black”;“N”;“17.67”;“Demo decr”;“http://suppliersite.gr/images/photos/920-84-5MH00015.jpg";“Y”;"http://suppliersite.gr/images/photos/920-84-5MH00015.pdf, http://suppliersite.gr/product_details4.asp?productid=920-84-5MH00015”

“920-84-5MH00015B”;“Cases-Peripherals///Combo”;“MS WIRED DESKTOP 400 PLUS PC TOOLS”;“N”;“22.15”;“Demo scr”;“http://suppliersite.gr/images/photos/920-84-5MH00015B.jpg";“Y”;"http://suppliersite.gr/images/photos/920-84-5MH00015B.pdf, http://suppliersite.gr/product_details4.asp?productid=920-84-5MH00015B”



You can find more detailed information about the format of import fields in the following Knowledge base article:



http://kb.cs-cart.co…d-fields-format



However, if you want to have these files just as attachments so that a customer could download them before purchasing a product, unfortunately, there is no way to import such files at once. You will need to enable the Attachments add-on and upload these files for products manually. You can find instructions on how to implement it in our Knowledge base:



http://kb.cs-cart.co…les-for-product



Please check it.



Thank you.



—

Pavel Zyukin

CS-Cart Support team

6

Thanks Pavel that was very helpful.

7

You are welcome.



—

Pavel Zyukin

CS-Cart Support team

8

Hi again,

I did the CSV as needed but now I am facing another problem.



The CSV has about 2.000 products and is 600KB. I try to import it local but I get the error:

Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 12420 bytes) in /home/system/public_html/core/fn_images.php on line 460



I changed the php.ini and the memory_ to 16MB but its still the same. Note that it stops only to the 5fth product! Will the problem be solved by increasing the memory or is it loss of time? Also is uploading the file to server and import it from there a solution?

9

Hello geokir,



Thank you for your message.



Sure, you can try increasing the value of the memory_limit directive to 48MB and even more (for example to 128MB). Also you should apply these changes to the config.local.php file located in the root directory of your CS-Cart installation as it is written in our Knowledge base article:



http://kb.cs-cart.co…wed-memory-size



Please check it.



—

Pavel Zyukin

CS-Cart Support team

10

Thanks again Pavel, I will try those and update… :-)

11

You are welcome.



—

Pavel Zyukin

CS-Cart Support team

12

I increased the memory a bit more and everything works just fine except a small problem at the description. The description language is Greek, after importing the CSV I notice in my product panel that the first one or two words in the description field of each product disappear!

13

Hello geokir,



Thank you for your message.



Could you upload the imported .csv file somewhere once again so that I can download it and check the issue in detail?



Thank you.



—

Pavel Zyukin

CS-Cart Support team

14

https://docs.google.com/open?id=0B4wxEQ6Do659UGliSjQzYzNfQ00

you can download it from there Pavel, I have erased most of products to save time while testing. There are only 17 now but enough to see the problem in almost all of them, first or more words are missing in the description.

15

Hello geokir,



Thank you for providing the file.



Unfortunately, I have failed to reproduce the problem in my local CS-Cart installation using this file. All descriptions were displayed properly for me. Maybe the problem in your case occurred because the file is saved in a character set which differs from the UTF-8 one. I have re-saved this file in the UTF-8 charset and attached it to this message. Please use this file and let me know the result.



Thank you.



—

Pavel Zyukin

CS-Cart Support team

products_utf8.txt

16

Yes Pavel that was it. My mistake, I have altered the file so many times that I caused that. When importing the original CSV created by my php merge I dont have any problem. Thanks again…

17

You are always welcome :)



—

Pavel Zyukin

CS-Cart Support team

18

Hello, i have been working on this and have the same problem. In my case i am using spanish. Could you please tell me what software do you use to edit the csv please? I have tested excel and openoffice and i can´t get this working.



Thank you in advance.