Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 05-02-2014 03:47:42
- timeclockexpress
- Member
- Registered: 04-15-2008
- Posts: 63
Leading 0 in zip code dropped in Admin
For years I have noticed orders default to standard carrier shipping rate randomly. I have just figured out if a zip code in Admin delivery has a leading 0 it is dropped causing a four digit zip code causing the default standard carrier. How can we allow CCP8 to include leading zero in delivery zip code?
Offline
#2 05-02-2014 09:40:43
Re: Leading 0 in zip code dropped in Admin
Sounds like you're uploading an Excel spreadsheet for products and your shipper zip code column is not formatted as five digits. Excel is notorious for this - the software doesn't drop leading zeroes.
Nick Hendler
Offline
#3 05-02-2014 10:19:17
- timeclockexpress
- Member
- Registered: 04-15-2008
- Posts: 63
Re: Leading 0 in zip code dropped in Admin
I am not uploading any excel spreadsheets. In the Delivery section of a product I input Connecticut and and zip code of 06451 and update. When i go back in product, CCP8 changed it to 6451 which causes the default standard carrier rate to be applied.
Offline
#4 05-02-2014 14:50:04
Re: Leading 0 in zip code dropped in Admin
And you're inputting that zip code directly into the CCP8 admin interface and clicking submit, or are you uploading that data via a spreadsheet?
We distribute high quality steel auto body panels for use in the rust repair industry.
Offline
#5 05-02-2014 18:36:35
- timeclockexpress
- Member
- Registered: 04-15-2008
- Posts: 63
Re: Leading 0 in zip code dropped in Admin
inputting directly into ccp8 admin interface and submitting. Not through spreadsheet
Offline
#6 05-03-2014 04:01:47
- zanart
- Member
- From: bedford
- Registered: 04-02-2008
- Posts: 1706
Re: Leading 0 in zip code dropped in Admin
I would check the column type for the shipzip column in your ecom_prod table.
Mines set to VARCHAR(20) DEFAULT '', and it doesn't drop the leading zero.
Rob
Offline
#7 05-03-2014 09:11:28
- timeclockexpress
- Member
- Registered: 04-15-2008
- Posts: 63
Re: Leading 0 in zip code dropped in Admin
Interesting, Mine is set to VARCHAR(20) DEFAULT also. I wonder if maybe problem lies with my hosting and a server setting?
Offline
#8 05-05-2014 09:36:25
Re: Leading 0 in zip code dropped in Admin
Let me guess, you're submitting zip 01234 to replace 1234. That won't work. The software will recognize those as the same and not update the field. First change 1234 to X, update it, then change X to 01234. The extra hoop is necessary because the bad value is in there already.
Nick Hendler
Offline
#9 05-05-2014 10:25:45
- timeclockexpress
- Member
- Registered: 04-15-2008
- Posts: 63
Re: Leading 0 in zip code dropped in Admin
That was it. Thanks Nick
Offline