The supplier sent the same SKU twice
One product code appears on more than one row of the same file, sometimes with two different prices.
Why it happens
- The commonest cause is a sender who appended rather than replaced.
- The second commonest is a genuine multiple: the same product at two pack sizes, or in two currencies, where the code identifies the product and something else identifies the line.
- Either way the cost lands later.
What to do now
- Before anything else, count distinct codes against total rows.
- Look at what differs between the duplicate rows.
- Ask the sender which is current rather than inferring it.
Next time
Mark the field unique and a second occurrence in the same delivery is refused at the door, named on its own row, before anything merges.
Start from the vendor price list template.
Related problems
My price column will not add upA column that plainly contains prices sums to zero, or sums to less than it should.Merging contact lists gives me duplicatesThree lists went in and the combined file has the same people more than once, often with slightly different spellings, capitalisation, or company names.“N/A” and dashes in a column that should be numbersA numeric column contains “N/A”, “-”, “n.a.”, or “(blank)” alongside real figures.My CSV columns are shifted or split in the wrong placesMost rows look right, but some have values in the wrong columns: a postcode in the country column, a phone number where the email should be.