You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Boris Hamanov <bs...@gmail.com> on 2012/09/04 13:46:55 UTC

This item is out of stock with variant products

Hi guys,

My setup is like this (taken form DemoData)

<Product productId="GZ-1006" productTypeId="FINISHED_GOOD"
primaryProductCategoryId="102" productName="Open Gizmo" internalName="Open
Gizmo" description="Gizmo based on open standards" longDescription="Highest
quality gizmo around." taxable="Y" chargeShipping="Y"
autoCreateKeywords="Y" isVirtual="Y" isVariant="N" createdDate="2001-05-13
12:00:00.0" createdByUserLogin="admin" lastModifiedDate="2001-05-13
12:00:00.0" lastModifiedByUserLogin="admin"/>
<Product productId="GZ-1006-1" productTypeId="FINISHED_GOOD"
primaryProductCategoryId="102" productName="Open Gizmo (LGPL)"
internalName="Open Gizmo (LGPL)" description="Gizmo based on open
standards" longDescription="Highest quality gizmo around." taxable="Y"
chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y"
createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
lastModifiedDate="2001-05-13 12:00:00.0" lastModifiedByUserLogin="admin"/>
<Product productId="GZ-1006-2" productTypeId="FINISHED_GOOD"
primaryProductCategoryId="102" productName="Open Gizmo (GPL)"
internalName="Open Gizmo (GPL)" description="Gizmo based on open standards"
longDescription="Highest quality gizmo around." taxable="Y"
chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y"
createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
lastModifiedDate="2001-05-13 12:00:00.0" lastModifiedByUserLogin="admin"/>


    <ProductAssoc fromDate="2001-05-13 12:00:00.0"
productAssocTypeId="PRODUCT_VARIANT" productId="GZ-1006"
        productIdTo="GZ-1006-1" quantity="1.0" reason=""/>
    <ProductAssoc fromDate="2001-05-13 12:00:00.0"
productAssocTypeId="PRODUCT_VARIANT" productId="GZ-1006"
        productIdTo="GZ-1006-2" quantity="1.0" reason=""/>

    <ProductFeature productFeatureId="8000" productFeatureCategoryId="8000"
productFeatureTypeId="LICENSE" description="LGPL"/>
    <ProductFeature productFeatureId="8001" productFeatureCategoryId="8000"
productFeatureTypeId="LICENSE" description="GPL"/>

    <ProductFeatureAppl productId="GZ-1006" productFeatureId="8000"
        productFeatureApplTypeId="SELECTABLE_FEATURE" fromDate="2001-05-13
12:00:00.0" sequenceNum="1"/>
    <ProductFeatureAppl productId="GZ-1006" productFeatureId="8001"
        productFeatureApplTypeId="SELECTABLE_FEATURE" fromDate="2001-05-13
12:00:00.0" sequenceNum="2"/>


I get the main(base / virtual) product page, but it says: *This item is out
of stock* and I don't see any variants listed to choose from.
Maybe this has something to do with my store, I don't use inventory in it.
I don't have any such trouble with my normal products. Is there something I
am missing here?

Kind Regards,
Boris

Re: This item is out of stock with variant products

Posted by Boris Hamanov <bs...@gmail.com>.
Thanks Ankit,

I solved my problem by adding two new lines

<ProductFeatureAppl productId="GZ-1006-1" productFeatureId="8000"
       productFeatureApplTypeId="STANDARD_FEATURE"
<ProductFeatureAppl productId="GZ-1006-2" productFeatureId="8001"
       productFeatureApplTypeId="STANDARD_FEATURE"

They were in DemoProduct.xml too, but it seems I missed them.

After spending half a day, staring at spaghetti code, I finally saw what it 
was looking for :)

-----Original Message----- 
From: Ankit Jain
Date: 05 септември 2012 г. 14:18 ч.
To: user@ofbiz.apache.org
Subject: Re: This item is out of stock with variant products

Hi Boris,

Check you ProductStore setting, I think the field  "Require Inventory" is
set to "Y", change it to "N" and give a try.

--
Ankit Jain




On Tue, Sep 4, 2012 at 6:26 PM, Boris Hamanov <bs...@gmail.com> wrote:

