Name

MV_OPTION_TABLE — name of database for product options

SYNOPSIS

{ database }

DESCRIPTION

If the Interchange variable MV_OPTION_TABLE is not set, it defaults to "options", which combines options for Simple, Matrix, and Modular into that one table.

VARIABLE TYPE

Catalog variable

EXAMPLES

No examples are available at this time. We do consider this a problem and will try to supply some.

NOTES

The term database in Interchange lingo has a different meaning as in common language, please check database for more information.

AVAILABILITY

MV_OPTION_TABLE is available in Interchange versions:

4.6.0-5.7.0 (git-head)

SOURCE

Interchange 5.7.0:

Source: lib/Vend/Options.pm
Line 104 (context shows lines 94-108 in find_options_type():61)

        };
    $item->{$attrib} = tag_data($tab, $field, $sku);
  }
  $module = $item->{$attrib} || '';
}
else {
  ## Old style options
  my $loc = $Vend::Cfg->{Options_repository}{Old48} || {};
  my $table = $opt->{table}
        ||= (
            $loc->{table} || $::Variable->{MV_OPTION_TABLE} || 'options'
        );
  my $db = $Vend::Interpolate::Db{$table} || database_exists_ref($table)
      or return;
  $db->record_exists($sku)

Source: lib/Vend/Options/Simple.pm
Line 152 (context shows lines 142-156 in display_options():138)


$loc ||= $Vend::Cfg->{Options_repository}{Simple} || {};
my $map = $loc->{map} || {};

my $sku = $item->{code};

my $db;
my $tab;
if(not $db = $opt->{options_db}) {
  $tab = $opt->{table} ||= $loc->{table} 
             ||= $::Variable->{MV_OPTION_TABLE}
             ||= 'options';
  $db = database_exists_ref($tab)
    or do {
      logOnce(

Source: lib/Vend/Options/Old48.pm
Line 87 (context shows lines 77-91 in display_options_matrix():77)

sub display_options_matrix {
my ($item, $opt, $loc) = @_;

$loc ||= $Vend::Cfg->{Options_repository}{Old48} || \%Default;
#::logDebug("Matrix options by module, old");
my $sku = $item->{mv_sku} || $item->{code};
my $db;
my $tab;

if(not $db = $opt->{options_db}) {
  $tab = $opt->{table} || $::Variable->{MV_OPTION_TABLE} || 'options';
  $db = database_exists_ref($tab)
    or do {
      logOnce(
          "Matrix options: unable to find table %s for item %s",

Source: lib/Vend/Options/Old48.pm
Line 359 (context shows lines 349-363 in display_options_simple():348)

my ($item, $opt) = @_;
#::logDebug("Simple options, item=" . ::uneval($item) . "\nopt=" . ::uneval($opt));
my $map = $opt->{options_map} ||= {};
#::logDebug("Simple options by module, old");

my $sku = $item->{code};
my $db;
my $tab;
if(not $db = $opt->{options_db}) {
$tab = $opt->{table} ||= $::Variable->{MV_OPTION_TABLE_SIMPLE}
           ||= $::Variable->{MV_OPTION_TABLE}
           ||= 'options';
$db = database_exists_ref($tab)
  or do {
      logOnce(

AUTHORS

Interchange Development Group

SEE ALSO

DocBook! Interchange!