Delivery Location [sn_shop_delivery_location] table

  • Release version: Australia
  • Updated July 13, 2026
  • 1 minute to read

    • The Delivery Location [sn_shop_delivery_location] table stores delivery address information.

    This table contains the following fields.

    Table 1. Delivery Location table
    Field Data type Description
    Address String Calculated value that combines the recipient's name and location.
    Street String Street address of the delivery location.
    City String City of the delivery location.
    State / Province String State of the delivery location.
    Zip / Postal Code String Zip code of the delivery location.
    Country Reference Country of the delivery location.
    Country Name String Country name of the delivery location.
    Shopper Reference Logged-in user who saved this address.
    Recipient Reference User who is the recipient of this address.
    User saved location Boolean Indicates that the user saved the address for future purchases.
    User default location Boolean Indicates whether this is the user's default location.
    Deleted Boolean Indicates that the user soft-deleted this saved address. The record is retained for auditability and possible restore rather than being removed.
    Work address Reference Office location associated with this address.
    Location Reference Location used for integration with third-party systems.
    Address verification Choice Indicates whether this delivery address is a real, shippable location. The options are Pending review, Valid address, or Invalid address.
    Address approval Choice Indicates whether this delivery address can be used for user purchases. The options are Company approved, Not approved, Pending Review, or One time approval.