> Thanks Praveen,
>
> This does not work. Choosing STANDARD FEATURE creates additional error:
> [java] 2012-09-04 15:35:28,049 (http-0.0.0.0-8080-1) [    ProductServices.
> j
> ava:170:WARN ] Problem reading product features. for product HUSA-1000-A
>
> requireInventory = 'N' also did not make any difference.
>
> I found out that those does not exists in productdetail.ftl
>
> product.virtualVariantMethodEnum
> featureLists
> variantTree
>
> and that leads program flow to the point where out of stock message is
> displayed
>
> I will check where are those initialized.
>
> I am using ofbiz 09.04.02 if that helps?
>
> On Tue, Sep 4, 2012 at 3:02 PM, Praveen Agarwal
> <pr...@gmail.com>wrote:
>
> > Hi Boris,
> >
> > 1) check the 'requireInventory' field for Virtual Product in Product
> > Entity. This should be set as 'N' if you are not using Inventory.
> >
> > 2) Make the ProductFeatureAppl  entry for Variant Products also setting
> the
> > productFeatureApplTypeId = 'STANDARD_FEATURE'.
> >
> > Thanks,
> > Praveen Agrawal
> >
> >
> > On Tue, Sep 4, 2012 at 5:16 PM, Boris Hamanov <bs...@gmail.com> wrote:
> >
> > > Hi guys,
> > >
> > > My setup is like this (taken form DemoData)
> > >
> > > <Product productId="GZ-1006" productTypeId="FINISHED_GOOD"
> > > primaryProductCategoryId="102" productName="Open Gizmo"
> > internalName="Open
> > > Gizmo" description="Gizmo based on open standards"
> > longDescription="Highest
> > > quality gizmo around." taxable="Y" chargeShipping="Y"
> > > autoCreateKeywords="Y" isVirtual="Y" isVariant="N"
> > createdDate="2001-05-13
> > > 12:00:00.0" createdByUserLogin="admin" lastModifiedDate="2001-05-13
> > > 12:00:00.0" lastModifiedByUserLogin="admin"/>
> > > <Product productId="GZ-1006-1" productTypeId="FINISHED_GOOD"
> > > primaryProductCategoryId="102" productName="Open Gizmo (LGPL)"
> > > internalName="Open Gizmo (LGPL)" description="Gizmo based on open
> > > standards" longDescription="Highest quality gizmo around." taxable="Y"
> > > chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y"
> > > createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
> > > lastModifiedDate="2001-05-13 12:00:00.0"
> > lastModifiedByUserLogin="admin"/>
> > > <Product productId="GZ-1006-2" productTypeId="FINISHED_GOOD"
> > > primaryProductCategoryId="102" productName="Open Gizmo (GPL)"
> > > internalName="Open Gizmo (GPL)" description="Gizmo based on open
> > standards"
> > > longDescription="Highest quality gizmo around." taxable="Y"
> > > chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y"
> > > createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
> > > lastModifiedDate="2001-05-13 12:00:00.0"
> > lastModifiedByUserLogin="admin"/>
> > >
> > >
> > >     <ProductAssoc fromDate="2001-05-13 12:00:00.0"
> > > productAssocTypeId="PRODUCT_VARIANT" productId="GZ-1006"
> > >         productIdTo="GZ-1006-1" quantity="1.0" reason=""/>
> > >     <ProductAssoc fromDate="2001-05-13 12:00:00.0"
> > > productAssocTypeId="PRODUCT_VARIANT" productId="GZ-1006"
> > >         productIdTo="GZ-1006-2" quantity="1.0" reason=""/>
> > >
> > >     <ProductFeature productFeatureId="8000"
> > productFeatureCategoryId="8000"
> > > productFeatureTypeId="LICENSE" description="LGPL"/>
> > >     <ProductFeature productFeatureId="8001"
> > productFeatureCategoryId="8000"
> > > productFeatureTypeId="LICENSE" description="GPL"/>
> > >
> > >     <ProductFeatureAppl productId="GZ-1006" productFeatureId="8000"
> > >         productFeatureApplTypeId="SELECTABLE_FEATURE"
> > fromDate="2001-05-13
> > > 12:00:00.0" sequenceNum="1"/>
> > >     <ProductFeatureAppl productId="GZ-1006" productFeatureId="8001"
> > >         productFeatureApplTypeId="SELECTABLE_FEATURE"
> > fromDate="2001-05-13
> > > 12:00:00.0" sequenceNum="2"/>
> > >
> > >
> > > I get the main(base / virtual) product page, but it says: *This item
> is
> > out
> > > of stock* and I don't see any variants listed to choose from.
> > > Maybe this has something to do with my store, I don't use inventory in
> > it.
> > > I don't have any such trouble with my normal products. Is there
> > something I
> > > am missing here?
> > >
> > > Kind Regards,
> > > Boris
> > >
> >
> 


