Skip to main content
Question

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

  • January 3, 2025
  • 3 replies
  • 90 views

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

Forum|alt.badge.img
  • Freshman II
  • 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.

 


DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi ​@ainscorpwill,

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

Hope, it helps!


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

@ainscorpwill Contact ID should be unique