This article covers how to configure mapping and import rules for SPS Commerce orders in ShipHero.
Once your SPS account is connected, ShipHero begins pulling in orders via the Transaction API. Mapping and import rules can be configured after the first order has been pulled. By default, ShipHero follows the folder structures and file naming conventions defined in SPS's documentation.
Import rules are tied to the trading partner IDs that SPS assigns to each of your retailers. Contact SPS directly if you haven't received these IDs yet.
SPS trading partner IDs are unique to a specific retailer-supplier relationship. They normally contain fifteen characters and follow this structure:
- The first three characters identify the retailer.
- The next three identify the context in which the ID is used.
- The last nine identify the supplier.
Mapping as a brand
The steps below apply to SPS Commerce accounts connected to a ShipHero brand account or 3PL client account.
The diagram below illustrates the brand and 3PL client order import flow:
Steps
- Log into shipping.shiphero.com or the Packing App.
- Click your profile picture and go to Settings > SPS. Under Partner Identifiers, you'll see a list of trading partners from your pulled orders.
-
Click Map for the trading partner you want to configure.
-
Select which SPS product identifiers to use when mapping purchase order line items to products. These identifiers come from the trading partner's orders and can be mapped to your ShipHero product SKUs or barcodes.
-
If the identifier values are not present on the orders, you can upload a mapping dictionary with the external values. This is useful when a retailer sends orders using their own part numbers for your products. Uploaded dictionaries can be reused across multiple rulesets.
Importing from ERPs
SPS can import retailer orders directly or through an ERP. ERP-sourced orders often come in as EDI 940 documents.
To import EDI 940s, ask your SPS Implementation Manager to convert them to EDI 850s before forwarding them to ShipHero.
If the ERP splits the order into individual pick tickets, ask your SPS Implementation Manager to place the pick ticket number in the DepositorOrderNumber field at the same level as PurchaseOrderNumber. ShipHero will import the pick ticket number as the order number and the PO number as the partner order ID.
Additional configuration
For custom folder configurations or other special mapping requirements, contact our Support Team.