Re: This item is out of stock with variant products

Posted by Ankit Jain <an...@gmail.com>.
Hi Boris,

Check you ProductStore setting, I think the field  "Require Inventory" is
set to "Y", change it to "N" and give a try.

--
Ankit Jain




On Tue, Sep 4, 2012 at 6:26 PM, Boris Hamanov <bs...@gmail.com> wrote:

> Thanks Praveen,
>
> This does not work. Choosing STANDARD FEATURE creates additional error:
> [java] 2012-09-04 15:35:28,049 (http-0.0.0.0-8080-1) [    ProductServices.
> j
> ava:170:WARN ] Problem reading product features. for product HUSA-1000-A
>
> requireInventory = 'N' also did not make any difference.
>
> I found out that those does not exists in productdetail.ftl
>
> product.virtualVariantMethodEnum
> featureLists
> variantTree
>
> and that leads program flow to the point where out of stock message is
> displayed
>
> I will check where are those initialized.
>
> I am using ofbiz 09.04.02 if that helps?
>
> On Tue, Sep 4, 2012 at 3:02 PM, Praveen Agarwal
> <pr...@gmail.com>wrote:
>
> > Hi Boris,
> >
> > 1) check the 'requireInventory' field for Virtual Product in Product
> > Entity. This should be set as 'N' if you are not using Inventory.
> >
> > 2) Make the ProductFeatureAppl  entry for Variant Products also setting
> the
> > productFeatureApplTypeId = 'STANDARD_FEATURE'.
> >
> > Thanks,
> > Praveen Agrawal
> >
> >
> > On Tue, Sep 4, 2012 at 5:16 PM, Boris Hamanov <bs...@gmail.com> wrote:
> >
> > > Hi guys,
> > >
> > > My setup is like this (taken form DemoData)
> > >
> > > <Product productId="GZ-1006" productTypeId="FINISHED_GOOD"
> > > primaryProductCategoryId="102" productName="Open Gizmo"
> > internalName="Open
> > > Gizmo" description="Gizmo based on open standards"
> > longDescription="Highest
> > > quality gizmo around." taxable="Y" chargeShipping="Y"
> > > autoCreateKeywords="Y" isVirtual="Y" isVariant="N"
> > createdDate="2001-05-13
> > > 12:00:00.0" createdByUserLogin="admin" lastModifiedDate="2001-05-13
> > > 12:00:00.0" lastModifiedByUserLogin="admin"/>
> > > <Product productId="GZ-1006-1" productTypeId="FINISHED_GOOD"
> > > primaryProductCategoryId="102" productName="Open Gizmo (LGPL)"
> > > internalName="Open Gizmo (LGPL)" description="Gizmo based on open
> > > standards" longDescription="Highest quality gizmo around." taxable="Y"
> > > chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y"
> > > createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
> > > lastModifiedDate="2001-05-13 12:00:00.0"
> > lastModifiedByUserLogin="admin"/>
> > > <Product productId="GZ-1006-2" productTypeId="FINISHED_GOOD"
> > > primaryProductCategoryId="102" productName="Open Gizmo (GPL)"
> > > internalName="Open Gizmo (GPL)" description="Gizmo based on open
> > standards"
> > > longDescription="Highest quality gizmo around." taxable="Y"
> > > chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y"
> > > createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
> > > lastModifiedDate="2001-05-13 12:00:00.0"
> > lastModifiedByUserLogin="admin"/>
> > >
> > >
> > >     <ProductAssoc fromDate="2001-05-13 12:00:00.0"
> > > productAssocTypeId="PRODUCT_VARIANT" productId="GZ-1006"
> > >         productIdTo="GZ-1006-1" quantity="1.0" reason=""/>
> > >     <ProductAssoc fromDate="2001-05-13 12:00:00.0"
> > > productAssocTypeId="PRODUCT_VARIANT" productId="GZ-1006"
> > >         productIdTo="GZ-1006-2" quantity="1.0" reason=""/>
> > >
> > >     <ProductFeature productFeatureId="8000"
> > productFeatureCategoryId="8000"
> > > productFeatureTypeId="LICENSE" description="LGPL"/>
> > >     <ProductFeature productFeatureId="8001"
> > productFeatureCategoryId="8000"
> > > productFeatureTypeId="LICENSE" description="GPL"/>
> > >
> > >     <ProductFeatureAppl productId="GZ-1006" productFeatureId="8000"
> > >         productFeatureApplTypeId="SELECTABLE_FEATURE"
> > fromDate="2001-05-13
> > > 12:00:00.0" sequenceNum="1"/>
> > >     <ProductFeatureAppl productId="GZ-1006" productFeatureId="8001"
> > >         productFeatureApplTypeId="SELECTABLE_FEATURE"
> > fromDate="2001-05-13
> > > 12:00:00.0" sequenceNum="2"/>
> > >
> > >
> > > I get the main(base / virtual) product page, but it says: *This item
> is
> > out
> > > of stock* and I don't see any variants listed to choose from.
> > > Maybe this has something to do with my store, I don't use inventory in
> > it.
> > > I don't have any such trouble with my normal products. Is there
> > something I
> > > am missing here?
> > >
> > > Kind Regards,
> > > Boris
> > >
> >
>

