| chat.freenode.net #tryton log beginning Fri Mar 30 00:00:01 CEST 2012 | ||
| 2012-03-30 00:18 <albertca> jcm: do you mean sale price or cost price? | ||
| 2012-03-30 00:18 <jcm> sale | ||
| 2012-03-30 00:23 <albertca> jcm: ok, I don't think there's anything like that | ||
| 2012-03-30 10:58 <sisalp> hello, | ||
| 2012-03-30 10:58 <sisalp> I wish to replicate products between two trytons | ||
| 2012-03-30 10:59 <sisalp> I mean one is "master" and creates the products | ||
| 2012-03-30 10:59 <sisalp> the other one is "slave" and updates products from the "master" | ||
| 2012-03-30 11:00 <sisalp> What would you suggest for this ? | ||
| 2012-03-30 11:00 <cedk> sisalp: why not use the multi-company? | ||
| 2012-03-30 11:02 <sisalp> it is a possibility, but it is a complex solution for a simple requirement at first glance | ||
| 2012-03-30 11:06 <sisalp> I know about two other alternatives : an external script and sharoon showed a mongodb replication in November | ||
| 2012-03-30 11:07 <sisalp> cedk: did someone succed in configuring a multicompany solution ? | ||
| 2012-03-30 11:07 <cedk> sisalp: replace the product tables by external table in postgresql | ||
| 2012-03-30 11:08 -!- silent82lion90(~quassel@123.20.245.75) has left #tryton | ||
| 2012-03-30 11:09 <sisalp> cedk: I understand I can either "synchronize" or "share" | ||
| 2012-03-30 11:09 <sisalp> cedk: share is real time, synchronize is better over long distance | ||
| 2012-03-30 11:10 <cedk> sisalp: long distance is quite reltive | ||
| 2012-03-30 11:11 <cedk> sisalp: sync has always the issue to resolve conflict | ||
| 2012-03-30 11:12 <sisalp> cedk: conflict : correct. the assumption is that the sync is made in a single direction | ||
| 2012-03-30 11:12 <sisalp> cedk: distance may matter in this case | ||
| 2012-03-30 11:13 <cedk> sisalp: even with single direction you can have conflict | ||
| 2012-03-30 11:13 <sisalp> cedk: there are place in switzerland where hosting is too slow for intensive use and they prefer a local server | ||
| 2012-03-30 11:14 <sisalp> cedk: other companies are in France and Hong-Kong | ||
| 2012-03-30 11:15 <sisalp> cedk: nevertheless, today they support bad performance on a multi-company centralized solution | ||
| 2012-03-30 11:16 <sisalp> cedk: single dir and conflict : ?? | ||
| 2012-03-30 11:18 <cedk> sisalp: it is possible because you sync relational data with constraint | ||
| 2012-03-30 11:18 <cedk> sisalp: it can happen when you got offline for some time | ||
| 2012-03-30 11:19 <sisalp> cedk: agrre, even if unlikely in this case, solution must consider the case | ||
| 2012-03-30 11:23 <cedk> sisalp: perhaps: https://code.google.com/p/golconde/ | ||
| 2012-03-30 11:24 <cedk> sisalp: also simple case that fails: delete a product in the main database | ||
| 2012-03-30 11:24 <cedk> sisalp: it succeed on main because nothing use it | ||
| 2012-03-30 11:25 <cedk> sisalp: it fails on the slave because it was used | ||
| 2012-03-30 11:26 <cedk> sisalp: indeed why did they want to share products? | ||
| 2012-03-30 11:28 <sisalp> cedk: subsidiaries sale main company products on their geographies | ||
| 2012-03-30 11:33 <cedk> sisalp: so I think it is more a business sync that needs to be done | ||
| 2012-03-30 11:33 <cedk> sisalp: by product code for example | ||
| 2012-03-30 11:34 <sisalp> cedk: business synch ? | ||
| 2012-03-30 11:34 <cedk> sisalp: and even not from an other tryton server but a shared product catalog | ||
| 2012-03-30 11:34 <cedk> sisalp: business synch = not a table replication | ||
| 2012-03-30 11:35 <sisalp> cedk: shared product catalog is made in tryton | ||
| 2012-03-30 11:36 <sisalp> cedk: "not a table replication", I favor this direction at first | ||
| 2012-03-30 11:37 <cedk> sisalp: which product properties did they share? | ||
| 2012-03-30 11:38 <sisalp> cedk: I'm not clear about what properties are | ||
| 2012-03-30 11:39 <sisalp> cedk: accounting properties are completly separate | ||
| 2012-03-30 11:39 <cedk> sisalp: that's the first thing to define | ||
| 2012-03-30 11:40 <cedk> sisalp: also when is a new product shared? | ||
| 2012-03-30 11:40 <sisalp> cedk: always | ||
| 2012-03-30 11:40 <cedk> sisalp: because it could be just that user create the product and set a code that will be used to fecth some properties | ||
| 2012-03-30 11:41 <cedk> sisalp: when = always, always is not a time but a duration | ||
| 2012-03-30 11:42 <sisalp> cedk: I meant always = all products, everytime, everywhere | ||
| 2012-03-30 11:42 <sisalp> cedk: where can I find the list of properties of a product ? | ||
| 2012-03-30 11:43 <cedk> sisalp: it depend on which modules are installed | ||
| 2012-03-30 11:43 <cedk> sisalp: otherwise it is in Administration>Models>Models | ||
| 2012-03-30 11:46 <sisalp> cedk: checked in Administration>Models>Properties of you demo2.2 database | ||
| 2012-03-30 11:47 <sisalp> cedk: none of these properties can be shared iiuc | ||
| 2012-03-30 11:47 <cedk> sisalp: indeed, I think most of the time it is just a code and a name | ||
| 2012-03-30 11:47 <sisalp> each company has its own account chart and rules | ||
| 2012-03-30 11:49 <sisalp> cedk: a code and a name + product features (size, packaging...) | ||
| 2012-03-30 11:51 <sisalp> cedk: there will be also extra complexity which is not to be discussed here, but a generic requirement is to share stock levels in other companies | ||
| 2012-03-30 11:52 <sisalp> cedk: I sell from my stock, if I don't have I purchase from another company of the group, if there is still not enough, I purchase from outside | ||
| 2012-03-30 11:56 <cedk> sisalp: so there is not one prefered supplier? | ||
| 2012-03-30 11:57 <cedk> sisalp: but I guess it can be done when the purchase request is created, it could queries other servers to see if there is in stock | ||
| 2012-03-30 11:57 <cedk> sisalp: I don't think it is a big deal | ||
| 2012-03-30 11:58 <sisalp> cedk: in practice one company holds most of the stocks | ||
| 2012-03-30 12:00 <sisalp> cedk: sales are stock driven for sale subsidiaries : they are in charge of sellin what is in stock somewehere in the group, nothing else | ||
| 2012-03-30 12:00 <cedk> sisalp: ok but could it be that it is always this one that buy by default | ||
| 2012-03-30 12:00 <sisalp> cedk: but I think this is special to that business | ||
| 2012-03-30 12:01 <sisalp> cedk: no, several companies buy | ||
| 2012-03-30 12:01 <sisalp> cedk: they buy differently when they buy outside | ||
| 2012-03-30 12:03 <sisalp> cedk: switzerland buys from wholesalers, while france buys from producers (at better conditions) | ||
| 2012-03-30 12:03 <sisalp> cedk: switzerland is the main company, france is the company which creates products from everybody | ||
| 2012-03-30 12:03 <cedk> sisalp: ok so it could be done as I said but this will not prevent some cases where it buys to inhouse company and this one has sale just before | ||
| 2012-03-30 12:05 <sisalp> cedk: this may happen of course. It already happen today. In this case an extra purchase will be done. Same if product gets broken. | ||
| 2012-03-30 12:07 <sisalp> cedk: they use a specific process to reserve products. | ||
| 2012-03-30 12:10 <sisalp> cedk: 1-customer orders, 2-customer is billed and goods are reserved, 3-customer pays and goods are shipped, 4- if customer doesn't pay, goods are unreserved | ||
| 2012-03-30 12:10 <cedk> sisalp: what do you mean by reserved? | ||
| 2012-03-30 12:11 <cedk> sisalp: is it that nobody else can take or that they try to have the quantity in stock? | ||
| 2012-03-30 12:11 <sisalp> cedk: nobody else can take | ||
| 2012-03-30 12:12 <sisalp> cedk: it leads to extra inventory, but they cannot afford to bill and not be able to deliver | ||
| 2012-03-30 12:14 <sisalp> cedk: there are specifics in this case, but based on a generic relationship between wholesalers and retaillers | ||
| 2012-03-30 12:15 <sisalp> nobody here has a similar case ? | ||
| 2012-03-30 12:22 <cedk> sisalp: and what happens in case the product can not be reserved when billing? | ||
| 2012-03-30 12:25 <sisalp> cedk : 2- goods are reserved and customer is billed solves the case | ||
| 2012-03-30 12:28 <cedk> sisalp: yeps :-) | ||
| 2012-03-30 15:33 -!- Mayank(~mayank@122.162.51.50) has left #tryton | ||
| 2012-03-30 16:45 -!- verneda(~verneda@169.99.79.188.dynamic.jazztel.es) has left #tryton | ||
| 2012-03-30 19:57 <sisalp> hello, iirc, there was a discussion about modules dependencies to avoid to create extra modules just in case of module combinations | ||
| 2012-03-30 19:59 <sisalp> for ex: carrier adds a product and sale_analytic adds an analytic account requirement, so we should define a carrier_sale_analytic so carrier fills this account up | ||
| 2012-03-30 19:59 <sisalp> do you remember what was told about it , | ||
| 2012-03-30 22:50 <zodman> dudes exist a repo por proteus.js ? |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!