Product Dynamic Codes

The tool to flexibly and automatically update product internal references

12.0 11.0

€ 78

The tool is compatible with both Odoo Enterprise and Odoo Community

The tool price includes all necessary dependencies

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.

As soon the app is installed, current products' references might be re-calculated

The tool allows users to 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 aluminum 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. Since services do not relate to any of named rules, this position in their references is just empty
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. Have a look at the section Dynamic Code Parts
Product references are updated automatically and regularly. Have a look at the section Automatic Updates of Product References
Product templates and variants might be marked as 'Manual reference'. If so, their codes will be not generated by code rules. References become editable for such products and should be updated manually
Codes are calculated in a current user language (cron jobs are done under Odoo SuperUser). Try to avoid using translated fields in codes generation
The right to define product coding rules belongs only to Odoo administrators
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

Feedback allows improving Odoo tools for you. If you tested the app, please leave a review on the product page

Dynamic Code Parts

  • 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

Automatic Updates of Product References

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.
Product reference is updated according to coding rules
Product automatic code example
Have as many code positions (parts) as required
Code position to make product reference
Use product field values to generate auto references
Product dynamic code (manufacturer example)
Apply static code parts based on products filtering
Static rules in product coding
Code rule with filtering by categories
Product category rule for references
Product automatic reference (example)
Example of auto product code update
Flexibly configure rules to combine a product internal reference
Product coding rules and settings
Exclude products from reference automatic updates
Manual code for products

Scheduled jobs

You may change the frequency of automatic references' updates. To this end:
  1. Turn on debug mode
  2. Go to technical settings > Automation > Scheduled jobs
  3. Find the job 'Construct Dynamic Codes'
To contact us please register in our support system. Registration form is available by any link below. Registration doesn't take more than 30 seconds. No phone number or credit card are required