This article explains mapping and importing data for SPS Commerce orders.
Once you have connected your SPS account, we will start pulling in orders using their Transaction API. You will be able to configure the rules for mapping and importing order data and importing after the first order has been pulled. By default, we will use the folder structures and file naming conventions in their documentation.
Our order importing rulesets are tied to the trading partner IDs that SPS assigns to your retailers. SPS will happily provide them to you if they haven’t done so already.
Note: SPS trading partner IDs are unique to a specific retailer-supplier relationship. They will normally contain fifteen characters, and follow this structure:
- The first three 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
This section covers configuring how orders are imported from an SPS Commerce account connected to a ShipHero brand account or 3PL client.
The diagram below illustrates the brand and 3PL client order import flow:
Steps
Log into shipping.shiphero.com or the Packing App.
Click on your profile picture and navigate to Settings > SPS. Under Partner identifiers, you will see a list of trading partners obtained from pulled orders.
Click on the Map button for the trading partner that you want to configure.
From the pulled orders, select which SPS product identifiers to use when mapping PO line items to products. These product identifier types are obtained from the trading partner's orders. You can map them to your ShipHero products' SKUs or barcodes.
If neither value would be found on the orders, you can upload a dictionary with the external values. This may be necessary, for example, if your retailer sends you orders with their own part numbers identifying your products. Once uploaded, these dictionaries are reusable across multiple rulesets.
Importing from ERPs
SPS is able to import retailer orders through an ERP as well as directly. These orders will often take the form of EDI 940 docs.
In order to import EDI 940s, please 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 a field called DepositorOrderNumber at the same level as the PurchaseOrderNumber field. We will import the pick ticket number as our order number, and the PO number as our partner order ID.
Additional configuration
If you need orders to be pulled from a folder other than the one suggested by SPS, or have other special requirements for mapping SPS order fields, please contact our Support Team.