Friday, January 17, 2025
3 changes
New functionality added to Odoo
Odoo can now connect to Shopee to import orders from multiple accounts and shops. Businesses can match Shopee items to Odoo products, handle both Shopee-fulfilled and merchant-fulfilled orders, and keep stock levels synchronized for merchant fulfillment.
Original PR description
* Import orders from multiple accounts and shops * Match products based on their internal reference (`item_id` or `model_id` in Shopee) * Support both Fulfillment by Shopee (FBS) and Fulfillment by Merchant (FBM): * FBS: import the completed orders * FBM: fetch the delivery information from Shopee, track and synchronize the stock level to Shopee task-3623720
Enhancements to existing features
The HTML editor now lets users upload files directly from the file command, a new upload button, and the link popover without opening the media dialog first. Uploaded files appear as smaller blue download boxes that can sit alongside other files, making documents cleaner and file sharing faster.
Original PR description
This PR changes the behavior of the /file powerbox command in the following aspects: - it no longer opens the media dialog, and skips it directly to the system's file selector - the resulting download box has gone through visual changes, mainly: - it no longer takes the whole width of the screen, and multiple file boxes can be placed on the same line - it has blue color an the looks of a bootstrap alert-info banner - the same command is also available as a powerbutton. This PR also allows the user to upload a file (also skipping the media dialog) from the link popover, thus creating a link to the created attachment. https://github.com/odoo/enterprise/pull/75045 task-3522395
Resolved issues and error corrections
The sales commission report now loads much faster by making database lookup rules match the invoices included in the report. This removes a slowdown that affected large databases, reducing report load times from minutes to seconds in benchmarked cases.
Original PR description
## Description Following 9a8777b4b96367597418cdc1c1ffc7ea3264113f, the criteria on the `move_type` of the invoices used in `sale.commission.report` was changed from `'out_invoice'` to `'out_invoice' AND 'out_refund'`, but the respective index `account_move_invoice_user_id_date_idx` partial clause hasn't been updated, leading to Postgres not being able to use the index, leading to a performance regression. We're updating both custom indexes partial clause to match the invoice `move_type` condition used in the reporting. ## Benchmark On a large database with millions of invoices and customers | Timings (hot) | Before | After | |---------------|--------|-------| | 1 read_group | 40s | 1s | | full load | 225s | 6s | ## Reference task-4448879