The Orderful EDI Ecommerce connector connects the app to Orderful as a selling channel, so you can receive purchase orders from your EDI trading partner and send EDI documents back. It pulls purchase orders (850) into the app and pushes PO acknowledgments (855), ship notices (856), invoices (810), and inventory (846) to Orderful. The connector uses Orderful's Mosaic API and the ISA IDs of you and your trading partner.
With this connector, you can:
- Pull purchase orders (850) from your Orderful poller bucket into the app every 5 minutes.
- Send PO acknowledgments (855) that accept or reject orders.
- Send fulfillments to Orderful as ship notices (856), right away or grouped by day or week.
- Send invoices (810) to Orderful, either from invoices in the app or built from fulfillments.
- Send inventory levels (846) for each location or as totals across all locations, on the schedule you choose.
Setup
Before you begin, make sure you have:
- An Orderful account with access to the Orderful portal.
- An Orderful API token. You can find it on the API credentials page in Orderful settings.
- The bucket ID of an Orderful Inbound Poller communication channel set up for Mosaic. The connector pulls purchase orders from this bucket.
- Your ISA ID (Interchange Sender ID) and your trading partner's ISA ID.
- An active trading partner relationship in Orderful for the documents you plan to exchange.
To connect Orderful EDI Ecommerce:
- Navigate to Integrations in the app.
- Click Add Integration, and then select Orderful EDI Ecommerce.
- Under Select Orderful environment, select Orderful Production (https://api.orderful.com) or Orderful Sandbox (https://api.sandbox.orderful.com).
- Enter your Orderful API token in the API Token field.
- Enter the bucket ID of your Mosaic Inbound Poller channel in the Poller bucket ID (Mosaic — orders & fulfillments) field.
- Optionally, enter a bucket ID in the Poller bucket ID (EDI — inventory 846) field.
- Enter your ISA ID in the Your ISA ID field.
- Enter your trading partner's ISA ID in the Partner ISA ID field.
- Under Documents stream, select Live or Test.
- Click Connect.
- After you connect, toggle on the flows you want to use: Pull orders from Orderful, Push PO acknowledgments to Orderful, Push fulfillments to Orderful, Push invoices to Orderful, and Push inventory to Orderful. All are off by default.
Settings
| Setting | Description | Options/Default |
|---|---|---|
| Pull orders from Orderful | Pulls purchase orders (850) from your Orderful poller bucket into the app. | On/Off. Default: Off |
| Exclude orders created before this date | Pulls only orders created after this date and time. If you leave it empty, the app uses the date you created the integration. | Date. Optional |
| Process orders with specific order IDs | Pulls only the purchase order numbers you list. Use this while testing. | Optional. Empty pulls all orders |
| Push fulfillments to Orderful | Sends fulfillments to Orderful as ship notices (856). | On/Off. Default: Off |
| Group fulfillments before processing | Controls when the app sends fulfillments. Grouped fulfillments are sent once on the scheduled day (UTC). | Report without grouping (default), Group fulfillments daily, Group fulfillments weekly, report on Friday, or Group fulfillments weekly, report on Monday |
| Fulfillments transaction format (temporary) | Sends ship notices in X12 JSON format instead of Mosaic. Use X12 JSON only when Orderful hasn't enabled Mosaic for your trading partner. This option requires a custom mapping that produces X12 JSON. | Mosaic (default) or X12 JSON |
| Push invoices to Orderful | Sends invoices from the app to Orderful as invoices (810). | On/Off. Default: Off |
| Push invoice to Orderful with fulfillment | Builds an invoice (810) from each fulfillment and sends it right after the ship notice. When it's on, the app doesn't send invoices from Push invoices to Orderful. | On/Off. Default: Off |
| Push invoices only for specific statuses | Sends only invoices that have one of the statuses you choose. | Optional. Empty sends all statuses |
| Push PO acknowledgments to Orderful | Sends a PO acknowledgment (855) when an order is sent to fulfillment or canceled. | On/Off. Default: Off |
| Process only inventory items with specific SKUs | Sends inventory only for the SKUs you list. Use this while testing. | Optional. Empty sends all SKUs |
| Push inventory to Orderful | Sends inventory levels to Orderful as inventory advice (846) in X12 JSON format. | On/Off. Default: Off |
| Push inventory totals across all locations | Sends one 846 with inventory totals across all locations. When it's off, the app sends one 846 for each location. | On/Off. Default: Off |
| Push inventory on specified schedule | Sends only inventory that changed, or your whole inventory at the interval you choose. | Push only updated inventory (default), or push whole inventory every 15 minutes, 30 minutes, 1 hour, 3 hours, 6 hours, 12 hours, or once per day |
| Force inventory resync | Sends all inventory to Orderful on the next run, and then turns itself off. A full resync can take a long time if you have many products. | On/Off. Default: Off |
Flows
| Flow | Direction | Notes |
|---|---|---|
| Orders (850) | Orderful → Pipe17 | Runs every 5 minutes. Pulls up to 100 items from the poller bucket on each run and ignores document types other than 850. After the app processes a purchase order, it removes it from the bucket. If a newer version of an order arrives, the app updates the order only while it's still in Draft, New, New - Auto Hold, To Be Validated, Review Required, or Ready for Fulfillment. Orders have the source orderful. |
| PO acknowledgments (855) | Pipe17 → Orderful | Runs every 5 minutes. Sends an acknowledgment that accepts the order when it moves to Sent to Fulfillment, or rejects it when the order is canceled. |
| Fulfillments (856) | Pipe17 → Orderful | Runs every 5 minutes, or on the day set in Group fulfillments before processing. Includes tracking number, carrier, ship-to address, and shipped line items. The ship-to location code from the original purchase order is added to the ship notice. The tracking number is also used as the bill of lading number. |
| Invoices (810) | Pipe17 → Orderful | Runs every 5 minutes. Payment terms default to net 30 days. |
| Inventory (846) | Pipe17 → Orderful | Runs every 5 minutes, or at the interval set in Push inventory on specified schedule. Sends on-hand and available quantities by SKU, up to 500 SKUs in each 846. |
Troubleshooting
-
The connection fails with a missing ownerId or partnerId, or missing pollerBucketId, error
A required connection field is empty. Enter values in Your ISA ID, Partner ISA ID, and Poller bucket ID (Mosaic — orders & fulfillments), and then connect again. -
The connection fails with a 401 or 403 error
The API token is wrong or doesn't match the environment. Check that API Token comes from the same Orderful environment you selected in Select Orderful environment. -
Purchase orders don't appear in the app
Check that Pull orders from Orderful is on and that Process orders with specific order IDs is empty unless you're testing. In Orderful, check that the Inbound Poller channel is set up for Mosaic and that 850s are routed to it. If the bucket fills with other document types, they can block new purchase orders. -
An order, fulfillment, or invoice has the status Failed
Orderful rejected the document, for example because of missing data or a trading partner relationship issue. Check the transaction in Orderful for the validation error, fix the data, and then send the document again. -
Fulfillments aren't sent right away
Check Group fulfillments before processing. When you group daily or weekly, the app sends fulfillments only once on the scheduled day.
Need Help?
If you need additional assistance:
- Use Ask Pippen, our AI agent, located at the top of the platform page.
- Submit a support request with as much relevant detail as possible. Learn how to submit a request.
We’re here to help you succeed with your operations.
Comments
0 comments