Re: This item is out of stock with variant products

Posted by Boris Hamanov <bs...@gmail.com>.
Thanks Praveen,

This does not work. Choosing STANDARD FEATURE creates additional error:
[java] 2012-09-04 15:35:28,049 (http-0.0.0.0-8080-1) [    ProductServices.j
ava:170:WARN ] Problem reading product features. for product HUSA-1000-A

requireInventory = 'N' also did not make any difference.

I found out that those does not exists in productdetail.ftl

product.virtualVariantMethodEnum
featureLists
variantTree

and that leads program flow to the point where out of stock message is
displayed

I will check where are those initialized.

I am using ofbiz 09.04.02 if that helps?

On Tue, Sep 4, 2012 at 3:02 PM, Praveen Agarwal
<pr...@gmail.com>wrote:

> Hi Boris,
>
> 1) check the 'requireInventory' field for Virtual Product in Product
> Entity. This should be set as 'N' if you are not using Inventory.
>
> 2) Make the ProductFeatureAppl  entry for Variant Products also setting the
> productFeatureApplTypeId = 'STANDARD_FEATURE'.
>
> Thanks,
> Praveen Agrawal
>
>
> On Tue, Sep 4, 2012 at 5:16 PM, Boris Hamanov <bs...@gmail.com> wrote:
>
> > Hi guys,
> >
> > My setup is like this (taken form DemoData)
> >
> > <Product productId="GZ-1006" productTypeId="FINISHED_GOOD"
> > primaryProductCategoryId="102" productName="Open Gizmo"
> internalName="Open
> > Gizmo" description="Gizmo based on open standards"
> longDescription="Highest
> > quality gizmo around." taxable="Y" chargeShipping="Y"
> > autoCreateKeywords="Y" isVirtual="Y" isVariant="N"
> createdDate="2001-05-13
> > 12:00:00.0" createdByUserLogin="admin" lastModifiedDate="2001-05-13
> > 12:00:00.0" lastModifiedByUserLogin="admin"/>
> > <Product productId="GZ-1006-1" productTypeId="FINISHED_GOOD"
> > primaryProductCategoryId="102" productName="Open Gizmo (LGPL)"
> > internalName="Open Gizmo (LGPL)" description="Gizmo based on open
> > standards" longDescription="Highest quality gizmo around." taxable="Y"
> > chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y"
> > createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
> > lastModifiedDate="2001-05-13 12:00:00.0"
> lastModifiedByUserLogin="admin"/>
> > <Product productId="GZ-1006-2" productTypeId="FINISHED_GOOD"
> > primaryProductCategoryId="102" productName="Open Gizmo (GPL)"
> > internalName="Open Gizmo (GPL)" description="Gizmo based on open
> standards"
> > longDescription="Highest quality gizmo around." taxable="Y"
> > chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y"
> > createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
> > lastModifiedDate="2001-05-13 12:00:00.0"
> lastModifiedByUserLogin="admin"/>
> >
> >
> >     <ProductAssoc fromDate="2001-05-13 12:00:00.0"
> > productAssocTypeId="PRODUCT_VARIANT" productId="GZ-1006"
> >         productIdTo="GZ-1006-1" quantity="1.0" reason=""/>
> >     <ProductAssoc fromDate="2001-05-13 12:00:00.0"
> > productAssocTypeId="PRODUCT_VARIANT" productId="GZ-1006"
> >         productIdTo="GZ-1006-2" quantity="1.0" reason=""/>
> >
> >     <ProductFeature productFeatureId="8000"
> productFeatureCategoryId="8000"
> > productFeatureTypeId="LICENSE" description="LGPL"/>
> >     <ProductFeature productFeatureId="8001"
> productFeatureCategoryId="8000"
> > productFeatureTypeId="LICENSE" description="GPL"/>
> >
> >     <ProductFeatureAppl productId="GZ-1006" productFeatureId="8000"
> >         productFeatureApplTypeId="SELECTABLE_FEATURE"
> fromDate="2001-05-13
> > 12:00:00.0" sequenceNum="1"/>
> >     <ProductFeatureAppl productId="GZ-1006" productFeatureId="8001"
> >         productFeatureApplTypeId="SELECTABLE_FEATURE"
> fromDate="2001-05-13
> > 12:00:00.0" sequenceNum="2"/>
> >
> >
> > I get the main(base / virtual) product page, but it says: *This item is
> out
> > of stock* and I don't see any variants listed to choose from.
> > Maybe this has something to do with my store, I don't use inventory in
> it.
> > I don't have any such trouble with my normal products. Is there
> something I
> > am missing here?
> >
> > Kind Regards,
> > Boris
> >
>

