---
schema_version: "1"
id: 1c43f6fef30bbae4a223b17e6391b161b7f1af9321a9e26a75058e02dabdbefe
title: Store Associate Feed
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/commerce/264-0-0/rt_adv_config_data_feeds_specs_store_ass.md
canonical_url: https://help.salesforce.com/s/articleView?id=commerce.rt_adv_config_data_feeds_specs_store_ass.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 3bd8ea39d69638fb070ed954f519a28ba53f21d791b65f13620aa93993cd406d
description: The store associate feed drives the functionality that creates store associates for all stores. If an associate exists in Point of Sale, all of the data is updated with content from the file.
products:
  - Commerce
release: "264"
---
# Store Associate Feed

The store associate feed drives the functionality that creates store associates for all stores. If an associate exists in Point of Sale, all of the data is updated with content from the file.

## Format

The feed formats are CSV (comma-separated) and TSV (tab-separated).

![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-commerce-retail-264-0-0-production-enus/17d647fb-8988-49fb-9add-c4f4cc79c9e4/images/icon_important.png)

Important All feed files should be saved in a UTF-8 (not to be confused with UTF-8 with BOM) format else you receive an error during upload.

## Types

Full - A complete list of store associates across all stores in one feed file.

## Frequency

It can either be scheduled or manually uploaded

## Content

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col>
          <col>
          <col>
          <col>
          <col>
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d241086e73">CMS Field Display Name</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d241086e76">Data Type </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d241086e79">Max Character Length</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d241086e82">Description</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d241086e85">Example Data</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">first_name</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">128</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">First name of an associate</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">Jake</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">last_name</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">128</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Last name of an associate</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">Gayle</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">role*</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">512</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Role of the associate</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">STORE_MANAGER, STORE_ASSOCIATE, etc.</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">store_associate_id*</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">128</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Store associate ID</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">2036</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">store_type*</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">50</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Store associate password</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">2036</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">store_associate_password_pin</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">512</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Pin for when the password is forgotten</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">2036</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">store_id*</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">128</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Store's ID</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">1</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">additional_store_ids</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">65535</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Pipe-separated values of additional store IDs where the associate can log in</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">2021|2022</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">email_id</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">128</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Email address of the associate</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">associate@predictspring.com</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">gender</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">7</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Gender of the associate</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">male, female, unisex</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">hire_date</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">Number</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">-</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Hire date in UTC milliseconds</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">1640995200000; for 1-Jan-2022 00:00:00, to convert the date to UTC milliseconds a data
              transformation rule can be added on the field mapping.</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">image_url</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">65535</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Profile image link of the associate</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 "><a href="https://www.imgurl/jake.png" target="_blank">https://www.imgurl/jake.png</a></td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">is_active</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">Boolean</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">1</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Status of the associate (active/inactive)</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">1=Active, 0=Inactive</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">merchant_password</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">256</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Password of the associate in Demandware BM (or other ecomm system)</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">DWpwd123</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">merchant_user_id</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">128</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">User name of the associate in Demandware BM (or other ecomm system)</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">admin</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">mobile_config_token</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">Number</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">16</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Corresponding app config token for the associate</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">1212</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">mobile_phone_number</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">40</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Mobile phone number of the associate</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">(408) 555-1212</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">payment_device_id</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">128</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Payment device ID of the associate</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">7777</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">payment_device_merchant_id</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">String</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">128</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">Branch account ID for payment service</td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">7777</td>

          </tr>
          <tr class="">
            <td data-label="CMS Field Display Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e73 ">termination_date</td>

            <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e76 ">Number</td>

            <td data-label="Max Character Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e79 ">-</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e82 ">
              <p>Termination date in UTC milliseconds</p>
              <div>
                <div class="slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium">
                  <div class="slds-media slds-media_responsive">
                    <div class="slds-media__figure"><span class="slds-icon_container slds-icon_container_circle slds-icon-note-warning"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-commerce-retail-264-0-0-production-enus/17d647fb-8988-49fb-9add-c4f4cc79c9e4/images/icon_important.png" alt="Important"></span></div>
                    <div class="slds-media__body" style="padding-top:.5rem;padding-bottom:.5rem;"><span class="slds-text-title_caps">Important</span> The system automatically updates an associate to inactive if they
                      attempt to log in after their termination date. For more information, see <a href="https://help.salesforce.com/s/articleView?id=commerce.rt_cms_creating_store_associates_in_cms.htm&amp;release=264.0.0&amp;type=5" title="Create store associate users in the Point of Sale (POS) system through manual entry or by loading a feed into the Point of Sale CMS.">Creating Store Associates in Point of Sale CMS</a> .</div>
                  </div>
                </div>
              </div>
            </td>

            <td data-label="Example Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d241086e85 ">1640995200000; to convert the date to UTC milliseconds a data transformation rule can
              be added on the field mapping</td>

          </tr>
        </tbody>
      </table>

## Known Issues & Restrictions

- The feed is always a Full Feed i.e., only lines for associates where a change is required or a complete list of associates.
- To terminate an employee, you'll need to set the termination date and status as inactive (0).
- To render an associate inactive, you'll need to set the status as inactive (0). Though if an associate is on sabbatical leave, they can be rendered active based upon their return to work.
- If an associate works in all the stores, you cannot set the associate as "All" under additional\_store\_ids. Instead, you must set each store number (there is no limit on how many store numbers can be included in the field).
- In the initial file upload, the required Target Fields (denoted by an asterisk) must be mapped so they can be available as columns. However, they don’t need to have values and just need to line up with the schema.

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-commerce-retail-264-0-0-production-enus/17d647fb-8988-49fb-9add-c4f4cc79c9e4/images/icon_example.png)

Example

Example feed: [associates\_sample\_feed.csv](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/associates_sample_feed.csv)