ProductCart Shopping Cart Software Forums : Change Customer ID on an Order

Change Customer ID on an Order : I just want to say, it was easy!...

Tue, 25 Sep 2007 22:52:38 +0000

Author: fidjiti
Subject: 1080
Posted: 25-September-2007 at 10:52pm

I just want to say, it was easy! I was able to log into my DB using the sql web admin and edit the individual order with the correct customer ID (make sure you set up the customers first) and the order info transfered over nicely. I will add, that the order was still in PENDING status prior to the change. So I can't say for sure if it would have been the same had the order status been Processing or Shipped. But in the Pending stage it was a successful change!

Thanks for everyone's help. Now I can send my customers an email or letter letting them know what their Login and password is with their correct point total. :)

------(this is what a programmer told me to do to make sure i did it right)-------
Click on Tables, then find "Orders" and to the right of the row count column (2133 for the orders table) there is a little grid button... click on it.... or use the button to the right of that for a search to find a specific OrderId since the grid returns ALL records and you will have to page through to find the order you need.

At any rate, once you find the orderId there is a button to the left just above the red X, click on it to Edit that record. You will see IdCustomer and it value... just change it to the ID you want and click the "Update" button.

FYI if you use the Search to find the order you want to change, you have to change the "operator" column on the Search screen to an "equal sign" ("=") first and then it lets you put in the OrderId... when it first comes up, you can't put any values in until you set that.

Change Customer ID on an Order : Thanks Matt! yes I would have...

Fri, 14 Sep 2007 18:53:36 +0000

Author: fidjiti
Subject: 1080
Posted: 14-September-2007 at 6:53pm

Thanks Matt! yes I would have asked for their email address but I had about 10 people in line at the time and I was just trying to go quickly. Yes I will be getting their email addresses and making sure they each have a separate account before we do any changes to the DB. I just have a small retail store so walk-ins will happen, now i know better and I'll always ask for their email. :)

I not only want to track points but want customers to be able to see their past order. otherwise I would just add their points to the newly created account, right, cause that would be easier. But I want to do it right and want to make it super cool. (like my PC is supposed to be)

Okay, just so i understand you correctly, there is only 1 table which needs to be changed in the DB with the correct customer ID? (i just don't want to crew anything up.) Then the new customer will see this order show up in their account (after the switch is made) and the points will be seen in their account too? Just by changing this 1 table? Or are there multiple tables?

Thanks again for your help.
Linda
P.S. Maybe EI should add "move this order to a different account" button. ;)

Change Customer ID on an Order : Email is a required field...

Thu, 13 Sep 2007 18:49:39 +0000

Author: Matt
Subject: 1080
Posted: 13-September-2007 at 6:49pm

Email is a required field when creating a new customer. Youstill need an email address to �checkout without creating an account�. So it sounds like you don�t have a sessionissue, but rather were still logged in as the first user when placing ordersfor each consecutive user.

To correct the situation as described will be a serious endeavorjust to track point, especially considering the customers never planned to loginto their accounts (they never gave you emails and you placed the order on theirbehalf).

If you do proceed with the manual editing of your database here are some guidelines.The edit is made in the "orders" table to column"idCustomer". Don't go this route unless you have the entirecustomer account ready and their ID at hand. You should close the storeduring the update process and you must backup the database.

Change Customer ID on an Order : So would the customer id be changed...

Thu, 13 Sep 2007 18:31:58 +0000

Author: fidjiti
Subject: 1080
Posted: 13-September-2007 at 6:31pm

So would the customer id be changed for the order in 1 table (which table) or field (which field) or multiple tables and fields. If it's only one then i think i could get someone to do it fairly easily. I just want to be able to track the points from each order for each customer. I wish I would have just asked them for their email address to set up their account. That would have been easier.

Change Customer ID on an Order : You need to edit the database...

Thu, 13 Sep 2007 18:25:52 +0000

Author: Matt
Subject: 1080
Posted: 13-September-2007 at 6:25pm

You need to edit the database directly to do what you want,but it�s not recommended. It is possible to do if you have experience in editingdatabases and are very careful.

Otherwise you have to change that primary customer to yourself. That wayyou will get all of the emails and he will not be able view or access the otherorders. You should do that first.

Change Customer ID on an Order : Well, right now i think the orders...

Thu, 13 Sep 2007 18:18:36 +0000

Author: fidjiti
Subject: 1080
Posted: 13-September-2007 at 6:18pm

Well, right now i think the orders are all under 1 customer number, i.e. # 195 is what it says on the top of the Billing Shipping tab. So what I want to do it set up 19 different customers and then some how change the customer id on the each order to correspond to the correct customer.
I already tried editing the customer billing info but one of my customers received 19 emails. :(

Change Customer ID on an Order : The sessions should always...

Thu, 13 Sep 2007 18:14:53 +0000

Author: Matt
Subject: 1080
Posted: 13-September-2007 at 6:14pm

The sessions should always clear when the SSL is setupcorrectly. Since you mentioned updating to v3.1 in another post, I wouldproceed to do that first. Then, if you find this issue persists open a ticket. I believe the best way to fix your problem isto change the primary customer to yourself (just by updating the details). Thengoes through each order and edit the billing information.

Change Customer ID on an Order : So has anyone even tried this?...

Thu, 13 Sep 2007 17:04:17 +0000

Author: fidjiti
Subject: 1080
Posted: 13-September-2007 at 5:04pm

So has anyone even tried this? I just don't want to have to re-enter a customer's order into the system because it would ruin my inventory. it would just be easier if I could change the customer ID on the orders. Any ideas?

Change Customer ID on an Order : I would like to change the customer...

Tue, 11 Sep 2007 15:45:02 +0000

Author: fidjiti
Subject: 1080
Posted: 11-September-2007 at 3:45pm

I would like to change the customer ID on 19 of my orders. I want to keep the shipping addresses the same as they were when they were entered but I just need to change the customer it's assigned to.
I was trying to place several orders without creating accounts so it'd be quicker orders and for some reason the cookies on the site kept the main customer the same and simply changed the shipping addresses. :( Any ideas would be awesome.

In fact this would be a cool feature which PC could add. For example: a change customer for this order or assign an order to a customer. Anyways, please help.

Thanks!

Edited by fidjiti - 11-September-2007 at 3:46pm