Users - Virtual/Variant Product
Locked
 
|
I am having an issue with setting up a Virtual/Variant Product I have group of products that have the following options:
I setup:
ProductFeatureAppl is set to
It looks like very thing works right EXCEPT when I add the product (after Selecting Size and Color) to the cart it doesn't carry over the "Color" just the Size. I looked through the demo data (WG-9943) and it looks like everything "matches up"… did I miss something? Any help would be appreciated.
_______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Virtual/Variant Product
|
|
The only thing I can think of is ProductAssoc.
-----Original Message-----
I am having an issue with setting up a Virtual/Variant Product I have group of products
that have the following options: I setup: ProductFeatureAppl is set
to It looks like very thing works right EXCEPT when I add the product (after Selecting Size and Color) to the cart it doesn't carry over the "Color" just the Size. I looked through the demo data (WG-9943) and it looks like everything "matches up"… did I miss something? Any help would be appreciated.
_______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
In reply to this post by Bsmithson
I think this might help here is an example of one of my
products.
I took out the "extra" options and just listed two(there are
9 different Sizes and almost 42 different colors so it is quite long other
size).
<Product productId="whi-14000" productTypeId="FINISHED_GOOD" primaryProductCategoryId="FTops" productName="Unisex
V-Neck Top" brandName="White Swan" internalName="whi-14000" description="Fabric: 65/35 Poplin with Soil
Release" longDescription="To view the colors that are offered
in this style click the image above." taxable="Y"
chargeShipping="Y" autoCreateKeywords="Y" isVirtual="Y" isVariant="N"
weight="0.25" weightUomId="WT_lb"
requireInventory="N" salesDiscontinuationDate="" introductionDate="2006-02-03 12:00:00.1" createdDate="2001-05-13 12:00:00.1" createdByUserLogin="admin" lastModifiedDate="2006-02-05 12:00:00.1" lastModifiedByUserLogin="admin" />
<Product productId="whi-14000-S" productTypeId="FINISHED_GOOD" primaryProductCategoryId="FTops" productName="Unisex V-Neck Top - S" brandName="White Swan" internalName="whi-14000-S" description="Fabric: 65/35 Poplin with Soil Release" longDescription="To view the colors that are offered in this style click the image above." taxable="Y" chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N" isVariant="Y" weight="0.25" weightUomId="WT_lb" requireInventory="N" salesDiscontinuationDate="" introductionDate="2006-02-03 12:00:00.1" createdDate="2001-05-13 12:00:00.1" createdByUserLogin="admin" lastModifiedDate="2006-02-05 12:00:00.1" lastModifiedByUserLogin="admin" /> <ProductPrice productId="whi-14000" productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE" currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2005-01-01 00:00:00.000" price="6.8" createdDate="2005-01-01 00:00:00.000" createdByUserLogin="admin" lastModifiedDate="2005-01-01 00:00:00.000" lastModifiedByUserLogin="admin" /> < ProductFeatureCategory productFeatureCategoryId="11000" description="Apparel" /> <ProductFeatureCategoryAppl productFeatureCategoryId="11000" productCategoryId="D301-2ndAllProducts" fromDate="2001-05-13 12:00:00.0 " /><ProductFeature productFeatureId="11001" productFeatureCategoryId="11000" productFeatureTypeId="SIZE" description="Small" defaultSequenceNum="2" defaultAmount="" idCode="S"
abbrev="S" /> <ProductFeatureAppl productId="whi-14000-S" productFeatureId="11001" productFeatureApplTypeId="STANDARD_FEATURE" fromDate="2006-02-2 12:00:00.1" sequenceNum="1" /> <ProductFeatureAppl productId="whi-14000-S" productFeatureId="11009" productFeatureApplTypeId="STANDARD_FEATURE" fromDate="2006-02-2 12:00:00.1" sequenceNum="2" /> <ProductAssoc fromDate="2006-02-2 12:00:00.1" productAssocTypeId="PRODUCT_VARIANT" productId="whi-14000" productIdTo="whi-14000-S" quantity="1.0" reason="" /> Note: I did not include ProductCategoryMember, ProductCategoryRollup or ProductCategory in this e-mail but they are present in the product file. --- From: [hidden email] [mailto:[hidden email]] On Behalf Of Vinay Agarwal Sent: Wednesday, March 01, 2006 10:59 AM To: 'OFBiz Users / Usage Discussion' Subject: Re: [OFBiz] Users - Virtual/Variant Product The only thing I can think of is ProductAssoc.
-----Original
Message-----
I am having an issue with setting up a Virtual/Variant Product I have group of products
that have the following options: I setup:
ProductFeatureAppl is set
to It looks like very thing works right EXCEPT when I add the product (after Selecting Size and Color) to the cart it doesn't carry over the "Color" just the Size. I looked through the demo data (WG-9943) and it looks like everything "matches up"… did I miss something? Any help would be
appreciated.
_______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Virtual/Variant Product
|
|
In reply to this post by Bsmithson
hi,
I have a similar setup (variants with 2 features), the only difference I see is in the product id: you only add "S" for distinguishing the size, but how should the color be distinguished? If you set it up similar to the way I do then you would have products like Virtual Product X to "SELECTABLE_FEATURE" Small Variant Product X-S-B to "STANDARD_FEATURE" Small, Color blue Variant Product X-S-R to "STANDARD_FEATURE" Small, Color red ... and two ProductFeatureAppls for X-S-B to the two features "small" and "blue". If there is a other way to do it then I'm sorry, I'm not too experienced with this myself. If you need some more detail about my setup just say so.. hope that helps, Anna > --- Ursprüngliche Nachricht --- > Von: "Brent Smithson" <[hidden email]> > An: <[hidden email]> > Betreff: [OFBiz] Users - Virtual/Variant Product > Datum: Wed, 1 Mar 2006 09:45:31 -0800 > > > I am having an issue with setting up a Virtual/Variant Product > > > > I have group of products that have the following options: > > Size and Color (Size determines Color). > > > > I setup: > > Virtual product "X" & Variant product "X-S" > > All the Features and Colors have been setup already > > > > ProductFeatureAppl is set to > > Virtual Product X to "SELECTABLE_FEATURE" Small (11000) > > Variant Product X-S to "STANDARD_FEATURE" Small (11000) > > Variant Product X-S to "STANDARD_FEATURE" Color (11001) > > > > It looks like very thing works right EXCEPT when I add the product > > (after Selecting Size and Color) to the cart it doesn't carry over the > > "Color" just the Size. I looked through the demo data (WG-9943) and it > > looks like everything "matches up"... did I miss something? > > > > Any help would be appreciated. > > -Brent > > > > > -- Echte DSL-Flatrate dauerhaft für 0,- Euro*! "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Virtual/Variant Product
|
|
ok, to be a little more correct.. ;)
Virtual Product X: ProductFeatureAppl to "SELECTABLE_FEATURE" Small ProductFeatureAppl to "SELECTABLE_FEATURE" blue etc. Variant Product X-S-B: ProductFeatureAppl to "STANDARD_FEATURE" Small ProductFeatureAppl to "STANDARD_FEATURE" Color blue > --- Ursprüngliche Nachricht --- > Von: "Anna Schietz" <[hidden email]> > An: OFBiz Users / Usage Discussion <[hidden email]> > Betreff: Re: [OFBiz] Users - Virtual/Variant Product > Datum: Thu, 2 Mar 2006 10:42:36 +0100 (MET) > > hi, > > > I have a similar setup (variants with 2 features), the only difference I > see > is in the product id: you only add "S" for distinguishing the size, but > how > should the color be distinguished? > > If you set it up similar to the way I do then you would have products like > > Virtual Product X to "SELECTABLE_FEATURE" Small > Variant Product X-S-B to "STANDARD_FEATURE" Small, Color blue > Variant Product X-S-R to "STANDARD_FEATURE" Small, Color red > ... > > and two ProductFeatureAppls for X-S-B to the two features "small" and > "blue". > > > If there is a other way to do it then I'm sorry, I'm not too experienced > with this myself. If you need some more detail about my setup just say > so.. > > > hope that helps, > Anna > > > > > > > > > > > > > > > --- Ursprüngliche Nachricht --- > > Von: "Brent Smithson" <[hidden email]> > > An: <[hidden email]> > > Betreff: [OFBiz] Users - Virtual/Variant Product > > Datum: Wed, 1 Mar 2006 09:45:31 -0800 > > > > > I am having an issue with setting up a Virtual/Variant Product > > > > > > I have group of products that have the following options: > > > Size and Color (Size determines Color). > > > > > > I setup: > > > Virtual product "X" & Variant product "X-S" > > > All the Features and Colors have been setup already > > > > > > ProductFeatureAppl is set to > > > Virtual Product X to "SELECTABLE_FEATURE" Small (11000) > > > Variant Product X-S to "STANDARD_FEATURE" Small (11000) > > > Variant Product X-S to "STANDARD_FEATURE" Color (11001) > > > > > > It looks like very thing works right EXCEPT when I add the product > > > (after Selecting Size and Color) to the cart it doesn't carry over the > > > "Color" just the Size. I looked through the demo data (WG-9943) and it > > > looks like everything "matches up"... did I miss something? > > > > > > Any help would be appreciated. > > > -Brent > > > > > > > > > > -- > Echte DSL-Flatrate dauerhaft für 0,- Euro*! > "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > -- Bis zu 70% Ihrer Onlinekosten sparen: GMX SmartSurfer! Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
In reply to this post by Bsmithson
Anna,
Thank you for your help! I will give this a try, I was hoping to avoid creating more variant products (57+ plus apparel products x 378 options = a lot of entries) but we got to do what we got to do! - Brent -----Original Message----- From: [hidden email] [mailto:[hidden email]] On Behalf Of Anna Schietz Sent: Thursday, March 02, 2006 1:43 AM To: OFBiz Users / Usage Discussion Subject: Re: [OFBiz] Users - Virtual/Variant Product hi, I have a similar setup (variants with 2 features), the only difference I see is in the product id: you only add "S" for distinguishing the size, but how should the color be distinguished? If you set it up similar to the way I do then you would have products like Virtual Product X to "SELECTABLE_FEATURE" Small Variant Product X-S-B to "STANDARD_FEATURE" Small, Color blue Variant Product X-S-R to "STANDARD_FEATURE" Small, Color red ... and two ProductFeatureAppls for X-S-B to the two features "small" and "blue". If there is a other way to do it then I'm sorry, I'm not too experienced with this myself. If you need some more detail about my setup just say so.. hope that helps, Anna > --- Ursprüngliche Nachricht --- > Von: "Brent Smithson" <[hidden email]> > An: <[hidden email]> > Betreff: [OFBiz] Users - Virtual/Variant Product > Datum: Wed, 1 Mar 2006 09:45:31 -0800 > > > I am having an issue with setting up a Virtual/Variant Product > > > > I have group of products that have the following options: > > Size and Color (Size determines Color). > > > > I setup: > > Virtual product "X" & Variant product "X-S" > > All the Features and Colors have been setup already > > > > ProductFeatureAppl is set to > > Virtual Product X to "SELECTABLE_FEATURE" Small (11000) Variant > > Product X-S to "STANDARD_FEATURE" Small (11000) Variant Product X-S > > to "STANDARD_FEATURE" Color (11001) > > > > It looks like very thing works right EXCEPT when I add the product > > (after Selecting Size and Color) to the cart it doesn't carry over > > the "Color" just the Size. I looked through the demo data (WG-9943) > > and it looks like everything "matches up"... did I miss something? > > > > Any help would be appreciated. > > -Brent > > > > > -- Echte DSL-Flatrate dauerhaft für 0,- Euro*! "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Virtual/Variant Product
|
|
Brent,
I haven't been following this thread, but have you considered using configurations rather than variants? Andrew On Thu, 2006-03-02 at 08:58 -0800, Brent Smithson wrote: > Anna, > > Thank you for your help! > I will give this a try, I was hoping to avoid creating more variant products (57+ plus apparel products x 378 options = a lot of entries) but we got to do what we got to do! > > - Brent > > -----Original Message----- > From: [hidden email] [mailto:[hidden email]] On Behalf Of Anna Schietz > Sent: Thursday, March 02, 2006 1:43 AM > To: OFBiz Users / Usage Discussion > Subject: Re: [OFBiz] Users - Virtual/Variant Product > > hi, > > > I have a similar setup (variants with 2 features), the only difference I see is in the product id: you only add "S" for distinguishing the size, but how should the color be distinguished? > > If you set it up similar to the way I do then you would have products like > > Virtual Product X to "SELECTABLE_FEATURE" Small Variant Product X-S-B to "STANDARD_FEATURE" Small, Color blue Variant Product X-S-R to "STANDARD_FEATURE" Small, Color red ... > > and two ProductFeatureAppls for X-S-B to the two features "small" and "blue". > > > If there is a other way to do it then I'm sorry, I'm not too experienced with this myself. If you need some more detail about my setup just say so.. > > > hope that helps, > Anna > > > > > > > > > > > > > > > --- Ursprüngliche Nachricht --- > > Von: "Brent Smithson" <[hidden email]> > > An: <[hidden email]> > > Betreff: [OFBiz] Users - Virtual/Variant Product > > Datum: Wed, 1 Mar 2006 09:45:31 -0800 > > > > > I am having an issue with setting up a Virtual/Variant Product > > > > > > I have group of products that have the following options: > > > Size and Color (Size determines Color). > > > > > > I setup: > > > Virtual product "X" & Variant product "X-S" > > > All the Features and Colors have been setup already > > > > > > ProductFeatureAppl is set to > > > Virtual Product X to "SELECTABLE_FEATURE" Small (11000) Variant > > > Product X-S to "STANDARD_FEATURE" Small (11000) Variant Product X-S > > > to "STANDARD_FEATURE" Color (11001) > > > > > > It looks like very thing works right EXCEPT when I add the product > > > (after Selecting Size and Color) to the cart it doesn't carry over > > > the "Color" just the Size. I looked through the demo data (WG-9943) > > > and it looks like everything "matches up"... did I miss something? > > > > > > Any help would be appreciated. > > > -Brent > > > > > > > > > > -- > Echte DSL-Flatrate dauerhaft für 0,- Euro*! > "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users Kind Regards Andrew Sykes <[hidden email]> Sykes Development Ltd http://www.sykesdevelopment.com _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Virtual/Variant Product
|
|
ah yes, I forgot to mention that...
Product configurations are (imho) easier to set up but the order is not stored in the database (instead a production run is created) and using variants seemed to make more sense for the shop I'm working on that's why I switched back to using variants but maybe it would be a good idea for your shop. If you are interested in the info I got concerning product configurations: http://www.codecomments.com/archive420-2006-2-797763.html (couldn't find it on the list) > --- Ursprüngliche Nachricht --- > Von: Andrew Sykes <[hidden email]> > An: OFBiz Users / Usage Discussion <[hidden email]> > Betreff: Re: [OFBiz] Users - Virtual/Variant Product > Datum: Thu, 02 Mar 2006 17:39:23 +0000 > > Brent, > > I haven't been following this thread, but have you considered using > configurations rather than variants? > > Andrew > > On Thu, 2006-03-02 at 08:58 -0800, Brent Smithson wrote: > > Anna, > > > > Thank you for your help! > > I will give this a try, I was hoping to avoid creating more variant > products (57+ plus apparel products x 378 options = a lot of entries) but > got to do what we got to do! > > > > - Brent > > > > -----Original Message----- > > From: [hidden email] > [mailto:[hidden email]] On Behalf Of Anna Schietz > > Sent: Thursday, March 02, 2006 1:43 AM > > To: OFBiz Users / Usage Discussion > > Subject: Re: [OFBiz] Users - Virtual/Variant Product > > > > hi, > > > > > > I have a similar setup (variants with 2 features), the only difference I > see is in the product id: you only add "S" for distinguishing the size, > but how should the color be distinguished? > > > > If you set it up similar to the way I do then you would have products > like > > > > Virtual Product X to "SELECTABLE_FEATURE" Small Variant Product X-S-B > to "STANDARD_FEATURE" Small, Color blue Variant Product X-S-R to > "STANDARD_FEATURE" Small, Color red ... > > > > and two ProductFeatureAppls for X-S-B to the two features "small" and > "blue". > > > > > > If there is a other way to do it then I'm sorry, I'm not too experienced > with this myself. If you need some more detail about my setup just say > so.. > > > > > > hope that helps, > > Anna > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- Ursprüngliche Nachricht --- > > > Von: "Brent Smithson" <[hidden email]> > > > An: <[hidden email]> > > > Betreff: [OFBiz] Users - Virtual/Variant Product > > > Datum: Wed, 1 Mar 2006 09:45:31 -0800 > > > > > > > I am having an issue with setting up a Virtual/Variant Product > > > > > > > > I have group of products that have the following options: > > > > Size and Color (Size determines Color). > > > > > > > > I setup: > > > > Virtual product "X" & Variant product "X-S" > > > > All the Features and Colors have been setup already > > > > > > > > ProductFeatureAppl is set to > > > > Virtual Product X to "SELECTABLE_FEATURE" Small (11000) Variant > > > > Product X-S to "STANDARD_FEATURE" Small (11000) Variant Product X-S > > > > to "STANDARD_FEATURE" Color (11001) > > > > > > > > It looks like very thing works right EXCEPT when I add the product > > > > (after Selecting Size and Color) to the cart it doesn't carry over > > > > the "Color" just the Size. I looked through the demo data (WG-9943) > > > > and it looks like everything "matches up"... did I miss something? > > > > > > > > Any help would be appreciated. > > > > -Brent > > > > > > > > > > > > > > > -- > > Echte DSL-Flatrate dauerhaft für 0,- Euro*! > > "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl > > > > _______________________________________________ > > Users mailing list > > [hidden email] > > http://lists.ofbiz.org/mailman/listinfo/users > > > > _______________________________________________ > > Users mailing list > > [hidden email] > > http://lists.ofbiz.org/mailman/listinfo/users > -- > Kind Regards > Andrew Sykes <[hidden email]> > Sykes Development Ltd > http://www.sykesdevelopment.com > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users -- Bis zu 70% Ihrer Onlinekosten sparen: GMX SmartSurfer! Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Users - Database - Making a Clean Start
|
|
In reply to this post by Bsmithson
Hi All,
I have been playing with Ofbiz for a couple of week and accumulated a lot of junk in the database (derby). What is the best way to clean this out so that I can reload the seed data? I did try running the the 'drop all tables' action in WebTools but this produced a lot of errors. I have run 'ant run-install-seed'. I can no longer login with the admin user id - get message 'required permissions are missing'. I am thinking that there must be a simple way to start afresh such as deleting the <ofbiz>/data/derby/ofbiz folder and then running 'ant run-install-seed'. I am currently running svn 6915. Regards, Roger Bailey _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Database - Making a Clean Start
|
|
Hi Roger,
ant clean-all Jacopo Roger Bailey wrote: > Hi All, > > I have been playing with Ofbiz for a couple of week and accumulated a > lot of junk in the database (derby). What is the best way to clean this > out so that I can reload the seed data? > > I did try running the the 'drop all tables' action in WebTools but this > produced a lot of errors. > I have run 'ant run-install-seed'. > I can no longer login with the admin user id - get message 'required > permissions are missing'. > > I am thinking that there must be a simple way to start afresh such as > deleting the <ofbiz>/data/derby/ofbiz folder and then running 'ant > run-install-seed'. > > I am currently running svn 6915. > > Regards, > > Roger Bailey > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Database - Making a Clean Start
|
|
Thanks Jacopo. Worked fine.
Jacopo Cappellato wrote: > Hi Roger, > > ant clean-all > > Jacopo > > Roger Bailey wrote: > >> Hi All, >> >> I have been playing with Ofbiz for a couple of week and accumulated a >> lot of junk in the database (derby). What is the best way to clean this >> out so that I can reload the seed data? >> >> I did try running the the 'drop all tables' action in WebTools but this >> produced a lot of errors. >> I have run 'ant run-install-seed'. >> I can no longer login with the admin user id - get message 'required >> permissions are missing'. >> >> I am thinking that there must be a simple way to start afresh such as >> deleting the <ofbiz>/data/derby/ofbiz folder and then running 'ant >> run-install-seed'. >> >> I am currently running svn 6915. >> >> Regards, >> >> Roger Bailey >> >> _______________________________________________ >> Users mailing list >> [hidden email] >> http://lists.ofbiz.org/mailman/listinfo/users >> >> > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > > > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |