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 11-23-2014, 11:26 PM
Alexander369's Avatar
Alexander369 is offline
 
Join Date: Oct 2014
Posts: 4
Default

Problem with CSV products import


Dear All,

Seems like I am having an issue importing my test products using CSV and I can't really get the problem. I have attached the CSV file that I am using and it keeps telling me that there's some problem with the price here. When I remove price from the CSV, I start having an error with the fixed shipping rate. Seems like I am having a problem with putting numbers here. Can you, please, take a look at this problem and advise HOW I should write the numbers so that the import worked? I need to fix that because I will have over a thousand products and I really want to utilize ALL the possibilities of CSV import as I will need to do a lot of things by hand any way.

I am appreciating your help in advance!

Best regards,
Alexander

P.S. Sorry if I missed a thread with same issue =( I really tried to find the solution BEFORE posting a new thread!

Sorry for bothering, guys! I have managed to solve the issue by myself. The problem was that description and SKU are to be put inside "" so that the system treated it like 1 bit of info from a cell.

To be honest, the best thing you can do to make the perfect bulk upload is to enter 1 product by hand with ALL the information you want in there, then export this product, see how it is supposed to look and make the rest same way. If you are a confident MS Excel user and know how to work with columns and the combine text from different cells and actually compose a CSV, then this method works like a charm =)

ECWID WORKS GREAT!
Attached Files
File Type: csv products-upload-231114.csv (2.8 KB, 146 views)

Last edited by Liza; 11-24-2014 at 07:06 AM.
The Following User Says Thank You to Alexander369 For This Useful Post:
  #2  
Old 11-25-2014, 11:54 AM
Axiom
Guest
 
Posts: n/a
Default

Quote:
Originally Posted by Alexander369 View Post
Dear All,

Seems like I am having an issue importing my test products using CSV and I can't really get the problem. I have attached the CSV file that I am using and it keeps telling me that there's some problem with the price here. When I remove price from the CSV, I start having an error with the fixed shipping rate. Seems like I am having a problem with putting numbers here. Can you, please, take a look at this problem and advise HOW I should write the numbers so that the import worked? I need to fix that because I will have over a thousand products and I really want to utilize ALL the possibilities of CSV import as I will need to do a lot of things by hand any way.

I am appreciating your help in advance!

Best regards,
Alexander

P.S. Sorry if I missed a thread with same issue =( I really tried to find the solution BEFORE posting a new thread!

Sorry for bothering, guys! I have managed to solve the issue by myself. The problem was that description and SKU are to be put inside "" so that the system treated it like 1 bit of info from a cell.

To be honest, the best thing you can do to make the perfect bulk upload is to enter 1 product by hand with ALL the information you want in there, then export this product, see how it is supposed to look and make the rest same way. If you are a confident MS Excel user and know how to work with columns and the combine text from different cells and actually compose a CSV, then this method works like a charm =)

ECWID WORKS GREAT!
Hi Alexander!

We are happy that you could solve your issue!

If there is anything else I can help you with feel free to ask! I’ll be glad to help!
 
The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.

Tags
csv import, csv numbers error, csv numbers issue, import problems

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 11:12 AM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.