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.

How does Product Auto Mapping work?

Shopify

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

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).

Auto Update SKU Mapping

Turning on this option will update the SKU mapping of SKUs previously mapped manually by users.

Auto Remove SKU Mapping

Turning on this option will remove the SKU mapping of SKUs previously mapped manually by users per the new mapping logic.

Additional Mapping Options

In addition to SKU and Barcode, the following options are available when using the SKU to Vendor Mapping Table. Use % as a wildcard character.

Matched Pattern

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.