Goflow Documentation Logo

Mapping Listings to Products

Store listings represent the items you offer on sales channels. Each listing is mapped to a single product in your Goflow product catalog, which serves as the central record for product information and inventory. If you sell the same item on multiple channels, each channel will have its own listing. However, all of those listings can be mapped to the same product in your Goflow catalog.

For exmaple, you may sell the same water bottle on multiple channels:

All three listings are mapped to the same Goflow product:

Mapping multiple listings to a single product allows you to manage product data and inventory in one central place. This provides several benefits:

Mapping a Single Listing

To map a single listing, follow these steps:

  1. From the left sidebar, go to Listings › Listings and open the listing.
  2. On the Status card, under Not Mapped to a Product, click Map.
  3. Select the product item number.
  4. (Optional) Select the unit of measure.
  5. Click Save to apply the mapping.

If you enable order imports before listings are mapped, Goflow may import orders where the product is not yet known. In these cases, the order is placed in Review with the reason Listing Not Mapped. Once all listings in the order are mapped, the order automatically moves out of Review.

Mapping to a Unit of Measure

Units of measure define the quantity configurations by which a product can be sold. A store listing can be mapped either to a single unit of a product (Each) or to a case pack. When an order is placed for that listing, the order quantity reflects the mapped unit of measure.

When mapping a listing, the product default sales unit of measure is automatically prepopulated in the mapping modal.

Editing a Listing Mapping

To change the product mapped to a listing, you must first unmap the listing and then map it again to the new product.

To unmap a listing, follow these steps:

  1. From the left sidebar, go to Listings › Listings and open the listing.
  2. On the Status card, under Mapped to Product, click Unmap.
  3. In the mapping modal, click Unmap, then confirm by clicking Unmap again.

Unmapping a listing removes the product from all open orders containing that listing. Those orders are pulled out of their current workflow and moved to Review.

Mapping Listings in Bulk

You can map multiple listings in bulk using a CSV file. Follow these steps:

  1. From the left sidebar, go to Listings › Listings.
  2. At the top of the page, click Import › Import Listing Mappings.
  3. Select the store.
  4. Select the Columns tab to review the required file headers.
  5. Go to the Upload tab and click Download Listings Requiring Mapping to get an export of unmapped listings.
  6. Fill in the product Item Number for each listing.
  7. (Optional) enter the unit of measure quantity.
  8. Review the general guidelines for file uploads in Goflow.
  9. Click Choose File to select your file, then click Import.

Each row must include at least one listing identifier:

You do not need to include both headers. In most cases, the Store SKU is sufficient. The Listing ID is only required when multiple listings share the same Store SKU.

Because Listing IDs are often long numeric values that can be corrupted by Excel formatting, it is best practice to clear the Listing ID column and use only the Store SKU.

The sample file below demonstrates several listing mapping scenarios. The Comment column is included only to explain each example and would not normally be part of the upload file.

Store SKUListing IDItem NumberUnit of MeasureTitleComment
WB-32-BLUEBOTTLE-3232 oz Stainless Steel Water Bottle - BlueMapping a store SKU to a product
AV-32-BLUEBOTTLE-3232 oz Stainless Steel Water Bottle - BlueMultiple listings can be mapped to the same product
WB-32-BLUE-CS6BOTTLE-32CS32 oz Stainless Steel Water Bottle - Blue (Case of 6)Mapping to unit of measure by abbreviation
WB-32-BLUE-CS8BOTTLE-32832 oz Stainless Steel Water Bottle - Blue (Case of 8)Mapping to unit of measure by quantity
COF-MUG-WHT210067658MUG-12-WHTCeramic Coffee Mug 12 oz - WhiteUsing the listing ID because the SKU is duplicate
COF-MUG-WHT210097654MUG-12-WHTCeramic Coffee Mug 12 oz - WhiteUsing the listing ID because the SKU is duplicate

Approving Listing Mappings

If you are concerned about the accuracy of your listing mappings, especially with large catalogs, you can enable mapping approval. This feature allows you review and approve mappings individually at the time it matters, i.e. when a sale is actually made.

When mapping approval is enabled, orders containing unapproved listings are placed in Review with the reason Listing Approval Required. Once you approve the mapping, subsequent orders for that listing will process normally and skip Review. If the listing is later remapped, the previous approval is revoked.

To prevent overselling, listings with unapproved mappings send to the channel a maximum quantity of 1.

To enable this feature, contact Goflow Support.