Read the fine manual. You probably want [item-data foo name] instead.
The [item-field name]
tag normally only references items in the products
table.
The reason for this is the scenario where you split your products over
multiple tables using the ProductFiles
directive, Perhaps you have one named new
and one used
, or one for several different vendors.
The [item-field ...]
tag will select the data from the first ProductFiles
entry that pertains.
If you want to call data from a specific table, use
[item-data table column]
.