Skip to Content
Меню
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
Це запитання позначене
4 Відповіді
6807 Переглядів

Hello odooers,

 Any suggestions for converting purchase orders received from customers by email in PDF and Excel formats directly into odoo as sales orders?

thanks

Аватар
Відмінити
Найкраща відповідь

I get the identical issue for my purchase order from suppliers.

suppliers send their delivery orders or invoices either as a mail content (one ligne per product) or pdf

Importing these data into odoo is a nightmare.

if you just create a csv file from text and then import Odoo will will create new products thus creating duplicates, unles you provide the product id if the product already exist in odoo. but the PO import menu do not identify the PO order line product name with the product id!!!!


I use the follwing tools: for OCR Tabula, Tesseract, 

for data cleaning :Google OpenRefine

Аватар
Відмінити
Найкраща відповідь

Same question, any update for the topic? 

I tried to install the OCR from webkul, but it is not for sales order directly, I need to do more coding to make it. And, then it will have Automation in action.

Аватар
Відмінити
Автор Найкраща відповідь

Update :

Odoo 12 introduced Documents module. which allows to import vendor bills from PDF ( with embedded xml) or OCR  into Odoo automatically. So it is possible theoretically to convert Customer's orders into Odoo's SO. 

why odoo didn't include this and only limited to vendor bills?

on the other hand, there are several tools to extract tables from PDF files, which can be parsed somehow and imported to odoo. 

My questions aims to see if someone did that?   what are suggested solutions ? 

Аватар
Відмінити

Hi Firas,
We have the same need, we are running in v16EE and can't use Odoo's OCR to create the costumer orders automatically... Did you find any solution for that?

Найкраща відповідь

I think u can't do this.

Odoo works with internal references for each product and vendor. Its not like it relates text, it works with externa references in a Database.

Аватар
Відмінити
Related Posts Відповіді Переглядів Дія
0
трав. 20
2769
0
бер. 21
2079
2
лют. 21
4351
2
лип. 20
24938
0
жовт. 19
3306