Out of Area Postcodes
- Former user (Deleted)
- Sam Adams
- Deimena Veiksiene
There's a number of postcodes which are not eligible for Named Day Delivery or Saturday delivery and these options will not show on Telesales for any delivery address with these postcodes.
select delivery_zone.name, delivery_region.postcode from delivery_zone
join delivery_region on delivery_region.delivery_zone_id = delivery_zone.id
order by delivery_zone.name, delivery_region.postcodeNo Named Day Delivery, but can have Saturday Delivery
AB63 |
FK1 |
FK3 |
FK8 |
PA51 |
PA52 |
PA53 |
PA54 |
PA55 |
PA56 |
PA57 |
PA58 |
PA59 |
PA79 |
TR21 |
TR22 |
TR23 |
TR24 |
TR25 |
No Named Day or Saturday Delivery
AB30 |
|---|
AB36 |
AB31 |
AB33 |
AB34 |
AB35 |
AB37 |
AB38 |
AB39 |
AB41 |
AB42 |
AB43 |
AB44 |
AB45 |
AB51 |
AB52 |
AB53 |
AB54 |
AB55 |
AB56 |
BT22 |
BT24 |
BT25 |
BT29 |
BT30 |
BT31 |
BT32 |
BT33 |
BT34 |
BT35 |
BT37 |
BT38 |
BT39 |
BT40 |
BT43 |
BT44 |
BT45 |
BT46 |
BT47 |
BT48 |
BT49 |
BT51 |
BT52 |
BT53 |
BT54 |
BT55 |
BT56 |
BT57 |
BT58 |
BT60 |
BT61 |
BT62 |
BT63 |
BT64 |
BT65 |
BT66 |
BT67 |
BT68 |
BT69 |
BT70 |
BT71 |
BT74 |
BT75 |
BT76 |
BT77 |
BT78 |
BT79 |
BT80 |
BT82 |
BT81 |
BT92 |
BT93 |
BT94 |
DD1 |
DD2 |
DD3 |
DD10 |
DD11 |
DD4 |
DD5 |
DD6 |
DD7 |
DD8 |
DD9 |
FK16 |
FK17 |
FK18 |
FK19 |
FK20 |
FK21 |
G63 |
HS1 |
HS2 |
HS3 |
HS4 |
HS5 |
HS7 |
HS6 |
HS8 |
HS9 |
IM1 |
IM2 |
IM4 |
IM5 |
IM6 |
IM7 |
IM8 |
IM3 |
IM9 |
IV1 |
IV10 |
IV11 |
IV12 |
IV13 |
IV14 |
IV15 |
IV16 |
IV17 |
IV2 |
IV18 |
IV19 |
IV20 |
IV21 |
IV22 |
IV23 |
IV24 |
IV25 |
IV26 |
IV3 |
IV27 |
IV28 |
IV29 |
IV30 |
IV31 |
IV32 |
IV33 |
IV34 |
IV35 |
IV4 |
IV36 |
IV37 |
IV38 |
IV39 |
IV40 |
IV41 |
IV42 |
IV43 |
IV44 |
IV5 |
IV45 |
IV46 |
IV47 |
IV48 |
IV49 |
IV50 |
IV51 |
IV52 |
IV53 |
IV6 |
IV54 |
IV55 |
IV57 |
IV58 |
IV59 |
IV60 |
IV61 |
IV62 |
IV56 |
IV7 |
IV63 |
IV64 |
IV65 |
IV66 |
IV67 |
IV68 |
IV69 |
IV70 |
IV71 |
IV72 |
IV73 |
IV8 |
IV74 |
IV75 |
IV76 |
IV77 |
IV78 |
IV79 |
IV80 |
IV81 |
IV82 |
IV9 |
IV83 |
IV84 |
IV85 |
IV86 |
IV87 |
IV88 |
IV89 |
IV90 |
IV91 |
IV92 |
IV93 |
IV94 |
IV95 |
IV96 |
IV97 |
IV98 |
IV99 |
KA10 |
KA11 |
KA12 |
KA13 |
KA14 |
KA15 |
KA16 |
KA17 |
KA18 |
KA19 |
KA20 |
KA21 |
KA6 |
KA7 |
KA22 |
KA23 |
KA24 |
KA25 |
KA26 |
KA27 |
KA28 |
KA29 |
KA8 |
KA9 |
KW1 |
KW10 |
KW11 |
KW12 |
KW13 |
KW14 |
KW15 |
KW16 |
KW2 |
KW3 |
KW4 |
KW5 |
KW6 |
KW7 |
KW8 |
KW9 |
KW17 |
KY10 |
KY9 |
KY13 |
KY14 |
KY15 |
KY16 |
ML11 |
ML12 |
PA20 |
PA21 |
PA22 |
PA23 |
PA24 |
PA25 |
PA26 |
PA27 |
PA28 |
PA29 |
PA30 |
PA31 |
PA32 |
PA33 |
PA34 |
PA35 |
PA36 |
PA37 |
PA38 |
PA39 |
PA40 |
PA41 |
PA42 |
PA43 |
PA44 |
PA45 |
PA46 |
PA47 |
PA48 |
PA49 |
PA50 |
PA60 |
PA61 |
PA62 |
PA63 |
PA64 |
PA65 |
PA66 |
PA67 |
PA68 |
PA69 |
PA70 |
PA71 |
PA72 |
PA73 |
PA74 |
PA75 |
PA76 |
PA77 |
PA78 |
PA80 |
PA81 |
PA82 |
PA83 |
PA84 |
PA85 |
PA86 |
PA87 |
PA88 |
PH1 |
PH10 |
PH11 |
PH12 |
PH2 |
PH13 |
PH14 |
PH15 |
PH16 |
PH17 |
PH18 |
PH19 |
PH20 |
PH21 |
PH22 |
PH23 |
PH24 |
PH25 |
PH26 |
PH3 |
PH4 |
PH27 |
PH28 |
PH29 |
PH30 |
PH31 |
PH32 |
PH33 |
PH34 |
PH35 |
PH36 |
PH37 |
PH38 |
PH39 |
PH5 |
PH6 |
PH7 |
PH8 |
PH9 |
PH40 |
PH41 |
PH42 |
PH43 |
PH44 |
PH45 |
PH46 |
PH47 |
PH48 |
PH49 |
PH50 |
TD15 |
ZE1 |
ZE2 |
ZE3 |
BT1 |
BT2 |
BT3 |
BT4 |
BT5 |
BT6 |
BT7 |
BT8 |
BT9 |
BT10 |
BT11 |
BT12 |
BT13 |
BT14 |
BT15 |
BT16 |
BT17 |
BT18 |
BT19 |
BT20 |
BT21 |
BT23 |
BT26 |
BT27 |
BT28 |
BT36 |
BT41 |
BT42 |
BT50 |
BT59 |
BT72 |
BT73 |
BT83 |
BT84 |
BT85 |
BT86 |
BT87 |
BT88 |
BT89 |
BT90 |
BT91 |
DHL 48 Hour
To find postcodes that were sent 48 hour via DHL:
select count(*), postcode
from sales_order_delivery delivery
join sales_order on delivery.sales_order_id = sales_order.id
join sales_order_attribute service on sales_order.id = service.sales_order_id and service.name = 'service'
join sales_order_attribute courier on sales_order.id = courier.sales_order_id and courier.name = 'courier'
where sales_order.created_on > subdate(now(), INTERVAL 1 MONTH)
and courier.value = 'DHL'
and service.value like '%48%'
group by postcode
order by count(*) desc;