Importing your data into StoreBuilder
StoreBuilder has powerful data import tools built in. The most popular and common import format being an excel spreadsheet.
The built in tools support importing Brands, Categories, Tags, Specifications, Availability Rules and Products/Product Variants. Your excel spreadsheet may contain any or all of these data types.
Importing your store's Brands
If your spreadsheet contains a worksheet (or "tab") that is named Brands, the import tool will automatically process this sheet as incoming brand data.
The first two columns of your spreadsheet should be alias and name.
alias is a short, lower case alphanumeric code for this brand which contains no punctuation or spaces (hyphens and underscores are ok).
name is the human readable name for this brand and may contain capital letters, spaces, punctuation and international characters.
The import will try to find any existing brands with the provided alias and update the existing record if it exists, or create a new brand record if none exists.
Master list of supported columns for Brand Import data
| Column Name | Data Type | Description |
|---|---|---|
| Alias | text, maxmimum 32 characters | A short, lowercase alphanumeric code for this brand which contains no spaces or punctuation (hyphens and underscores ok). |
| Name | text, maxmimum 128 characters | The human readable name for this brand. May contain capital letters, spaces, punctuation and international letters. |
| UrlSlug | text, maxmimum 128 characters | The path within your website for the target brands main page. If no explicit Url Slug is provided, StoreBuilder may generate one from the Name or Alias field if provided. Example /acme-products |
| Summary | text | A short, 1-3 sentence summary about this brand or why you carry it. This content is often included on pages that reference this brand such as the brand listing page. This field may contain html markup. |
Importing your store's Categories
If your spreadsheet contains a worksheet (or "tab") that is named Categories, the import tool will automatically process this sheet as incoming category data.
Importing your store's Tags
If your spreadsheet contains a worksheet (or "tab") that is named Tags, the import tool will automatically process this sheet as incoming tag data.
Importing your store's Specifications
If your spreadsheet contains a worksheet (or "tab") that is named Specifications, the import tool will automatically process this sheet as incoming specification definition data.
Importing your store's Availability Rules
If your spreadsheet contains a worksheet (or "tab") that is named Availability Rules, the import tool will automatically process this sheet as incoming availability rule definition data.
Importing your store's Products and Product Variants
If your spreadsheet contains a worksheet (or "tab") that is named Products, the import tool will automatically process this sheet as incoming product data.
The first two columns of your spreadsheet should be product sku and variant sku suffix.
product sku is a short alphanumeric code for the target product master record.
variant sku suffix is appended to the master product sku for the target variant of this product.