Hello !

I have some questions concerning a proper way doing that...

I have 2 subscriptions plans.

1-Free for buyers.Registering without any Cbsub plan, directly to VirtueMart registration.

2-Paid for sellers, using a sub plan. Those sellers will also populate a new manufacturer, and an acount to sell products thru VM at registration.

Will an SQL action might populate the VM tables from CB fields previously entered at registration ? (I mean adress, name etc... that would have been the same into CB and VM, plus special from CB, but not used into VM directly)

The CbVM plugin just gives access to a user group, deleting group at cancel,and a shopper group.

So it might not be usefull, and better to use SQL Action instead ? Am I right ?
Unless you are planing to improve CbSubVM plugin ? If yes, in wich way?


If my free registering users are using VM, what happen if I use synchronize tool from CB ? (I'll test it, but I wanted to know more if you have any informations about that...)
I may need to make a sub plan finally for free users, to get a cleaner solution I guess...

Also, there are those solutions, untested yet :
joomlacode.org/gf/project/vmart_cb/frs/
www.southlasalle.com/forum/viewtopic.php?f=5&t=81&start=0&st=0&sk=t&sd=a

I'm also testing this:
www.nordmograph.com/shop/details/62/6/featured-products/vmvendor-suite-for-community-builder.html

To understand better how to populate product from front office to VM...

If someone got tested any part of the solution, or have any usedfull thinking...
Cos my mind is about to explode...^^

Post edited by: krileon, at: 2009/09/28 03:31

First, thanks Kyle for your support !

You surely know that mixing CB/VM/Joomfish etc...is just a nightmare for noobs like me

I'm fed up with all those part time working plugins (ok, they're free...so let's say I'm fed up with great stuffs that almost works, at the moment...)

So, it seems SQL actions may solve a big part of my actual problems...

What I need to do is populating from CB fileds the equivalent of VM fields used for oredering while register.

I'll see that tomorrow, but basicaly I just need a query to update the fields populated from cb.
Could you provide an example of that query ?

A kind of "set vm_vendor vm_name=$cb_name and vm_adress=$cb_adress and ..."

Thanks !

Just a postit message, tables related to users into VM:

jos_core_acl_aro2
jos_core_acl_groups_aro_map
jos_users
jos_vm_auth_user_vendor
jos_vm_shopper_vendor_xref
jos_vm_user_info

Found on french J! forums.

I also need to generate an user_info_id into `jos_vm_user_info`.

Might be something like (???):
[code:1]
UPDATE `#__vm_user_info` SET `user_info_id` = 'md5(uuid())',`first_name` = '[first_name]', `last_name` = '[last_name]', `phone_1` = '[cb_telephone]', `address_1` = '[cb_addresse]' WHERE `user_id` = [user_id][/code:1]

But it give me too much headaches, the free users/buyers will register thru normal VM form...