web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Importing 40k items

(0) ShareShare
ReportReport
Posted on by 34

Hi,

Currently i am working on a project on which we also are doing the data migration from NAV 2009 to Business Central SaaS. The customers, vendors and all other records have been transferred to BC, although I do have issues with the items, as there are in total 40.000 items that need to be imported in Business Central. When I try to use the configurations packages from this, the loading takes way to long and sometimes even times out. 

Is there perhaps a better way to import all these items, the mapping between NAV and BC has been done, so its just a matter of getting the data into Business Central. I am open to any workable suggestions!

Thans in advance,
Robert-Jan 

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    50,269 Super User 2026 Season 1 on at

    You can import them using the XmlPort, but you need to develop it and it is fast compare to a regular rapid start.

  • Suggested answer
    Muhammad Zaid Profile Picture
    286 on at

    Hi,

    I suggest you break items master data files into multiple files. You can segregate the data based on item categories or item numbers as you want.

    We also did a migration of 60K items for one of our clients. I did the same and create multiple sheets of item data by item category.

    I hope it helps.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,300 Super User 2026 Season 1 on at

    I would suggest to develop XMLPort. It is way much faster than Config Package. The time spent to develop it will be less than trying to import using Config Package.

  • Suggested answer
    JAngle Profile Picture
    150 on at

    If you want to avoid doing the DEV work try this: https://www.hougaard.com/bccl/

  • Verified answer
    Robert-Jan Walet Profile Picture
    34 on at

    HI all,

    Thanks for all the replies, I definitely have something to work with! Will first try to split the file up if that doesnt work, I will ask dev to make an XMLPort.

    Have a great day :)

    Robert-jan

  • Robert-Jan Walet Profile Picture
    34 on at

    For future refferences, I ended up with splitting the file in chunks of 10k items, just based of item number. Importing and applying took about 1,5h that way which was manageable.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,986 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,071 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 975 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans