Entering orders in the backend

  • Posts: 103
  • Thank you received: 7
10 years 2 months ago #169676

-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3.3

Hello - I often have orders that I need to enter in the backend. To do this, I need to create new customers. I do not have my customers do the Joomla registration, so I cannot use the regular user management system.

This has worked just fine in my website in the past, though through a somewhat convoluted process. Previously, i was able to create new customers by first creating a new order, then going back to the order listing and clicking on the pencil icon next to the blank email address for the new order. Then, through that page, I could create a new user (including email, name, address). Next, I could edit that particular order and attach the newly created user to that order by selecting the new email address. A nuisance, but it works (worked).

I have just updated to a new Joomla 3.x template/website, and this functionality has disappeared.

I actually asked about this problem a long time ago (thread #122275) after an earlier Hikashop update. You were able to send me an update that fixed this problem.

But, now the functionality has disappeared again. The little pencil icon in the customer column is gone. Can you help me figure out how to get that back?

It would be much easier, of course, if there were just a simple way to add new customers just like there is a simple way to add new orders... I understand that this is complicated by the Joomla user system, but if there's another way to do this, I'd love to know about it.

Thank you for your help!
Scott

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 2 months ago #169715

Hi,

Please provide a link to the thread you were talking about.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 103
  • Thank you received: 7
  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
10 years 2 months ago #169794

Hi,

There is actually a really simple way to add a customer. Just go in the Joomla user manager of your website and create a new user. You'll then be able to select it in your order when you create it in the backend.

And if you want to add a customer not attached to a joomla user account, just go to that URL on your website:
mywebsite.com/administrator/index.php?op...l=user&task=edit&cid []=0
That will allow you to create the customer before then being able to select it in the order.

Please Log in or Create an account to join the conversation.

  • Posts: 103
  • Thank you received: 7
10 years 2 months ago #169799

Thank you for responding, but I'm afraid I don't quite understand.

The reason that I don't want to create the joomla user account is that we occasionally have repeat customers. If they already have a joomla user account, then they can't reuse their email address (unless we've done the whole ordering authentication thing, which I'm trying to avoid for simplicity for my customers).

I tried the URL you mentioned in your post: mywebsite.com/administrator/index.php?op...l=user&task=edit&cid[]=0.

It just took me to my control panel in the backend. I can get to the user manager from there, but i'm trying to not use that. What I'd really like is to be able to go back to entering users through Hikashop that aren't part of the Joomla user manager...getting that little pencil back on the order listing would do the job nicely.

Any other thoughts? Thanks,
Scott

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
10 years 2 months ago #169937

Hi,

You didn't use the URL I gave properly. Our forum is stripping the URL and you need to click on it to be able to use it.
Here it is again with quotes so that it is easier to use for you:

http://mywebsite.com/administrator/index.php?option=com_hikashop&ctrl=user&task=edit&cid[]=0

The following user(s) said Thank You: jsyaruss

Please Log in or Create an account to join the conversation.

  • Posts: 103
  • Thank you received: 7
10 years 2 months ago #169943

Oh, sorry... I wondered about the ellipsis. I'll give it a try. Thanks for clarifying that for me!

Please Log in or Create an account to join the conversation.

  • Posts: 103
  • Thank you received: 7
10 years 2 months ago #169946

Okay - thanks. That gets me to the page I wanted to be at - the one I used to be able to get to with the little pencil icon on the order listing. In fact, it's back, so I wonder if there was just some odd glitch the other day.

I'm wondering if it would be an easy thing to put this page on the menu, so I can just enter as many users as I want without needing to first enter an order. It would be great if this could be an option under the "Customers" menu. Just to make it easier to add Hikashop customers that aren't registered Joomla users. Perhaps that would be confusing. I've got this figured out now (again), so I'm probably in good shape.

Thanks again for helping with the link. I don't know what went wrong with the pencil icon, but all is well now.
S

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
10 years 2 months ago #169966

Hi,

Yes, we didn't add a button to it because we fear that people wouldn't understand why that screen displays when they actually want to create a real user account for the customer (most of the time).

Please Log in or Create an account to join the conversation.

  • Posts: 103
  • Thank you received: 7
9 years 10 months ago #187723

Hello - I am posting on an old thread that I created before... you had helped me solve this problem previously, but i am again having trouble with this issue.

Briefly: I occasionally have a situation where I need to create customers through the backend rather than going through the regular site. (I create the order, then create the user and assign the user to the order.) I do not have my customers create joomla user accounts - they are only hikashop users, so I can't create users using the regular joomla process.

You have previously showed me how to access the new customer page directly by going to ...index.php?option=com_hikashop&ctrl=user&task=edit&cid[]=0. That worked just fine and allowed me to manage the site the way i wanted to.

Unfortunately, that appears to have stopped working. Now, when I attempt to create a new user in hikashop this way, i get an "error saving" message. I turned on the debug information, but I'm afraid I don't know how to make sense of it. I did see that I get an error in a few places in the debug stream that says "NO INDEX KEY COULD BE USED" and "Impossible WHERE noticed after reading const tables," but I'm not sure if that's at all related. It's just the only thing I could think of to do.

Can you please help me figure out how to create customers through the backend again? Thank you for your help
Scott

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 10 months ago #187740

Hi,

I am sorry but I can't reproduce your issue in my local website.
The "old" procedure is still working for me (using HikaShop 2.3.5).

"NO INDEX KEY COULD BE USED" is not a real error, it means that the SQL query is not fully optimized using indexes.
So it's not the SQL query we are looking for.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 103
  • Thank you received: 7
9 years 10 months ago #187838

okay, well, i didn't know if that was related or not, but i thought i'd mention it. (I don't know much about this stuff, so i was just guessing).

in any case, can you tell me what debug information would be helpful to you for figuring it out? Or, is it possible for me to create a user for you to give it a try on my site so we can figure out what went wrong? it used to work flawlessly, but now i just get the error message. thank for any suggestions you can offer.

Scott

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
9 years 10 months ago #187992

Hi,

Please provide a backend access (with access to the Joomla configuration) and a link to this thread via our contact form so that we can look at the issue as we were not able to reproduce the issue, even on several different test websites configured differently.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
9 years 10 months ago #188039

Hi,

I looked at your backend with the access you provided but as far as I could see, it's not a SQL issue and the query to insert the user is not run. It looks like a plugin is blocking the user saving but I couldn't find which.
What you what you can try is to perform tests by disabling the hikashop and system plugins one by one to see which one would be causing the problem.
If you can't find any plugin which would cause the issue (meaning that it would work if you disable it), please provide a FTP access so that we can look further into the issue by adding traces in the code.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
9 years 10 months ago #188216

Hi,

Thank you for the FTP access. We found the issue which comes from the HikaShop group plugin which was modified to better support guest checkouts on the frontend and lead to that issue in the backend.

We've changed the code:

		if(empty($user->user_cms_id)){
to:
$app = JFactory::getApplication();
		if(empty($user->user_cms_id) && !$app->isAdmin()){
in the hikashop group plugin's onBeforeUserCreate function and the problem is solved. Which also means that you must have missed that plugin when you tested each plugin one by one.
We'll add that patch on our end. It could be useful for other users with similar needs.

The following user(s) said Thank You: jsyaruss

Please Log in or Create an account to join the conversation.

  • Posts: 103
  • Thank you received: 7
9 years 10 months ago #188226

Oh, thank you. You are right - i must have missed that entirely. I thought I went one-by-one and disabled each of them in turn, but i admit that I did get a bit confused about which I did and which I didn't as I went through the list. (At one point I sorted by whether the module was turned on/off and then that made me lose track...i thought I was thorough...evidently, I was not). Thank you for fixing the problem for me. As always, I appreciate your help!

Please Log in or Create an account to join the conversation.

Time to create page: 0.067 seconds
Powered by Kunena Forum