Pipe17 Candidate Challenge
- Patrick Sayegh
- Raul Lopez
A new Pipe17 customer, Martha, is a Shopify merchant looking to automate her post-checkout operations. She's hoping that Pipe17 will be able to automatically route US orders to her US-based warehouse while Canadian orders route to her Canadian-based warehouse. Martha is already live on Shopify and has connected her store to Pipe17. However, she is not sure where to begin. As Martha's onboarding manager, you are responsible for getting her account configured and troubleshooting any errors along the way. Let's begin!
To get started, visit Martha's online store by going to https://pipe17-hiring-challenge.myshopify.com/ . The password to access the store is Pipe17Challenge
In a separate tab, log in to Martha's Pipe17 instance:
Site: https://app.pipe17.com
Username: ops+challenge@pipe17.com
Password: Pipe17Test!@
You can use the following resources within the Pipe17 Help Center to guide you through this challenge:
Pipe17 Quick Start Guide
Setting Up Shopify
Location Mapping
Exceptions
Email:
First and Last Name:
1.
Martha is wanting Pipe17 to Pull her orders, products from Shopify and wants to Push inventory updates and fulfillments back to Shopify. Through the Shopify V3 integration settings and based on the Pipe17 Help Guide for setting up Shopify - are the integration settings setup to achieve what Martha wants? Explain below:
Steps:
Resources Links Used If Any:
2.
After the integration settings are setup, can you confirm that Martha integrated her 3PL that will handle her fulfillments? What is the name of the 3PL/Warehouse connected?
Name of integration:
Link in admin:
Resources Links Used If Any:
3.
Now that you have checked the Shopify integration settings and confirmed the 3PL - now you will need to check what locations are being pulled into Pipe17. For context, each connector will pull locations into Pipe17. This will be true for Shopify and for any 3PL that is connected. Please head into Inventory > Locations and see what locations show up. What locations do you see?
Location(s) Name and links:
Screenshot of locations:
Resources Links Used If Any:
4.
With the locations confirmed, are both locations linked/merged? If not, using the location mapping resource for reference on how you can link both locations that are created by Marthas 3PL to the Shopify created location? Explain your steps below:
Steps:
Screenshot:
Resources Links Used If Any:
5.
Once the locations are confirmed and linked together, head into integrations > Order Routing Engine > Routing Rules and see if Martha set anything up. If nothing is setup, please setup routing for Martha so US based orders route to the US 3PL and CA based orders are routed to the CA 3PL. Explain your steps below:
Steps:
Screenshot:
Link to Order Routing Engine:
Resources Links Used If Any:
6.
Everything is looking great! Now you can test your setup by Placing an order on Marthas Shopify site for Product1. Use your own name with a shipping/billing address of:
2101 4th Ave.
Seattle, WA 98121
United States
Be sure to enter your own email address so that you can stay updated on the order's progress. Your total should be $0.00, so no credit card will be required for this order. Once the order is placed, please enter the order # below.
Order#:
7.
After about 5 minutes, the new order should be in Pipe17. You can view the order by clicking Orders > All Orders in the Pipe17 portal. Is the new order in Pipe17?
Yes
No
If no, please check the Shopify connector settings within the Pipe17 portal by going to Integrations > Shopify V3 > Settings tab. Please also explain your steps.
Other:
Resources Links Used If Any:
8.
Great! The order is in Pipe17 and should be routed soon. Since the address is in the United States, the order should be routed to the Pipe17 US Warehouse. But wait...there's a "Sent Order Failure" exception that is preventing the order from being routed. Locate the source of the problem, fix it, then re-run routing on this order.
Remember, Martha would like to route any order with a US address to the "Pipe17 US Warehouse"
Were you able to successfully route the order? Explain what you did below.
Steps:
Links in admin:
Resources Links Used If Any:
9.
Assuming you've successfully routed the order to the correct warehouse, the status of your order in Pipe17 should have changed from "Ready for Fulfillment" status. What does the status appear as now?
Steps:
Links in admin:
Resources Links Used If Any:
10.
To close out the order, Pipe17 should have pushed the tracking information to Shopify, but this did not happen.
Martha writes the following into support: "The order shows as fulfilled in Pipe17 with a tracking number - but the tracking did not push to Shopify. My customers are now left in the dark not knowing where their order is. What is going on? Please fix this" Locate the source(s) of the problem, fix it, then type your response to Martha in the box below.
Steps:
Links in admin:
Resources Links Used If Any:
11.
Next, visit Martha's store once more and place an order for PRODUCT2 under your name, with a shipping and billing address of:
2101 4th Ave.
Seattle, WA 98121
United States
The total for this order should be $0.00 so no credit card will be required.
Enter the new order number in the box below.
Order#:
12.
This order should automatically route and fulfill within 5 minutes. However, you see another Sent Order Failure exception in the Pipe17 portal.
Hint: The source of this problem could exist in two places within the Pipe17 portal.
Fix the problem(s), re-run routing, and explain what you did to fix it in the box below.
Steps:
Links in admin:
Resources Links Used If Any:
13.
Now that everything is running, Martha mentions that there was a change by one of her staff on this date: . This change has been reverted since then, but help Martha understand where she could go to look at what was changed and by who on the date given? Where do you find that in Pipe17?
Steps:
What Was The Change?
Who Made the Change?
Links in admin:
Screenshot:
Resources Links Used If Any:
14.
The last part of this challenge will require a meeting with the Pipe17 team to perform an API exercise. Please review the following API docs. Within the coming days, we will reach out to schedule a 1-hour meeting where you will need to have the ability to share your screen.
Please enter your availability in the box below.
BONUS CHALLENGE
Now that everything is working as it should, Martha would like to add a virtual bundle in Pipe17 so that orders for SKU BUNDLE1 are fulfilled with both PRODUCT1 and PRODUCT2. In Pipe17, add PRODUCT1 and PRODUCT2 (both qty1) to SKU BUNDLE1 as components. Submit a screenshot of the final result.
Steps:
Links in admin:
Screenshot:
Resources Links Used If Any: