madcrazygirl Posted August 1, 2006 Share Posted August 1, 2006 Hi can anyone give me a simple fix for this? As a newbie all the threads I find look real complicated :'( and is frazzling my little brain lol I just want to change the order of the address for the UK postal system please many thanks Link to comment Share on other sites More sharing options...
kgt Posted August 1, 2006 Share Posted August 1, 2006 Look in the address_format table of the database. Choose the format that you want, or create a new one. In the admin section, go to Locations/Taxes > Countries. Select the United Kingdom, then set the Address Format to the address_format_id you want from the table. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
madcrazygirl Posted August 1, 2006 Author Share Posted August 1, 2006 Ok thanks for pointing me in right direction. I have now found countries bit where to choose address field 1-5 ty. However, once in mysql even though i find the right line in table and then change and press go it does not seem to change the packing slip? Will it only affect new orders or am I doing something wrong in mysql? Link to comment Share on other sites More sharing options...
madcrazygirl Posted August 1, 2006 Author Share Posted August 1, 2006 Hurrah may have answered own question. Placed dummy order and yes it seems i can print this packing slip correctly. Hope all my ramblings hope others :lol: Link to comment Share on other sites More sharing options...
kgt Posted August 1, 2006 Share Posted August 1, 2006 To answer your question: Yes, the change only applies to new orders. If you look in the orders table, you will see a delivery_address_format_id and a billing_address_format_id. So those are the formats that will be used for existing orders. To change the format for existing orders, you would need to edit all of your orders to change the format_id's to the correct format. You can actually do this in the SQL tab of phpMyAdmin if all of your orders are supposed to use the same address format: update orders set delivery_address_format_id=#, billing_address_format_id=# where # is the address_format_id. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
madcrazygirl Posted August 1, 2006 Author Share Posted August 1, 2006 Thank you so much for being so helpful - this has been bugging me for a while now and just could not get head around it :) best wishes Link to comment Share on other sites More sharing options...
Guest Posted August 1, 2006 Share Posted August 1, 2006 # 1 - USA, 2 - UK, 3 - Spain, 4 - Singapore, 5 - Germany Link to comment Share on other sites More sharing options...
madcrazygirl Posted August 2, 2006 Author Share Posted August 2, 2006 No I tried all the numbers! None gave the correct layout including no.2 so I just changed in the database in the end as suggested Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.