At Pragmatic, we have developed an app where user can import all the Contact data into Odoo very easily. The app supports both file formats i.e. Excel and CSV. So user can import excel file or csv file directly into Odoo
Simple to use and fast paced operations
Both excel and csv files supportive
For importing sale orders,
Go to Sales app-> Orders->Import Sale Order
2. After clicking on Import Sale order you will see a new window as shown below
In this window, user can select the type of the file i.e. CSV or XLS file.
In CSV/Excel file user can insert following data fields:-
ORDER NUMBER
CUSTOMER [Mandatory field]
PRICELIST
PRODUCT [Mandatory field]
QUANTITY [Mandatory field]
UOM [Mandatory field]
DESCRIPTION
PRICE [Mandatory field]
SALESPERSON
TAX
DATE [Mandatory field]
3. Quotation State available
Import Quotation in Draft Stage
If you want to automatically confirm the quotation after importing then please select this option.
4. Then Upload required file just by clicking on Upload file button.
5. Sequence Available :-
You can use the sequence number available in Excel/CSV file
Or you can use the odoo default sequence number
After uploading the file you can see the sale order details have been imported to odoo as follows.
It is very simple to use and operations are fast paced.