The Point of Sale store feed drives the functionality to find a nearby store for a user based either on the user’s location or a manually entered location by the user.
Format
The feed formats are CSV (comma-separated), TSV (tab-separated), PSV (pipe separated), and pipe separated.
Frequency
Once a week.
Content
| CMS Field Display Name | Required | Important | Description | Data Type | EXample Data |
|---|---|---|---|---|---|
| address_line_1 | Yes | Required | The street address of the store. | String | 123 Main St |
| business_name | Yes | Required | The name of the store. | String | Stanford Mall Store |
| city | Yes | Required | The city of the store. | String | Los Altos |
| country | Yes | Required | The country code of the store. | String | US |
| hours | Yes | Required |
The hours of the store's operation (1=Sunday, 7 = Saturday).  Note This field is not required, however, if this field is left blank for field mappings
(not create/edit) it will default to 8hrs.
|
String |
1:11:00:AM:7:00:PM,2:10:00:AM:8:00:PM,3:10:00:AM:8:00:PM,4:10:00:AM:8:00:PM,5:10:00:AM:8:00:PM,6:10:00:AM:8:00:PM,7:10:00:AM:8:00:PM |
| latitude | Yes | Required | The latitude of the store. | Number | 12.122474 |
| longitude | Yes | Required | The longitude of the store. | Number | 123.457316 |
| postal_code | Yes | Required | The zip code of the store. | String | 94022 |
| primary_phone | Yes | Required | The phone number of the store. | String | 1-503-242-0037 |
| store_code | Yes | Required | A unique store identifier. | String | abc-2036 |
| address_line_2 | No | No | The additional address information. | String | Shopping center ABC, Cross street DEF |
| allow_pickup_in_store | No | No | Buy online pick up in-store | Boolean | true | false |
| allow_ship_to_store | No | No | Buy online ship to store | Boolean | true | false |
| allow_try_at_store | No | No | Is it allowed to try at the store? | Boolean | true | false |
| CustomString0 | No | No | For any new customer field which is not supported by Point of Sale, the custom string is used. | String | |
| CustomString1 | No | No | For any new customer field which is not supported by Point of Sale, the custom string is used. | String | |
| facebook_url | No | No | The URL of the store's Facebook page. | String | https://www.facebook.com/store1' |
| local_time_offset | No | No | This specifies the store-specific time offset. | String | "-07:00" for California stores |
| location_groups | No | No | List of pipe delimited location groups to which a store belongs to in SFOCI inventory services. | String | locgrp1|locgrp2 |
| pinterest_url | No | No | The URL of the store's Pinterest page. | String | https://www.pinterest.com/store1' |
| product_scan_code_type | No | No | The store-level product barcode type. | String | GTIN, EPC, or GTIN-OR-EPC |
| state | No | No | The state of the store. | String | CA |
| store_description | No | No | The description of the store. | String | Los Altos Store |
| store_erp_configuration | No | No | The store-specific ERP configuration. | JSON |
'{"storeCustomerId":"PSERPCustomer","storeLocationId":"PSERPLocation", "storeDepartmentId":"PSERPDepartment ","storeClassId":"PSERPClassID","storeTaxItemId":"PSERPTaxItemID"}' |
| store_events | No | No | The in-store promotion or event text. | String | Storewide 30% off from 22nd December to the year-end!!' |
| store_images | No | No | The store image URLs. Multiple image URLs should be accepted when it is pipe-separated in the feed file. | String |
http://a.mktgcdn.com/p/WRMSe.png| http://a.mktgcdn.com/p/WRH7H2rx.png |
| store_type | No | No | The store type. POS Supports outlet, warehouse, and regular store types. | String | Regular |
| twitter_url | No | No | The URL of the store's Twitter page. | String | https://www.twitter.com/store1' |
| website | No | No | The URL link of the store's website. | String | www.store.com |
| youtube_url | No | No | The URL of the store's Youtube page. | String | https://www.youtube.com/store1' |
Store Custom Fields
Stores have custom fields. By using these fields, the values that are entered can be printed on, for example, the receipts of a specified store (from the old receipt configuration) by using the tags assigned to them.
This can be configured in CMS by going to .
- Either create a store by clicking on CREATE in the upper right or edit an existing one by clicking on the pencil icon to the right of the store.
- Under Other Attributes, enter the information manually or use a tag that you wish to display associated with the store.
- Click UPDATE.
Make sure that CustomString0 and CustomString1 are mapped correctly in your Stores Field Mappings. Refer to Map Data Feed Fields.
Known Issues & Restrictions
- For columns that do not conform to the following feed spec names/values, we are able to apply field mappings and optionally field transformations so that product data gets indexed correctly.
- There are several fields that are common with Google Maps store feed spec, see Create a bulk upload spreadsheet for Business Profiles.
- 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.
