|
Home > Archive > WebSphere Commerce suite > May 2006 > Can't use inventory
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can't use inventory
|
|
|
| Hello,
I want to show, in the main store page, if the product is currently in the inventory or not.
I thought that the inventory was handled in the INVENTORY table, but it seems that each row have a "9999.0" quantity and a "2" inventoryflag.
The other problem is that my Websphere Commerce configuration doesn't seems to manage inventory: a client is allowed to purshase an item, even if no one is allocated.
Anyone got a clue?
| |
|
| Check the Store's table defination, by default commerce goes for ATP Inventory. In order to use Inventory table, change the allocationgoodfor column in stores table to 0, and inventory flags for the catentries in INVENTORY table to 0 instead of 2.
Try this.
| |
|
| Thanks for your help.
The STORE's ALLOCATIONGOODFOR column was already to "0".
I tried to change the inventory flag to 0, but nothing changed: when I buy a product, quantity keep its value, and every new product have a "2" inventory flag .
Maybe the product quantity is somewhere else in the database ?
| |
|
| Now, I can calculate if a product is available or not. Everything works great with ConsumerDirect sample products.
The last problem is that I don't know how to create a new product with an inventory. I thought that the "Track inventory" option in the Fulfillment section handles that, but whatever I enable in this page, nothing changes.
| |
|
| If ALLOCATIONGOODFOR column is having 0 value, Commerce ATP inventory will not be used. You also need to update your orderitemadd and orderitemupdate forms (jsps where these actions are called) not to pass ATP parameters (merge,remerge,check,allocate etc)
Once ALLOCATIONGOODFOR column is 0, commerce starts using INVENTORY table to track the product inventory. If you create products from Accelerator by default it sets the quantity value to 9999 and inventoryflags to 2 in INVENTORY table. If you create produ
cts using massload then you can change those values to be what you want them to be.
At the time of adding and updating items in shoppingcart OrderItemAdd and OrderItemUpdate will call checkInventorycmd to make sure the quantity that user requested is available (it looks at quantity column in INVENTORY table).
Once the order is submitted Orderprocess command calls UpdateInventoryCmd to reduce the quantity of the item that was purchased from the quantity value in INVENTORY table.
You need to keep monitoring the quantity value to maintain your inventory levels.
|
|
|
|
|