7.3.3 Add buyer organizations to store member groups

7.3.3 Add buyer organizations to store member groups

When a buyer organization is registered through a particular store, that organization is automatically added to that store's member group. We created our buyer organizations through the Organization Administration Console. Now we have to complete the following steps to create accounts and contracts at our B2B direct stores for the buyer organizations.

1. Open a DB2 command window.

2. Connect to the WebSphere Commerce database.

3. Issue this command once for each Extended Sites B2B direct store:

db2 select mbrgrp_id from mbrgrp where mbrgrpname = `RegisteredCustomers' and owner_id = (select member_id from storeent where identifier = `<store identifier>')
Our store identifiers are SWG and IGS.

4. Record the results.

5. Issue this command once for each buyer organization:

db2 select orgentity_id from orgentity where orgentityname = `<buyer organization name>'
Our buyer organizations are IBM, SWG, and IGS.

6. Record the results.

7. Create entries in the MBRGRPMBR table for each required combination of store and buyer organization.

Note: This creates a business account in each store for IBM and a contract for the suborganization.

8. We issued the following insert command four times: to make the buyer organizations of IBM and SWG part of the Registered Customer member group for the SWG store, and to make the buyer organizations of IBM and IGS part of the Registered Customer member group for the IGS store.

The syntax for the insert command is:
db2 insert into mbrgrpmbr (member_id, mbrgrp_id) values (<buyer org>, <store>)

9. Make sure that you commit the changes when you are finished.

10. Close the DB2 command window.

ibm.com/redbooks

+
Search Tips | Advanced Search