Hi Thuy, thanks for your reply. I looked at your video and see you are indeed importing SN and updating inventory. I can work that out. My issue is about the additional properties that I need for each serial number, as per the additional message here below. All the best, Sebastian

Hi Sebastian,

In the video I sent above, please watch carefully the part about searching fields to export data to excel (from 50:03 to 51:09 in the video). You can absolutely select the Rental and Manuf Date fields as in the image you describe.

Hi Thuy,
Thanks again for your message.
The Rental, Manuf Date, First Renting Date, Inventory value, Initial Inv Value and Last Month Inv Value are not field available in Odoo. I have added these as (custom) properties for the serial number and they are not visible directly in Odoo, with the "Add a Property" in the serial number window

It is possible to export the lot properties and properties, but they export as complicated field: such as :

[{'name': 'e424cf8662b1c4ba', 'type': 'boolean', 'string': 'Rental', 'default': False, 'view_in_kanban': True}, {'name': '4b0b912652a51cfc', 'type': 'float', 'string': 'Inventory Value (€)', 'default': 0, 'view_in_kanban': True}, {'name': 'd78db6cf05ded031', 'type': 'date', 'string': 'First Renting Date', 'default': False, 'view_in_kanban': True}, {'name': 'e9ebdea34265eebd', 'type': 'float', 'string': 'Initial Inv Value (€)', 'default': 0, 'view_in_kanban': True}, {'name': '80a08dc8215eb807', 'type': 'date', 'string': 'Manuf Date', 'default': False, 'view_in_kanban': True}, {'name': '77b420381675775f', 'type': 'float', 'string': 'Last Month Inv Value (€)', 'default': 0}]

and their properties also:

{'4b0b912652a51cfc': 1591, '77b420381675775f': 3408, '80a08dc8215eb807': '2024-01-15', 'd78db6cf05ded031': '2023-03-06', 'e424cf8662b1c4ba': True, 'e9ebdea34265eebd': 13633}

I have tried to reimport them, but I suspect that some of the hexadecimal number are index and need to be generated by Odoo. When I tried, The message in the import area is: not possible to import the type 'properties'.

Hi Sebastian,
Can you record a video of your file export operation?

Hello Thuy, finally managed to find time to make the video: Here it is:https://youtu.be/PreO3nOONOY
then I get this xls file https://youtu.be/2BYUkL-HRwQ , which I can't reimport given the lot property field.

Hi Sebastian,

Based on the video you posted, I see you are exporting the wrong data field. For example, if you want to export the value of the Manuf Date field, you must select the Manuf Date field, not the Properties field (in the video I saw you select the Properties field).

Hi Thuy, this is the only way I foudn to export the custom properties of the serial number. Manuf Date, Rental, and the other custom properties are not explicit field that are exportable. I have searched for it all through all the field and expanded each of them one by one but could not find them. The only way I found is to export the lotproperty and associated property in Product and I get both the name of the custom property and its value, but not usable in the export and import. If you have a way to find where these custom lot/SN properties, that would be great.

Hi Sebastian,

I have never created new fields on the interface like this before. I usually create them in code so I can't help you this time.

Hi Thuy, OK, thanks for having tried.

Hello Thuy, I think I found the way. I am indeed adding the additional properties as new field using Studio. then it can be exported and imported again. Using the native additional property field does not allow to export and reimport. I believe this is similar to what you were suggesting. Thanks and all the best, Sebastian