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.

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.