Skip to Content
This question has been flagged
1 Respondre
954 Vistes
Avatar
Grant Dingwall

Hi all,


Just trying to import a spreadsheet with stock on hand and reordering rules for one of our warehouses, but an error stopping me from importing the file regarding location_id, even though the location_id is included in the spreadsheet. Is there any way to fix this or am I not doing something wrong?



Avatar
Descartar
Avatar
Pektsekye
Best Answer

Can you attach the .csv file?

Avatar
Descartar
Pektsekye

I see your file has Windows line endings.
Try to import it in UTF-8 with Unix line endings.

I don't have any kudos on this forum yet. so I cannot use any links here. You can contact be by email pektsekye@gmail.com
I will send you the UTF-8 with Unix line endings version of the file.

Grant Dingwall
Autor

is the link not visible to copy and paste?

Pektsekye

The link is visible for me. But I don't know how to send a file to you.

Grant Dingwall
Autor

Thanks for the offer of help. Are you able to please explain this process via the forums? As our company is uncomfortable receiving files from outside sources.

Pektsekye

You are right we should solve the problem on forum. So other people can do the same without my help.

1) Search in google "convert to unix line endings online".
2) Then choose one of the first results. An online converter from "execeratics".
3) Upload your CSV file and choose "CRLF to LF".
4) Download the converted with Unix line endings.
5) Try to import it. (Just don't open it with any program! As you can break the file format.)

Grant Dingwall
Autor

Awesome, thank you so much for your help