This issue is just additional datafile for OFBiz. I don't think it is necessary to add these files to run-install target

Interesting... Is there any signifigance of the productCategoryId or any hierarchial structure to the categories?

http://www.unspsc.org/
from what I read the Code number they have is important
http://www.unspsc.org/Search.asp

I would think this would be better under GoodIdentification

<GoodIdentificationType goodIdentificationTypeId="SPSC" hasTable="N" description="UNSPSC global classification system" lastUpdatedStamp="2006-06-18 02:49:54.453" lastUpdatedTxStamp="2006-06-18 02:49:54.273" createdStamp="2006-04-03 19:15:15.517" createdTxStamp="2006-04-03 19:15:12.713"/>

<GoodIdentification goodIdentificationTypeId="SPSC" productId="GZ-1000" idValue="10000000" lastUpdatedStamp="2005-07-12 06:31:15.251" lastUpdatedTxStamp="2005-07-12 06:31:14.897" createdStamp="2005-07-12 06:31:15.251" createdTxStamp="2005-07-12 06:31:14.897"/>

OOPS
<GoodIdentificationType goodIdentificationTypeId="SPSC" hasTable="y" description="UNSPSC global classification system" lastUpdatedStamp="2006-06-18 02:49:54.453" lastUpdatedTxStamp="2006-06-18 02:49:54.273" createdStamp="2006-04-03 19:15:15.517" createdTxStamp="2006-04-03 19:15:12.713"/>

<UNSPC ID="10000000" Description="Live Plant and Animal Material and Accessories and Supplies " lastUpdatedStamp="2006-06-18 02:49:54.453" lastUpdatedTxStamp="2006-06-18 02:49:54.273" createdStamp="2006-04-03 19:15:15.517" createdTxStamp="2006-04-03 19:15:12.713"/>

Sorry for late answer but I was very busy last week.

To Chris : No there is no hierarchical structure in UN/SPSC. Every Product Categories defined in UN/SPSC are on same level (ie Product level in product catalog).

To BJ : I thought a long time to your comment and I read again UN/SPSC documents and my conclusion is : UN/SPSC is only defined for product category because it has to be used to classifed products. So I don't think GoodIndentificationType usage is a good solution.

But I know that usage of more than 20000 Product Categories can occurs some performance problem with OFBiz (try to go to Catalog main page after the load of UN/SPSC. You'll send 20000 row in the search drop-down )

Yannick

1 more thing I forgot :
I can find UN/SPSC in spanish and japanese but I can't garantee that these data are all good because I don't speak spanish and japanese.

I agree that the ProductCategory is probably the best place for these.

A couple of thoughts:

• the ProductCategory is probably the best structure for this, though we could consider using something like the ProductFeature/ProductFeatureAppl

• for the ProductCategory simply set the showInSelect field to N to avoid having those show up in the drop-downs

• we might want to consider starting to change the ProductCategory drop-downs to look up windows...

As a practical thing, I find most cataroies are short and descriptive of the products under them.
Maybe find a association other than goodIdentification to the category.
this is to say, this catagorey is associated with this UN/SPSC code.

Shouldn't this issue be moved to product component?

I wonder why they did not create a taxinomy !
I think zipped versions may be useful...

Are you ok to commit these files but no put them in seed or demo ?

Not sure what to do with that...

I'd say let's not be too hasty about closing this sort of issue just because it hasn't made it in yet. These are still of value and should be considered, and having open issues doesn't kill us.

HI David,

Now I'm sure I'm not the only one to care about that one ;o)

Thanks

Actually UNSPSC is a tree structure, so there should be a parentCategory for each category except the first level, the rule is

a category with code 11111111 is a child category of 11111100, and 11111100 is a child category of 11110000, then 110000 etc.

So we could easily decide the tree structure of the codes.

I am also seeking a way to load UNSPSC as product category in ofbiz.