Shopify is a leading ecommerce platform which many online merchants use for an ecommerce storefront and order management system. At Excelsior, our warehouse near Connecticut, has 3PL fulfillment integration to Shopify that allows us to hook into to your Shopify account to automatically pull new orders, confirm shipped orders, and sync inventory. Here’s how it works:
As Excelsior’s integration is running through the open Shopify orders, it will tag each one to signify the action taken. It will tag the order with a “FULFILLMENT IN PROCESS” tag, if that order passes all the above checks and Excelsior is able to successfully import it for fulfillment. Or it will tag the order with an error tag, if it fails to import an order for any of the above-mentioned reasons. Error tags include: “FULFILLMENT ERROR INVENTORY”, “FULFILLMENT ERROR CHARACTER MAX”, “FULFILLMENT ERROR FOREIGN CHARACTER”, “FULFILLMENT ERROR SHIP ADDRESS”, and “FULFILLMENT ERROR INVALID ITEM”.
Excelsior will skip any order that has a “HOLD” tag applied to it, or a “HIGH RISK” tag applied to it, before our integration imports it. If you do not see a “FULFILLMENT IN PROCESS” tag on the order, then you are free to apply a HOLD tag to the order if you’d like to keep it out of the Excelsior fulfillment system temporarily. Customers can also setup automated processes/scripts in shopify using Shopify Flow, that identify problematic orders and tag them with “HIGH RISK” until they have a chance to review them. Read more about Shopify Flow here: https://help.shopify.com/en/manual/apps/apps-by-shopify/flow
If you need us to cancel an order in the Excelsior system, that same order will import again into Excelsior on the next integration run, unless it is handled in Shopify as well – either by cancelling it, marking it refunded, or marking it fulfilled.
Once an order is imported into Excelsior’s system, any edits made in Shopify will not be carried into Excelsior. Also be aware that orders that have items with missing or invalid SKUs in Shopify, will not be fixed after you fix the item setup in shopify. Order item data is not editable after the order is placed, so if there’s a mismatch it will have to be fixed by Excelsior through an order exception.
After Excelsior physically ships an order and it is marked COMPLETE in our system, our confirmation process will automatically mark that order as fulfilled in Shopify. The order confirmation is a scheduled batch process that runs at 6pm ET and/or 6pm PT (can vary by customer). Orders are confirmed at the line item level. For each order that we mark as shipped, we include the following data which populates in Shopify:
Please talk to Excelsior’s IT support team. The first step is to grant us a login to your shopify account. We will login and generate a private app in shopify called “Excelsior Integrated” with read/write access to both orders and inventory resources. We will then utilize the API keys from the private app in our integration to your store. Setup can take 1-3 days.