If you have a support question or comment, click the Post New Topic link below.
Current Version: 3.6.1 | Sytist Manual | Sytist Articles 

Invoice Before Account Was Created

Please log in or Create an account to post or reply to topics.
Jonathan Nobach
47 posts
Wed Aug 14, 19
9:40 AM
Hi. I created an invoice for someone that did not have an account already in the system. They then paid off the balance of the invoice. Since then, they created an account on my site and I need to create another invoice for them for something else. Is their anyway to attach the first invoice to their account so everything shows up under their new account? Thanks, Jon
Tim - PicturesPro.com
12053 posts
Wed Aug 14, 19
11:54 AM
There is not an option to assign an order to a customer account. You would have to do it manually like this:

View the customer's account in the admin. Look at the URL in the address bar and get the customer ID. It is this value:


Jot that down and the order number of the order you want to assign to their account.

Next click Settings in the main menu then underneath the left menu click MySQL query.

Copy this line, paste it in there and replace the red with the customer ID and the blue with the order number and click run,.

UPDATE ms_orders SET order_customer='999' WHERE order_id='123456';

Edited Wed Aug 14, 19 11:55 AM by Tim - PicturesPro.com
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Jonathan Nobach
47 posts
Wed Aug 14, 19
12:41 PM
Wow Tim, you're the best. That worked great! Thank you
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

©2003 - 2019 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window