I am sure this is a common problem but not sue how to get around it.
I have set up a csv export file that transports my order information directly into myhermes with the help of the pick pack extension by moogento. This works great apart from the phone number field as it removes the ‘0’. I get why it does this but is there anyway through pick pack that we can automate this to put a zero at the beginning? Or any other suggestions?
Hmmmm this sounds like a cell formatting issue.
Have you tried setting the phone number field to format cell > text? By doing this it should read the first 0. If it is set to Number then most databases will read a beginning 0 as meaning nothing and will auto remove.
Have you tried this already?
Every expert was once a beginner
I’ve just noticed that one phone number shows a ‘0’ at the beginning and it is the one that has a space after the area code.
eg 01706 123456 will show correctly but 01706123456 will miss of the zero! I tested it by changing the format on another phone number and it works. I assume it recognises it as a text field when a space has been inserted?
Why Should You Join UnderstandingE?
- Access to over 500 step-by-step video tutorials
- +20 video courses available
- Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
- Everything is in 100% Plain English
- Learn how to build your own multi-channel software for eBay & Amazon
- Access to the community forums, meet fellow business owners like yourself
Join Now with 2 Clicks
Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.
Most Users Ever Online: 1012
Currently Browsing this Page:
Jim @ Moogento: 688
Steve Froggatt: 514
Badeth - UE: 513
Paul Cartwright: 414
Administrators: Matthew Ogborne: 4565, Dave Furness: 4606