This is the tool to implement product automatic coding which satisfies your real requirements. The app is flexible enough to reflect almost any product reference structure, since it let you define as many code parts and as complex criteria as you like.
Advanced rules to construct product reference
Specify an unlimited number of code positions of internal references. For example, the first position relates to a category, the second – to a manufacturer, the third – to the attribute 'material', etc.
Code positions for certain products might be empty: e.g. for services there is no sense to have a code part of the attribute 'material'.
Each position has rules to generate a code value. For example, for products made of aluminium it is '-AL', for products with material steel it is '-ST'. In order a code part is calculated for this product, there should be at least a single rule this product satisfies.
Product reference is updated according to coding rules
Have as many code positions (parts) as required
Flexibly configure rules to combine a product internal reference
Static and dynamic code parts
Each rule might lead to a static code (e.g. '-AL') or to a dynamic one. In the latter case a real product property is used. For instance, the first 2 letters of a category or a year of a manufacture date.
- Use fields of a product variant and product templates
- Apply any field of the types: char, integer, float, date and date with time, selection, and many2one.
- Rely upon any standard or custom fields (e.g. manufacturer or manufacture date)
- In case of many2one field (e.g. a related product category) you should select its field (for example, category name or category custom code)
- Use not the whole field value, but its part. For instance, apply first 2 letters (0-1) of a category name or only month of a manufacture date (5-7). Leave '0' in both start and end to retrieve the whole field value
Use product field values to generate auto references
Apply static code parts based on products filtering
Code rule with filtering by categories
Product automatic reference (example)
Automatic generation of codes
Product references are updated regularly.
For certain product templates and variants you can switch the auto update off. If you mark items as 'Manual reference': their codes will be not generated by rules. References become editable for such products and should be updated by users.
Codes are updated in the following cases:
- When a product is created or updated
- Regularly by the cron job for all products (have a look a the tab 'Configuration', the section 'Scheduled jobs')
- Manually when you push the button on a product form
- Manually for all products when you push the button on the configuration page
Why the logic is so complex? To avoid slowdowns. The point is that codes rules are advanced and there is no way to define recalculation triggers. Generating codes on fly would result in low performance. That is why to make sure codes are generated, Odoo regularly look over all products.
Exclude products from reference automatic updates
Coding relies upon standard Odoo tools
Codes are calculated in a current user language (cron jobs are done under Odoo SuperUser). Try to avoid using translated fields in codes generation.
Product coding is global: rules are applied to each company in the same way. Simultaneously, you can restrict products in rules by using filters by company.
The right to define product coding rules belongs only to Odoo administrators.
The module features and support depend on your Odoo version. Please select required one on the top right of this page.
We guarantee to provide a working plan by your issue within 5 days. The most of issues are solved within 2 business days.
You may like the tools
The tool to make inventory data essential and comfortable for elaboration€ 36
The tool to search, select and update product templates in batch€ 92
The tool to always know how much our production may promise€ 36
The tool to restrict users' access to stocks, locations and warehouse operations
The tool to restrict rights for create, edit and delete products€ 28
The tool to configure variant prices based on attributes coefficients and surpluses€ 96
The tool to build deep and structured knowledge base for internal and external use€ 228
The tool to automatically synchronize Odoo attachments with OwnCloud / NextCloud files in both ways€ 394
The tool to automatically synchronize Odoo attachments with Google Drive files in both ways€ 394