Shorter Order Number

[cdlphil]

Hi All

I'm new to Actinic an have Catalog V8.5.1.

Simply want to change the long order number format 'PL36DY10000009' to the following format 'W1455'.

Had a look round can't seem to find mods to perl script specific to V8.

Any pointers would be appreciated.

[Dave Fisher]

Hi Phil,

Wecolme to the forum. Its always worth having a quick search around before posting because there is lots of informative information here with many common questions solved.

Is the following of interest
http://community.actinic.com/showthr...t=order+number

I know its a version 6 thread and might not be applicable to v8 but well worth checking out and reporting back

Dave

[dave_finlayson]

Should work fine for v8, we use it here!

[cdlphil]

yes it does work with V8

Cheers Dave,

Don't know anything about Perl but changed ot as follows an it worked a treat.

file: os900001.pl line: 4083 (test server), would guess this is os000001.pl in production mode

$::s_sOrderNumber = "W" . substr($$::g_pSetupBlob{CGI_ID}, -1) .
substr("0000000" . $nCounter, -3);

this returns W1001 W1002 etc.

used 'help' 'troubleshooting' option to reset numbering sequence to 1000.

[brian.mc]

this returns W1001 W1002 etc.

used 'help' 'troubleshooting' option to reset numbering sequence to 1000.

What happens when you get to W9999 ?

[cdlphil]

9999

I imagine it either

1) starts again at 0000 or
2) blows up!

[Dave Fisher]

If I managed to get to 9,999 orders I would get the champagne on ice to celebrate the 10,000th order and worry later about what happens next!

I would assume the 10,000th order would re-set to 0000 and continue up from there.

Dave

[TraceyHand]

I would assume the 10,000th order would re-set to 0000 and continue up from there.

I wonder how the database would handle that though if that resulted in duplicate order numbers (which it would eventually)?
Not to mention the psps (if used) might object to a non-unique order number being re-used (I know Protx would)

[Dave Fisher]

I wonder how the database would handle that though if that resulted in duplicate order numbers (which it would eventually)?
Not to mention the psps (if used) might object to a non-unique order number being re-used (I know Protx would)

Another option could be to change the pre-fix from W to X or perhaps have the pre-fix as the last 2 digits of the year 07, 08 etc

Dave

[brian.mc]

I wonder how the database would handle that though if that resulted in duplicate order numbers (which it would eventually)?
Not to mention the psps (if used) might object to a non-unique order number being re-used (I know Protx would)

That would be my concern too.
Depends on how many orders you expect to get. We're already well past 10,000 but if you're selling a low volume, high value product it might not be so much of a problem.

Setting the number to, say, W10001 would give you a potential 100,000 orders before duplication would become an issue.

[JSnow]

2) blows up!

So you were right then