1WorldSync Basic Categorization

Description

All products captured by 1WorldSync are classified into categories. These categories are defined by the type of products they will regroup and one PDM (Product Data Model) will be attributed to each category to describe the features of these products.

Example:

Class: “A Systems”

Category: “AA Desktop & Servers”

Database Structure

The Cds_Cctxx table is the vocabulary table which contains all classes and category descriptions. A product’s category can be determined by joining the Prod
table to the Cctxx table. All categories are represented by a two-letter code while classes are represented by a single letter code in cds_Cctxx.

cds_Cctxx

cds_Prod

Related Queries

Here’s a query to export the class and the category for a product.

SELECTLEFT(p.catid,1)AS[Class ID],

c1.descriptionAS[Class Name],

p.catid AS[Category ID],

c2.descriptionAS[Category_name]

FROMcds_prodp

JOINcds_cctxxc1ONLEFT(p.catid,1)=c1.id

JOINcds_cctxxc2ONp.catid=c2.id

WHERE p.prodid=’PRODUCTID’