Invoice Before Account Was Created

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

Edited by

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:

index.php?do=people&p_id=999#page=thumbs

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

Wow Tim, you're the best. That worked great! Thank you

Edited by