You may have multiple products that come in multiple variations, such as sizes and colours, but choose to display the product only once on your web store with a drop down selection of the various attributes. These are called Product Variants and are managed differently in each eCommerce system. 


A classic example is a t-shirt style, that comes in different sizes.


The ability to group products together offers many benefits:

  • Search and product pages aren't cluttered
  • Your customers can see available size/colour variations on the one product page
  • You only have to maintain one product


You group your products together on your website automatically using the ManufacturerSKU in Retail Express.

The Manufacturer Code groups the variants in ECommerce as shown below by “Product”.  This SKU is the link between Retail Express and ECommerce. The Supplier SKU is unique for each option or variant such as sizes, this links each product to its corresponding product in ECommerce.


Products are grouped together on your website automatically by giving them the same the ManufacturerSKU (also known as the Code) in Retail Express.

It groups the variants that have a matching Manufacturer SKU in Retail Express into a single product that has "variant options" in your eCommerce. The ManufacturerSKU and Supplier SKU both become links for a product between Retail Express and Ecommerce. The Manufacturer SKU links the product to its grouping both within Retail Express and between Retail Express and your eCommerce, and the Supplier SKU (which is unique for each different product in the group - e.g. the different sizes of a t-shirt), links each variation of the product in ECommerce to its corresponding product in Retail Express.

 

You do not create "Master" products or parents, TranslatorHQ will do that for you.


(There is a special option to group by the Custom3 field, please contact us for more information or check the Knowledge Base.)

 

Retail Express Example

As shown below, In Retail Express the Product group is the Manufacturer SKU, whereas the Supplier SKU includes the size variants.

ProductIdSKU – Supplier SKUCode – Manufacturer SKU
139996MMULXSMMUL
139997MMULSMMUL
139998MMULMMMUL
139999MMULLMMUL

 


Sizes and Colours

A Retail Express variable product matrix must contain unique sizes and colour combinations. The product error report in the comparison reports outline which products contain incorrect variable options.


Good


SizeColourProductIdCode – Manufacturer SKUSKU – Supplier SKU
8BLACK139996MMULMMULXS
9BLACK139997MMULMMULS
8WHITE139998MMULMMULM
9WHITE139999MMULMMULL


SizeColourProductIdCode – Manufacturer SKUSKU – Supplier SKU
8BLACK139996MMULMMULXS
9BLACK139997MMULMMULS
10BLACK
139998MMULMMULM
11BLACK
139999MMULMMULL


Bad


SizeColourProductIdCode – Manufacturer SKUSKU – Supplier SKU
8BLACK139996MMULMMULXS
9BLACK139997MMULMMULS
8BLACK139998MMULMMULM
9WHITE139999MMULMMULL