Brands
Module overview
In this module, brands are managed. This module is language dependent. It is typically the starting module when creating completely new assortments.
How to use the data editing feature
How to use the editing template
Data & definitions
The brand template is divided into five sheets:
- Brands: This is where brands are created and basic information about brands is managed
- Images: Brand images are managed here
- Documents: Brand documents are managed here
- Videos: Brand videos are managed here
- Descriptions: Descriptions for brand entities are managed here
Brands
| Data | Definition | Rules & validation |
|---|---|---|
| brand_name_slug | Unique identifier for the brand entity | Mandatory. Can only contain alphanumerical characters and “-“, “_”. Each brand slug must be unique within the organization. |
| brand_name | The public name of the brand entity | Mandatory |
| logo_image_url | The URL to the brand logo | Highly recommended |
| landing_page_url | The URL to the manufacturer’s landing page for the corresponding brand | Only filled when applicable. Must be valid URL. Validated for 200 response. |
Images
| Data | Definition | Rules & validation |
|---|---|---|
| brand_name_slug | Reference to a brand in the brand sheet or an existing brand in SQARP | Mandatory. |
| image_url | URL to one image file | Must be valid URL to an image file. Validated for 200 response. |
Documents
| Data | Definition | Rules & validation |
|---|---|---|
| brand_name_slug | Reference to a brand in the brand sheet or an existing brand in SQARP | Mandatory |
| document_url | URL to one document file | Must be valid URL to a document file. Validated for 200 response. |
| document_type | Indication of the document type | Must be valid document type |
| document_language_code | Indication of the document language | Lowercased ISO 639-1 Code |
Available document types
Videos
| Data | Definition | Rules & validation |
|---|---|---|
| brand_name_slug | Reference to a brand in the brand sheet or an existing brand in SQARP. | Mandatory. |
| video_url | URL to one externally hosted video. | Must be valid URL to a video. Preferably youtube or vimeo. Validated for 200 response. |
| video_type | Indication of the video type | Must be valid video type. |
| video_language_code | Indication of the spoken video language. | Lowercased ISO 639-1 Code |
Available video types
Descriptions
| Data | Definition | Rules & validation |
|---|---|---|
| brand_name_slug | Reference to a brand in the brand sheet or an existing brand in SQARP. | Mandatory. |
| header | Header to one description block | Cannot contain html, line breaks or other text formatting. |
| description | Body of one description block | Cannot contain html, line breaks or other text formatting |
| bullets | Bullet points of one description block (pipe-separated) | Cannot contain html, line breaks or other text formatting. "|" is used as separator between bullet points. |
| description_image_url | URL to one image file corresponding to one description block. | Must be valid URL to an image file. Validated for 200 response. |
| description_video_url | URL to one externally hosted video corresponding to one description block. | Must be valid URL to a video. Preferably youtube or vimeo. Validated for 200 response. |
Brands
Each row represents one brand entity.
Brands have one global name. If your brand has different names in different languages, please create multiple brands.
To add a new brand, create a new row in the template, identify the brand entity using a slug for the brand, add the brand_name and the URL for the brand logo. Finally the URL for the brand_page if applicable.
To change or remove information for a brand, change or remove the information in the appropriate cells.
Only the brands included in the template will be affected by the change upon upload.
Images
Each row represents one image.
The URL must be a path to an image file. Each brand can have none, one or several images.
To add several images to the same brand, you create several rows with the same brand_name_slug.
To add a new image, simply add a new row, identify the brand entity you want to add the image to using the slug for the brand and add the image URL.
To remove an image from a brand that currently has several images, remove the whole row for that image. To remove an image from a brand that has one image, remove only the image URL.
The order of the images matter and will have the same order in the SQARP platform as they have in the sheet.
To change the order of images, change the order of the rows, so that the image you want as primary appears first and so on.
Only the brands included in the template will be affected by the change upon upload.
Documents
Each row represents one document.
The URL must be a path to a document file. Each brand can have none, one or several documents.
To add several documents to the same brand, you create several rows with the same brand_name_slug.
To add a new document, simply add a new row, identify the brand entity you want to add the document to using the slug for the brand. Add a URL to the document file and then add meta information: identify the document type and the language of the document.
To remove a document from a brand that currently has several documents, remove the whole row for that document. To remove a document from a brand that has one document, remove only the document URL, document type and language.
Only the brands included in the template will be affected by the change upon upload.
Videos
Each row represents one video.
The URL must be a path to an externally hosted video. Each brand can have none, one or several videos.
To add several videos to the same brand, you create several rows with the same brand_name_slug.
To add a new video, simply add a new row, identify the brand entity you want to add the video to using the slug for the brand. Add the URL to the video, video type and language.
To remove a video from a brand that currently has several videos, remove the whole row for that video. To remove a video from a brand that has one video, remove only the video URL, video type and language.
Only the brands included in the template will be affected by the change upon upload.
Descriptions
Each row represents one description block.
Each description block can consist of a header, description, bullets, image and video.
Each description block must be filled in either description or bullets - but can of course have data in all columns.
Each brand can have none, one or several description blocks.
To add several description blocks to the same brand, you create several rows with the same brand slug.
Remember that the order of description blocks matter and will have the same order in the SQARP platform as in this sheet.
To add a new description block, simply add a new row, identify the brand entity you want to add the description block to using the slug for the brand, the brand type and the reference to the brand. Then add the contents to the description block.
To remove a description block from a brand that currently has several description blocks, remove the whole row for that block.
To remove a description block from a brand that has one description block, remove all data except the brand reference, the brand type and the brand slug.
To change the order of description blocks, change the order of the rows, so that the block you want as primary appears first, and so on.
Only the brands included in the template will be affected by the change upon upload.