Small and medium business | Business Central, N...

Creating multiple Items

(4) Share

Report

Posted on by JS-12061503-0

Is there a method to create multiple items using a table?
It would be similar to "Edit in Excel", but I would like to include Attributes.

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

Andrés Arias 1,293 on at

Like (2)

Report

Creating multiple Items

Hello,

I could do it from 2 options according to my understanding.

1.- In the item page - Home - Copy Item option and include the attributes:

2.- Prepare a configuration package with the necessary tables.

I hope I can help.

Regards,

Andres
Suggested answer

YUN ZHU 85,670 Super User 2025 Season 1 on at

Like (2)

Report

Creating multiple Items

Hi, If you need to create multiple similar items, you can use the Copy Item function.

If you have special requirements, you need to customize it. If you use Configuration Package, you need to import multiple tables at the same time.

PS: Dynamics 365 Business Central: Bulk add/update Item Attributes (Edit the attributes of multiple items at the same time) – Customization

https://yzhums.com/51270/

Thanks

ZHU
Suggested answer

Sohail Ahmed 4,747 on at

Like (2)

Report

Creating multiple Items

Attributes are not directly editable in the Item table via Excel.

Here's how you can proceed:

✅ Step 1: Use Edit in Excel from the Item list page to bulk create item master records.

✅ Step 2: For adding Item Attributes, you must use the Item Attribute Value and Item Attribute Value Mapping tables. These are not available via “Edit in Excel,” so you’ll need to:

Use Configuration Packages, Web Services, or

Create a custom API/page to expose and map attributes during item creation.

Alternatively, you can use Power Automate with the standard APIs to automate both item creation and attribute assignment.

✅ Mark this answer as verified if it helps you.