WebSite X5Help Center

 
Jeff W.
Jeff W.
User

Error on Product Import  en

Author: Jeff W.
Visited 905, Followers 1, Shared 0  

I export my product list in .csv then immediately import it. i get this error "An occurred while importing products (Invalid Field Count (line 965))". I change nothing. i am testing to see how to do this so I can update my pricing.

Posted on the
6 ANSWERS - 1 USEFUL - 1 CORRECT
Incomedia
Claudio D.
Incomedia

Hello Jeff,

Can you please try to zip the file and add it here as tacchment so I can test it?

Can you please also try to see if you edit the file and then import it if then it works?

It can depend on the fact the products are the same and since it cannot find and differences it wont be imported. 

You can also try it on a new project where this file should be possible to be imported.

Many thanks!

Read more
Posted on the from Claudio D.
Jeff W.
Jeff W.
User
Author

hi

heres my file. i tried changing some prices but i got the same error

Read more
Posted on the from Jeff W.
Incomedia
Claudio D.
Incomedia

Hello Jeff,

In 2 description you used the semicolon (;) and this is used by the system to divide the fields. I removed them from the file and now it should be possible to import it.

Avoid to use the semicolon in the name or description of the products.

You can download the file from following link:

http://we.tl/Uc2PScdWEG

When you update products leave in the CSV file only the updated products so you import only the updates.

Many thanks!

Read more
Posted on the from Claudio D.
Jeff W.
Jeff W.
User
Author

Hello Claudio

Thanks for the response. I was able to import your version opf the csv file. to better understand my mistake can you show the line that i used the semi-colon on

Thanks

Read more
Posted on the from Jeff W.
Incomedia
Claudio D.
Incomedia

Hello Jeff,

As example on NEXUS MELODY BLANCO in the description you wrote

... wire as many as you like; only limited by the size ...

The ; is causing the issue and you need to avoid to add the semicolon in the description.

Many thanks!

Read more
Posted on the from Claudio D.
Jeff W.
Jeff W.
User
Author

thank you so much Claudio, i total life saver

Read more
Posted on the from Jeff W.