[mv] How to: multiple product tables, ProductFile, CommonAdjust

[Barney Treadway <barney@wttech.com>]

******    message to minivend-users from Barney Treadway <barney@wttech.com>     ******

Just thought I'd consolidate the multiple product database process for those
of little brain (like myself). Everything is in the docs and mailing list
but it took me a while to get it all together and I though I might save
someone else the trouble.

QUEST: I'm adding a similar mysql table/database to products called
products2. I'm running 3.14.

1) I created an empty mysql table called products2 with same
username/password as products.

2) I copied products.asc to products2.asc

3) To my catalog.cfg I added --

Database      products2 products2.asc dbi:mysql:mydatabase:localhost:3306
and
Database    products2 USER   billybob
Database    products2 PASS   secretword

4) Added the this line inside my catalog.cfg --

## Say your prayers boys
ProductFiles    products lodging

5) At Common Adjust in catalog.cfg I added ;products2:price like so...

CommonAdjust   pricing:q2,q5,q10,q25,q100, ;products:price, ==color:pricing,
==size:pricing, ;products2:price,

6) Then reconfigured catalog, and bless my soul everything was peachy. MV
grabs fields from products2 just like products and check out goes as it
should.

I haven't yet done the modifiers, but thought I'd share this. I'm sure
there's different (ie better) ways to accomplish this but in the
meantime....

Barney Treadway

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list