[ic] RE: Multiple product file woes.

Jerry Brady interchange-users@icdevgroup.org
Thu Oct 10 17:08:01 2002


My catalog(4.8.6) has two product tables in MySQL: products and
spot_products.

Catalog.cfg contains: "ProductFiles products spot_products" and I've
commented out the include directive for after.cfg.

No matter how hard I try, however, using the default processing for
adding items to the cart with mv_order_item and mv_order_quantity,
Interchange won't pull items in from the second products table,
spot_products.

I've even set mv_order_mv_ib to "spot_products" on the cart submission
page and verified that [data spot_products sku] exists, but the item
won't show up in the cart.

I've resorted to hacking at the Interchange source and inserting some
instrumentation and I'm confused by the fact that given my configuration
$Vend::Productbase does not contain an entry for "spot_products".

At the call to product_code_exists_tag() in Data.pm (which is called
from add_items() in Order.pm, I get the following debug output:

Vend::Data:debug: product_code_exists_tag(SKU-456525, spot_products)
  (invoked with the sku and the "base" products table name to search)

But, an ::uneval of @Vend::Productbase shows only two hashes: 

'options' and 'products' with no sign of 'spot_products' being added to
the hash.

So, I added code to update_productbase and it isn't seeing my second
products table "spot_products" either upon initialization.

I'm amazingly confused as to what is going on. 

- Jerry