The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.
 
 
Thread Tools Display Modes
  #1  
Old 07-09-2013, 03:50 AM
Sticky Walls Ltd.'s Avatar
Sticky Walls Ltd. Sticky Walls Ltd. is offline
 
Join Date: Sep 2012
Posts: 6
Default Error details: 'SKU' or 'Name' column has to contain value on IMport

Hello,

I have received the following message when I try to import a csv file back in. The funny thing is I am using the export that I got from Ecwid and only changed the SKU and some descriptions.

Error Message:

Error details: 'SKU' or 'Name' column has to contain value
Line number: [1094]

I checked all 109 products SKU and Name and all of them contain a value. Why is it putting up this error message?

I have attached a link to the file for review. I did not change the order from what was exported from Ecwid.

http://boxadordecals.com/images/boxador.csv

Thanks

Mike
  #2  
Old 07-09-2013, 07:50 AM
Eugene Rimmer's Avatar
Eugene Rimmer Eugene Rimmer is offline
Senior Member
 
Join Date: Jan 2011
Location: Ecwid headquarters
Posts: 7,765
Default

Please, attach the screenshot of the import settings that you made your import with.
  #3  
Old 07-09-2013, 10:58 AM
Sticky Walls Ltd.'s Avatar
Sticky Walls Ltd. Sticky Walls Ltd. is offline
 
Join Date: Sep 2012
Posts: 6
Default

Eugene, here is a screenshot of my import settings
Attached Images
File Type: jpg SS_2.jpg (85.9 KB, 145 views)
  #4  
Old 07-09-2013, 12:00 PM
Lanna's Avatar
Lanna Lanna is offline
Ecwid Team
 
Join Date: Jan 2011
Posts: 2,675
Default

Quote:
Originally Posted by Sticky Walls Ltd. View Post
Eugene, here is a screenshot of my import settings
Hi,

Thank you. The problem was that the file contained odd symbols (commas) in the end. I've corrected the file and attached it to my message. Please, check.
The unnecessary symbols might be added when file is opened in Excel or OpenOffice. And you can notice it if to open the file in a text editor, which I'd recommend doing before the import.

Also, please mind, the file has two additional columns for product URL and product ID. They should be included in the import settings too as 'Skip column'. Here's a screenshot of the import settings for your file: http://d.pr/i/jNy6

And one more thing, the product images links in the file almost all are not working and give 404 page not found error. For ex.:
http://boxadordecals.com/BXD0117.jpg
http://www.boxadordecals.com/BXD0114.jpg
http://www.boxadordecals.com/BXD0113.jpg
etc.
Hence the images won't be created.
Please, make sure to update the file with working links for the images.
Attached Files
File Type: csv boxador_corrected.csv (224.4 KB, 78 views)
__________________
Lana W.
Ecwid Customer Care Team

More tips and hints on Ecwid use in our Help Center

⬇ Please click Thanks if my reply helped you.

Thank Ecwid team on Twitter
The Following User Says Thank You to Lanna For This Useful Post:
Sticky Walls Ltd. (07-09-2013)
 
The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:17 PM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.