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

Hi Experts,
I need to import BOM revisions and i have more than one components for every BOM revision to upload, do I need same external IDs for every components line or different external IDs for every component line?

The external id is what tells the import processor “these components all go together” so lines with the same ID will be put into 1 revision record

If you had separate IDs for each line you would make a separate revision for each line and each revision would only have 1 component

for same IDs csv response shows that Id already used and do not import all component records.

Try using the multiple files import. Or create the revision with one component. Then go back and UPDATE existing revisions with the full component list in a separate import

Primary file should contain
External ID
Revision Name
BOM
(No duplicate lines)

Secondary field should include
External ID
Component (item ID)
Quantity

Then use external ID as the join between the two files)

So if you are creating 5 revisions each with 10 components your primary file should have 5 rows and your secondary file should have 50 rows

Okay. Thank you for the help. I will try to upload through multiple files.

<@U03GYQZTZDW> Thank You for your help. Multiple files import work very well.