Product Data Format Table
| Field Name |
Field Description |
Data Type |
Size | Sample Data | Notes |
|---|---|---|---|---|---|
| product_container | Product Information | ||||
| caption* | Name or heading for a product. | String | 255 | “Great Product!” |
This is the value that appears throughout the CRMS, wherever a user sees product information. |
| department* |
Client defined department (category) hierarchy. |
TIBCO Reward supports at most five department levels. These categories are used for targeting, reporting, and offer qualification. |
|||
| department_l evel_1* |
Top-level product category |
String |
100 |
“Books” “DVDs” “CDs” “Software” “Toys” |
The range of values for this field across all products are the categories available in the Shopper Application for the “What I Like” functionality. These same values appear in the “Preferred Category Breakdown” report. |
| department_l evel_2 |
Second-level product category |
String | 100 | “Fiction”, “Books”, “DVDs”, “CDs”, “Periodicals” “Fantasy” “Educational” | If Department_Level_2 is specified, Department_Level_1 is required. |
| department_l evel_3 | Third-level product category |
String |
100 | “Mysteries”, “Fantasy” “Financial” “Cooking” “Jazz” “automotive” | If Department_Level_3 is specified, Department_Level_2 is required. |
| description* | Human Readable Description |
"Complete New Collection" |
|||
| image_url | URL to an image of the product. | String | 100 | http://example.com/ image.gif | This image is available when creating new offers and when adding rewards to the Reward Catalog. |
| sku* | Required, must be unique. SKU, stock keeping unit, or product number. | String | 100 | “S1000001 23” |
Catalog management (additions, removal) is done on SKU, which must be unique. This appears in most of the application where product name (caption) does. This SKU does not correspond to the SKU used in the Rewards Catalog. |
| list_price* |
List price of product. i.e. The manufacturer's suggested retail price. |
Decimal |
15.23,34.78 | ||
| sale_price | Sale price of product. This is the price the customer should pay for the product. | Decimal | 12.23,31.78 | ||
| brand | brand | String | 100 | Maytag |
Brand used for targeting. |
| CustomDateTi meValueLastC hangedDateTi me | Date Time | 19 |
2007-01-17 14:22:01. 032 |
The last time a custom date field was changed for this product, cumulative across all product custom date/time fields. | |
| CustomDateTi meName1 | String | 100 | Shipment Received |
The name of the first date/time custom attribute, as defined in CRMS: in this case, "ShipmentReceived". The line can be omitted from the file if a custom attribute is not defined. |
|
| CustomDateTi meValue1 | Date Time |
19 |
2012-07-19T00:00:01.065 |
The value of the 1st date/time custom attribute for this product. A Custom Attribute line can be omitted from the file if a custom attribute is not defined. Can be blank if not defined. |
|
| CustomDateTi meName2 | String | 100 | ReleaseDate | The name of the second date/time custom attribute, as defined in CRMS: in this case, " ReleaseDate ". Line can be omitted from the file if a custom attribute is not defined. | |
| CustomDateTi meValue2 |
Date Time |
19 |
2012-07- 01T00:00 :00.001 |
The value of the second date/time custom attribute for this product. Line can be omitted from the file if a custom attribute is not defined. |
|
| Name and value columns repeat for third through 19th attributes | |||||
| CustomDateTi meName20 | String | 100 |
The name of the 20th date/time custom attribute, as defined in CRMS. Line can be omitted from file if a custom attribute is not defined. |
||
| CustomDateTi meValue20 |
Date Time |
19 |
The value of the 20th date/time custom attribute for this product. Can be omitted if not defined. |
||
| CustomNumericValueLastChangedDateTime |
Date Time |
19 | The last time a custom numeric field was changed for this product, cumulative across all custom numeric fields. | ||
| CustomNumeri cName1 | String | 100 |
StorageCa pacityIn Gigabyte s |
The name of the 1st numeric custom attribute, as defined in CRMS: in this case, " StorageCapacityInGigabytes".. Can be blank if not defined. | |
| CustomNumeri cValue1 | Decimal | 10 | 20 |
The value of the first numeric custom attribute for this product. Can be blank if not defined. |
|
| CustomNumeri cName2 | String | 100 |
GenericD ollars |
The name of the second numeric custom attribute, as defined in CRMS. Can be blank if not defined. | |
| CustomNumeri cValue2 | Decimal | 10 | 128.94 |
The value of the second numeric custom attribute for this product. Can be blank if not defined. |
|
|
Name and value columns repeat for third thru 19th attributes |
|||||
| CustomNumeri cName20 | String | 100 |
The name of the 20th numeric custom attribute, as defined in CRMS. Can be blank if not defined. |
||
| CustomNumeri cValue20 |
Decimal |
10 | The value of the 20th numeric custom attribute for this product. Can be blank if not defined. | ||
| CustomLookup ValueLastChan gedDateTime |
Date Time |
19 | The last time a custom lookup field was changed for this product, cumulative across all custom lookup fields. | ||
|
CustomLookup Value1 |
String | 45 |
Winter Collection |
The value of the first lookup custom attribute for this product. Can be blank if not defined. |
|
|
CustomLookup Name2 |
String | 100 |
The name of the second lookup custom attribute, as defined in CRMS. Can be blank if not defined. |
||
|
CustomLookup Value2 |
String | 45 | The value of the second lookup custom attribute for this product. Can be blank if not defined. | ||
| Name and value columns repeat for third thru 19th attributes. | |||||
|
CustomLookup Name20 |
String | 100 |
The name of the 20th lookup custom attribute, as defined in CRMS. Can be blank if not defined. |
||
|
CustomLookup Value20 |
String | 45 | The value of the 20th lookup custom attribute for this product. Can be blank if not defined. | ||
|
CustomTextVa lueLastChange dDateTime |
String | 100 | The last time a custom text field was changed for this product, cumulative across all custom text fields. | ||
| CustomTextNa me1 | String | 100 | The name of the first text custom attribute, as defined in CRMS. Can be blank if not defined. | ||
| CustomTextVa lue1 |
String |
100 |
The value of the first text custom attribute for this product. Note: Only the first 100 characters of the text custom attribute fields are included in the Export file. |
||
| CustomTextNa me2 | String | 100 |
The name of the second text custom attribute, as defined in CRMS. Can be blank if not defined. |
||
| CustomTextVa lue2 | String | 100 | The value of the second text custom attribute for this product. Note: Only the first 100 characters of the text custom attribute fields are included in the Export file. | ||
| CustomDateTi meName3 | String | 100 |
The name of the third date/time custom attribute, as defined in CRMS. Line can be omitted from the file if a custom attribute is not defined. |
||
| CustomDateTi meValue3 |
Date Time |
19 |
The value of the third date/time custom attribute for this product. Line can be omitted from the file if a custom attribute is not defined. |
||
| Name and value columns repeat for fourth through 19th attributes | |||||
| CustomDateTi meName20 | String | 100 |
The name of the 20th date/time custom attribute, as defined in CRMS. Line can be omitted from the file if a custom attribute is not defined. |
* Required