Jump to content

I Dunno What Errors Occurred when importing my CSV file.


Alan Cobain
 Share

Go to solution Solved by Mag,

Recommended Posts

  • 1 month later...

This is a normal problem and there is nothing wrong with the file itself.

What happens is that your excel is not being able to display all the values in a nice table like you were expecting.

There is different ways to solve this issue but one of them is the following:

  1. Open Blank Workbook.
  2. Go to DATA tab.
  3. Click button From Text in the General External Data section.
  4. Select your CSV file.
  5. Follow the Text Import Wizard. (in step 2, select "comma" as delimiter of your text)

There is many videos in youtube that can be helpful.

Another option is to Open your file with a different program such as Google Sheets.

Link to comment
Share on other sites

  • 1 month later...

In the items name in the CSV file, the items are written and saved in Arabic fonts. Upon importing the CSV file, all Arabic letters are transferred to "?" mark. I tried modifying the imported items by directly writing the item name in Arabic font, and it excepts. Nevertheless, the list of items is too large to do modifications one by one. Pls support to fix this import problem

Link to comment
Share on other sites

  • 2 weeks later...
You need to open excel program first, then click Data, from Text. A window will open to select your CSV file. After you select it, another window called Text Import Wizard will open. Follow the Three Steps that apear. The first step Choose the File Type that best describes your data (select Delimited). You may start import at row 2 as row 1 is too large and contains names of each coloum which you may not need. File Origin select 65001 unicode (UTF-8). Then go to next step Delimiters, select Comma only. Then next and finish.
Link to comment
Share on other sites

  • 2 months later...

When uploading a CSV, I only get a message with the number of titles that are already on the product list. With thousands of different products (books) it takes a lot of time to find out which titles are double.

Link to comment
Share on other sites

During import at the back office, there is a report of errors and warning signs. They indicate which sell, row or column has a problem and the type of problem. 

So, it is easy to change mistakes in the CVS file.

errors during import of customers

 

Link to comment
Share on other sites

  • 1 month later...

Hi.

When I export the item list in Excel, I just notice that if the barcode starts with 0(zero), the first digit 0(Zero) is removed in Excel.  

For instance, if a bardcode is "0234567", if appears as "23456" in exported Excel. If I edit other information beside a barcode, the barcode is replaced with the number without 0(zero).

Does anyone know how to download a barcode without missing 0(zero) or anyway not to edit the bardcode if I import Excel file?

 

Thanks  

Link to comment
Share on other sites

Every digital table system inculude excel, doesn't recognize the '0' as the biginning number. I mean if you try to type '0333' then It will show only '333'
 

So you can try to make barcode as the text. but what I recommand you is "try not to start barcode with 0." It is the most simple way. 

Link to comment
Share on other sites

If you import the CSV file into excel and set the barcode column to text it will display the 0.  make sure you save the file as csv if you want to import it into the POS. otherwise it will drop the zero

Link to comment
Share on other sites

  • 2 months later...

Hi,

Do you have any info about the import template. I need to know which each of the columns means so I know what info to input where and which fields I can leave blank etc

Link to comment
Share on other sites

Hello. 

When you have a list of sample items, you can export them. Click on the ‘Export’ button.

Open your CSV file (the best way is to open it from Google Sheets, but you can also use other tools). You will see the sheet with your sample items. You can use it to add other items you intend to import. Follow the pattern of your sample items when filling in the fields.

More details read official help.

Link to comment
Share on other sites

  • 1 year later...

Hi there we export item list then edit the prices save as comma delimited then export back to loyverse, this does not work because all of our barcodes change when we export back into loyverse, we are doing this as loyverse say to do in help tutorials, can any one solve this problem, how Loyverse say to do import export does not work, we using excel.

Thank you, Garry Ross.

 

 

 

 

 

 

Link to comment
Share on other sites

Hello Garry, 

Could you give us an example of what happens to the barcodes and how they change when you import them back to Loyverse? 

Link to comment
Share on other sites

  • 7 months later...

I have trouble uploading the inventory CSV file as the system always says that error message "cell cannot have the same handle name"

