Manual

Login

Manual

3.2.17. Classification according to CNSORDERNO / CNSTYPECODE 3.2.17.1. Use of CNSORDERNO and CNSTYPECODE with examples
Prev	Next

3.2.17.1. Use of CNSORDERNO and CNSTYPECODE with examples

Classification according to CNSORDERNO or CNSTYPECODE?

CNSORDERNO = Order number (article number) describes a fixed defined catalog product, where each product corresponds to a fixed PARTsolutions project row.

Common product fields are: Angles, switches, bolts, nuts, etc.

Example project without value ranges
CNSTYPECODE = Type code (article code / order code) describes a configurable product (with possibly complex set of rules), where the product corresponds to a table row with value range (one or several yellow fields) and a type code / key resulting from it.

Common product fields are: Cylinders, motors, gears, linear modules, if configurable and customizable.

	Note
Note/special cases In old catalogs/projects it is possible that there is no variable for article number or article code. In these cases the variable LINA can be used for the classification. This solution is NOT intended as default, but in fact only as solution for old projects. Furthermore please regard that the use of LINA can be unfavorable in some cases. Example: Primary / Secondary Key (Code / Type) Article number: 158473 -> CNSORDERNO classification. Article code: DNC-100-63-PPV-P -> CNSTYPECODE classification. LINA: 158473 (DNC-100-63-PPV-P) -> If LINA maps both article number and code, then it cannot be used individually as CNSORDERNO or as CNSTYPECODE.

Note

Note/special cases

In old catalogs/projects it is possible that there is no variable for article number or article code. In these cases the variable LINA can be used for the classification.

This solution is NOT intended as default, but in fact only as solution for old projects. Furthermore please regard that the use of LINA can be unfavorable in some cases.

Example:

Primary / Secondary Key (Code / Type)

Article number: 158473 -> CNSORDERNO classification.

Article code: DNC-100-63-PPV-P -> CNSTYPECODE classification.

LINA: 158473 (DNC-100-63-PPV-P) -> If LINA maps both article number and code, then it cannot be used individually as CNSORDERNO or as CNSTYPECODE.

Example project with value ranges (yellow fields)

Enter article number in eCATALOGsolutions correctly

	Note
	In the case of leading zeros in the article number please regard the exact use on the manufacturer side, otherwise searching and attribute mapping won't work.

Manufacturer uses four to six-digit numbers without leading zeros. On the side of PARTsolutions please regard, not to fill up with zeros.

Negative example from PARTsolutions table: Erroneously, it was filled up with zeros.

Manufacturer Website

Manufacturer always uses a six-digit article number (also with leading zeros). In this case, in PARTsolutions, the zero must be contained in the catalog.

Hidden variables can also be used for a mapping. The variable is considered when indexing and can be searched.

Prev	Up	Next
3.2.17. Classification according to CNSORDERNO / CNSTYPECODE	Home	3.2.17.2. Benefits of classification according to CNSORDERNO and CNSTYPECODE

Manual

Login

Top Links

Manual

3.2.17.1. Use of CNSORDERNO and CNSTYPECODE with examples