Mapping and import rules in ShipHero control how SPS Commerce purchase orders are matched to your products and imported for fulfillment. Configure these settings after your SPS account is connected and the first orders have been pulled.
Once your SPS account is connected, ShipHero begins pulling in orders via the Transaction API. 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 SPS Commerce Orders as a Brand Account
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:
- Go to shipping.shiphero.com or open 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, 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 SPS Commerce Orders 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 SPS Commerce Configuration
For custom folder configurations or other special mapping requirements, contact our Support Team.