Modular Merchant: Shopping Cart Software

Shopping Cart Software Service
Advanced SearchAdvanced Search RegisterRegister ProfileProfile FAQFAQ MemberlistMemberlist Log inLog in
How do I link a new customer account to an existing order
 Post new topic   Reply to topic
Modular Merchant Forum Index -> Store Administration
Author Message

HolyHell1982




Joined: 14 Nov 2007
Posts: 1
PostPosted: Nov 14, 2007 02:21pm    Post subject: How do I link a new customer account to an existing order Reply with quote
Hi,
I have the problem, that as soon as people are paying via PayPal their customer account does not get transfered to Modular Merchant.
I spoke with Modular Merchant about that and I know it's a problem with PayPal. In order to Export Order Information, I need to have a customer account for every order. Now I was wondering, if I could create a new customer account for this person and link it to an existing Order!!!!!!!!

Hope someone can help me with that.

Thanks

Mail Bag


Answering Your Questions Since... 9:30am

Joined: 28 Aug 2005
Posts: 113
PostPosted: Nov 15, 2007 10:20am    Post subject: Reply with quote
Quote:
create a new customer account for this person

A new customer account can be created in your store's administration area at: [Navigation Menu > Customers > Add a Customer]. After you have created the customer account, make note of the System ID (SID) number of the customer account. You'll need the customer's SID in the next step.


Quote:
and link it to an existing Order!

This can be done by using the database management tool that is available within your Plesk control panel. (Plesk is available for clients who's store is hosted under their domain name.) Follow these steps:

Note: The steps below are intended for advanced users.

1. Log in to Plesk.
2. In Plesk, click the link of the domain name you're working with.
3. On the next screen, click the "Databases" icon.
4. Next, click the link for your store's database. This is usually something like "mm2_ACCOUNT-NAME".
5. On the next screen, click the "DB WebAdmin" icon. This will open a popup window with a database editor tool called "phpMyAdmin".
6. In phpMyAdmin, there will be a list of database tables on the left-side of the screen. Click the link for the database table titled, "orders".
7. Next, click the "Browse" button at the top of the frame on the right-side of the screen to view the details for each order.
8. Use the navigation options to locate the order that you want to edit.
9. Once you locate the order, click the "edit" or pencil icon to open that order for editing.
10. On the order's editor screen, enter the customer's SID number from part one in the database field titled "cid".
11. Click one of the "Go" buttons on the screen to save your changes.

The customer with the SID that matches the value entered in the "cid" field will now be associated with that order.
_________________
Modular Merchant Mail Bag
Answering your questions, queries and puzzlers.
Modular Merchant shopping cart software, website hosting, and custom programming.
Display posts from previous:   
Post new topic   Reply to topic    Modular Merchant Forum Index -> Store Administration All times are GMT - 7 Hours
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group