How to set the quantity of product available to the store?
Locked
How to set the quantity of product available to the store?
 
|
Hi,
a very basic question... What is the right way to change the available quantity of a product? I have set the store "require inventory" flag to Y so that now "out of stock" message is displayed in the product ecommerce page (and I like this). But how to let ofbiz know that I have pieces available to be sold? Many thanks, -Bruno |
Re: How to set the quantity of product available to the store?
|
|
I am trying to create a new invetory item but ofbiz says:
The Following Errors Occurred: ERROR: Could not complete the Update an InventoryItem [file:/F:/ofbiz/applications/product/script/org/ofbiz/product/inventory/InventoryServices.xml#updateInventoryItem] process [env variable for value-name lookedUpValue is not a GenericValue object; for the relation-name: Facility] Am I missing something? -Bruno 2008/4/16, Bruno Busco <[hidden email]>: > > Hi, > a very basic question... > > What is the right way to change the available quantity of a product? > I have set the store "require inventory" flag to Y so that now "out of > stock" message is displayed in the product ecommerce page (and I like this). > But how to let ofbiz know that I have pieces available to be sold? > > Many thanks, > > -Bruno > > > > |
Re: How to set the quantity of product available to the store?
|
|
Sorry for the error reporting, this has disappeared after a ant
run-install... Now I have created an Inventory Item, then I selected the Inventory Item and using the " Physical Inventory Variances" have set a "Quantity On Hand Var" to 1000. Now, looking at the Inventory Items list I see the created one with 0/1000 in the transfer column but still nothing in the "Quality On Hand Total" and so the product results still "out of stock". What I need to do now to have the 1000 items available? Thanks, Bruno 2008/4/16, Bruno Busco <[hidden email]>: > > I am trying to create a new invetory item but ofbiz says: > > The Following Errors Occurred: > > ERROR: Could not complete the Update an InventoryItem > [file:/F:/ofbiz/applications/product/script/org/ofbiz/product/inventory/InventoryServices.xml#updateInventoryItem] > process [env variable for value-name lookedUpValue is not a GenericValue > object; for the relation-name: Facility] > > Am I missing something? > > -Bruno > > > 2008/4/16, Bruno Busco <[hidden email]>: > > > > Hi, > > a very basic question... > > > > What is the right way to change the available quantity of a product? > > I have set the store "require inventory" flag to Y so that now "out of > > stock" message is displayed in the product ecommerce page (and I like this). > > But how to let ofbiz know that I have pieces available to be sold? > > > > Many thanks, > > > > -Bruno > > > > > > > > > |
|
|
In reply to this post by Bruno Busco
Bruno
For me, I imported the existing inventory data and with it came the onhand amounts. If your not importing data, you can create a purchase order and receive it. You could also manually modify InventoryItem record(s) but thats a pain if you have lots to do and you loose the InventoryItemDetail. Skip -----Original Message----- From: Bruno Busco [mailto:[hidden email]] Sent: Wednesday, April 16, 2008 1:02 PM To: [hidden email] Subject: How to set the quantity of product available to the store? Hi, a very basic question... What is the right way to change the available quantity of a product? I have set the store "require inventory" flag to Y so that now "out of stock" message is displayed in the product ecommerce page (and I like this). But how to let ofbiz know that I have pieces available to be sold? Many thanks, -Bruno No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: 4/14/2008 9:26 AM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: 4/14/2008 9:26 AM |
Re: How to set the quantity of product available to the store?
|
|
Skip,
I have imported the demo inventory data, I am fine with them but I would like to understand what is the normal way to change the available inventory amount in ofbiz so that they are available to the eshop. Is the purchase order you suggest the "regular" way to change available amounts in inventory? (apart of the manual changing of the records) -Bruno 2008/4/17, skip@thedevers <[hidden email]>: > > Bruno > > For me, I imported the existing inventory data and with it came the onhand > amounts. If your not importing data, you can create a purchase order and > receive it. You could also manually modify InventoryItem record(s) but > thats a pain if you have lots to do and you loose the InventoryItemDetail. > > Skip > > > -----Original Message----- > From: Bruno Busco [mailto:[hidden email]] > Sent: Wednesday, April 16, 2008 1:02 PM > To: [hidden email] > Subject: How to set the quantity of product available to the store? > > > Hi, > a very basic question... > > What is the right way to change the available quantity of a product? > I have set the store "require inventory" flag to Y so that now "out of > stock" message is displayed in the product ecommerce page (and I like > this). > But how to let ofbiz know that I have pieces available to be sold? > > Many thanks, > > -Bruno > > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > 4/14/2008 > 9:26 AM > > No virus found in this outgoing message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > 4/14/2008 > 9:26 AM > > |
Re: How to set the quantity of product available to the store?
Administrator
|
Yes these are 2 ways to increase stocks. You could also try to use Inventory Xfers, Stock moves and mostly Physical Inventoy
Jacques From: "Bruno Busco" <[hidden email]> > Skip, > I have imported the demo inventory data, I am fine with them but I would > like to understand what is the normal way to change the available inventory > amount in ofbiz so that they are available to the eshop. > Is the purchase order you suggest the "regular" way to change available > amounts in inventory? > > (apart of the manual changing of the records) > > -Bruno > > > 2008/4/17, skip@thedevers <[hidden email]>: >> >> Bruno >> >> For me, I imported the existing inventory data and with it came the onhand >> amounts. If your not importing data, you can create a purchase order and >> receive it. You could also manually modify InventoryItem record(s) but >> thats a pain if you have lots to do and you loose the InventoryItemDetail. >> >> Skip >> >> >> -----Original Message----- >> From: Bruno Busco [mailto:[hidden email]] >> Sent: Wednesday, April 16, 2008 1:02 PM >> To: [hidden email] >> Subject: How to set the quantity of product available to the store? >> >> >> Hi, >> a very basic question... >> >> What is the right way to change the available quantity of a product? >> I have set the store "require inventory" flag to Y so that now "out of >> stock" message is displayed in the product ecommerce page (and I like >> this). >> But how to let ofbiz know that I have pieces available to be sold? >> >> Many thanks, >> >> -Bruno >> >> >> No virus found in this incoming message. >> Checked by AVG. >> Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: >> 4/14/2008 >> 9:26 AM >> >> No virus found in this outgoing message. >> Checked by AVG. >> Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: >> 4/14/2008 >> 9:26 AM >> >> > |
|
|
In reply to this post by Bruno Busco
Bruno
I guess "regular" is in the eye of the beholder. For my clients, the "regular" way was to import their existing inventory. As it was sold, more was purchased. When it was purchased, a second (or third) InventoryItem record was created increasing the quantity on hand. (At some point, I am going to modify that code so that new InventoryItem records are not created if the cost and supplier are the same.) Doing it this way keeps an audit trail. I NEVER allow the users to manually adjust inventory. There is a single person responsible for figuring out and correcting why ATP/OH != physical counts. The normal process for them is to write a purchase order and email/send it to the supplier. They then ship the goods. When the goods are received, the shipping clerk receives the purchase order, modifying the quantities as needed. This creates an invoice for Accounts Payable, handles the GL details and increases the quantity on hand that can then be sold. Unlike like you, I have "require inventory" flag to N. My users (sales clerks as they don't currently have an ecommerce site) can then sell an item and have a backorder (actually a requirement) automatically generated. The purchasing agent then generates orders from the backorder requirements. I have spent two months modifying this purchasing/backorder code heavily, so I don't fully remember how it worked before, but I think this is standard behavior OOTB. Skip -----Original Message----- From: Bruno Busco [mailto:[hidden email]] Sent: Wednesday, April 16, 2008 3:37 PM To: [hidden email] Subject: Re: How to set the quantity of product available to the store? Skip, I have imported the demo inventory data, I am fine with them but I would like to understand what is the normal way to change the available inventory amount in ofbiz so that they are available to the eshop. Is the purchase order you suggest the "regular" way to change available amounts in inventory? (apart of the manual changing of the records) -Bruno 2008/4/17, skip@thedevers <[hidden email]>: > > Bruno > > For me, I imported the existing inventory data and with it came the onhand > amounts. If your not importing data, you can create a purchase order and > receive it. You could also manually modify InventoryItem record(s) but > thats a pain if you have lots to do and you loose the InventoryItemDetail. > > Skip > > > -----Original Message----- > From: Bruno Busco [mailto:[hidden email]] > Sent: Wednesday, April 16, 2008 1:02 PM > To: [hidden email] > Subject: How to set the quantity of product available to the store? > > > Hi, > a very basic question... > > What is the right way to change the available quantity of a product? > I have set the store "require inventory" flag to Y so that now "out of > stock" message is displayed in the product ecommerce page (and I like > this). > But how to let ofbiz know that I have pieces available to be sold? > > Many thanks, > > -Bruno > > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > 4/14/2008 > 9:26 AM > > No virus found in this outgoing message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > 4/14/2008 > 9:26 AM > > No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: 4/14/2008 9:26 AM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: 4/14/2008 9:26 AM |
Re: How to set the quantity of product available to the store?
|
|
Thank you very much for the clear explanation.
I will try to find the way through the ofbiz menus to execute the work cycle you have described: - Make a purchase order - Receive goods and create new inventory - Have it available to the eshop Anyone has such a list of links url at hand? At the moment I do not understand why, even if I have some enchiladas available as QOH, the "not in stock" label is displayed in the ecommerce... ...i need to follow the code...or may be someone could imagine why? -Bruno 2008/4/17, skip@thedevers <[hidden email]>: > > Bruno > > I guess "regular" is in the eye of the beholder. For my clients, the > "regular" way was to import their existing inventory. As it was sold, > more > was purchased. When it was purchased, a second (or third) InventoryItem > record was created increasing the quantity on hand. (At some point, I am > going to modify that code so that new InventoryItem records are not > created > if the cost and supplier are the same.) Doing it this way keeps an audit > trail. I NEVER allow the users to manually adjust inventory. There is a > single person responsible for figuring out and correcting why ATP/OH != > physical counts. > > The normal process for them is to write a purchase order and email/send it > to the supplier. They then ship the goods. When the goods are received, > the shipping clerk receives the purchase order, modifying the quantities > as > needed. This creates an invoice for Accounts Payable, handles the GL > details and increases the quantity on hand that can then be sold. > > Unlike like you, I have "require inventory" flag to N. My users (sales > clerks as they don't currently have an ecommerce site) can then sell an > item > and have a backorder (actually a requirement) automatically > generated. The > purchasing agent then generates orders from the backorder requirements. > I > have spent two months modifying this purchasing/backorder code heavily, so > I > don't fully remember how it worked before, but I think this is standard > behavior OOTB. > > > Skip > > -----Original Message----- > From: Bruno Busco [mailto:[hidden email]] > > Sent: Wednesday, April 16, 2008 3:37 PM > To: [hidden email] > > Subject: Re: How to set the quantity of product available to the store? > > > Skip, > I have imported the demo inventory data, I am fine with them but I would > like to understand what is the normal way to change the available > inventory > amount in ofbiz so that they are available to the eshop. > Is the purchase order you suggest the "regular" way to change available > amounts in inventory? > > (apart of the manual changing of the records) > > -Bruno > > > 2008/4/17, skip@thedevers <[hidden email]>: > > > > Bruno > > > > For me, I imported the existing inventory data and with it came the > onhand > > amounts. If your not importing data, you can create a purchase order > and > > receive it. You could also manually modify InventoryItem record(s) but > > thats a pain if you have lots to do and you loose the > InventoryItemDetail. > > > > Skip > > > > > > -----Original Message----- > > From: Bruno Busco [mailto:[hidden email]] > > Sent: Wednesday, April 16, 2008 1:02 PM > > To: [hidden email] > > Subject: How to set the quantity of product available to the store? > > > > > > Hi, > > a very basic question... > > > > What is the right way to change the available quantity of a product? > > I have set the store "require inventory" flag to Y so that now "out of > > stock" message is displayed in the product ecommerce page (and I like > > this). > > But how to let ofbiz know that I have pieces available to be sold? > > > > Many thanks, > > > > -Bruno > > > > > > No virus found in this incoming message. > > Checked by AVG. > > Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > > 4/14/2008 > > 9:26 AM > > > > No virus found in this outgoing message. > > Checked by AVG. > > Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > > 4/14/2008 > > 9:26 AM > > > > > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > 4/14/2008 > 9:26 AM > > No virus found in this outgoing message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > 4/14/2008 > 9:26 AM > > |
Re: How to set the quantity of product available to the store?
|
|
if you back track from the
applications\ecommerce\webapp\ecommerce\WEB-INF\actions\catalog\miniproductsummary.bsh and trace miniProdQuantity you will find all the things that effect the quanity on hand. for instance ou may not have a supplier(vendor) that you designated for the received inventory, specified for the product. you can also start with the inventory artifact and work you way thru it. select entity then use inventory as the key searchword. Bruno Busco sent the following on 4/17/2008 5:57 AM: > Thank you very much for the clear explanation. > > I will try to find the way through the ofbiz menus to execute the work cycle > you have described: > - Make a purchase order > - Receive goods and create new inventory > - Have it available to the eshop > > Anyone has such a list of links url at hand? > > At the moment I do not understand why, even if I have some enchiladas > available as QOH, the "not in stock" label is displayed in the ecommerce... > ...i need to follow the code...or may be someone could imagine why? > > -Bruno > > > > 2008/4/17, skip@thedevers <[hidden email]>: >> Bruno >> >> I guess "regular" is in the eye of the beholder. For my clients, the >> "regular" way was to import their existing inventory. As it was sold, >> more >> was purchased. When it was purchased, a second (or third) InventoryItem >> record was created increasing the quantity on hand. (At some point, I am >> going to modify that code so that new InventoryItem records are not >> created >> if the cost and supplier are the same.) Doing it this way keeps an audit >> trail. I NEVER allow the users to manually adjust inventory. There is a >> single person responsible for figuring out and correcting why ATP/OH != >> physical counts. >> >> The normal process for them is to write a purchase order and email/send it >> to the supplier. They then ship the goods. When the goods are received, >> the shipping clerk receives the purchase order, modifying the quantities >> as >> needed. This creates an invoice for Accounts Payable, handles the GL >> details and increases the quantity on hand that can then be sold. >> >> Unlike like you, I have "require inventory" flag to N. My users (sales >> clerks as they don't currently have an ecommerce site) can then sell an >> item >> and have a backorder (actually a requirement) automatically >> generated. The >> purchasing agent then generates orders from the backorder requirements. >> I >> have spent two months modifying this purchasing/backorder code heavily, so >> I >> don't fully remember how it worked before, but I think this is standard >> behavior OOTB. >> >> >> Skip >> >> -----Original Message----- >> From: Bruno Busco [mailto:[hidden email]] >> >> Sent: Wednesday, April 16, 2008 3:37 PM >> To: [hidden email] >> >> Subject: Re: How to set the quantity of product available to the store? >> >> >> Skip, >> I have imported the demo inventory data, I am fine with them but I would >> like to understand what is the normal way to change the available >> inventory >> amount in ofbiz so that they are available to the eshop. >> Is the purchase order you suggest the "regular" way to change available >> amounts in inventory? >> >> (apart of the manual changing of the records) >> >> -Bruno >> >> >> 2008/4/17, skip@thedevers <[hidden email]>: >>> Bruno >>> >>> For me, I imported the existing inventory data and with it came the >> onhand >>> amounts. If your not importing data, you can create a purchase order >> and >>> receive it. You could also manually modify InventoryItem record(s) but >>> thats a pain if you have lots to do and you loose the >> InventoryItemDetail. >>> Skip >>> >>> >>> -----Original Message----- >>> From: Bruno Busco [mailto:[hidden email]] >>> Sent: Wednesday, April 16, 2008 1:02 PM >>> To: [hidden email] >>> Subject: How to set the quantity of product available to the store? >>> >>> >>> Hi, >>> a very basic question... >>> >>> What is the right way to change the available quantity of a product? >>> I have set the store "require inventory" flag to Y so that now "out of >>> stock" message is displayed in the product ecommerce page (and I like >>> this). >>> But how to let ofbiz know that I have pieces available to be sold? >>> >>> Many thanks, >>> >>> -Bruno >>> >>> >>> No virus found in this incoming message. >>> Checked by AVG. >>> Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: >>> 4/14/2008 >>> 9:26 AM >>> >>> No virus found in this outgoing message. >>> Checked by AVG. >>> Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: >>> 4/14/2008 >>> 9:26 AM >>> >>> >> No virus found in this incoming message. >> Checked by AVG. >> Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: >> 4/14/2008 >> 9:26 AM >> >> No virus found in this outgoing message. >> Checked by AVG. >> Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: >> 4/14/2008 >> 9:26 AM >> >> > |
Re: How to set the quantity of product available to the store?
|
|
I will follow the path you suggest.
Thank you -Bruno 2008/4/17, BJ Freeman <[hidden email]>: > > if you back track from the > > applications\ecommerce\webapp\ecommerce\WEB-INF\actions\catalog\miniproductsummary.bsh > and trace miniProdQuantity > you will find all the things that effect the quanity on hand. > > for instance ou may not have a supplier(vendor) that you designated for > the received inventory, specified for the product. > > you can also start with the inventory artifact and work you way thru it. > select entity then use inventory as the key searchword. > > > > Bruno Busco sent the following on 4/17/2008 5:57 AM: > > > Thank you very much for the clear explanation. > > > > I will try to find the way through the ofbiz menus to execute the work > cycle > > you have described: > > - Make a purchase order > > - Receive goods and create new inventory > > - Have it available to the eshop > > > > Anyone has such a list of links url at hand? > > > > At the moment I do not understand why, even if I have some enchiladas > > available as QOH, the "not in stock" label is displayed in the > ecommerce... > > ...i need to follow the code...or may be someone could imagine why? > > > > -Bruno > > > > > > > > 2008/4/17, skip@thedevers <[hidden email]>: > >> Bruno > >> > >> I guess "regular" is in the eye of the beholder. For my clients, the > >> "regular" way was to import their existing inventory. As it was sold, > >> more > >> was purchased. When it was purchased, a second (or third) > InventoryItem > >> record was created increasing the quantity on hand. (At some point, I > am > >> going to modify that code so that new InventoryItem records are not > >> created > >> if the cost and supplier are the same.) Doing it this way keeps an > audit > >> trail. I NEVER allow the users to manually adjust inventory. There is > a > >> single person responsible for figuring out and correcting why ATP/OH != > >> physical counts. > >> > >> The normal process for them is to write a purchase order and email/send > it > >> to the supplier. They then ship the goods. When the goods are > received, > >> the shipping clerk receives the purchase order, modifying the > quantities > >> as > >> needed. This creates an invoice for Accounts Payable, handles the GL > >> details and increases the quantity on hand that can then be sold. > >> > >> Unlike like you, I have "require inventory" flag to N. My users (sales > >> clerks as they don't currently have an ecommerce site) can then sell an > >> item > >> and have a backorder (actually a requirement) automatically > >> generated. The > >> purchasing agent then generates orders from the backorder requirements. > >> I > >> have spent two months modifying this purchasing/backorder code heavily, > so > >> I > >> don't fully remember how it worked before, but I think this is standard > >> behavior OOTB. > >> > >> > >> Skip > >> > >> -----Original Message----- > >> From: Bruno Busco [mailto:[hidden email]] > >> > >> Sent: Wednesday, April 16, 2008 3:37 PM > >> To: [hidden email] > >> > >> Subject: Re: How to set the quantity of product available to the store? > >> > >> > >> Skip, > >> I have imported the demo inventory data, I am fine with them but I > would > >> like to understand what is the normal way to change the available > >> inventory > >> amount in ofbiz so that they are available to the eshop. > >> Is the purchase order you suggest the "regular" way to change available > >> amounts in inventory? > >> > >> (apart of the manual changing of the records) > >> > >> -Bruno > >> > >> > >> 2008/4/17, skip@thedevers <[hidden email]>: > >>> Bruno > >>> > >>> For me, I imported the existing inventory data and with it came the > >> onhand > >>> amounts. If your not importing data, you can create a purchase order > >> and > >>> receive it. You could also manually modify InventoryItem record(s) > but > >>> thats a pain if you have lots to do and you loose the > >> InventoryItemDetail. > >>> Skip > >>> > >>> > >>> -----Original Message----- > >>> From: Bruno Busco [mailto:[hidden email]] > >>> Sent: Wednesday, April 16, 2008 1:02 PM > >>> To: [hidden email] > >>> Subject: How to set the quantity of product available to the store? > >>> > >>> > >>> Hi, > >>> a very basic question... > >>> > >>> What is the right way to change the available quantity of a product? > >>> I have set the store "require inventory" flag to Y so that now "out of > >>> stock" message is displayed in the product ecommerce page (and I like > >>> this). > >>> But how to let ofbiz know that I have pieces available to be sold? > >>> > >>> Many thanks, > >>> > >>> -Bruno > >>> > >>> > >>> No virus found in this incoming message. > >>> Checked by AVG. > >>> Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > >>> 4/14/2008 > >>> 9:26 AM > >>> > >>> No virus found in this outgoing message. > >>> Checked by AVG. > >>> Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > >>> 4/14/2008 > >>> 9:26 AM > >>> > >>> > >> No virus found in this incoming message. > >> Checked by AVG. > >> Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > >> 4/14/2008 > >> 9:26 AM > >> > >> No virus found in this outgoing message. > >> Checked by AVG. > >> Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: > >> 4/14/2008 > >> 9:26 AM > >> > >> > > > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |