WebSite X5Help Center

 
Ross P.
Ross P.
User

Importing multiple product via .csv creating error message  en

Autore: Ross P.
Visite 340, Followers 1, Condiviso 0  

Hello

I have uploaded some items to a shopping cart individually but now have been attempting to upload several more via .csv file. Each time it fails with the error below:

I have also tried removing the category column and I just get the same message but instead of "category" it says "name/code".

Can anyone send me a draft of how the file should be set up please.

A copy of a portion of items I am looking to upload are in the .csv files attached. I have addded another file below with the ; after each item in the column - eg. Bathroom; Dresden...; description field; RP17704; 190; images...\3 pce Suite RP17704.png; file which I have also tried, both of which failed.

Kind regards

Ross

Postato il
15 RISPOSTE - 1 UTILE
Incomedia
Eric C.
Incomedia

Hello Ross,
could you please provide a copy of the .csv file itself?
You can archive it as .zip and attach it to your reply.
Thank you.

Leggi di più
Postato il da Eric C.
Ross P.
Ross P.
User
Autore

Thank you Eric.

File attached.

Kind regards

Ross

Leggi di più
Postato il da Ross P.
Incomedia
Eric C.
Incomedia

Hello,
there were some issues in the file, for example with the headings, please check this .csv file, you should be able to import it and use it as the basis for adding other products.

Leggi di più
Postato il da Eric C.
Ross P.
Ross P.
User
Autore

Hello Eric

Thank you very much.

I have just tried it and got this error, sorry.

Sorry to be a nuisance.

Kind regards

Ross

Leggi di più
Postato il da Ross P.
Incomedia
Eric C.
Incomedia

Hello Ross,
was this with the file I sent, without any changes, or after editing it?
Looking at the error, it seems that the header has become "images,,,," instead of only "images"

Leggi di più
Postato il da Eric C.
Ross P.
Ross P.
User
Autore

Hello again Eric

Sorry about not replying sooner but had to get some sleep as it was after midnight here in NZ when I sent my last message.

Yes it was as you sent it. I edited it in Notepad, removed the commas after images, then saved it as a .txt file. This uploaded fine, except for the images loaded on the products that had more than one image attached. (as per this image)

However, this is fine as I can probably go through and add them later, even though it would be better if they were all added at once.

Thank you very, very much for your help and expertise, Eric it is really appreciated.

Kind regards

Ross

Leggi di più
Postato il da Ross P.
Incomedia
Elisa B.
Incomedia

Hi Ross, 

does the same happen also if you import the file in .csv format?

Thanks!

Leggi di più
Postato il da Elisa B.
Ross P.
Ross P.
User
Autore

Hi Elisa,

Thanks for your reply. I have tried again to import the revised addition of what Eric sent me, but it has gone back to this error 

I have attached the .csv causing this problem??

I don't know what is going wrong that this is happening all the time. Is there any thought of setting up an Excel template that can be downloaded that works every time by just adding the products.

Kind regards

Ross

Leggi di più
Postato il da Ross P.
Incomedia
Eric C.
Incomedia

Hello Ross,
can you tell me exactly what steps you are taking with these files?
I checked the file I sent you, for example, and it does not contain those commas, unlike the one you sent back.
Perhaps this is an issue with the software you are using to further edit the .csv files, which is incorrectly adding some delimiters in the headers.

Leggi di più
Postato il da Eric C.
Ross P.
Ross P.
User
Autore

Hello Eric

As you can see I saved your file with your name as an Excel Worksheet then saved it as CSV (Comma delimited) and clicked yes to save, as per the image:

Then the zip file attached is what they have save like.

 The software I have used to do this on is Microsoft Excel 10. 

Sorry to be a nuisance.

Kind regards

Ross

Leggi di più
Postato il da Ross P.
Incomedia
Eric C.
Incomedia

Hello Ross,
could you please check the situation if you edit it through online tools such as https://edit-csv.net/ ?
If this occurs only after opening the file in Excel, the cause is likely a modification applied by the software.

Leggi di più
Postato il da Eric C.
Ross P.
Ross P.
User
Autore

Thank you Eric

Below is your file I downloaded of yours and put it through the software ....Edit CSV

 

Should I perhaps look at doing it with another spreadsheet software like Google Sheets???

Kind regards

Ross

Leggi di più
Postato il da Ross P.
 ‪ KolAsim ‪ ‪
 ‪ KolAsim ‪ ‪
Moderator

... Eric's CSV header is OK:
id;category;name/code;description;sku;price;weight;options;enable discounts;discounts;availability type;available;pending;images

... your CSV header contains an error at the end in images attribute:
id;category;name/code;description;sku;price;weight;options;enable discounts;discounts;availability type;available;pending;images,,,,

... error >> images,,,,   ... >  images[,,,,]  ...!...

.

... to generate the CSV file you can use Windows Notepad, or to make it easier, any spreadsheet that you know and can use, in any case load, save, import and export the CSV in UTF-8  encoding...

.

ciao

.

Leggi di più
Postato il da  ‪ KolAsim ‪ ‪
Incomedia
Eric C.
Incomedia

Hello,
the file I attached on July 2nd does not contain the commas, please download it again from the attachment and open it into the editor directly, without using Excel or other software before.

Leggi di più
Postato il da Eric C.
Ross P.
Ross P.
User
Autore

Hello KolAsim and Eric

Thank you for all your assistance I have now got the situation sorted and have been able to add more products, and hope that continues.

Kind regards

Ross

Leggi di più
Postato il da Ross P.