Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Change address format in my database now address not showing


Recommended Posts



Need help


Been having a few problems with address format on my osc site v2.2 from day 1 and to be fair have coped OK with it even though the address lines were mixed up. What is was getting was the post code above the city. I read here on the forum that it could be altered in the my sql database in address format. I edited


$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country




$firstname $lastname$cr$streets$cr$city, cr$statecomma$$postcode$country




Main thing here is that it did alter the address format how I wanted it. I could see this on the delivery information and payment information pages.


Problem is now the billing address and shipping address are missing when going through the checkout on the conformation page also not showing on the invoice either.


What in the world have I done? I have changed the address format back to what it was also but no luck at all.


Site is useess now so just hoping I have just not done something right in the SQL DB


I am not the most technical person and no litte about the database


Anyone have any ideas please? Seems such a silly thing to happen just by editing the above.



Link to comment
Share on other sites

Hi Aso I do get an email order conformation and this does have the billing and shipping address in.


Only hope one of you guys can help on this one hopefully today :thumbsup:


Would be great if someone could help on this one.



Link to comment
Share on other sites

  • 2 months later...


This topic is now archived and is closed to further replies.

  • Create New...