Business Import Guidelines
==========================

Use this document as a reference when importing businesses using the Excel import feature. Each row in your spreadsheet must follow the structure below.

Each parameter corresponds to a column header in your Excel file.

-----------------------------------------------------------------------------------------------------------------------------------------------
| Field Name                 | Required                       | Description                                                                   |
-----------------------------------------------------------------------------------------------------------------------------------------------
| name                       | Yes                            | The official name of the business. Must be a string (max 255 chars).          |
| website                    | Yes                            | The business website URL. Must be a valid URL and unique.                     |
| logo                       | No                             | Path to the business logo image. (Max 255 characters)                         |
| email                      | No                             | Business contact email. Must be valid and not disposable.                     |
| phone                      | No                             | Phone number of the business.                                                 |
| short_description          | No                             | Short summary (30–60 chars). If omitted, a default will be used.              |
| description                | No                             | Detailed description (max 1500 characters).                                   |
| tags                       | No                             | Comma-separated list of tags (e.g., tech,design). Alphanumeric only.          |
| address_line_1             | No                             | First line of the business address.                                           |
| address_line_2             | No                             | Second line of the business address.                                          |
| city                       | No                             | City name where the business is located.                                      |
| state                      | No                             | State/region of the business location.                                        |
| zip                        | No                             | Postal code of the business location.                                         |
| country                    | No                             | Country code (must match system-defined country codes).                       |
| category_name              | Conditionally (see note below) | Name of category. Required if `sub_categories` is present.                    |
| sub_categories_names       | Conditionally (see note below) | Names with comma of sub categories. Only used if deeper categorization.       |
| sub_sub_categories_names   | No                             | Names with comma of sub subcategories. Only used if deeper categorization.    |
-----------------------------------------------------------------------------------------------------------------------------------------------

Conditional Field Notes:
- `category_name` becomes **required** if `sub_categories_names` is present in the import row.

- `sub_categories_names` becomes **required** if `sub_sub_categories_names` is present in the import row.
- `sub_categories_names` should be names with comma like (services,shopping,etc...).
- `sub_categories_names` must be linked with the main category

- `sub_sub_categories_names` becomes **required** if `sub_categories_names` is present in the import row.
- `sub_sub_categories_names` should be names with comma like (services,shopping,etc...).
- `sub_sub_categories_names` must be linked with the one of sub categories

- Category names and sub subcategory and sub subcategories names must already exist in the categories table.

Additional Notes:
- Ensure your Excel file includes a header row with the exact field names listed above.
- The importer processes data in chunks of 500 rows for performance.
- Duplicate websites or domains will be rejected.
- All text inputs must comply with content filtering rules (block patterns).
- Use proper formatting for URLs and emails.

Example Header Row in Excel:
name | website | logo | email | phone | short_description | description | tags | address_line_1 | address_line_2 | city | state | zip | country | category_name | sub_categories_names | sub_sub_categories_names