OFBiz
  1. OFBiz
  2. OFBIZ-72

UN/SPSC Product classification datafiles

    Details

    • Type: New Feature New Feature
    • Status: Reopened
    • Priority: Trivial Trivial
    • Resolution: Unresolved
    • Affects Version/s: Trunk
    • Fix Version/s: None
    • Component/s: product
    • Labels:
      None
    • Environment:

      N/A

      Description

      I need it for one of our project so I think it can usefull for other OFBiz users.

      Here a description of UN/SPSC :
      The United Nations Standard Products and Services Code®
      (UNSPSC®) provides an open, global multi-sector
      standard for efficient, accurate classification of
      products and services. Search the code on this website
      to locate commodity codes that can be used by your company.

      The UNSPSC offers a single global classification system
      that can be used for:

      • Company-wide visibility of spend analysis
      • Cost-effective procurement optimization
      • Full exploitation of electronic commerce capabilities
      1. ProductCategoryUNSPSCData_fr_FR.zip
        272 kB
        Jacques Le Roux
      2. ProductCategoryUNSPSCData_fr_FR.xml
        2.63 MB
        Yannick Thebault
      3. ProductCategoryUNSPSCData_en_US.zip
        239 kB
        Jacques Le Roux
      4. ProductCategoryUNSPSCData_en_US.xml
        2.51 MB
        Yannick Thebault

        Activity

        Hide
        Yannick Thebault added a comment -

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

        Show
        Yannick Thebault added a comment - This issue is just additional datafile for OFBiz. I don't think it is necessary to add these files to run-install target
        Hide
        Chris Howe added a comment -

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

        Show
        Chris Howe added a comment - Interesting... Is there any signifigance of the productCategoryId or any hierarchial structure to the categories?
        Hide
        BJ Freeman added a comment -

        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"/>

        Show
        BJ Freeman added a comment - 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"/>
        Hide
        BJ Freeman added a comment -

        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"/>

        Show
        BJ Freeman added a comment - 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"/>
        Hide
        Yannick Thebault added a comment -

        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

        Show
        Yannick Thebault added a comment - 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
        Hide
        Yannick Thebault added a comment -

        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.

        Show
        Yannick Thebault added a comment - 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.
        Hide
        David E. Jones added a comment -

        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...
        Show
        David E. Jones added a comment - 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...
        Hide
        BJ Freeman added a comment -

        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.

        Show
        BJ Freeman added a comment - 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.
        Hide
        Scott Gray added a comment -

        Shouldn't this issue be moved to product component?

        Show
        Scott Gray added a comment - Shouldn't this issue be moved to product component?
        Hide
        Jacques Le Roux added a comment -

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

        Show
        Jacques Le Roux added a comment - I wonder why they did not create a taxinomy ! I think zipped versions may be useful...
        Hide
        Jacques Le Roux added a comment -

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

        Show
        Jacques Le Roux added a comment - Are you ok to commit these files but no put them in seed or demo ?
        Hide
        Jacques Le Roux added a comment -

        Not sure what to do with that...

        Show
        Jacques Le Roux added a comment - Not sure what to do with that...
        Hide
        David E. Jones added a comment -

        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.

        Show
        David E. Jones added a comment - 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.
        Hide
        Jacques Le Roux added a comment -

        HI David,

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

        Thanks

        Show
        Jacques Le Roux added a comment - HI David, Now I'm sure I'm not the only one to care about that one ;o) Thanks
        Hide
        Liu Xiangqian added a comment -

        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.

        Show
        Liu Xiangqian added a comment - 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.

          People

          • Assignee:
            Unassigned
            Reporter:
            Yannick Thebault
          • Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development