When creating stores in CMS, use the available fields to provide unique store details.
Field Name
| Field Name | Required | Description |
|---|---|---|
| Store ID | Yes | Unique ID for the store. |
| Name | Yes | Descriptive name for this location. |
| Location Type | No | Type of retail location. |
| Location Brand | No | Brand identifier for this location. |
| Phone Number | No | Contact phone number for customers. |
| Fax Number | No | Fax number for business communications. |
| Address | Yes | Street address. |
| Apartment, suite, etc | No | Additional address details such as suite or unit number. |
| City | Yes | City name. |
| Postal Code | Yes | Postal or ZIP code. |
| Country | Yes | Two-letter country code. |
| State | No | State or province. |
| Latitude | Yes | Geographic latitude coordinate. |
| Longitude | Yes | Geographic longitude coordinate. |
| Time Zone | No |
The order JSON records this time zone under the attribute "timeZoneId". If you enable time zone matching requirements (enabled by default in builds 11.8.1 and later), the system derives the time zone from your postal code. |
| Local Time Offset | No | Refer to Local Time Offset for more information. |
| Hours of Operation | No | Refer to Hours of Operation for more information. |
| Customer ID | No | Customer ID of your ERP configuration, if applicable. For more information, refer to NetSuite ERP CMS Config. |
| Location ID | No | Location ID of your ERP configuration, if applicable. For more information, refer to NetSuite ERP CMS Config. |
| Secondary Location ID | No | Store showroom reference ID of your ERP configuration. The system uses this ID for clearance items. For more information, refer to NetSuite ERP CMS Config. |
| Department ID | No | Department ID of your ERP configuration, if applicable. For more information, refer to NetSuite ERP CMS Config. |
| Class ID | No | Class ID of your ERP configuration, if applicable. For more information, refer to NetSuite ERP CMS Config. |
| Subsidiary | No | Store-level subsidiary internal ID. For NetSuite calls (Search and Create Customer) that pass the subsidiary ID, the system sends the store-level ID if populated at the store level. Otherwise, the system uses the merchant-level ID from the ERP configuration settings in the CMS. For more information, refer to NetSuite ERP CMS Config. |
| Tax Item ID | No | Tax Item ID of your ERP configuration, if applicable. For more information, refer to NetSuite ERP CMS Config. |
| Homepage URL | No | Store website URL. |
| Facebook Page URL | No | Store Facebook page URL. |
| YouTube URL | No | Store YouTube channel URL. |
| Pinterest URL | No | Store Pinterest page URL. |
| Twitter URL | No | Store Twitter profile URL. |
| Product Scan Code Type | No | Barcode format used for product scanning. |
| Allows ship to store | No | Enables customers to ship orders to this location. |
| Allows pickup at store | No | Enables customers to pick up orders at this location. |
| Allows try at store | No | Enables customers to try products at this location before purchasing. |
| CustomString0-CustomString11 | No | Refer to Custom Target Fields in Field Mappings for more information. |
| Location Group Reference IDs | No | SFOCI location group that checks online inventory. Use this field to configure the fulfillment locations and segment inventory. |
Local Time Offset Field Format
You can enter hours in the 24-hour format (+HH:MM).
Example: +10:00 or +00:00 (that is, UTC).
Hours of Operation Field Format
Format Details
The hours of operation are composed of numerical days and hours separated by commas (that is, comma-delimited). The numerical values 1–7 represent the days, with 1 representing Sunday, and 7 representing Saturday.
Example: 1:HH:MM-HH:MM,2:HH:MM-HH:MM,... and so on
You can enter hours in 24-hour format, HH:MM-HH:MM, or in AM/PM format, HH:MMAM-HH:MMPM.
00:00 and 24:00 are equivalent and both acceptable end times for an hour's range.
| Opening Hours | Example |
|---|---|
| Standard hours | 09:00AM–05:00PM |
| Standard hours | 09:00-17:00 |
| Closes at midnight | 09:00AM–12:00AM |
| Closes at midnight | 09:00-00:00 |
| Open 24 hours | 12:00AM–12:00AM |
| Open 24 hours | 00:00–00:00 (or 00:00-24:00) |
| Closed all day | X |
| Open past midnight | Enter these hours in the column for the day when the set begins. |
| Open past midnight | 06:00PM–02:00AM |
| Open past midnight | 18:00-02:00 |
| Open for two sets of hours in one day | 11:30AM–02:00PM, 05:00PM–10:00PM |
| Open for two sets of hours in one day | 11:30–14:00, 17:00–22:00 |
Full Examples
1:x,2:10:00:21:30,3:10:00:21:30,4:10:00:21:30,5:10:00:21:30,6:10:00:21:30,7:10:00:21:30
OR
1:x,2:10:00AM:9:30PM,3:10:00AM:9:30PM,4:10:00AM:9:30PM,5:10:00AM:9:30PM,6:10:00AM:9:30PM,7:10:00AM:9:30PM