Column tags are essential in AMP for determining how data in tables is displayed and used. While the column names can be customized, it’s the tags that define how the system processes and displays the data. For example, a column named "SKU" will be tagged with the SKU tag, which will allow AMP to treat that data as a product ID wherever necessary.


This article will walk you through how to tag columns in AMP and what each tag means.


How to Tag Columns in a Table

  1. Navigate to the Table You Want to Edit

    • Whether you are working with the Product Table, Customer Table, Rep Table, etc., start by accessing the specific table you need to tag columns in.

  2. Click the “Update Columns” Button

    • In the table editing toolbar, click the Update Columns button to begin editing your column tags.

  3. Select Column Tags

    • In the review screen, you will see a dropdown menu under each column name. Use this dropdown to select the appropriate column tag for each column.

  4. Accept and Upload

    • Once all columns are tagged correctly, click Accept the Upload to save your changes. Your tagged columns will now be properly formatted for use across AMP.



  5. Tag Columns After Uploading (Optional)

    • If you’ve already uploaded a table, you can still tag columns by navigating to the column settings after the upload is complete.


Column Tags and Their Functions

Below is a list of common column tags and their functions. Understanding these tags will help you organize your data efficiently.

  • SKU

    • Uniquely identifies a product.
    • Used in AMP to reference the product ID and appears on order forms.
    • Data Type: String.

  • Item Name

    • The name of the product (e.g., “Amadeus Standing Desk”).
    • Displayed next to the product photo and on order forms.
    • Data Type: Counted String Set.

  • Category

    • Specifies the category (e.g., “Dining”, “Bedroom”).
    • Helps filter products within the app.
    • Data Type: String Set.

  • Sub-Category

    • Defines the subcategory (e.g., “Chair”, “Table”).
    • Aids in filtering products further.
    • Data Type: String Set.

  • Item Short Description

    • A brief product description.
    • Data Type: String.

  • Item Long Description

    • A detailed product description.
    • Data Type: String.

  • Item Dimensions

    • Measurements of the unboxed product (length, width, height).
    • Data Type: String.

  • Item Weight

    • The weight of the product (in pounds).
    • Data Type: Decimal.

  • Inventory

    • Shows the product’s availability or stock level.
    • Data Type: Inventory.

  • Exclusive Price

    • A special price for authorized customers.
    • Data Type: Price.

  • General Price

    • A base price available to all customers.
    • Data Type: Price.

  • Photoset - Solo

    • A product solo image.
    • Data Type: Highlander String.

  • Page Title

    • Title of the product page. If not specified, a default page title will be generated.
    • Data Type: String.

  • Item Sorting Key

    • Determines the order in which items appear on a page (alphanumeric order).
    • Data Type: String.

  • Page ID

    • Used to create custom product or item groups.
    • Data Type: String Set.

  • Product Prominence

    • Indicates the prominence of the product on the page. Can be “Low”, “Medium”, or “High”.
    • Data Type: String.

  • Stock Level

    • Indicates stock availability (based on inventory).
    • Data Type: Stock Level Basic.

  • Item Features

    • A list of product features (e.g., "water-resistant", "ergonomic design").
    • Data Type: String Set.

  • Documents

    • A list of related documents for the product (e.g., user manuals, warranties).
    • Data Type: String Set.

  • Cost

    • The price at which the product is purchased from suppliers.
    • Data Type: Price.

  • Replacement SKU

    • The SKU used to replace a product in different catalogs or sources.
    • Data Type: String.

  • Brand Name

    • The brand name of the product.
    • Data Type: String.

  • UPC

    • The Universal Product Code (UPC), used for scanning.
    • Data Type: String.

  • Shipping Weight

    • Weight including packaging, used for shipping calculations.
    • Data Type: Decimal.

  • Volume

    • The shipping volume in cubic feet.
    • Data Type: Decimal.


Conclusion

Tagging your columns correctly is essential to ensuring that your data is displayed properly and functions correctly in AMP. By using the correct column tags, you help AMP understand how to treat and display the data, making it easier for you and your team to manage your product catalogs, pricing, inventory, and more.


If you have questions about specific tags or need additional assistance, feel free to reach out to AMP Support at support@amptab.com.