Customizing ProductCart - Change Customer ID on an Order

Print Page | Close Window

Change Customer ID on an Order

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=1080
Printed Date: 15-July-2025 at 9:39am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Change Customer ID on an Order

Posted By: fidjiti
Subject: Change Customer ID on an Order
Date 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!

-------------
Linda - I wish I knew ASP.
To view my ever evolving site click the "www" button below. :)

Replies:

Posted By: fidjiti
Date 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?

-------------
Linda - I wish I knew ASP.
To view my ever evolving site click the "www" button below. :)

Posted By: Matt
Date Posted: 13-September-2007 at 6:14pm

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

Posted By: fidjiti
Date 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. :(

-------------
Linda - I wish I knew ASP.
To view my ever evolving site click the "www" button below. :)

Posted By: Matt
Date 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 editing databases and are very careful.

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

Posted By: fidjiti
Date 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.

-------------
Linda - I wish I knew ASP.
To view my ever evolving site click the "www" button below. :)

Posted By: Matt
Date Posted: 13-September-2007 at 6:49pm

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

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

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 entire customer account ready and their ID at hand. You should close the store during the update process and you must backup the database.

Posted By: fidjiti
Date 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. ;)

-------------
Linda - I wish I knew ASP.
To view my ever evolving site click the "www" button below. :)

Posted By: fidjiti
Date 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.

-------------
Linda - I wish I knew ASP.
To view my ever evolving site click the "www" button below. :)