Skip to Content
Menu
This question has been flagged
2 Replies
736 Views

Dear all,

I am checking out the platform and its functionality from a free trial account to see if the workload for managing a product portfolio should be expected to be manageable.

In that context, I am looking for a way to update my product list by uploading data from an Excel sheet. When I go to eCommerce>Products, select all products and export to Excel sheet with the flag " I want to update data (import-compatible export) " checked, I obtain an Excel sheet that I can edit and which also includes a field 'id' which I understand is important to avoid duplicates during upload.

I fail to find any working functionality for reversing the process. Going back to my product list and selecting 'Import Records', followed by 'Upload File', 'Test' and 'Load File' doesn't seem to do it. My understanding is that this is only a function for defining a template for interpretation of the Excel sheet with the data to be uploaded.

I fail to find any information in the documentation. Could anyone please help out?

TIA

Avatar
Discard
Author Best Answer

Thanks Sander,

Thank you for your response. During the evaluation phase, product variants are not the focus of my investigation, but rather the ability to update the online product details from an offline record, e.g. as concerns product offerings, prices etc.

Concerning your leaving remark, you claim that it is possible to reverse the process. That is very reassuring, but could you please explain how or link to a part of the documentation where this is described in detail.


Thanks again. I did find the video at: '

'

The key to the solution was to press 'Import' again, not 'Load File'.

Avatar
Discard
Best Answer

I started the same way as you. For me I had some specific requirements for product variants, and ultimately bought a specific Excel import module for this. (Not a big investment). Depending on your requirements, you can try to make the standaard functionality work. Or go ahead with the more advanced Excel import modules. For me it was totally satisfactory to buy an extra module and now have a master Product Sheet that will import all the data I need from an external system.

With regard to your question, if you leave the ID in tact, you could reverse the process and import the products as needed. 


I think you were almost there, after you 'Test' the file Odoo should respond that everything is fine. Then you can use the Import button to do the actual import. At least this is how I did it, and works.

In addition you could use the developer tools in your browser, and check that the action is actually executed when pressing the Import button.


As for documentation, I'm not sure, but I think I found a youtube video explaining this process.



Avatar
Discard

Glad to hear that this worked.

Related Posts Replies Views Activity
2
May 25
460
2
May 24
5918
2
Jan 24
1905
0
Nov 23
1066
0
Sep 23
917