Skip to main content
Question

Help with Import Scenario: Issue with Updating Existing / Creating New Contact


ainscorpwill

Hi Acumatica Community,

I’ve set up an import scenario to handle contact records using a CSV file exported from Shopify.
The goal is to either update an existing contact (based on the email) or create a new one if the contact doesn’t exist.
 


However, I’m encountering an issue where the scenario always creates new contacts, even if a matching email with the contact exists in the system.

I am using <Key: External> in the first row.  My understanding is that this is used to identify records in the system, but it does not look like the whole import is updating any existing contact at all, instead, creating new ones.

Is there something wrong with how I’ve configured the <Key: External> mapping or could there be another setting or mapping I’m overlooking that might cause this issue?

Any help would be really appreciated!


Will
 

3 replies

  • Freshman I
  • 9 replies
  • January 21, 2025

I’ve been waiting for a while to find an answer to this.  Did you ever solve it?

I’m trying to do a lookup based on an internal ID we have as part of our migration from an old system to Acumatica and I need to lookup the contact to link it to the record I’m importing.

 


Nilkanth Dipak
Semi-Pro I
Forum|alt.badge.img+10

Hi ​@ainscorpwill,

Try to pass Contact ID as well in your import scenario.
 

Hope, it helps!


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

@ainscorpwill Contact ID should be unique


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings