I am using Odoo v16 online enterprise. I have come across a situaltion several times that I need to add one by one items in purchase order, which is very time consuming task.
In reality. I dont create purchase orders and send them to vendor. I call vendor, tell them to prepare offer for me. I go through the offer and send confirmation. Then I receive the products with bill. Then I add quantites and expiry dates to the system.
So, why should not I be able to directly import bill with received quanitties and expiry dates of each products.
Basically, I dont want to go each product --> add quantity --> add expiry date. Better to import one file containing, product name, product quantity, expiry dates and that's it.
Let me know how to get this done.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
The module named "VKS Import Excel" can help you solve this problem easily: https://apps.odoo.com/apps/modules/16.0/vks_import_excel.
Please contact me via email anhtuan.acoi@gmail.com if you need further assistance.
Per the Odoo assistance I am informed that "importing purchase orders, will require a product name, with a product ID is not possible."
This is an issue as it will create duplicates of products if the name is even slightly different from was is in your db
Hi, you can follow https://youtu.be/SgFmOD9Q2S4?si=46y7nPM_rumGs9NU
I hope it helps, thanks
There is no direct solution for it but you can do this using the create value at runtime import of the record.
For one-time export the purchase order template xlsx or CSV file according to your needed fields
Second, suppose you have vendors that are not predefined in your system and there are products also not predefined in the system so while importing there are three options given if your value does not match with the system record select create new value so according to that your vendor are created and also your product are created then after only you update your things that remaining in both fields.
If this is useful for you then please first check and test in the testing database
Hope it will be useful for you.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Jul 24
|
2386 | ||
|
3
Nov 23
|
8228 | ||
|
1
Dec 21
|
5391 | ||
|
Import products from excel
Solved
|
|
1
Jan 19
|
4048 | |
|
0
Jul 16
|
4223 |
Hello Any Answer on above comment?
Hello,
You can import products and its quantity from excel file and we directly process it. But for that a custom script required for upload the excel and read excel file and create the order line accordingly.
Thanks,
shivoham.odoo@gmail.com