When setting up your customer table, you have the option to choose between general column tags or standardized tags for Billing and Shipping information.
General tags, like "Billing Address," are used when the entire address is in a single column. However, standardized billing and shipping column tags break the address into individual fields, such as "Billing - Address Line 1" or "Shipping - State." Using the standardized format ensures consistency across customer entries and is especially helpful for organizing order exports.
Benefits of Using Standardized Column Tags:
- Consistency: Helps ensure that all customer address information is formatted consistently.
- Easier Organization: Improves data organization in the AMP system.
- Order Exports: Standardized tags make it easier to export billing and shipping information in an organized, predictable format.
Standardized Column Tags
Below is a list of the standardized billing and shipping column tags:
| Column Tag | Input Example | Column Tag | Input Example |
|---|---|---|---|
| Billing - Address Line 1 | 2552 Poplar Ave | Shipping - Address Line 1 | 6220 S Orange |
| Billing - Address Line 2 | Suite 002 | Shipping - Address Line 2 | (empty) |
| Billing - City | Memphis | Shipping - City | Miami |
| Billing - State | TN | Shipping - State | FL |
| Billing - Postal Code | 38112 | Shipping - Postal Code | 32809 |
| Billing - Country | US | Shipping - Country | US |
How to Convert from Single Column to Multi-Column Format
If you're updating your customer table to use the standardized tags, follow these steps:
Check API Integration:
- If your customer table is updated via an API, verify the integration through the Integrations and Connections tab in the CMS (top-center).
- If needed, work with your IT team to update the API to support the new columns.
Manually Add the Columns:
- Add 12 new columns for billing and shipping details. Each column should represent one part of the address (e.g., Billing - Address Line 1, Shipping - Postal Code, etc.).
- You can either manually add these columns using Excel or through the Edit Table function in AMP.
Tag the Columns:
- Be sure to tag each column with the correct standardized tag. For more details, see How to Column Tag in the AMP documentation.
Remove or Hide Old Columns:
- Remove the previous single address columns or change their tag to "Hidden / Unused" to ensure they're not included in future exports.
Pro Tip:
If you’re using an API to update your customer table, it’s recommended to perform steps 2-4 before updating the API file. This helps prevent downtime or data issues with your integration. Additionally, notify AMP Support if you want to take advantage of these new fields for AMP order exports.