Add Prefix to Customer Number (Customer ID)?
-
I recently moved from Zencart to WordPress/WooCommerce website and on all orders it shows a unique customer ID – I use this on my Sage accounts system as the unique customer account number.
My problem is some numbers are being duplicated from my old zencart to new accounts on wordpress i.e. customer Joe Bloggs on new wordpress site may have customer id allocated as 12345 where on my Sage Accounts system account number 12345 is already used by customer Jane Smith from 4 months ago on my old zencart website. I need to keep accounts on sage for a specific amount of time so cannot simply delete all the old zencart customers.
Basically is there a way to add a prefix to all newly generated account numbers on wordpress/woocommerce? IE if I put WP before each account number then Joe Blogs new account would show as WP12345 and my Sage accounts program would recognise that as a new account different from the old 12345 one.
I hope this makes sense and thanks for any help.
- You must be logged in to reply to this topic.