Can anyone help please!

We have 2 sites both using the HSBC payment module. After much tweaking both sites can now take payments but I have a new problem as the second site is getting Duplicate Order ID as they were both just using straight forward Order IDs.

To get round this problem we have put a prefix of MEN in front of one of the Order ID and this shows in Admin, in the email confirmation but not in the actual email, Customer Order History and most importantly passed to HSBC.

I have tried to update the Order numbers via Tools / Store Manager to a much higher number 20000+ but this also only updates in the same places and then puts my Order IDs totally out of sync as they are MEN200999 in Admin / Orders but my customer has order ID MEN376.

Can anyone suggest how to update all these Order ID items so that I don't get the duplicates between the 2 sites. The thought of having to create 20000 dummy orders to work around this is mighty depressing.....

Many thanks
Sophie
www.golfwear4girls.com / www.golfwear4men.com