Updating Offline Order Number

[auztin100]

This little script helped me when I was was adding missing orders back into actinic, after recovering from a corrupt database.

It simply updates the next offline order number by changing the value in the script.

ALWAYS BACKUP YOUR SITE BEFORE RUNNING ANY SCRIPTS LIKE THIS. AND MAKE SURE YOU DON'T SET A NUMBER THAT ALREADY EXISTS, YOU NEW OFFLINE ORDER WILL FAIL.

Set MyConn = CreateObject("ADODB.Connection")
MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=*PATH TO YOUR DATABASE FILE.MDB*"
MyConn.Execute "UPDATE SetupInfo SET sData=*5 DIGIT ORDER NUMBER* WHERE sName='Last Offline Order Sequence Number'"
MyConn.Close

Paste this into a new text document in notepad, Update the starred values above, and save the file as .vbs.

Then just double click the file to run it. I would advise exiting actinic before running this, When you go back into actinic, and click NEW ORDER - the number should reflect the number you entered.

[Duncan Rounding]

Is this the same as in Help | Troubleshooting - Order Number?

[auztin100]

Is that not the main order number, from the website ? not the offline order number ? the offline order number is in business settings - Order Processing - But - depending on the weather - is normally greyed out ?

[Duncan Rounding]

Ah - offline - or course - missed that.

[auztin100]

) - While you are there duncan ....


I now have 3 separate sites,

1. Restored from Last Back-Up
2. Orders manually inputted from email receipts.
3. Latest orders (while I was inputting)

Really I'd like to get all the orders back into the 1 site again :S

I have tried the import orders, but that simply replaces all the existing orders.

Is there another way I can get them all into the same site ? exporting etc ?

Thanks.

Austin.

[Duncan Rounding]

Not that I know of unfortunately.