The CSV file you create should contain all the supported data attributes arranged in a row at the top of your spreadsheet. You can use the provided template and fill your location information into the relevant fields in the spreadsheet.
Types of fields:
The following table describes each data field with an example and specifies the type as required or optional.
|
Data Field |
Description |
Type |
|
Name |
The name of your business location is used consistently across branding. This text field should have between 2 to 150 characters. |
Required |
|
Address |
The address of the location should be between 5 to 100 characters. Eg: 123 Main St. |
Required |
|
City |
Fill in a valid city/locality for the location. This field should have characters between 5 to 30. Eg: New York. |
Required |
|
State |
Use the abbreviation of the state in the state column. Eg: FL for Florida. |
Required |
|
Postal Code/ Zip Code |
Fill in a valid Postal Code/Zip Code for the location corresponding to the country. Eg: 1001 |
Required |
|
Country |
Fill in the 2 letter county code for the country in which the location is present. Eg: US |
Required |
|
Phone |
Fill in a valid phone number for the location excluding the country code. This field should not exceed 10 digits. Eg: 1234567890 or 800123456 |
Required |
|
Business Categories |
Fill in the valid primary business category for the business engaged in. Refer to categorylist.xlsx for Platform supported categories. Eg: Asian Restaurants |
Required |
|
Description |
Fill in the business description. This field can have a minimum of 200 characters. Eg: Bayside Kitchen is your local restaurant offering the quintessential San Francisco waterfront dining experience. Take in award-winning views of the San Francisco Bay and the Golden Gate Bridge while enjoying complimentary sourdough bread baked in-house every hour, and dining on the freshest sustainable seafood and meats available. Bayside Kitchen is proud to be the first restaurant in Fisherman’s Wharf to serve 100% sustainable seafood. |
Required |
|
Store ID |
A unique ID to help identify the location. This field is optional but strongly recommended. Store ID field supports:
Eg: 123ABC or 123-N |
Optional, but recommended. |
|
Address 2 |
The address of the location should be between 5 to 100 characters. Eg: Suite 51A |
Optional |
|
Additional Categories |
Fill in additional categories for the business engaged in. Refer to categorylist.xlsx for Platform supported categories. Eg: Car Auctions, Car Brokers, Car Buyers, Car Share Services. |
Optional |
|
Hours_Monday |
Business operating hours on Monday. This field should have characters between 7-11. Valid values include: closed / holiday / 24h / hh:mm-hh:mm/ hh:mm-hh:mm, hh:mm-hh:mm (Split Hours). Eg: 10:00-21:00 |
Optional |
|
Hours_Tuesday |
Business operating hours on Tuesday. This field should have characters between 7-11. Valid values include: closed / holiday / 24h / hh:mm-hh:mm/ hh:mm-hh:mm, hh:mm-hh:mm (Split Hours). Eg: 24h |
Optional |
|
Hours_Wednesday |
Business operating hours on Wednesday. This field should have characters between 7-11. Valid values include: closed / holiday / 24h / hh:mm-hh:mm/ hh:mm-hh:mm, hh:mm-hh:mm (Split Hours). Eg: Closed |
Optional |
|
Hours_Thursday
|
Business operating hours on Thursday. This field should have characters between 7-11. Valid values include: closed / holiday / 24h / hh:mm-hh:mm/ hh:mm-hh:mm, hh:mm-hh:mm (Split Hours). Eg: 24h |
Optional |
|
Hours_Friday
|
Business operating hours on Friday. This field should have characters between 7-11. Valid values include: closed / holiday / 24h / hh:mm-hh:mm/ hh:mm-hh:mm, hh:mm-hh:mm (Split Hours). Eg: 09:00 - 12:00, 03: 00 - 11:30 |
Optional |
|
Hours_Saturday
|
Business operating hours on Saturday. This field should have characters between 7-11. Valid values include: closed / holiday / 24h / hh:mm-hh:mm/ hh:mm-hh:mm, hh:mm-hh:mm (Split Hours). Eg: holiday |
Optional |
|
Hours_Sunday
|
Business operating hours on Sunday. This field should have characters between 7-11. Valid values include: closed / holiday / 24h / hh:mm-hh:mm/ hh:mm-hh:mm, hh:mm-hh:mm (Split Hours). Eg: closed |
Optional |
|
Service Area Business |
Choose to hide the address for service area businesses without a storefront. The default value for this field is 'No' (indicates that it is not a Service area business). Valid values: 'Yes' or 'No'. Eg: Yes |
Optional |
|
Business_URL |
Fill in the business website URL. This link should begin with either - HTTP:// or HTTPS://. Eg: https://www.acme.com |
Optional |
|
Business Tagline |
Fill in the brand tagline for the business. Eg: Connect Smarter |
Optional |
|
Owner Name |
Fill in the name of the owner or person in charge of the location. This field has no character limitations. Eg: John Doe |
Optional |
|
Owner Email |
Fill in the email ID of the owner or person in charge of the location. Eg: johndoe@acme.com |
Optional |
|
Payment Options |
Accepted payment options that are available at the Location. Valid inputs: 'Visa', 'Master Card', 'American Express', 'Cheque', 'Crypto'. Eg: Visa, Master Card, American Express |
Optional |
|
Year of Incorporation |
Fill in the valid year the company was incorporated in. Eg: 1997 |
Optional |
|
Logo > URL |
Add a PNG or JPG image of the business logo by filling in a valid URL of the image which can be accessed publicly. Eg: http://www.acme.com/logo.png |
Optional |
|
Cover > URL |
Add a PNG or JPG image of the location by filling in a valid URL of the image which can be accessed publicly. Eg: http://www.acme.com/cover.png |
Optional |
|
Facebook Page URL |
Fill in the Facebook Business Page URL. This link should begin with either - HTTP:// or HTTPS:// Eg: https://www.facebook.com/pages/acme |
Optional |
|
|
Fill in the Twitter Business Handle URL. This link should begin with either - HTTP:// or HTTPS:// Eg: https://twitter.com/acme |
Optional |
|
|
Fill in the LinkedIn Business Page URL. This link should begin with either - HTTP:// or HTTPS:// Eg: https://www.linkedin.com/acme |
Optional |
|
Photo_URL 1 |
Add a PNG or JPG image of the business Location/Products by filling in a valid URL of the image which can be accessed publicly. Note: The image file size should be between 10KB - 5 MB. Eg: http://www.acme.com/exterior.jpg |
Optional |
|
Photo_URL 2 |
Add a PNG or JPG image of the business Location/Products by filling in a valid URL of the image which can be accessed publicly. Note: The image file size should be between 10KB - 5 MB. Eg: http://www.acme.com/interior.jpg |
Optional |
|
Photo_URL 3 |
Add a PNG or JPG image of the business Location/Products by filling in a valid URL of the image which can be accessed publicly. Note: Image file size should be between 10KB - 5 MB. Eg: http://www.acme.com/product.jpg |
Optional |
|
Video_URL |
Fill in a video link of the business/location. This link should start with either - HTTP:// or HTTPS:/ Eg:https://youtu.be/Rb0UmrCXxVA?t=1 |
Optional |