Item references mass-upload?

(0) Share

Report

Posted on by Community member

I want to add a couple of hundreds of rows in the item reference table.

I want to connect our item number to a customer's item number. Doing this manually, one by one, is straightforward.

However, it is not feasible since I want to add about 2000 new rows.

If I look at the item reference table though, there's some fields missing.

When I do it manually, here's what I see and what I use (sorry, it's in swedish):

[Removed]

When I look at the item reference table, here's what I see:

[Removed]

And as you can see, there's no way for me to add the information that the reference number is based on a customer, nor what customer ID it is connected to.

How can I proceed?

Categories:

Inventory and warehouse management

All responses (2)

Answers (1)

Suggested answer

YUN ZHU 68,341 Super User 2024 Season 2 on at

Like (0)

Report

Item references mass-upload?

Hi, the easiest way is to use the Configuration Package.

More details: How to Export and Import Data (Using Configuration Packages)

https://yzhums.com/4286/

Edit in Excel can also be used, but some minor customization may be required if you need custom fields.

How to add custom fields in Edit in Excel

https://yzhums.com/39254/

How to use Edit in Excel in the browser/web (Excel Online)

https://yzhums.com/39161/

Hope this helps.

Thanks.

ZHU
Verified answer

Community member 12 on at

Like (0)

Report

Item references mass-upload?

When I opened the table in Excel, the missing fields were made accessible.