Running VM 2.0.7d, Joomla 2.5.3 on Apache & Linux
Long story short, finished off a large virtuemart install, lots of config and fiddling etc. but all running etc. All of a sudden now when new users are made in the Administrator they arent showing up as VM shoppers.
This is an issue as my client has certain shoppers they want to create themselves with elevated privileges (shopper group).
Have tried:
Install or Update tables button
Dropping all user related tables then using said button to recreate
Dropping ALL virtuemart tables and recreating via the tools
Downgrading, upgrading virtuemart + joomla (was running J! 1.7.3)
Upgrading virtuemart AIO component and etc's.
Users created through the Joomla frontend also dont get added as shoppers UNLESS added through Virtuemart itself.
If a shopper could be added directly through the Virtuemart admin there wouldnt be any problems...
Users without any shoppergroup are automatically in the default shoppergroup.
Thats not the problem. Theres NO SHOPPER AT ALL for new users now. Before it would add a shopper albeit with lots of missing details (as expected).
Our client has 'special' users that they are making themselves and setting a different shopper group to.
Quote from: Mole on May 31, 2012, 08:05:48 AM
All of a sudden now when new users are made in the Administrator they arent showing up as VM shoppers.
What means you made a new user in the BE? Just create a user in joomla and you will see it appears as shopper, because it just uses the joomla list.
I create a new user in the Joomla admin and it does not show in shoppers. Doesn't matter if its FE or BE.
I can send you some Joomla admin details if you want to check it out yourself.
Okey, then do that.
Sorry, been busy, have PMd details.
Bump... still no fix for this.
Have tried updating to the latest Virtuemart and Joomla again, no improvement.
Looking at the vmusers table there are currently 13 entries but only 11 show up on the shoppers page - there are 16 actual users.
I have come across the same issue - tested -
This is my test site with - standard VM , VM template and all VM standard test products.
1/ Image one is the Joomla registered users
2/ Image two is VM users after a page refresh
What happens is that they do not show up in the VM shop until they are logged in- and fixed all their address information.
* so the first time they come to my shop - they use their user name and password - and then their information is requested to be filled in.
* then when that is all complete they appear on the VM list .
* I'm sure this not the way that is expected but it works ? Mole could you test and see if that works for you too.
Looking for ID 54
[attachment cleanup by admin]
Thanks, I'll give that a try, if it works then at least that's a decent workaround for my issue.
Edit: That method worked well, thanks for the suggestion!
Hi guys. I had the same issue. My VM version is 2.0.8e / Revision: 6286. I solved it by replacing the file administrator/components/com_virtuemart/models/users.php with the same file from an older VM version (2.0.6 / Revision: 5917). Worked for me!!!
i have the same problem.i use now virtuemart 2.0.10 with joomla 2.5.6, but the problem stay. :(
i replace the user.php file with a older one but not solve my problem.any solution for this problem?????
oh heavens, please dont replace the usermodel with an old version. :o For me it works. And it is not connected to the userinfo.
If it is connected to something then the __virtuemart_vmuserstable and the __virtuemart_vmuser_shoppergroups, we use:
SELECT DISTINCT .... FROM #__users AS ju
LEFT JOIN #__virtuemart_vmusers AS vmu ON ju.id = vmu.virtuemart_user_id
LEFT JOIN #__virtuemart_vmuser_shoppergroups AS vx ON ju.id = vx.virtuemart_user_id
LEFT JOIN #__virtuemart_shoppergroups AS sg ON vx.virtuemart_shoppergroup_id = sg.virtuemart_shoppergroup_id
You may try the attached file (BE/models, rename to user.php). I enhanced a bit the sql, should work robuster now.
[attachment cleanup by admin]
Milbo, I tried the file you uploaded, and received the following error:
QuoteFatal error: Call to undefined method VirtueMartModelShopperGroup::appendShopperGroups() in /home/content/28/9553028/html/administrator/components/com_virtuemart/models/user.php on line 172
I'm running J 2.5.6 and VM 2.0.10. I have the same response as John2400. Once the user adds their billing address, they get added to the shopper list.
Once this is solved, I'd like to know how to add missing users to the shoppers list.
Thanks for your help.
I just saw your post .
I updated to 2.0.11 try that - I think a few registration issues were solved here - just test for me and then post again.
_stu my error, I forgot that i should have sent two files, but both changes are in 2.0.11
Having the same issue as _stu. I updated to 2.0.11d. Joomla users and VM users are still not in sync. Any help would be greatly appreciated. Thanks!
Edit* Here are some additional details of what we see happening on our end...
If I add a 'test' user to joomla, login to the FE and enter their address and other required fields in Account Maintenence they will show up in the VM user list. If I then remove the 'test' user from Joomla's user list, it will disappear from VM's user list. So it looks like it is syncing on some level just not on the addition of new users via Joomla's User Manager.
The workaround is fine, but exhausting when you have a large number of users that need to be updated. Please let me know if this should be working now in 2.0.11d or can be fixed in another release. Thanks again!
Hi, i have the same problem.i use now virtuemart 2.0.12 with joomla 2.5.7, but the problem stay. I can use VM only 2 user (admin and a new user).
hello, I've got the same problem
I update to joomla 2.5.7 and VM 2.0.12b and now shoppers are not added automatically.
My shop allow users to register with an admin approuval and that process always works. In my shop, I disabled the fact users can change their adress during checkout because I did it manually when a user was created.
But now, first i can't because shopper is not created but updating VM i've got now links to shipping adress but it redirects to homepage with no errors. I added a shipping adress menu link to and it's the same
if anyone has any idea
thanks
The shoppers are created, they are just not displayed, since in vm shoppers are only displayed if the joomla user is stored one time.
I'm not sure I understand. What do you mean by 'shoppers are only displayed if the joomla user is stored one time? Can the shoppers be displayed in VM by default upon creation in joomla's user manager?
well in fact now shoppers are not added automatically when they register from joomla.
Before it worked and i updated their data but now it seems that the shopper has to connect and fill its data in order we can see it shoppers list.
How and wich file could i hack this ?
I'm using 2.08c and i tried 2.012 and it's the same
thanks
Same problem here!
When I create 2 users (Admin is already there and set as vendor) in usermanager only the second shows up. If I delete this one, the fist suddenly pops-up. If I fill the missing fileds and save, the second also shows up. This is strange behaviour and a rather large bug! Hope someone has a fix very quick. This problem occurs in three different shops with VM 2.0.12b and Joomla 2.5.7.
Anybody any other suggestions how to solve this issue?
Same problem here. Updated to 2.0.10 (joomla 2.5.7) on test website some days ago and managed to get new users synced again after the update broke it. Part of the solution was to delete all users through the joomla usermanager, but the admin (42). Test users will show up in virtuemart as soon as you edit part of the details through frontend virtuemart (address, etc). Problem is recurring after 2.0.12b update. Kinda is a serious problem (bug?). Will post if i find a decent solution.
Another situation:
I did a fresh, brand new test install of Joomla 2.5.7 and vm 2.0.12b about a week ago. Created a 2nd Joomla user as manager/administrator/registered. It is seen by 2.0.12b as a storeadmin BUT it does not display/show/list any orders placed. The area where the orders are supposed to be listed is just blank. I never filled in the 2nd user details. So, 2nd user never "registered" in VM.
Updated a moment ago to 2.0.12e hoping that the 2nd user, the storeadmin could see orders, but same story as above. Now, reading the problems with new users and sync, etc. I created a 3rd user. This 3rd user was created as a superuser. It sees everything in the backend but as soon as I downgraded its access to manager/administrator/registered it became a simple shopper in VM. Is that correct? Why didn't it become storeadmin?
Added a 4th user in Joomla with manager/administrator/registered rights. VM sees it as a storeadmin. It can't see any orders either. Why can't storeadmins see any orders? I don't understand.
Update:
After posting this message I went directly to virtuemart_vmusers in the database and edited the information for the 2nd user. I changed the field 'perms' from -shopper- to -admin- and now 2nd user can see orders. But this is a hack and should not be the case.
I too am having this MAJOR problem, just updated to the latest 2.0.12f version of VM and AIO and the problem persists.
when a user creates an account the joomla account is created disabled and non-activated, no email is sent and the user does not appear in Virtuemart.
It seems if the user is manually enabled (no email is sent still) and I manually activate the user and do a password request then the user can then login (although still does not appear in VM until they create shipping details)
The user can then shop.
This is a MAJOR issue, I cannot possibly sit here enabling, activating and doing a forgot password request for every user as they sign up, it sort of defeats the point of having an automated shopping cart doesn't it !
Help please someone,
Mike
Updated to the latest version of Virtuemart 2.0.12f and we still have the same problem as described in this thread. Only 2 shoppers of the 200+ Users we have in Joomla were added to Virtuemart. This is such a major bug in VM2 that I can't believe you haven't solved this yet.
Please let us know how we can fix this.
Thanks!
You have a completly misunderstanding of the usermanagment in vm.
Every joomla user is automatically a virtuemart user, just without the vm specific data, except the shoppergroup and perms, which are taken from the default values. Perms are taken from the joomla values anyway. So your users dont need to be "in" vm. it is not a bug! It is meant that way. The problem is, otherwise you have a lot users, you think they are shoppers, but they are just joomla users. So joomla users should be handled in joomla and shoppers, people who bought in your store in vm.
So how can I assign shopper groups to the Joomla users without being able to 'see' them in the Shoper section?
We're working on a new version of an already existing webshop. They have a whole bunch of wholesalers who need to be assigned a shopper group in order to receive special discounts. So, yes I want all Joomla users to automatically become shoppers, since this is a pure online shop...
Oh, there are around five users we created with which we have actually placed orders. The orders have been registered, the details have been entered and they are still not shown in the Shopper section.
Hi Milbo,
Please find the two attachments...as you can see...long list of Joomla Users....short list (only 3) of VM Shoppers. How can I import the Joomla Users to VM2 Shoppers and/or make them visible to be able to edit the details in the background and give them special front end permissions, e.g. assign a VM Shopper Group to them.
Thank you very much.
[attachment cleanup by admin]
I can confirm that this is also a problem on my site. Users added to Joomla do not appear as Shoppers in VirtueMart. They do however appear when I try and edit a Shopper's info. Once I try and save an error will appear but the hidden Shoppers mysteriously appear.
What's going on here?
Okey, I think I must explain this a bit more.
The first idea is that the list in virtuemart is the "shopper" list, while the list of joomla is the "user" list. Shoppers are usually only people who already bought in your shop, therefore we show only people who used the cart or account maintance at least one time.
If a joomla user is logged in, then he is in the default shoppergroup. If there is a non logged user, he is assigned to the anonymous shoppergroup.
Two problems with this:
First: people constantly think that there are "virtuemart users" and "joomla users". There exist no virtuemart users. We have only joomla user and this user can be shoppers. So for most problem here it is not a real problem.
Second: Some people here want that someone is registered to put this user then in another shoppergroup. We do the same on our store, but we let the people register here http://extensions.virtuemart.net/my-account. So they are directly shoppers. Maybe some people here just use the joomla registration and do not know that they should use the virtuemart address edit view for registering.
The other question is how we can do it better. It could be nice to have a shoppers listed, but it should be visible if they are shoppers, or just users. The next problem is that it is very hard to rebuilt the joomla internals for both versions. Maybe we add a link to the joomla user profile. Usually you do not have to change the joomla permissions and things like this. But this is the next people ask for.
Not at all what we asked for. Believe me, we understand how your system works.
Our programmer created a little tweak which imports all Joomla users to be automatically shoppers in Virtuemart without them having to sign in / register in the front end. This is what my programmer wrote:
I found in VM migration code that VM users doesn't exists before VM2 and in VM2 for users in database was added table *_virtuemart_vmusers*
If joomla user doesn't exists in *_virtuemart_vmusers* they will not be shown in VM shoppers. Need just correctly copy joomla user which isn't exists in *_virtuemart_vmusers* to *_virtuemart_vmusers* that's all - joomla users will be shown in VM shop
I write little script which do this. Script just copy joomla 2.5 users which doesn't exists in VM2 to *_virtuemart_vmusers* table and then they shown in 'Shoppers list'
To run script: just copy in joomla 2.5 root folder dbvm2 (unzip first) and type in browser http://signag.alfahosting.org/sign.ag/dbvm2/showshoppers.php
After script complete work you should remove/delete folder dbvm2.
Hope this helps you guys out...if you want to get in touch with my programmer, Tymur, PM me, he's brilliant.
[attachment cleanup by admin]
Sorry. But I am lost.
I have about 430 trade customers that I want to register on the site with a specific shoppergroup status (lets call it wholesale), and then send them their log in details by email.
All other user I want to have the default shoppergroup level (which is normal operation).
How do I achieve this?
getting an issue with this also..
i want to manually add user/customers in joomla backend and then give em a a shopper group in VM directl so they can see special prices. Then mail them their logininformation.
Tried the script above,, hehe, worked good but i cant run that script after every registration. is their not a good registrer module exstension to solve it or something?
It cant be necessery to have a wholesale to first buy a item at regular prices so them show up in VM back end. Or..
I am sorry, I do not understand the problems. The new version will show now also all joomla users in the vm list. There exists no synchronisation. IF you start todo this, you will create redundant data. We could use for the shoppergroups something like for the products and categories, that would help mlmpenny
I found that this issue still exists in 2.0.14 however if you search for the shoppers name it will appear in the list. In my case I wanted to add the shoppers address myself rather than force them to when they came to the store and was able to do so by searching for the names not showing in any lists by default.
Last version is 2.0.16.
We should make users register directly at the account maintenance of Virtuemart?
Watching that VM webpage I see that you use that menu item as the only place where they can log in together with the log in at checkout.
Is that the correct way?
We made it so that users registered via the joomla default register, that is a bad idea no?
The problem for what I see in VM webpage is that you don't use any log in module in any other page of the website so basicly users only log in from those 2 places, if you added a log in module the register will redirect to the joomla default register which is one of the issues we were facing.
EDIT= We placed the account maitenance of VM as the register menu and redirect our login module to that webpage, now everything seems more logical.
Regards
To add to the problem, when a list is imported to the database, and all fields are correctly in place, neither Joomla nor VM2 will display the data within admin.
I can see over 2,000 users that I imported into the db.
All of the fields are there, although I don't see the username anywhere. The only db field "username" that exists is in Joomla tables.
With all those users it would seem I should see at least 1 of them by editing the created date, or something that would update the user list.
But neither Joomla nor VM2 recognizes the data - even though I'm staring at the data in the correct tables in the VM2 db.
Additionally, I found it very odd that there is no import feature for users/shoppers in VM2. Why not?
It would be so simple to add that functionality, and it's SO important to existing businesses to have their customer list transferred to the new system, I don't understand the logic of not including that ability.