IRC logs of #tryton for Friday, 2012-03-30 #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@ 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:
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@ has left #tryton
2012-03-30 16:45 -!- verneda( 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 2.17.3 by Marius Gedminas - find it at!