Import Issues with CSV file

[SimonWest]

Good Morning

I am having the all too familiar issue from reading other posts that the import of updated CSV file does not work and not seen any explained method that works.

I have tried exporting the file and not making any changes and re-uploading and have 34 errors saying "Issues found on row 8 of import. The importer has found multiple rows for this product, so we'll use the values from the last row".

I have tried using google sheets to edit and import and same issue.

I have tried Excel to edit and import and same issue.

What is the solution?

I need this to be resolved urgently as I am working on other websites which will have a large stock of items and the only other option I see is moving away from Weebly.

Regards

Simon

[Adam7]

Welcome to the Community, @SimonWest. 

After importing your sheet into Google sheets, can you remove all the rows except for the first one, then export that back to a CSV and import it?

I find it's sometimes easier to trouble shoot something like this when you're just working with a single row.

[SimonWest]

Hi Adam

I have tried what you have said and get the same errors as screenshots below.

Regards

Simon

[Adam7]

Hmm... So this should be updating an existing item in your store, correct? And everything within the row is what was there when you exported it - you didn't make any changes?