This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hey Everyone:saluting_face:

i have a question? i created Order using Celigo with all etail info but when i try to import same order via CSV it's creates the duplicate

How can i add external Id to CSV how to add this field in CSV

are you mapping that order number to the external id field in Celigo mapping?

Hey <@U03HQ088UKY> it's celigo Shopify app can i map it or it's already defaulting that, thanks in advance

<@U03HQ088UKY> I map *ID* to *External ID* but it didn't overwrite the value

External ID still showing: *SHPF-30522048647-4696835686585*

The shopify IA must be creating that external id in the background

You would need to match that on your csv upload then or you could use Celigo dataloader for free which has a lot more options compared to netsuite's native csv uploader

<@U03HQ088UKY> Exactly, but if i want to do CSV upload in NetSuite how can i know this External ID for Other Orders? is that possible

there isn't really a good way to export external ids and I personally wouldn't use them because of how difficult netsuite makes it to use, export, and display. I would use that etail custom field and data loader

<@U03HQ088UKY> i agree the issue is we sync Order from Celigo with all Etail Info (Etail Order ID, Shopify Store, Transaction Id) .

So here it's get tricky, normally if we try to sync same Order Celigo will ignore it right, but what happened is client try to create same Order via CSV and it not ignoring that it create a duplicate and i want to know which fields exactly i need to add in CSV to make it work like celigo Criteria

Thanks Tyler

You could give the client a celigo user and only allow access to the data loader you create