| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) |
| Lines of code | 471 |
| Technical Name |
qworx_variant_price |
| License | LGPL-3 |
Overview
Automatically manage product variant prices in a dedicated pricelist. When new variants are created, they are automatically added to your default variant pricelist with the template's list price.
Key Features
- Auto-add variants: New saleable product variants are automatically added to the default pricelist
- Price sync: Single-variant products automatically sync price when template price changes
- Archive handling: Archived variants are removed from pricelist, unarchived variants are re-added
- Bulk add: Add all existing variants to pricelist with one click in Settings
- Export/Import: Built-in export template for bulk price updates via Excel
- Multi-company: Each company can have its own default variant pricelist
- Notifications: User notifications for all pricelist changes
Configuration
1. Set Default Variant Pricelist
Go to Sales > Products > Pricelists and check the "Default Variant Pricelist" checkbox on one pricelist.
2. Add Existing Variants (Optional)
Go to Settings > Sales > Pricing and click "Add All Variants to Pricelist" to add existing variants.
Usage
Automatic Behavior
- New variants with
sale_ok=Trueare automatically added to the default pricelist - Single-variant products: price syncs when template list price changes
- Multi-variant products: prices are manually managed per variant
- Archiving a variant removes it from the pricelist
- Unarchiving a variant re-adds it to the pricelist
Bulk Price Updates
- Go to Sales > Products > Pricelists
- Select your default variant pricelist
- Use Actions > Export with template "Pricelist Items Export"
- Edit the fixed_price column in Excel
- Import the file back using Favorites > Import records
Note: Only edit the
fixed_price column. Other columns are for reference only.
Technical Details
- Models extended: product.pricelist, product.product, product.template, res.config.settings
- Dependencies: sale
- Multi-company: Fully supported with per-company defaults
- Translations: Spanish (Chile) included
Qworx Variant Price
Automatically manage product variant prices in a dedicated pricelist.
Configuration
Set Default Variant Pricelist
- Go to Sales > Products > Pricelists
- Open or create a pricelist
- Check "Default Variant Pricelist"
- Save
Only one pricelist per company can be set as default.
Add Existing Variants
- Go to Settings > Sales > Pricing
- Find "Variant Pricelist Management"
- Click "Add All Variants to Pricelist"
This adds all active saleable variants not yet in the pricelist.
Usage
Automatic Behavior
- New variants with sale_ok=True are added to the default pricelist
- Single-variant products: price syncs when template list price changes
- Multi-variant products: prices are manually managed per variant
- Archived variants are removed from the pricelist
- Unarchived variants are re-added to the pricelist
- Setting sale_ok=False removes variant from pricelist
- Setting sale_ok=True adds variant back to pricelist
Bulk Price Updates
- Go to Sales > Products > Pricelists
- Select your default variant pricelist
- Click Actions > Export
- Select template "Pricelist Items Export"
- Export to XLSX
- Edit the fixed_price column in Excel
- Import using Favorites > Import records
Note
Only edit the fixed_price column. Other columns are for reference only.
Multi-Company
Each company can have its own default variant pricelist:
- Company-specific pricelist takes priority
- Global pricelist (no company) serves as fallback
- Variants are added based on product's company compatibility
Notifications
Users receive notifications when:
- Variants are added to or removed from the pricelist
- Default pricelist checkbox is checked/unchecked
- Default pricelist is archived, unarchived, or deleted
Technical
Models Extended
- product.pricelist - Added is_default_variant_pricelist field
- product.product - Auto-add/remove on create/write/archive
- product.template - Price sync for single-variant products
- res.config.settings - Bulk add button
Dependencies
- product
- sale
License
LGPL-3
Please log in to comment on this module