This helps me a lot to understand external id and id and how to import process works. This is a really good additional learning resource apart from Odoo elearning.
I have a searchable excel sheet (quite complex) that currently is being used outside of odoo and requires manual lookup outside of odoo. If I wanted to have odoo use the spreadsheet to display select data related to certain products like work instruction or jig location for product (all on the soread sheet) is it possible to have odoo look up the info via the soread sheet and display certain lines from it?
Well done! Thank you. I'm struggling with attributes and the product specific "price_extra" field (V16 Enterprise Online) - export is ok, import fails every time. Hopefully now I'm able to figure out, how to solve the issue.
Hi Kevin, Thanks for the great video, I am trying to import partner debit and credit as new open balance, but when I press on import, and choose the excel file, I can not select debit or credit from the drop down menus, I only see journal items. kindly let me know if there is any extra step needed.
im trying to export the external ids but when i select name, there is only list of names exported, not the same as what you have in the video. and when i am doing the import, i have the sales order id for the first line of each customer and then order lines for each product line, but this results in creating individual sales orders for each order line. I have tried to put sales order id in each order line, it comes out with all order lines in 1 sales order but the sales order number is not in a consecutive way, it jumps from S00005 to S06595, not sure in which part i have made mistakes
Thanks for the video! What would you recommend if I need to import approx 40k items? Added a bunch of new fields, but all mapping and fields are correct so not worried about errors. Would you recommend just posting directly to db using something like PostgreSQL or something like that?
I would not recommend going directly through the DB layer. Instead, either write a quick script using the external API, shell or just import them in batches through the UI.
Yes you can. Search for External Identifiers on your dashboard in developer mode. That will list all of your external id's. After that you can mass export after you filter down what you are looking for and re-import your new id's.
Hey Kevin, We exported a product series (135 records) and updated the prices, I now want to import them back into our production database... when I load the file I have 2 fields that tell me "to import multiple values, seperate them by a comma...... these fields have NOW changes, can I simply remove them from the import or will it over write with BLANK data?
You can remove them from the import. If the field is not in the import file it will not get overwritten. However, if you have the field/column and have the values as blank it will overwrite the field.
Hi Kevin, this is Javed Shakir from Qatar, I hope you are doing fine. can you please do me a favour. We are a group of Companies, and we want to implement Odoo 15 in our group. Can you help us in implementing the Odoo in all companies? Kindly, tell us your fee for doing this job for us. I really want someone professional like you to do this job for us. Here in Qatar, we have many Companies who do so, but I cannot rely on their competencies. I like your videos and you are doing your best. I will be waiting for your reply at the soonest.
This helps me a lot to understand external id and id and how to import process works. This is a really good additional learning resource apart from Odoo elearning.
Wow.... helpful video. Wish I was able to start out with this one.
Great explanation thanks for doing this!
Great video!
I have a searchable excel sheet (quite complex) that currently is being used outside of odoo and requires manual lookup outside of odoo. If I wanted to have odoo use the spreadsheet to display select data related to certain products like work instruction or jig location for product (all on the soread sheet) is it possible to have odoo look up the info via the soread sheet and display certain lines from it?
you are wonderful Keven
I have a question for you, how can I include product photos in bulk import and export?
did you figure out how ?
Well done! Thank you. I'm struggling with attributes and the product specific "price_extra" field (V16 Enterprise Online) - export is ok, import fails every time. Hopefully now I'm able to figure out, how to solve the issue.
I want to add ads.txt file plz help me
Hi Kevin, Thanks for the great video, I am trying to import partner debit and credit as new open balance, but when I press on import, and choose the excel file, I can not select debit or credit from the drop down menus, I only see journal items. kindly let me know if there is any extra step needed.
Very well explained
Thx a lotttt
im trying to export the external ids but when i select name, there is only list of names exported, not the same as what you have in the video.
and when i am doing the import, i have the sales order id for the first line of each customer and then order lines for each product line, but this results in creating individual sales orders for each order line. I have tried to put sales order id in each order line, it comes out with all order lines in 1 sales order but the sales order number is not in a consecutive way, it jumps from S00005 to S06595, not sure in which part i have made mistakes
Thanks for the video! What would you recommend if I need to import approx 40k items? Added a bunch of new fields, but all mapping and fields are correct so not worried about errors. Would you recommend just posting directly to db using something like PostgreSQL or something like that?
I would not recommend going directly through the DB layer. Instead, either write a quick script using the external API, shell or just import them in batches through the UI.
Thank you for your video sir! Could you show me how to import records for many2many field?
Hi Kevin, do you know where I can get someone to help me set up my Odoo Inventory accunt?
Hey Kevin, is it possible to rename external id ? For example the one autogenerated during export is ugly
Yes you can. Search for External Identifiers on your dashboard in developer mode. That will list all of your external id's. After that you can mass export after you filter down what you are looking for and re-import your new id's.
Hey Kevin, We exported a product series (135 records) and updated the prices, I now want to import them back into our production database... when I load the file I have 2 fields that tell me "to import multiple values, seperate them by a comma...... these fields have NOW changes, can I simply remove them from the import or will it over write with BLANK data?
You can remove them from the import. If the field is not in the import file it will not get overwritten. However, if you have the field/column and have the values as blank it will overwrite the field.
@@KZAKI GREAT... THANKS
Hi sir please also explain that how to import Prices list with discount implications
How can we import opening balance of the Chart of Accounts? Please suggest me some ideas.
Watch this video:
ua-cam.com/video/Rdjh3j9c1DY/v-deo.html
cant you share the plantilla the importar
The video content is good but the audio level is way down too low. Zooming up the images will help much.
Hi Kevin, this is Javed Shakir from Qatar, I hope you are doing fine. can you please do me a favour. We are a group of Companies, and we want to implement Odoo 15 in our group. Can you help us in implementing the Odoo in all companies? Kindly, tell us your fee for doing this job for us. I really want someone professional like you to do this job for us. Here in Qatar, we have many Companies who do so, but I cannot rely on their competencies. I like your videos and you are doing your best. I will be waiting for your reply at the soonest.
سلام منبع آموزش اودو به فارس خیلی کم است لطفا به فارسی نیز پست قرار دهید
❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
It’s all fun and games until you gotta upload several locations and routes. 💩