Users - Newbies importing Products

[Walter Vaughan]

I cannot believe that we cannot figure out what field/table links the PRODUCT_ID
to a catalog so that an item will appear in the webstore.

We are just trying to get the minimum data for testing purposes.

We have a sample xml as follows

<entity-engine-xml>
     <Product productId="60-0506-11" productTypeId="FINISHED_GOOD"
primaryProductCategoryId="RUBBER" internalName="60-0506-11"
productName="Support, engine" description="1933-36 Motor mount, rear support.
Replaces #836805." longDescription="1933-36 Motor mount, rear support. Replaces
#836805." taxable="Y" chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N"
isVariant="N" fromDate="2001-05-13 12:00:00.0" />
     <ProductPrice productId="60-0506-11" productPriceTypeId="DEFAULT_PRICE"
productPricePurposeId="PURCHASE" currencyUomId="USD" productStoreGroupId="_NA_"
fromDate="2001-05-13 12:00:00.0" price="93.20" />
</entity-engine-xml>

What do I need to add this part so it's in the webstore?

Thanks

--
Walter
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Andrew Sykes]

Walter,

Here's a quick summary, (I think this is everything)...

ProductStore
WebSite (make sure webSiteId is in web.xml)
ProductCatalog
ProductCatalogCategory
ProductCategory
ProductCategoryMember
Product

- Andrew

On Tue, 2006-06-13 at 10:51 -0400, Walter Vaughan wrote:

> I cannot believe that we cannot figure out what field/table links the PRODUCT_ID
> to a catalog so that an item will appear in the webstore.
>
> We are just trying to get the minimum data for testing purposes.
>
> We have a sample xml as follows
>
> <entity-engine-xml>
>      <Product productId="60-0506-11" productTypeId="FINISHED_GOOD"
> primaryProductCategoryId="RUBBER" internalName="60-0506-11"
> productName="Support, engine" description="1933-36 Motor mount, rear support.
> Replaces #836805." longDescription="1933-36 Motor mount, rear support. Replaces
> #836805." taxable="Y" chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N"
> isVariant="N" fromDate="2001-05-13 12:00:00.0" />
>      <ProductPrice productId="60-0506-11" productPriceTypeId="DEFAULT_PRICE"
> productPricePurposeId="PURCHASE" currencyUomId="USD" productStoreGroupId="_NA_"
> fromDate="2001-05-13 12:00:00.0" price="93.20" />
> </entity-engine-xml>
>
> What do I need to add this part so it's in the webstore?
>
> Thanks
>
> --
> Walter
>  
> _______________________________________________
> 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

[Andrew Sykes]

Ooops!

I knew I'd miss one...

ProductStoreCatalog

 - Andrew

On Tue, 2006-06-13 at 16:17 +0100, Andrew Sykes wrote:

> Walter,
>
> Here's a quick summary, (I think this is everything)...
>
> ProductStore
> WebSite (make sure webSiteId is in web.xml)
> ProductCatalog
> ProductCatalogCategory
> ProductCategory
> ProductCategoryMember
> Product
>
> - Andrew
>
> On Tue, 2006-06-13 at 10:51 -0400, Walter Vaughan wrote:
> > I cannot believe that we cannot figure out what field/table links the PRODUCT_ID
> > to a catalog so that an item will appear in the webstore.
> >
> > We are just trying to get the minimum data for testing purposes.
> >
> > We have a sample xml as follows
> >
> > <entity-engine-xml>
> >      <Product productId="60-0506-11" productTypeId="FINISHED_GOOD"
> > primaryProductCategoryId="RUBBER" internalName="60-0506-11"
> > productName="Support, engine" description="1933-36 Motor mount, rear support.
> > Replaces #836805." longDescription="1933-36 Motor mount, rear support. Replaces
> > #836805." taxable="Y" chargeShipping="Y" autoCreateKeywords="Y" isVirtual="N"
> > isVariant="N" fromDate="2001-05-13 12:00:00.0" />
> >      <ProductPrice productId="60-0506-11" productPriceTypeId="DEFAULT_PRICE"
> > productPricePurposeId="PURCHASE" currencyUomId="USD" productStoreGroupId="_NA_"
> > fromDate="2001-05-13 12:00:00.0" price="93.20" />
> > </entity-engine-xml>
> >
> > What do I need to add this part so it's in the webstore?
> >
> > Thanks
> >
> > --
> > Walter
> >  
> > _______________________________________________
> > 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

[Si Chen-2]

It might be easier if you set up the store, catalog, and categories  
in catalog manager and then just import ProductCategoryMember which  
points your product to a category.


On Jun 13, 2006, at 8:21 AM, Andrew Sykes wrote:

> Ooops!
>
> I knew I'd miss one...
>
> ProductStoreCatalog
>
>  - Andrew
>
> On Tue, 2006-06-13 at 16:17 +0100, Andrew Sykes wrote:
>> Walter,
>>
>> Here's a quick summary, (I think this is everything)...
>>
>> ProductStore
>> WebSite (make sure webSiteId is in web.xml)
>> ProductCatalog
>> ProductCatalogCategory
>> ProductCategory
>> ProductCategoryMember
>> Product
>>
>> - Andrew
>>
>> On Tue, 2006-06-13 at 10:51 -0400, Walter Vaughan wrote:
>>> I cannot believe that we cannot figure out what field/table links  
>>> the PRODUCT_ID
>>> to a catalog so that an item will appear in the webstore.
>>>
>>> We are just trying to get the minimum data for testing purposes.
>>>
>>> We have a sample xml as follows
>>>
>>> <entity-engine-xml>
>>>      <Product productId="60-0506-11" productTypeId="FINISHED_GOOD"
>>> primaryProductCategoryId="RUBBER" internalName="60-0506-11"
>>> productName="Support, engine" description="1933-36 Motor mount,  
>>> rear support.
>>> Replaces #836805." longDescription="1933-36 Motor mount, rear  
>>> support. Replaces
>>> #836805." taxable="Y" chargeShipping="Y" autoCreateKeywords="Y"  
>>> isVirtual="N"
>>> isVariant="N" fromDate="2001-05-13 12:00:00.0" />
>>>      <ProductPrice productId="60-0506-11"  
>>> productPriceTypeId="DEFAULT_PRICE"
>>> productPricePurposeId="PURCHASE" currencyUomId="USD"  
>>> productStoreGroupId="_NA_"
>>> fromDate="2001-05-13 12:00:00.0" price="93.20" />
>>> </entity-engine-xml>
>>>
>>> What do I need to add this part so it's in the webstore?
>>>
>>> Thanks
>>>
>>> --
>>> Walter
>>>
>>> _______________________________________________
>>> 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

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users