add zone to order prefix

[bookworm]

I changed our order number prefix by following the useful advice in http://community.actinic.com/showthread.php?t=4741.

I wondered if there was some way of picking up the customer's shipping zone and popping that in the prefix as well?

We are using Mole End's one stop automation to fire off orders and invoices to a fulfillment house. We now need to send them to two different fulfilment houses, depending on which zone the customer lives in. I thought a simple email filter should do the job, as long as we can extract the zone from the order number.

Any help or comments as ever greatly appreciated.

Bob

[Darren B]

I dont know what method you use for zones or what you have done to your order number. But i modify my order number to use the 1st 4 digits from the postcode so this will give me something like ME80 (medway) or CV37 (stratford upon avon) or are you using zones for international orders.

D

[bookworm]

Yes we use shipping charges based on zones - UK, rest of EU, North America & Canada, rest of the world.

We want to filter all of the orders from the North American zone to a fulfillment house in San Francisco. All the rest are shipped from the UK.

My idea is to put the zone code, which is presumably numeric, into the order prefix.

Thanks,

Bob

[bookworm]

I've been looking through OrderScript.pl and found the variable ShippingZone.

I wonder if that might be what I need to insert into the order prefix? Anyone know if there is any reason why that couldn't be used in the same way as postcode and initials are in the default order prefix?

Thanks,

Bob