Product Dynamic Codes v.12

The tool to flexibly and automatically update product internal references

48€

The tool does not require extra dependencies beside standard Odoo apps.
Current version: 12.0.1.0.2

Enterprise
Community
Odoo.sh
As soon the app is installed, current products' references might be re-calculated
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.

Screenshots

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

Flexibly configure rules to combine a product internal reference

Product coding rules and settings

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.

How dynamic code parts work

  • 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

Screenshots

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

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.

When product references are updated

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.

Screenshots

Exclude products from reference automatic updates

Manual code for products

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.

Configuration and Installation Tips for Product Dynamic Codes Odoo v.12

Scheduled jobs

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'

Bug reporting

In case you have faced any bugs or inconsistent behavior, do not hesitate to contact us. We guarantee to provide fixes within 60 days after the purchase, while even after this period we are strongly interested to improve our tools.

No phone number or credit card is required to contact us: only a short email sign up which does not take more than 30 seconds.

Please include in your request as many details as possible: screenshots, Odoo server logs, a full description of how to reproduce your problem, and so on. Usually, it takes a few business days to prepare a working plan for an issue (if a bug is confirmed) or provide you with guidelines on what should be done (otherwise).

Public features requests and module ideas (free development)

We are strongly motivated to improve our tools and would be grateful for any sort of feedback. In case your requirements are of public use and might be efficiently implemented, the team would include those in our to-do list.

Such a to-do list is processed on a regular basis and does not assume extra fees. Although we cannot promise deadlines and final design, it might be a good way to get desired features without investments and risks.

No phone number or credit card is required to contact us: only a short email sign up which does not take more than 30 seconds.

You may also like the tools
Cloud Storage Solutions

The technical core to synchronize your cloud storage solution with Odoo

245€
KnowSystem: Knowledge Base System

The tool to build deep and structured knowledge base for internal and external use. Knowledge System. KMS

298€
OneDrive / SharePoint Odoo Integration

The tool to automatically synchronize Odoo attachments with OneDrive files in both ways

394€
Google Drive Odoo Integration

The tool to automatically synchronize Odoo attachments with Google Drive files in both ways

394€
Universal Appointments and Time Reservations

The tool for time-based service management from booking appointment to sale and reviews

398€ 358€
Product Management Interface

The tool to search, select and mass update product templates

148€
Advanced Variant Prices

The tool to configure variant prices based on attributes coefficients and surpluses

98€ 88€
Stock Demand Trends and Forecast

The tool to calculate stock demand trends and make prediction for future demand statistically. Stock Forecast

98€ 88€
Stocks by Locations

The tool to make inventory data essential and comfortable for elaboration

38€