IRC logs of #tryton for Wednesday, 2019-01-02 #tryton log beginning Wed Jan 2 00:00:01 CET 2019
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton23:45
-!- thaneor( has joined #tryton00:59
-!- yangoon1( has joined #tryton03:27
-!- thaneor( has joined #tryton03:48
-!- semarie(~semarie@unaffiliated/semarie) has joined #tryton07:09
-!- rpit( has joined #tryton07:29
-!- JanGB(~jan@2a02:810a:143f:f822:63af:b5ef:1410:6c4c) has joined #tryton07:34
-!- JanGB(~jan@2a02:810a:143f:f822:63af:b5ef:1410:6c4c) has left #tryton07:34
-!- udono( has joined #tryton07:35
-!- thaneor1( has joined #tryton07:46
-!- tafelgeschirr(~tafelgesc@ has joined #tryton08:30
-!- Timitos( has joined #tryton08:33
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton08:58
-!- nicoe(~nicoe@2a02:2788:54:1b6:7e2a:31ff:fe5e:b25d) has joined #tryton10:06
-!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton10:25
LordVani was wondering .. is it possible to copy attributes from one product to another?10:26
LordVanlike if i have similar parts and want to save myself entering everything every time10:27
cedkLordVan: you can duplicate any record10:29
LordVanah you mean just copy the product instead of trying to copy over just the attrivbutes? .. does make sense ..10:30
LordVanmaybe a stupid question, but how do i dupplicate a record?10:30
cedkLordVan: on the form menu, there is a menu entry Duplicate10:31
LordVanah yes there.. i was looking at the symbol bar ..10:32
LordVanah .. i'd have to copy both the product and the product template though - or is there a way to do both at once?10:33
LordVancuz I have product DL74002-A01-03 (baed on a template with the same name) and want to create 04,05,...10:34
LordVanor am i getting the concept of product templates wrong here by making a template for each10:35
LordVani get the feeling i am ..10:35
cedkLordVan: if you duplicate a template, it will duplicate all variants10:36
LordVanah hadn't tried that10:45
LordVanbtw can i get your opinion on how i think i will use product templates and products?10:46
LordVan(i don't want to mess it up from the start)10:46
LordVanlike i intend to make a template for decoration items (candle holders, wind chimes,.. ) and then variants fro different sizes10:47
LordVandoes it (from a system point of view) make sense to make a template for each, or would it make more sense (the tryton way) to just create one template called "decoration"10:48
cedkLordVan: you must use variant only when they really share most of their attributes10:48
LordVanwell they do all have the same sort of attributes but obv. different values10:49
LordVani mean just about all the parts we make are sheet metal cut, bent, soldered, painted,.. but one template for all of that seems a bit ..10:51
LordVanbut on the other hand making a template for each different sheet metal part is also not right .. hmm10:51
LordVanor does it make sense (in a tryton way) to really only have one template for "sheet metal part" and then variants for all the different ones?10:57
cedkLordVan: it is not really possible to answer, it depends on each case11:10
cedkLordVan: follow what you find is easier for you11:10
-!- Telesight( has joined #tryton11:47
-!- Telesight( has left #tryton11:47
LordVancedk, yeah i will have a look at a few options .. i just really don't want to create templates and products for every little thing11:55
cedkLordVan: in the setup we have done, most of the time there is one template with one variant11:58
LordVanisn't that creating *a lot* of templates for no reason? i mean in our case we are talking easily tens of thousands11:59
LordVanprobably even 100k11:59
cedkLordVan: it is not for no reason, they store data12:01
LordVanyeah looking at it again ..12:10
LordVanthere are fields (like measurements) that are only editable in the template not the actual variant12:10
LordVanand salable and the time to manufacturing12:11
LordVan / time to procure12:11
LordVanguess i do have to also create one template per product variant12:14
csoteloHi all, I was looking for the place where product prices are stored and I have noticed is not product_template, could you help me on now wich one is this table for product_prices ?12:41
csoteloHello? any suggest?12:52
-!- rpit( has joined #tryton12:57
csoteloHi all, I was looking for the place where product prices are stored and I have noticed is not product_template, could you help me on now wich one is this table for product_prices ?13:21
csoteloany suggest?13:21
semariecsotelo: just a guest. there is a table product_cost_price13:29
plaesit's somewhat complicated13:30
plaeslist_price vs cost_price13:30
csotelosemarie, no.. there is not13:31
semarieI have such table. but I doubt using sql level is right approch13:32
csoteloI need to update all list ṕrices with a formula13:33
semarieproteus script ?13:33
csoteloI need update the whole list prices with a formula13:33
csoteloany suggest?13:33
csotelosemarie, I have thought that but is too urgent to prepare a script13:34
csoteloI just need to do something like list_price = listprice / 1.1813:34
csotelosql is faster...13:34
semariedump your db in a file (with pg_dump), and search for a know value13:35
semarieit could help to found the right table13:35
cedkcsotelo: use price list14:16
csotelocedk, yes, but, there is a batch mode?14:53
csotelofinally I do that on a proteus script14:53
csotelohowever, I guess it could be faster on an sql sentence14:54
cedkcsotelo: I mean the product_price_list module15:05
csoteloI see15:05
LordVanis there some way to bulk-assign things like product category and/or attributes from the list view btw?15:27
cedkLordVan: no16:10
cedkLordVan: but for category, adding a many2many on category should allow to select multiple products to add16:11
cedkI think it will be a good addition16:11
LordVanyes that would indeed16:38
LordVancedk, want me to add an issue to the tracker?16:40
cedkLordVan: why not16:41
LordVangonna do that then ;)16:41
LordVancedk, i worded it rather generally .. is it clear what i mean?16:46
LordVanhmm is it possible to create some sort of "link" between 2 products? (i want them in there seperate, but they are 99% of the time made at the same time so some report i want to generate can be one page for both of them instead of seperately16:48
cedkLordVan: I think this is too specific17:05
LordVanbut i found a different solution for that already it is fine17:05
LordVanI think i will also have to extend the search on the products to let me search for specific attributes too (unless that can be done somehow already)17:10
cedkLordVan: searching on Dict values will require
LordVancedk, ah so it is currently not possible? i have to admit i am not sure by looking at the bug how far along to finished it is ?17:17
LordVanah gtg .. i shall be back tomorrow17:20
LordVanthanks & cya17:20
-!- thaneor( has joined #tryton19:48
-!- semarie(~semarie@unaffiliated/semarie) has joined #tryton21:01
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton21:26

Generated by 2.17.3 by Marius Gedminas - find it at!