Field

Data Type

Notes

Value Required

Cannot be Null

Store Identifier

integer

Will be used as a primary key.

X

X

Store Name

string

255 characters maximum.

X

First Address Line

string

255 characters maximum.

X

Second Address Line

string

255 characters maximum.

X

City

string

500 characters maximum.

X

State

string

50 characters maximum.

X

Zip Code

string

10 characters maximum.

X

Phone

string

20 characters maximum.

X

Country Code

string

4 characters maximum.

X

Latitude

string

255 characters maximum.

X

Longitude

string

255 characters maximum.

X

Store Number

string

100 characters maximum.

X

Hours

string

X

Updated Date

datetime

Defaults to the current date.

X

Active Flag

string

Value should be either “Y” or “N”, defaults to “N”. 1 character maximum.

X

Site Identifier

integer

X

External Store Code

string

55 characters maximum.

X

Store Type Identifier

integer

X

Store Pickup Availability Flag

string

Value should be either “Y” or “N”. 1 character maximum.

X

Title

string

Image File

string

255 characters maximum.

X

Image File Alternate Text

string

255 characters maximum.

X

Meta Keywords

string

Meta Description

string

Sitemaps Priority

string

Valid values are 0.1 to 1.0, in 0.1 increments.

Sitemaps Change Frequency

string

Valid values are “Always”, “Daily”, “Weekly”, “Monthly”, and “Yearly”.

Meta Keywords

string

Exclude from XML Sitemaps Flag

string

Value should be either “Y” or “N”. 1 character maximum.

Notification Start Date

date

Notification End Date

date

Notification Radius

integer

Special Hours Notification

string

Notification Display Start Date

date

Notification Display End Date

date

Special Hours

string