What can I do???

Thank U

Screenshot 2020-12-25 00.21.37.png

Link to comment
Share on other sites

Hello. 

The ‘Handle’ field is required for items with variants and it should be the same for all variants of the same item.

The system will give mistake if you put the same handle for different items. To avoid this just delete all handles from the import file. 

  • Like 1
Link to comment
Share on other sites

  • 3 weeks later...

Hello! Have you made any changes to the handle of the items in the file? Please send the file you are trying to import to help@loyverse.com. And explain the steps you took. For example, are you exporting, making changes to a file and importing a file, or are you trying to import new items?

  • Like 1
Link to comment
Share on other sites

  • Solution

Thank you for sending file. It looks like you already have items with the same SKU as you use in the file. So those items have already handle in back office. It is the reason, why you receive such error message. We recommend you to use new SKU in the import file.

Link to comment
Share on other sites

  • 9 months later...

Hello!

You can try to open the file in google sheets if you have opened them from Excel when this questions marks appeared. 
This most probably happened because sometimes excel or whichever program you are using to open the CSV file is not able to recognize the language. In such cases, I can suggest that you try to follow this guide provided about opening in excel and then you can try opening the file in Google Sheet instead.

Excel:https://help.loyverse.com/help/export-excels

 

Google Sheet:https://help.loyverse.com/help/how-open-csv-file-google-sheets

Link to comment
Share on other sites

  • 9 months later...

After puting my items in the csv template, fill out the VAT value as applicable and importing the file without errors it turns out that the applicable VAT knob is not selected under the items, all imported items have no VAT selected at all.

Is this an import error?

Link to comment
Share on other sites

Hello!

May I ask how did you fill out the VAT value as application in your import file? 

Link to comment
Share on other sites

14 hours ago, Shinji said:

Hello!

May I ask how did you fill out the VAT value as application in your import file? 

As follows:

afbeelding.png.f3ca519a29b086a9230bcb14dda149b5.png

"Tax - ""VerkoopLaag"" (9%)""Tax - ""VerkoopHoog"" (21%)""Tax - ""VerkoopNul"" (0%)"

NYN

Link to comment
Share on other sites

Could you be able to send the csv file for us to check here? 

Link to comment
Share on other sites

14 hours ago, Shinji said:

Could you be able to send the csv file for us to check here? 

Please tell me how

Link to comment
Share on other sites

  • 1 month later...

Same to Korean language. I have korean product and need to put korean name on item. 

I tried above as Encoding UTF-8 but still same.

image.thumb.png.1fc75b891d4cdfc3c1a0a11941139904.png

I tried Google Spreadsheet and Excel 2007 and office365..I cannot fix this

Link to comment
Share on other sites

Hi, I export "sales by item" for stock sales by time and date.

I cannot see Korean langauage on CVS file.

I tried to encode UTF-8 in tools option in save as.

But still it does not change back to korean.

I can see the korean language on website. Not on CVS file and even I tried to encode to UTF-8, it does not change.

image.thumb.png.bc26f2ff655c9f02e044173655ad595d.png

Can you help?

I tired google spreadsheet and excel 2007 and Excel365

Link to comment
Share on other sites

Hello!

In these kinds of cases, may I ask that you try to follow this guide provided on how to open the csv file in google sheet please? And in this guide, please note to remove the "Convert Text to numbers, dates, and formulas". This should allow you to display the texts of the csv file as is without the program automatically changing it for you:

 image.png.274765d3a4b264d8b8787215a8694809.png

 

Here is the link to the guide as well: https://help.loyverse.com/help/how-open-csv-file-google-sheets

Link to comment
Share on other sites

It should be possible to do so if you follow this guide provided: https://help.loyverse.com/help/export-excels but based on my experience of using excel, there's always a chance where the program will automatically change data when you even did not want to so. If this did not work, I'd suggest sticking to Google Sheets.

Link to comment
Share on other sites

  • andres changed the title to I Dunno What Errors Occurred when importing my CSV file.
  • andres pinned this topic

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share

Loyverse Point of Sale

 

 

 

 

×
×
  • Create New...