October 4, 2025
Preserve leading zeros in zip codes
Excel users can now preserve leading zeros in zip codes by prefixing them with a single quote
ImportsOrdersCustomersCompaniesDraft Orders
October 4, 2025
Importing zip codes that start with zeros (like 01234
) can be tricky because Excel automatically strips leading zeros. We’ve made this easier to handle by allowing you to prefix the zip code with a single quote ('01234
).
🔧 Improvements
- Zip code formatting – prefix any zip code with a single quote (
'01234
) in your spreadsheet to preserve leading zeros. The quote is automatically removed during import and works for all address types across orders, draft orders, customers, and company locations.