I'm trying to import customer records to update their custom item pricing but am getting the csv error response - There is an existing custom price in this currency for this item. Please select a different currency or item.
I have overwrite sublists checked, so I would have thought it would just try to overwrite these values, no? How do I get around this?
Here are my import settings. Also, should this be Update or Add/Update? Currently using just Update since I'm assuming I'm just updating customer records, not adding new lines as it might be…
Here is my mapping
I have started testing this in Sandbox, for which I have cleared all the existing custom prices from the customer records. But this error is still occurring, even though no prices exist at all.
So perhaps it's a duplicate in the CSV? But I've checked my CSV for all instances of there being a Duplicate existing in both the Customer ID and Item and can't find any.
One of the customer records that fails with no Item Pricing
Formula highlights blue if similar values appear in both A and C
Filter showing no lines have been coloured