Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Odd Situation


VideoDude

Recommended Posts

Hi, On my osCommerce site I allow people the option to pay by check. One of my customers went through the order process and stopped short of "confirming" the order. She printed out the page that appears just prior to the "Finished!" page and mailed it to me with a check. So in other words, she never actually finanized her order. I want to keep things nice-and-clean... where for every payment I receive I have a corresponding order on my osCommerce system. Without having my customer's logon details I don't know how to get her order into the system. Any suggestions?

Link to comment
Share on other sites

Create a fake user with your own email address and whatever information you have from the customer and enter the order there. We do that for reviews that we get in emails or letters.

In olden times the men were made of iron and the ships were made of wood; now it's the other way around. :wink:

Link to comment
Share on other sites

Ok, I see your point, but this customer is already registered and I'd like to have the order tied to her account. It seems that what you're suggesting would get the order into the system, but wouldn't necessarily be linked to the actual customer's order history. I guess I could go into phpmyadmin and change her email to mine... do a "forgot my password"... get the new password, log-in, order... THEN send an email to the customer explaining that I had to reset her password. Ugh.

Link to comment
Share on other sites

Ya, it would be nice if the Customers->Orders section of the admin had an Add button so that you could add an order to handle your case as well as to be able to add phoned in orders to an existing customer's account.

In olden times the men were made of iron and the ships were made of wood; now it's the other way around. :wink:

Link to comment
Share on other sites

I supposed you could go into phpMyAdmin and add a line to the orders table for the new order, but you are probably supposed to add or modify other fields too to keep the order totals and other things correct.

In olden times the men were made of iron and the ships were made of wood; now it's the other way around. :wink:

Link to comment
Share on other sites

One other thing I just thought of...

 

My biggest issue regarding this whole thing was that in order to complete the order for my customer I was going to have to:

1. using phpMyAdmin change the customer's email to my own;

2. using the "password forgotten?" link, I was going to have to reset the password to something OTHER than what my customer had chosen for herself; then,

3. I would have had to sent a letter of apology to the customer explaining the issue of the reset password. It would have been messy/awkward and would NOT have instilled confidence in the customer.

 

Over a good night's sleep I think I may have figured out how to handle this transparently to the customer.

 

  • Step 1 - Go into phpMyAdmin and copy the contents of the encrypted password field to the clipboard;

[*]Step 2 - Again, while in phpMyAdmin, change the email address for the customer from her address to my address;

[*]Step 3 - Get into my osCommerce site and use the "forgotten password" link to generate a new password for the customer;

[*]Step 4 - Log in as the customer and confirm the order as needed

[*]Step 5 - Go back into phpMyAdmin and change the customer's email back to what it was originally; and finally,

[*]Step 6 - Paste the contents of the clipboard (the user's encrypted password) back into the password field... save and exit.

This process will have allowed me to confirm the order on behalf of the client without the client really knowing that I did it. No communication (aside from "Your shipment is on the way!") would have been required as the customer's password stays intact.

 

Ok, so it's still a significant process... but at least it's a pseudo-solution that doesn't jeopardize the customer's trust.

Link to comment
Share on other sites

Or simply - to get access to a customers accout - install the admin override password which lets you log into anybodys account with one master password!!

 

The customer wouldnt even know!!

 

Warren

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...