I still need clearer brand guidelines

I still didn’t get any answer about that

So for now every time I need to specify brand, I write all possible options, which doesn’t look as health practice. But until brands and stores don’t have separate entities in OFF DB, I don’t see any other option to in other proper way.

  • זול סטוק - Hebrew brand name
  • Zolstock - Same brand name, but in English
  • Z.School - Subbrand of Zolstock for school products such as pens, pencils etc
  • Z.School by Zolstock (one of options given in OFF app)

If it would be use relational DB, it could be something like:

Table “brands”

brand_id main_brand_name
111 זול סטוק
112 Z.School

Table “brand_aliases”

brand_alias_id brand_id xxx_lang_code alias alias_type
34 111 eng Zolstock legal name, name on packaging, translated_name, informal name etc.

Table “brand_relationships”

brand_rel_pair_id brand_id brand_id_1 relationship_id
1 111 (Zolstock) 112 (Z.School) 23 (111 ‘Zolstock’ owns brand 112 ‘Z.School’)

It would allow also to link products with their exact brand and not link them just to approximate brand names, that in fact can be owned to different brands.