Tryton - Issues

 

Message55508

Author ced
Recipients
Date 2020-02-21.14:44:24
Content
Following https://discuss.tryton.org/t/sql-query-to-compute-sku-for-template/2352

Having a code on template is useful to get a SKU for web shop that display variant as a single product (see issue9010).
My proposal is to add a prefix_code on template and a suffix_code on variant and to keep up to date the field code with the concatenation of both codes.
This design allow to have both codes stored in the database in the proper table which can have an index for searching.
Another option would have been to use a Function field that concatenate both codes but this means that we need to join the both table when doing a search which may not be very efficient with a lot of variants.
History
Date User Action Args
2020-02-21 14:44:25cedsetmessageid: <1582292665.8.0.420879806303.issue9080@tryton.org>
2020-02-21 14:44:25cedlinkissue9080 messages
2020-02-21 14:44:24cedcreate

Showing 10 items. Show all history (warning: this could be VERY long)