hmmm... in a complex system like OFBiz there are so many configuration constraints (even spanning data on different tables) that we will always need to enforce them at the business layer: I don't see a big value in adding this constraint at the db layer. We should instead, in my opinion, implement this constraint in the services that are responsible for the creation and update of the information in the ProductStore
Jacopo On Nov 27, 2014, at 3:38 PM, Jacques Le Roux <[email protected]> wrote: > Even though it makes sense, we could maybe add a constraint for that in DB. > > Unfortunately I don't think this possibility already exists in OFBiz and it > depends on DBMS > http://www.w3schools.com/sql/sql_check.asp > <<If you define a CHECK constraint on a table it can limit the values in > certain columns based on values in other columns in the row.>> > We could create a Jira and fill the gap when we get a chance, opinions? > > Jacques > > Le 27/11/2014 14:51, Hoan dang van a écrit : >> Thanks Divesh Dutta very much >> I have just done follow you and system run as I like >> >> >> On Thu, Nov 27, 2014 at 7:39 PM, Divesh Dutta <[email protected]> >> wrote: >> >>> Hi Hoan dang van, >>> >>> isImmediatelyFulfilled and reserveInvetory flags are mutually exclusive, >>> i.e if isImmediatelyFulfilled is set to "Y" then reserveInventory should >>> always set to "N" and vice versa. So for web stores/e-commerce stores >>> settings should be : >>> >>> isImmediatelyFulfilled = N >>> >>> reserveInventory = Y >>> >>> Other warehouse settings for web store are given here: >>> >>> http://www.hotwaxmedia.com/apache-ofbiz-blog/diy-configure-ofbiz-warehouse-management/ >>> >>> >>> >>> and for POS stores: >>> >>> isImmediatelyFulfilled = Y >>> >>> reserveInventory = N >>> >>> requireInventory = System avoids this field when reserveInventory = "N". So >>> you can leave it empty or set it to N. >>> >>> Items should be immediately issued, skipping reservation process of system. >>> So ideally, once order is placed it should be marked completed >>> automatically. >>> >>> >>> Thanks >>> >>> -- >>> >>> Divesh Dutta. >>> >>> >>> >>> On Thu, Nov 27, 2014 at 4:08 PM, Hoan dang van <[email protected]> wrote: >>> >>>> Hi Rishi Solanki >>>> Yes, I'm using OFBIZ trunk. This is my product store xml >>>> However, when I completed order form webpos component (status of order is >>>> completed), the quantity of items which I had bought before is imported >>>> into " Ordered", instead of "Ship request". >>>> >>>> >>>> >>>> On Wed, Nov 26, 2014 at 5:34 PM, Rishi Solanki <[email protected]> >>>> wrote: >>>> >>>>> Hoan dang van, >>>>> >>>>> As requested on original ticket where you shared this problem, could you >>>>> please share the complete product store xml data you have setup. It will >>>>> help us to diagnose the problem you are facing. I'm assuming you are >>> using >>>>> 13.07 or trunk to setup your store. >>>>> >>>>> Best Regards, >>>>> >>>>> Rishi Solanki >>>>> Manager, Enterprise Software Development >>>>> HotWax Media Pvt. Ltd. >>>>> Direct: +91-9893287847 >>>>> http://www.hotwaxmedia.com >>>>> >>>>> On Tue, Nov 25, 2014 at 1:01 PM, Hoan dang van <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi Scott Gray! >>>>>> I have set up reserve inventory is Y. >>>>>> >>>>>> >>>>>> >>>>>> On Tue, Nov 25, 2014 at 1:23 PM, Scott Gray < >>> [email protected] >>>>>> wrote: >>>>>> >>>>>>> Is your store configured to reserve inventory? It's that setting >>> that >>>>>>> causes reservations to be created which in turn to decreases ATP >>>>>>> >>>>>>> Regards >>>>>>> Scott >>>>>>> >>>>>>> On Tue, Nov 25, 2014 at 6:05 PM, Hoan dang van <[email protected]> >>>>>> wrote: >>>>>>>> When I configure store in catalog component and i selected Is >>>>>>> Immediately >>>>>>>> Fulfilled Tab is N then i create a order by webpos. The order is >>>>>>> completed >>>>>>>> but when i check this order in order, i appear that the product >>>>> that i >>>>>>> buy, >>>>>>>> have Qty Shipped status is 0 and Ship Request status is 2 (2 is >>>>>> quantity >>>>>>>> that i bought in this order) >>>>>>>> >>>>>>>> When i selected again Is Immediately Fulfilled Tab is Y , Qty >>>>> Shipped >>>>>>>> status is 2 and Ship Request status is 0. Then i create a order by >>>>>> order >>>>>>>> component , Order is created but ATP of product that i bought with >>>>> this >>>>>>>> order, not automatic decrease (equal before i bought ) >>>>>>>> >>>>>>>> Can everybody tell me where i do wrong and how to fix it >>>>>>>> >>>>>>>> Thanks >>>>
