Master SKU & Channel Listings

Overview

To connect your Channel Listings to the Master SKU, follow one of these three options:

Setting the Master SKU via the Import Listings Channel Integration
Setting the Master SKU in bulk via the Import Master SKUs tool
Setting the Master SKU manually at an individual listing level

What is Master SKU?

Within Flxpoint, the Master SKU is a unique, primary identifier. For more information on Master SKU, please see: Master SKU.

Setting Master SKU via Import Listings

What is Import Listings?

If you're unfamiliar with the Import Listings integration, we recommend you begin here: Import Listings. This guide will provide detailed information on using and troubleshooting the Import Listings Integration.

Please note - Only the following channels support Import Listings:

Shopify, Amazon, WooCommerce, BigCommerce & Magento

How to Set Master SKU via Import Listings
Navigate to Channels Select the Import Listings Integration During Step 1: choose your integration type and configure your connection Click Save and Proceed During Step 2: configure your settings and select your Master SKU field Click Save and Complete To import the listings, click Run Integration

Master SKU options will vary by sales channel. Please see below for a comprehensive list of Master SKU value options:

Amazon	Big Commerce	Magento	Shopify	WooCommerce
SKU	SKU	SKU	SKU	SKU
	UPC	UPC	Barcode
	MPN

Pre-Existing Master SKUs

If you have previously imported listings and set Master SKUs, any future import listings job will automatically link to existing Master SKUs.

If no Master SKU match is found, Flxpoint will create a new product with the Master SKU.

Setting Master SKUs at a Later Time

If you choose to set your Master SKUs at a later time, you will need to set the Master manually or in bulk using the Import Master SKUs tool.

Setting Master SKU via Import Master SKUs

How to Import Master SKUs
Navigate to Channel Listings Click Actions Scroll down to Import Select Master SKUs In the pop-up menu, select the channel you have imported listings from Click Export Listings. The export will automatically select all listings missing Master SKU. Select Download Listings In the downloaded CSV, customize your Master SKU by entering the new value in the Master SKU column Once you have entered new Master SKU values for all SKUs, save the file Once saved, click Upload Master SKUs and select the file To complete, select Import Master SKUs

Download Listing Spreadsheet: UPC, MPN, ASIN, & Title Fields

The UPC, MPN, ASIN, and Title fields are populated to help you identify the item tied to a SKU. These fields will not update using the Import Master SKUs tool.

To customize these fields, please see: Customizations.

Download Listings Spreadsheet: SKU & Master SKU Required

The SKU and Master SKU fields are the only required fields to operate Import Master SKUs.

If you choose to upload your own file, the following header names are required:

Header Name: SKU

Header Name: Master SKU

The header names are case-sensitive. Be sure to enter the header names exactly as provided.

Manually Setting Master SKU

Flxpoint also provides you the ability to manually set your Master SKU on an individual listing. Follow the directions below for each listing you would like to manually set the SKU for.

How to Manually Set Master SKU
Navigate to Channel Listings Select the filter: "Missing Master SKU" Click and open desired listing In the Product Link section, click Select/Create Product In the pop-up menu, you have two options: Link to an existing product & master sku Create a new product & master sku by clicking New Product in the top right Once you have selected or created the Master SKU, click Save Variant to complete

Identifying Listings Missing Master SKUs

To identify listings missing the Master SKU, use the saved filters "Missing Master SKU" in the Needs Attention category. Once identified, you can follow the instructions for manually setting the Master SKU or use the Import Master SKUs tool.

Flxpoint Knowledge