But the question still remain unanswered is how do I increase the inventory for a product? Is it possible to do from catalog/store?if yes, then how?
another thing I did observe is that when I place an order for a product A(suppose) with a particular user name more than I record got populated in the INVENTORY_ITEM and INVENTORY_ITEM_DETAIL table. If I do a checkout again for that same product with the same user name and password more then one records are inserted but is not same for the earlier case. As this continues for a long time during the check out process lots of record get populated and add to the performance over head. Is there any way to check the insertion of the records into the table? or an event that can be commented in the code? I want to stop the query (SELECT INVENTORY_ITEM_ID, INVENTORY_ITEM_TYPE_ID, PRODUCT_ID, PARTY_ID, OWNER_PARTY_ID, STATUS_ID, DATETIME_RECEIVED, DATETIME_MANUFACTURED, EXPIRE_DATE, FACILITY_ID, CONTAINER_ID, LOT_ID, UOM_ID, BIN_NUMBER, LOCATION_SEQ_ID, COMMENTS, QUANTITY_ON_HAND_TOTAL, AVAILABLE_TO_PROMISE_TOTAL, QUANTITY_ON_HAND, AVAILABLE_TO_PROMISE, SERIAL_NUMBER, SOFT_IDENTIFIER, ACTIVATION_NUMBER, ACTIVATION_VALID_THRU, UNIT_COST, CURRENCY_UOM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM INVENTORY_ITEM WHERE (PRODUCT_ID = ? AND FACILITY_ID = ?) to fire. This query occurs when checkout of a product is done many times, which should not happen. -- View this message in context: http://ofbiz.135035.n4.nabble.com/How-to-create-inventory-for-a-product-tp3033600p3035847.html Sent from the OFBiz - User mailing list archive at Nabble.com.
