Skip to content
  • There are no suggestions because the search field is empty.

Site Product Auto Mapping (Site Setting)

Spark Shipping can map your SKUs to your vendor SKUs automatically.

This process works differently based on the site type you're working on. Please turn on this option with caution, and reach out to support@sparkshipping.com for additional advice.

To find this setting, go to your site and click Product Auto Mapping in the left menu. It is available for Shopify, BigCommerce, ChannelAdvisor, eBay, SellerActive and Amazon sites. The Vendor Defined by Site strategy only works for BigCommerce (Brand) and ChannelAdvisor (Manufacturer); for Shopify, eBay, SellerActive and Amazon sites, use the SKU to Vendor Mapping Table strategy. Turn on Product Auto Mapping, choose the Vendor SKU and Mapping Strategy, and click Update Product Auto Mapping.

How does Product Auto Mapping work?

With the Vendor Defined by Site mapping strategy, the vendor name match is not case sensitive, and only products that are not yet mapped to a vendor are auto-mapped.

Shopify

Spark Shipping does not read a vendor name from Shopify products, so the Vendor Defined by Site strategy does not map Shopify products. Use the SKU to Vendor Mapping Table strategy instead: in the SKU to Vendor Mapping section of this page, click New and add the SKU pattern and the vendor. Products that match are mapped when you save the row. Products added to Shopify later are not mapped automatically, so save the row again after new products come in.

BigCommerce

Spark Shipping will map your product SKUs to your vendors by looking up the Brand field in BigCommerce associated with each product. If you have SKU 123 in BigCommerce with a Brand of Vendor #1, Spark Shipping will map the product to Vendor #1 in Spark Shipping (the vendor name in Spark Shipping must match the Brand in BigCommerce), and will set the vendor SKU to either SKU (maps the SKU to itself) or Barcode (pulled from BigCommerce and set as the vendor SKU).

Channel Advisor

Spark Shipping will map your product SKUs to your vendors by looking up the Manufacturer field in Channel Advisor associated with each product. If you have SKU 123 in Channel Advisor with a Manufacturer of Vendor #1, Spark Shipping will map the product to Vendor #1 in Spark Shipping (the vendor name in Spark Shipping must match the Manufacturer in Channel Advisor), and will set the vendor SKU to either SKU (maps the SKU to itself) or Barcode (pulled from Channel Advisor and set as the vendor SKU).

What does Auto Update SKU Mapping do?

Turning on this option will update the SKU mapping of SKUs previously mapped manually by users. The page warns: This will update all mapped SKUs.

What does Auto Remove SKU Mapping do?

Turning on this option will remove the SKU mapping of SKUs previously mapped manually by users per the new mapping logic. The page warns: This will remove all mappings other automapped SKUs.

What additional mapping options are available?

In addition to SKU and Barcode, the following Vendor SKU options are available when the Mapping Strategy is SKU to Vendor Mapping Table (choosing one of them switches the strategy for you). Use % as a wildcard character.

What is the Matched Pattern option?

Matches the end of a SKU and sets the vendor SKU to the matched portion. Example: %123 matches SKU-123 and sets the vendor SKU to 123

Unmatched Pattern

Matches the beginning of a SKU and sets the vendor SKU to the remaining portion. Example: SKU-% matches SKU-123 and sets the vendor SKU to 123

User Specified

Allows users to define their own mapping logic. To use this option, contact Spark Shipping Support and provide a file containing all your SKU mapping definitions. You can also add individual rows yourself with the New button in the SKU to Vendor Mapping section of the same page.