Re: This item is out of stock with variant products

Posted by Praveen Agarwal <pr...@gmail.com>.
Hi Boris,

1) check the 'requireInventory' field for Virtual Product in Product
Entity. This should be set as 'N' if you are not using Inventory.

2) Make the ProductFeatureAppl  entry for Variant Products also setting the
productFeatureApplTypeId = 'STANDARD_FEATURE'.

Thanks,
Praveen Agrawal


On Tue, Sep 4, 2012 at 5:16 PM, Boris Hamanov <bs...@gmail.com> wrote:

> Hi guys,
>
> My setup is like this (taken form DemoData)
>
> <Product productId="GZ-1006" productTypeId="FINISHED_GOOD"
> primaryProductCategoryId="102" productName="Open Gizmo" internalName="Open
> Gizmo" description="Gizmo based on open standards" longDescription="Highest
> quality gizmo around." taxable="Y" chargeShipping="Y"
> autoCreateKeywords="Y" isVirtual="Y" isVariant="N" createdDate="2001-05-13
> 12:00:00.0" createdByUserLogin="admin" lastModifiedDate="2001-05-13
> 12:00:00.0" lastModifiedByUserLogin="admin"/>
> <Product productId="GZ-1006-1" productTypeId="FINISHED_GOOD"
> primaryProductCategoryId="102" productName="Open Gizmo (LGPL)"
> internalName="Open Gizmo (LGPL)" description="Gizmo based on open
> standards" longDescription="Highest quality gizmo around." taxable="Y"
> chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y"
> createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
> lastModifiedDate="2001-05-13 12:00:00.0" lastModifiedByUserLogin="admin"/>
> <Product productId="GZ-1006-2" productTypeId="FINISHED_GOOD"
> primaryProductCategoryId="102" productName="Open Gizmo (GPL)"
> internalName="Open Gizmo (GPL)" description="Gizmo based on open standards"
> longDescription="Highest quality gizmo around." taxable="Y"
> chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y"
> createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin"
> lastModifiedDate="2001-05-13 12:00:00.0" lastModifiedByUserLogin="admin"/>
>
>
>     <ProductAssoc fromDate="2001-05-13 12:00:00.0"
> productAssocTypeId="PRODUCT_VARIANT" productId="GZ-1006"
>         productIdTo="GZ-1006-1" quantity="1.0" reason=""/>
>     <ProductAssoc fromDate="2001-05-13 12:00:00.0"
> productAssocTypeId="PRODUCT_VARIANT" productId="GZ-1006"
>         productIdTo="GZ-1006-2" quantity="1.0" reason=""/>
>
>     <ProductFeature productFeatureId="8000" productFeatureCategoryId="8000"
> productFeatureTypeId="LICENSE" description="LGPL"/>
>     <ProductFeature productFeatureId="8001" productFeatureCategoryId="8000"
> productFeatureTypeId="LICENSE" description="GPL"/>
>
>     <ProductFeatureAppl productId="GZ-1006" productFeatureId="8000"
>         productFeatureApplTypeId="SELECTABLE_FEATURE" fromDate="2001-05-13
> 12:00:00.0" sequenceNum="1"/>
>     <ProductFeatureAppl productId="GZ-1006" productFeatureId="8001"
>         productFeatureApplTypeId="SELECTABLE_FEATURE" fromDate="2001-05-13
> 12:00:00.0" sequenceNum="2"/>
>
>
> I get the main(base / virtual) product page, but it says: *This item is out
> of stock* and I don't see any variants listed to choose from.
> Maybe this has something to do with my store, I don't use inventory in it.
> I don't have any such trouble with my normal products. Is there something I
> am missing here?
>
> Kind Regards,
> Boris
>