Update parts using Data Import

Hello Team,

I’m currently attempting to update the Revision field on the part window under the Main Warehouse using the following path:

ADMIN → APIS & MORE → DATA IMPORT

I selected Parts and checked the Update Related Data option.

As part of the test, I included both part_revision and revision fields in the import file. The part_revision values were imported successfully, but the revision field did not update as expected.

Could you please advise if I may have missed a step in the process, or if there is an alternative method to update the Revision field?

Thank you for your continued support!

Regards,
Mahtab

Hi,
I do not think you can change the revision on a product that is already in your inventory by import.
What you do is setting the revision for the future (if you produce it, then the next version will become of that revision. if you buy it it will get that revison by default at receive)
If you want to change the revision on current inventory you have to go to edit on the right hand side here.

//H

Hello Henrik,
Thank you for your reply and the helpful information.

Regarding the Bin version, there isn’t any information in this field at the moment. We currently have around 18,000 records, and I’m exploring options to perform a mass update. If there’s any way to streamline this process, I would appreciate your guidance.

Thanks again for your support.

Regards,
Mahtab

I took a quick look at the parts template data under ADMIN → APIS & MORE → DATA IMPORT
And I think it might be doable if you in your excel file that you import add the following

bin_location ->The unique name of the bin that is storing your parts in a warehouse.
revision → The name of the revision for the prcpart
part_revision → The name of the revision for the prcpart
quantity → The amout of inventory of the prcpart in the bin

Might be a good idea to just test with one part first.
//H