Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search

Import: "Missing column Add PRODUCT ID column" When the column is there


Recommended Posts

So I got the importing worked out and I want to add a ton more products to a store.

I exported a CSV, added another product as a test, and imported the new CSV and got the following error:

"Missing column
Add PRODUCT ID column"

So I go to check the CSV and it's right there as the first column. I'm baffled by this one. How can I solve this? I have a ton more to add to my store.

Link to post
  • Replies 13
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

I just tried using Google Sheets (I was previously using Numbers on my mac) .  I made the changes in google sheets, then exported it as a csv file.  I then imported this csv to my website and I did no

I've had multiple issues with this and I've reached out to Customer Support and they told me to check my .csv template haha. So no avail. Sounds like a bug in the system   @srodrigues

Posted Images

I just tried using Google Sheets (I was previously using Numbers on my mac) .  I made the changes in google sheets, then exported it as a csv file.  I then imported this csv to my website and I did not get the error message any more and all the changes I made were there.  Hope this helps.  

Link to post
  • 2 months later...
  • 4 weeks later...
  • 2 weeks later...
  • 1 month later...
  • 2 weeks later...

Hey @alexamargs

From what you are describing it seems the issue might be related with the the .csv file formatting. Most likely that's the reason why double-checking the .csv file was the suggestion. If you keep experiencing issues with importing your products even after you have ensured that the file meets the required formatting rules, continuing the conversation with Customer Support would be the best approach to get further assistance. 

Link to post
  • 2 weeks later...

I am having the same problem! 

@srodrigues - I believe we are all using the .csv file from the help area - and editing it as instructed. For some reason, it still says the column is missing. Are we supposed to Edit the Product ID Column in some way?

Edited by raeroshow
Link to post

Hey @raeroshow -- I have also struggled for hours and just realized the walkthrough video suggested users to use google sheet. So I did the same -- download the template -> upload it to google drive -> convert it to google sheet format -> copy paste all the data to the google sheet -> and then export the csv file.  And it works. Yay!

Edited by cantocookingclub
Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment


×
×
  • Create New...