| chat.freenode.net #tryton log beginning Wed Jan 2 00:00:01 CET 2019 | ||
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 23:45 | |
| -!- thaneor(~lenovo3@r179-24-159-243.dialup.adsl.anteldata.net.uy) has joined #tryton | 00:59 | |
| -!- yangoon1(~mathiasb@i59F4D8CF.versanet.de) has joined #tryton | 03:27 | |
| -!- thaneor(~lenovo3@r179-24-159-243.dialup.adsl.anteldata.net.uy) has joined #tryton | 03:48 | |
| -!- semarie(~semarie@unaffiliated/semarie) has joined #tryton | 07:09 | |
| -!- rpit(~rpit@p200300C88F26900010356F95BE8E2B88.dip0.t-ipconnect.de) has joined #tryton | 07:29 | |
| -!- JanGB(~jan@2a02:810a:143f:f822:63af:b5ef:1410:6c4c) has joined #tryton | 07:34 | |
| -!- JanGB(~jan@2a02:810a:143f:f822:63af:b5ef:1410:6c4c) has left #tryton | 07:34 | |
| -!- udono(~udono@105-140-067-156.ip-addr.inexio.net) has joined #tryton | 07:35 | |
| -!- thaneor1(~lenovo3@r179-25-165-143.dialup.adsl.anteldata.net.uy) has joined #tryton | 07:46 | |
| -!- tafelgeschirr(~tafelgesc@5.104.149.54) has joined #tryton | 08:30 | |
| -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton | 08:33 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 08:58 | |
| -!- nicoe(~nicoe@2a02:2788:54:1b6:7e2a:31ff:fe5e:b25d) has joined #tryton | 10:06 | |
| -!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton | 10:25 | |
| LordVan | hi | 10:26 |
|---|---|---|
| LordVan | i was wondering .. is it possible to copy attributes from one product to another? | 10:26 |
| LordVan | like if i have similar parts and want to save myself entering everything every time | 10:27 |
| cedk | LordVan: you can duplicate any record | 10:29 |
| LordVan | ah you mean just copy the product instead of trying to copy over just the attrivbutes? .. does make sense .. | 10:30 |
| LordVan | maybe a stupid question, but how do i dupplicate a record? | 10:30 |
| cedk | LordVan: on the form menu, there is a menu entry Duplicate | 10:31 |
| LordVan | ah yes there.. i was looking at the symbol bar .. | 10:32 |
| LordVan | thanks | 10:32 |
| LordVan | ah .. 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 |
| LordVan | cuz I have product DL74002-A01-03 (baed on a template with the same name) and want to create 04,05,... | 10:34 |
| LordVan | or am i getting the concept of product templates wrong here by making a template for each | 10:35 |
| LordVan | i get the feeling i am .. | 10:35 |
| cedk | LordVan: if you duplicate a template, it will duplicate all variants | 10:36 |
| LordVan | ah hadn't tried that | 10:45 |
| LordVan | thanks | 10:45 |
| LordVan | btw 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 |
| LordVan | like i intend to make a template for decoration items (candle holders, wind chimes,.. ) and then variants fro different sizes | 10:47 |
| LordVan | does 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 |
| cedk | LordVan: you must use variant only when they really share most of their attributes | 10:48 |
| LordVan | well they do all have the same sort of attributes but obv. different values | 10:49 |
| LordVan | i 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 |
| LordVan | but on the other hand making a template for each different sheet metal part is also not right .. hmm | 10:51 |
| LordVan | or 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 |
| cedk | LordVan: it is not really possible to answer, it depends on each case | 11:10 |
| cedk | LordVan: follow what you find is easier for you | 11:10 |
| -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton | 11:47 | |
| -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has left #tryton | 11:47 | |
| LordVan | cedk, yeah i will have a look at a few options .. i just really don't want to create templates and products for every little thing | 11:55 |
| cedk | LordVan: in the setup we have done, most of the time there is one template with one variant | 11:58 |
| LordVan | isn't that creating *a lot* of templates for no reason? i mean in our case we are talking easily tens of thousands | 11:59 |
| LordVan | probably even 100k | 11:59 |
| cedk | LordVan: it is not for no reason, they store data | 12:01 |
| LordVan | hmm | 12:09 |
| LordVan | yeah looking at it again .. | 12:10 |
| LordVan | there are fields (like measurements) that are only editable in the template not the actual variant | 12:10 |
| LordVan | and salable and the time to manufacturing | 12:11 |
| LordVan | / time to procure | 12:11 |
| LordVan | guess i do have to also create one template per product variant | 12:14 |
| csotelo | Hi 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 |
| csotelo | Hello? any suggest? | 12:52 |
| -!- rpit(~rpit@p5B22B44D.dip0.t-ipconnect.de) has joined #tryton | 12:57 | |
| csotelo | Hi 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 |
| csotelo | any suggest? | 13:21 |
| semarie | csotelo: just a guest. there is a table product_cost_price | 13:29 |
| csotelo | thanks | 13:30 |
| plaes | https://github.com/tryton/product/blob/develop/product.py#L66 | 13:30 |
| plaes | it's somewhat complicated | 13:30 |
| plaes | list_price vs cost_price | 13:30 |
| csotelo | semarie, no.. there is not | 13:31 |
| semarie | I have such table. but I doubt using sql level is right approch | 13:32 |
| csotelo | I need to update all list ṕrices with a formula | 13:33 |
| semarie | proteus script ? | 13:33 |
| csotelo | I need update the whole list prices with a formula | 13:33 |
| csotelo | any suggest? | 13:33 |
| csotelo | semarie, I have thought that but is too urgent to prepare a script | 13:34 |
| csotelo | I just need to do something like list_price = listprice / 1.18 | 13:34 |
| csotelo | sql is faster... | 13:34 |
| semarie | dump your db in a file (with pg_dump), and search for a know value | 13:35 |
| semarie | it could help to found the right table | 13:35 |
| csotelo | really? | 13:35 |
| csotelo | OMG | 13:36 |
| cedk | csotelo: use price list | 14:16 |
| csotelo | cedk, yes, but, there is a batch mode? | 14:53 |
| csotelo | finally I do that on a proteus script | 14:53 |
| csotelo | however, I guess it could be faster on an sql sentence | 14:54 |
| cedk | csotelo: I mean the product_price_list module | 15:05 |
| csotelo | I see | 15:05 |
| LordVan | is there some way to bulk-assign things like product category and/or attributes from the list view btw? | 15:27 |
| cedk | LordVan: no | 16:10 |
| cedk | LordVan: but for category, adding a many2many on category should allow to select multiple products to add | 16:11 |
| cedk | I think it will be a good addition | 16:11 |
| LordVan | yes that would indeed | 16:38 |
| LordVan | cedk, want me to add an issue to the tracker? | 16:40 |
| cedk | LordVan: why not | 16:41 |
| LordVan | gonna do that then ;) | 16:41 |
| LordVan | cedk, https://bugs.tryton.org/issue7961?@template=item&@pagesize=50&@startwith=0 i worded it rather generally .. is it clear what i mean? | 16:46 |
| LordVan | hmm 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 seperately | 16:48 |
| cedk | LordVan: I think this is too specific | 17:05 |
| LordVan | yes | 17:05 |
| LordVan | but i found a different solution for that already it is fine | 17:05 |
| LordVan | I 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 |
| cedk | LordVan: searching on Dict values will require https://bugs.tryton.org/issue7905 | 17:10 |
| LordVan | cedk, 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 |
| LordVan | ah gtg .. i shall be back tomorrow | 17:20 |
| LordVan | thanks & cya | 17:20 |
| -!- thaneor(~lenovo3@r179-25-160-128.dialup.adsl.anteldata.net.uy) has joined #tryton | 19:48 | |
| -!- semarie(~semarie@unaffiliated/semarie) has joined #tryton | 21:01 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 21:26 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!