Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

How long the normal import customer and vendor master in average ?

Posted on by 362
Hi guys,
 
Just curios to know, when we import customer master, with DMF, with some normal (basic) information of customer data, contact persons and addresses. 
How much record is the average per minute ?
 
Same question about vendor as well. Btw, this is for D365 FO, not AX or on-premise.
 
Because some say, for customer, it may took 5 records only per minute, so for 400 customer only can takes up to 1.5 hours. Now I have 6,000, not included few contact person in 1 customer, and few addresses for 1 customer. I'm getting dizzy to even think about the upload process for how long.
 
For vendor, I have close to 10,000 vendors.
 
Thanks,
  • Layan Jwei Profile Picture
    Layan Jwei 7,345 Super User 2024 Season 2 on at
    How long the normal import customer and vendor master in average ?
    Hi Teevo,

    is your questions answered? if yes then please verify the answers that helped. Thanks.
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    How long the normal import customer and vendor master in average ?
    There are many variables, as Layan alludes to, including how many fields in the master record you're populating but my experience over the years has been in the neighborhood of 125 records per minute.  10,000 vendors would take ~80 minutes in a sandbox (Tier 2) environment.
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 7,345 Super User 2024 Season 2 on at
    How long the normal import customer and vendor master in average ?
    Hi Teevo,
     
    I don't really think thay 400 customers will take 1.5 hours.
    The speed depends on alot of factors like environment itself(if it's devBox or Prod), complexity of the entity, the network...etc
     
    You could test this yourself..Try importing 100 records via DMF 3 times and see how much time it takes in those three trials.
     
    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans