Traceparts

You can, if you wish, transmit additional information about your products for the people who view your catalog.

The information you can transmit concerns the characteristics or โ€œattributesโ€ of your products.
An attribute is defined for a product. The values assigned to the attribute will be linked to your part number.

Templates are customized in two steps:

  • The first step is to declare an attribute by supplying a definition in the โ€œAttributes_Definitionโ€ tab so that the programs that will be processing the file recognize the element and know what to do with it;
  • The second step is to declare the attribute in the โ€œProducts_XXโ€ tab so that its values can be assigned.

Whatever the attribute type โ€“ dimensional or text โ€“ the template manages them in the same way. We will see, in the following examples, how to create different attributes. Before going any further, make sure you have fully understood the constraints on attribute identifiers.

The first step of the process is to declare attributes in the โ€œAttributes_Definitionโ€ tab.

Take a screw, for example. Screws are characterized by two main dimensional attributes: diameter and length. We want to add this information for each part number on our screw in the โ€œProductsโ€ tab.
The โ€œdiameterโ€ attribute of the screw is identified as โ€œDโ€; the โ€œlengthโ€ attribute is identified as โ€œLgโ€.
Screws are also characterized by their material attribute, so we also want to add this information for each part number of our screw. We will identify this material attribute as โ€œMATโ€. The key difference between the dimensional attributes and this material attribute is that the former have numeric values whereas the latter is a text attribute, and thus translatable.

  • Scroll down the table to the first unused row.
    By default, if you have not yet added an attribute, the first empty row is row โ€œ4โ€.
  • In the first column, โ€œAttribute_IDโ€, enter the identifier of the โ€œdiameterโ€ attribute: โ€œDโ€.
  • The following columns, which start with โ€œAttribute_Nameโ€, can be used to assign a name to the attribute.
    For example, suppose that with the wizard, you selected English and French; you therefore have 2 columns: โ€œAttribute_Name_ENโ€ and โ€œAttribute_Name_FRโ€.
    In the column โ€œAttribute_Name_ENโ€ you can specify the English name for the attribute, for example โ€œDiameter D (mm)โ€ (or just โ€œDโ€ if you prefer).
    In the column โ€œAttribute_Name_FRโ€, do likewise, but in French: โ€œDiamรจtre D (mm)โ€ (or just โ€œDโ€ if you prefer. Even if you already entered that for the English label, you have to enter it again for the French label).
    Remember that it is always advisable to include, in the attribute label, the symbol for the units in which the attribute is measured.
  • Fill the “Add_As_BOM_Field” with “1” to allow the corresponding attribute to displayed to the users (in the example below, both “MASS” & “QUANTITY” fields won’t be displayed to the users)
  • Repeat the procedure on the next row with the โ€œlengthโ€ attribute, identified as โ€œLgโ€
  • Repeat the procedure on the next row with the โ€œScrew Materialโ€ attribute, identified as โ€œMATโ€
  • Important: Do not leave any blank rows in the table between attribute declarations.
  • Example:
Attributes_Definition’s tab
 

For the second step of the process, we move on to the โ€œProducts_XXโ€ tab.

  • Find the first unused column (where the first row of the column is empty).
  • In the first row of this column, enter โ€œDโ€ โ€“ the identifier for the โ€œdiameterโ€ attribute.
  • Go to the next unused column.
  • In the first row of this column, enter the identifier for the second attribute, โ€œLgโ€.
  • These two new columns will be used to hold the values for the โ€œdiameterโ€ attribute and the โ€œlengthโ€ attribute respectively.
  • Go to the next unused column.
  • In the first row of this column, enter the identifier for the third attribute, โ€œMATโ€.
  • This new column will be used to hold the value for the โ€œmaterialโ€ attribute.
  • It only remains for you to complete the table by entering the diameter and the length of your screws against each individual part number. If you have selected more than one language in the wizard (as in our example), copy the attributes and values into each of your Products_XX tabs.
  • Complete the table by entering the material of your screws against each individual part number. In this case, if you have selected more than one language in the wizard, you will need to translate the values of the attribute in each of your Products_XX tabs (see example below).
  • Example (visble data are fictional)
     
Products_EN tab
Products_FR tab

As you progressively customize the file and add more attributes, some of the attributes will not be meaningful for certain products.
In this case, in the โ€œProducts_XXโ€ tab, leave the cells of these attributes empty for those part numbers to which they do not apply.
These attributes will be ignored in the products that do not use them.

Conversely, some attributes may be found in several products of completely different types (the โ€œcolorโ€ attribute, for example).
In this case, no need to create a separate attribute for each product: you can use a single unique attribute (identified, for example, as โ€œCOLORโ€) for all of the products.

Finally, bear in mind that you cannot have 2 identical identifiers in the same โ€œProducts_xxโ€ tab.
So if, for the previous example, we had used a bearing rather than a screw, we might have declared 2 diameter attributes, one for the internal diameter, and one for the external diameter.
If we had done so, we couldnโ€™t have identified them as โ€œDโ€ and โ€œdโ€. The programs would assume they were dealing with the same identifier, as they donโ€™t distinguish between upper and lower case.
The two attribute identifiers must therefore be distinct. For example, you might use โ€œDIA_EXTโ€ and โ€œDIA_INTโ€.
There is no such concern when it comes to the attribute names: they can take the values โ€œDโ€ and โ€œdโ€.

File structure > Customizing the template > Where will the data be displayed on the site?