Optimizing 3PL Management for Multi-Channel Operations with Integration – Register

Optimizing 3PL Management for Multi-Channel Operations with Integration – Register2020-09-17T18:11:18+00:00
ON DEMAND WEBINAR

Optimizing 3PL Management for Multi-Channel Operations with Integration

Register Now

Chris Bidleman Chris Bidleman Integration Solutions
CELIGO
Ebru Saglam Ebru Saglam Sr. Product Marketing Manager
CELIGO

With the unprecedented impact of COVID on supply chain, now more than ever, businesses need to optimize their 3PL management processes. Whether they need to work with fewer resources or process an increasing number of orders, automation is key for operational efficiency.

By integrating their 3PL into NetSuite, businesses can eliminate the need for manually exchanging product, order and fulfillment information with their 3PL Providers, and keep accurate track of inventory leading to healthy business decisions.

In this on-demand webinar, Chris Bidleman from Celigo discusses best practices for fully automating 3PL management processes.

Topics include:

  • State of Ecommerce and impact on supply chain
  • Challenges managing 3PL for multi-channel ecommerce
  • Best Practices for 3PL Management Automation
  • Q & A

Watch now!

Full Webinar Transcript
We have a very hot topic today so we’ll talk about optimizing 3PL Management for multi-channel operations with integrations. And I’m here with Chris Bidleman. So Chris is the director of solutions integration at Celigo and he heads up the solution architect steep. And he has been with the company for more than nine years now. And before that, Chris have worked for different consulting and software companies and he focused on solution-driven results in health care, IT, and supply chain management. And he also has more than 20 years of experience in e-procurement and in e-commerce. So for those of you new to Celigo, a VRN pass integration platforms for the service company. And on our platform, any application can be connected with any other application to automate business processes. So whether you’re struggling to handle increase in sales or had to recently narrow down the size of your operations and work with fewer resources, either case, automation helps. For example, with order-to-cash automation, you can technically process and fulfill more orders without increasing the size of your operations. And if you have NetSuite as your ERP, you can connect any of the business systems you see here on this slide to NetSuite like e-commerce marketplaces storefronts, 3PLs, POS systems, return management applications.. And once connected, then you can centrally manage all aspects of your business from your ERP. As an example, whenever an order is placed on Shopify, it can be– or it will be automatically processed for fulfillment in NetSuite. So today, we will specifically focus on automating 3PL management. So Chris will start by briefly talking about the state of e-commerce today and the impact on supply chain of the various events. And then he will also talk about the challenges of managing 3PL, and then he will share with us his deep experience in this area and walk us through the best practices for 3PL management and operations. And now I will hand it off to Chris. Thank you, Ebru. Hello and welcome. Good morning, good afternoon, everyone. As Ebru mentioned, I am the solution architect here at Celigo. And it’s been an interesting ride since COVID hit in March. The big influx in conversations I’ve had with our different customers across the world, as far as the variety of impacts that I think everyone has seen, the majority of them have seen this uptick in the number of online orders. So a lot of stores had to close physical stores, and everyone’s seen a big spike, especially the folks that were selling essential goods– or even the changes in policy at Amazon as far as shipping out only essential goods, forcing a lot of customers to do MFN or merchant-fulfilled orders that way. So the spike you’ve seen kind of peaked around May, at least according to CCN site, as far as the retail sales and online orders were placed. So this did put a big strain on just the supply chain in general, just from the e-commerce standpoint, but also to the change and the quick reaction people had to do as far as spikes and knowing what stock they had available and when it was going to get there and be able to make some promises. So again, I had some interesting conversations over the last several months with the different customers which I’ll try and share with you today. So there are various challenges as far as managing what’s going on in your third-party logistics companies just because you may have your own warehouse. You may have some 3PLs in different parts of the country, in East Coast, West Coast. You may want to be opening up a new marketplace. I’ve seen a lot of customers wanting to expand into European marketplace or Australia, Down Under. And so I’ve been doing this for a long a long time and thought about being able to spool up a warehouse in weeks as opposed to months that it used to take is still kind of blows my mind. But there are a lot of things you have to evaluate to understand is what is you’re trying to achieve? What is it you want to do with that? If you do want integration going on, can you still handle it manually? So there’s different aspects to the different business processes that you have to look at. But I’ve done literally hundreds of integrations with 3PLs and not a single one of them has been the same because the business needs have been different, the products have been different, what the 3PL’s doing is different because they all offer different solutions across the map. Some do manufacturing, they can do embroidery, they can do lots of other things besides just pick, pack, and ship. So it’s evaluation of knowing all those different aspects and what they can offer as far as a different 3PLs. So we at Celigo as an iPaaS provide that at management to be able to sort of route the logistic side of the orders that are coming in from your multi-channels. So we have a lot of customers that we see have expanded their capacity within their e-commerce platforms spooling up there may be a B2B site versus a B2C site. And so to be able to manage that throughout your entire supply chain you need to be able to have that visibility. And we like to think with our products and iPaaS you can then be able to control that and be able to see when there is problems but also optimize across your supply chain. As I said, we’ve had some recent conversations with customers who had a huge spike of orders coming in and if they would do a flash sale or something and to be able to handle that through their systems, we found bottlenecks, we made some optimization changes, some timing changes, and they’re able to get their orders quickly. And, of course, that translates to customer satisfaction. So those kind of things that we want to be able look at to be able to see across your entire ecosystem. So as I mentioned, when automating a 3PL integrations or be able to interact with your 3PLs, there’s different aspects that you need to kind of look at. You don’t have to do everything. It’s just what is going to be most important and what are those aspects that you want to do? So I’ll get into a little bit more. But this roadmap you can do a phased approach as far as probably more support, of course, always order fulfillment. That’s where you want to be able to get your orders and get your shipments and get things moving through the system. But then there are other– especially if you’re a multi-channel that inventory visibility is very important to be able to syndicate out that inventory. So folks know what they have available or if you have multiple channels that you’re trying to allocate orders across and not do any stock-outs, then again this real-time visibility into the supply chain, again, is one of the things that sort of blows my mind to think about now we can do two-day Prime, now we can do same-day shipping with these type of systems in place and the way the warehouses have optimized their own operation. So it is amazing. And the consumers are also expecting this now, they’re expecting to know where their order is, they’re expecting to know how much you have inventory or if you’re out of stock, when is it going to be in stock. So that visibility there’s a lot of back-end systems that need to be brought into place to be able to do that. As far as items, whenever you introduce new products too to be able to successful launch and be able to handle that expected spike when you do release the new products, especially if you’re in the apparel business where you’re constantly changing your inventory, new seasonal changes, discontinuing others, clearances. So it may be for you it’s more important to have that automation and control over your product sale or your item catalog. We have some customers all they do is sell five items, so they really don’t need automation on that because it’s pretty much the same products. Just sells thousands of them. We could do a whole seminar on return processing, but I’ll touch lightly on that here. And then as far as just getting orders to your 3PLs and to your other distribution centers that you need is also important. But, again, maybe depending on what you’re doing internally and what your business processes are, that each one of these may have a different priority level for you. So what I’d like to do is kind of step you through sort of the guidance that we try and provide to some our customers as far as when they d.o want to automate some of the 3PL integrations or think about expanding out to different marketplaces to kind of go through these different steps as far as review the business processes, look at that the data that’s being transferred between the two endpoints, be able to select an integration option. Because, again, there’s a lot of 3PLs and others that are still using EDI. Maybe they have to go through a value-added network. So I’ll touch on that in the course of what is going to be the next steps. So let’s jump in to look at the business processes. As I said, there’s you look at orders, your inventory, inbound shipments, and your catalog. There are some things to think about. I’m not going to talk about all of these, but I just do want to point out a few things. And one of the main things is your order volume. How are you going handle backorders, which is an interesting conversation in itself, is some folks allow the 3PL to control those backorders? So if you have an order with three items, one of them’s out of stock, do you hold that order, or do you ship out those two items and then ship out the backorder item later? Some folks have policies as far as ship only holding those on. And some 3PLs actually have a policy that they have what they call a fill or kill. If they don’t have the item, they’re going to kill that line item and cancel it. And so now you have to replace that order for that item that wasn’t available. So there’s different things that you have to take into account when you’re talking through your backorder handling. Our recommendation is you handle backorders within your ERP to be able to allocate those out. And I’ll get into that a little bit later here. Because when you’re doing multi-channel order allocation, what is the policies are? Are you putting priority on your B2B wholesale business? Do they get the largest part of the order? Do you want to react to the different– do you steal stock from one of the other locations to be able to fulfill those orders or do you just take everything in a first-in, first-out FIFO approach? So that’s part of the order allocation thing that you have to look at. And I’ll tell you some strategies here in a moment. As far as inventory, obviously there’s adjustments and different things going on within the warehouses themselves, what is available inventory, and be able to keep those in sync. Because if there’s things called shrinkage which happens where a stock just kind of disappears or gets lost even within Amazon, they have whole inventory adjustment report that says we found stock, we lost stock, we damaged stock, etc. etc. So it’s one of those things where stock movements can cause some changes that you thought you had the stock available and it’s not. It’s sitting on a cart moving from one location to another so it sort of disappears, or as Amazon often does, they’ll actually move stock between our warehouses. So having some of that visibility, understanding where your stock is is also very important, especially if it’s sitting on a boat coming across the sea, so to understand where that is and when you’re going to get it. As far as catalogs, I did mention a little bit as far as sort of the strategy there as far as the frequency of how often things change, how many SKUs you have, which is stock-keeping units. Some systems call them items, some call it products but it’s all kind of the same thing. As I mentioned, personalization of those items too. How do you get that? How do you send that personalization message to the warehouse so they can put it on a machine and do some of that type of work before it gets shipped out? So there is some things to work out in your supply chain to be able to get that information properly. And then just what type of items do you sell. Are they assemblies or are you doing job ship orders from other locations? Are you kitting it? So all those aspects have to be taken into account when you’re– especially kits, because a lot of times warehouses don’t know your kit number. All they know is that two items that are in that kit that they have to pick off the shelves, so again, it’s a matter of providing the right information to the warehouse so they know exactly what they are shipping and how it needs to ship, especially if you have customers on your website who are picking, they may have a kit of different items that they are selecting from, different sizes, different colors for this particular kit which we call variable kit or variance. And that also can be quite tricky so there’s different strategies that you need to do as far as be able to tell the warehouse exactly what it is that your customer ordered, but then you’ve got to keep the accountants happy to know what did that item sell for and what is refund value of those items that were sold in those kits. So all those type of strategies need to be taken into account as you’re figuring out where you want automate. And then finally, inbound shipments. This is anything that’s coming into the warehouse, so a shipment from a vendor, a transfer from another warehouse, maybe a return that somebody went on your portal or your web store and want to return is going to ship it back to the warehouse. So all those things the warehouse needs to be aware of that something’s coming in so they can properly receive it. So for Celigo, we do a lot of NetSuite integrations. That’s the majority what we do and I imagine some of the folks on this call have NetSuite as your ERP or order management system. So there are a couple things to consider, hints, if you will, that I want to bring up for your sake is how you’ll set up your 3PLs in your basically virtual locations. How are you going to handle the status? So normally they would have two different locations for maybe good, damaged or QA locations. They would actually be completely different setups of physical locations, but NetSuite recently released what they call inventory statuses. So within the same inventory location, you can have good inventory, bad inventory and be able to allocate across that, so part of your strategy needs to understand which of those features you’re going to enable inventory status is a little trickier because it gives a false view if you just look at that inventory location because maybe everything went into QA and is being inspected, but it’s really not available to pick, pack, and ship. So those are kind of things you have to consider whenever you’re building your saved searches or anything else. Within NetSuite, they have what’s called the inbound shipment record. A lot of the other ERPs have similar sort of records where you might have multiple purchase orders that are accounted for. It’s in a container ship that’s actually going to be received for those multiple POs at the warehouse. So again, which of those are you going to utilize? And it’s best to speak to your NetSuite consultant on the pros and cons of that particular record. Serialization or lot numbers, if you have to manage those, we’ve often found it’s sometimes easier to just use custom fields instead of using the native NetSuite functionality with those serialization or lot numbers because there’s some restrictions. You have to have those numbers in the system before you can actually do a fulfillment. So those are some of the things you have to consider. And then if you have more than one 3PL, if you want to figure out, maybe, zone-based shipping – which warehouse is most cost-effective to ship out of? – there are some functions within NetSuite and other ERPs that do have that sort of order allocation feature to figure out which warehouse that you’re going to allocate those orders to when they once they come in to figure out, what’s the most cost-effective shipping that you can get? And some 3PLs will actually do that for you, whereas an Ingram Micro or some of these others where we just send in the order to them, and they figure out where it needs to ship out of most effectively. I mean, that’s essentially what Amazon does with their FBA. You place a Amazon order, and they’re going to figure out which warehouse is going to be lowest cost for them. And so that’s why sometimes your stock is spread across multiple regions. So again, it just depends on who your partners are to be able to fulfill that need. So when you’re thinking about automating obviously you want to look at what you’re doing manually today. A lot of times, the old what we call sneakernet, when you’re taking orders off your web, printing them out, and then are having to manually enter them to your order management system or into a 3PL portal or their site, is not the best way to do that. I mean, if you are low order volume, sure, maybe that’s not a big deal to you, but we often see errors with that. So those are the type of things that present themselves as good opportunities to save a fair amount of money and repurpose those FTEs that have been doing that manually. When you’re looking at these things you can certainly look at hours per week and look at your return on investment. If you do want to automate some of these steps, as I said, the orders, there’s a couple of different strategies with orders that we’ve seen. Even if you’re doing this manually or through automation, through like an iPaaS like Slagle has, a lot of 3PLs can pull those orders directly out of your web store, and they’ll go in to that system. But then if you’re multi-channel, a lot of times we recommend maybe you– actually, if you have multiple stores, bring that order directly into your ERP. You can allocate it to your different channels, if you will, give priority to it, and allocate it at the ERP and then send it to the 3PL. So again, it’s really up to you how you want to manage that, but it’s just a part of your strategy. And last thing you really want to do is enter those orders in two different systems, possibly three if you have a dropship vendor that’s also going to fulfill that order that was placed on your storefront. So that’s a totally different animal to have to deal with. As far as shipping, certainly different systems need to know about when the order ships, what’s the tracking numbers, and such. So again, if you’re having to manually enter that, that’s a lot of labor. But certainly, with the automation to pull that information out, you can syndicate out that information from the 3PL back to your ERP or order management system and then send it out to the proper channel that that order was placed in. So if you have an eBay order that was fulfilled or Amazon order that you fulfilled, you can certainly route it to that particular web store so then that person can get their notification. Because I think everyone who’s in supply chain management understands that the customer is anxious and wants to get that message that it’s shipped and understand it and be able to track it through FedEx or UPS and see that it’s going to arrive next day if they ordered that overnight shipping order or two-day shipping. So again, that visibility into the supply chain is usually important. And a lot of 3PLs do have the ability to what we call real time pushes or webhooks, or they can syndicate out those messages to whoever subscribes to that event, if you will. So we, Slagle, have the ability to be able to consume that message and do the same sort of syndication out to others in a near real-time basis. So there are a lot of advantages you can have to be able to automate this and get this out to everywhere it needs to know. And same thing with the items, usually your ERP is your item master, so you want to be able to syndicate out the pricing, the inventory, the item information to your storefront as well as your 3PL because they have to understand what is the size of that item, where is it going to be stocked, and all the other things before they can even receive or ship that item out. So again, it’s very important to keep the 3PL updated on all your different items. So as far as integration options that you may have, as I mentioned before, you can handle this in-house, develop a lot of this yourself, but obviously there’s some pros and cons associated with that. There are certain 3PLs that still route through what they call value-added networks and utilize ADI. ADI has been around 30 plus years. And so it’s been part of the supply chain [laughter]. I’d have started mainframes if we were doing still doing ADI. And here we are, doing a lot of ADI integrations to this day. So it is still highly utilized within supply and chain management systems to support for all your trading partners as well as your 3PL. So it’s something to consider. 3PLs also offer some of these integrations that they can plug into your order management system or, as I mentioned before, directly into your e-commerce system. So that is certainly an option. And, of course, we, at Celigo, offer iPaaS integration platform as a service to be able to provide some vantages there too. So certainly, you can look at all those as far as which is you’re going to be your best option, the most cost-effective going forward. So to kind of wrap things up here, I want to– just there’s different checklists you want to be able to do to get through to make sure that you have a successful integration project. As far as understanding your experience within your different partners who are involved with that integration, how much in-house knowledge you may have on the technology itself or your ERP. You definitely need to have your ad-man, whoever that is, available and then be able to sort of go through these checklists of getting credentials and file samples and understanding mappings between the systems. As I said, one might call it product. Another will call it a SKU, and another will call it a variant. Another will call it a matrix item. So there’s lots of different translations. And that’s what sort of we, at Celigo, do. As far as iPaaS, be able to try that sort of mapping between the systems easily and effectively and certainly, cut over and project planning. As I said, you don’t need to do a big bang. You can do this in small chunks and be able to get this– start realizing your investment right away, hit your orders, get your shipments, and then phase in all those other aspects of the different flows that are available to you. So I’m going to show a little bit about this, but there are some common data flows that we often see for each one of these. Doesn’t matter who the 3PL is or who the ERP or order management system is. They’re all kind of the same. There are some minor differences like– let me just mention on inventory. There’s two different type of inventory reports that you can get. One’s called inventory adjustments, which are stock movements that you might want to know when stock’s been damaged or when they find new stock or lose stock. That’s through cycle counts. That’s where that comes in. And then there’s inventory snapshots, which is like name says. It’s like, “What do I have at this point of time?” So this is where you can also pick up shrinkage or other things that might be going on in your inventory. And hopefully, the other hasn’t been too much of that going along the way. And as you see it, the inbound shipments, there’s a lot of different transactions that go on there. So we want to be able to address that depending on how your business model is because perhaps when you ship orders from your vendor, they come into your central warehouse. And then you’re going to do a transfer to the three 3PL instead. Or you may have it shipped directly to the warehouse. So you may want to use inbound shipment. So there’s a lot of decisions that need to be made along the way as far as which data flows might be appropriate for you. And [laughter] as I said, whenever we would do– if I do a scoping call with somebody on their 3PL integrations, there’s a lot of different possible data flows that you may want to do depending on if you’re doing Netsuite, for example, as your ERP. We want to step through each one and understand what is a priority, which is one you want now, do you even need it? Maybe for whatever reason there’s reverse or you just have returns sent in and they just show up on the doorstep of the 3PL. And now we have to figure out how to get those returned and back into stock and then of course get a refund back out to your customers. So there’s lots of different things that we can show. I would like to just quickly give you a view of how this looks when you’re looking at it from an integrator standpoint. So this is our integrator.io platform. As I mentioned each one of these data flows is a flow that we can set up to handle that. We look at it as endpoints and as an example for sales orders, it really doesn’t matter what the data format is that the 3PL might be using. They could be using CSP flat files. They could be using EDI. For us, it looks pretty much the same thing if we’re going to be sending an order out of say NetSuite, it’s the same search. Transforms into the CSP file but if it’s an EDI, same thing. The exact same export out but then we transform it to that 940 EDI format that the 3PL needs. But perhaps say they’re a little more modern and they’re using a web service or they’re using XML as a flat-file. So again there’s lots of different options that are available but for us, it’s just a matter of changing the different endpoint and how they need to communicate and be able to schedule that for you. So we have a lot of templates associated with different 3PLs. So DCL for example is a 3PL we’ve been working with for years and years and done lots of those integrations. We have these preset templates that are already built out. DCL happens to have a web service that has a REST API so we can communicate with them very effectively and be able to connect to their API, send them the order information, and then update the order in NetSuite of whatever that internal ID is for that order. So now we can reference that whenever you want to query about has it shipped yet and then be able to do that. So again the whole idea is to give you a user interface that’s user-friendly, easy to manipulate, and you don’t have to be a programmer to do that. So let me just go back here and just kind of sum things up and hand it back over to Ebru. So as I mentioned we have a lot of examples of different customers who have deployed in this manner and be able to do this Hairhouse Warehouse is one of those that are based out of Australia and they have a supply chain. They want to be able to get out to their different stores. So we integrated a lot of their backend systems to be able to pry that supply chain management with them. So again, I won’t go into all the details here but as you see there’s a lot of things I was talking about as far as the triggers and different things that would be passed between the 3PL provider as well as the inbound and outbound data coming into what they happen to be using, NetSuite in this case. So in summary, automating integrating to your 3PL be it one distribution center or multiple ones across the world, there’s both aspects to the business side as far as being able to have better decisions on your distribution channel and how orders are coming in, provide a better customer experience to that fast and information that they’re expecting to have as far as where things are, and also just be able to shift some of the operations to more strategic instead of a lower-level data entry and all that type of stuff. So there’s a lot of advantages there. And now the IT side, certainly reducing the total cost of ownership by managing all these integrations on a single platforms, who have the visibility of where data is and how it’s going. And when there are problems, you’re managing by exception rather than always having to manually move data around and be able to easily customize it. And also the scaling is up. As I mentioned, we can stand up a 3PL integration in a few weeks where orders and shipments– and you can have a new distribution center up and running in no time. It’s less time than it takes actually to ship the goods there so they can actually stock them and then pick back and ship them when orders do come in. So there’s amazing scalability that’s available to you in the marketplace now as you can make decisions. I mean, we have small, little mom-and-pop shops now who are worldwide distributors of their products with less than 10 people in their entire company because they’ve outsourced to all these different partners. And so again, it kind of blows my mind thinking about the changes I’ve seen over the last 20 years as far as just the supply chain management, the visibility, the systems that are available, and the integrations that are possible to be able to provide that visibility up and down the supply chain. I think with that, Ebru, I’m going to hand it back over to you. Thank you, Chris. That was an excellent presentation. And now, we’ll be taking some questions. So if you have any questions, you can enter them through the chat window. So Chris, first question is, when is a good time to start with automating 3PL business processes? Personally, I think day one is always a good time to start, but as I mentioned before, there is certainly a cost associated with that. I think a phased approach strategy is the best way to handle that. Again, like I say, every time we’ve done a 3PL integration, it’s different as far as priorities. Often, when somebody is going to fire up a new distribution center, their highest priority is actually getting the inbound shipment because, obviously, that warehouse has to receive that stock coming in. And so we have a little bit of a race of time to make sure that that information gets to them before that slow boat comes into their warehouse so they can receive it. Okay. Great. So another question is, can you explain how ticked items in NetSuite can be fulfilled as separate items in the 3PL? Sure. So this is a case where you may have a single SKU out on your, say, Shopify web store. It has a price associated with that. What happens is that comes in, and within NetSuite, you designate that those items are components within that kit. So what happens is you have ability to – I don’t know. I think it’s the old term – blow out the bill of materials, basically, list those two kit items on the pick order that’s going to go to the warehouse. Now often you want to keep track of the kit parent because again, you have to know what it was that they actually bought because in that sales order is just the kit item has a price. But when we send an order to the warehouse, we’re actually listing out those two kit items’ components that are the ones that they actually have to pick, pack and ship in that order. Now, again, coming back in on shipment’s a little tricky but that’s why it’s good to reference that kit parent maybe in a custom column field or something of that nature so that when you do look that up in NetSuite, say, “Okay. I know which line item was actually shipped,” and there again that’s another way of making sure that the line items of the order is also sent to the 3PL so when they actually fulfill it, you can look up the line item. You don’t have to sit there and try and look up SKU numbers because maybe a kit component can be the same and across multiple kits, so then you get into a little bit messy, but that’s usually, again, a conversation needs to be had. Matrix items kind of fall in that same realm too, but yeah, definitely kits can be a bit of a headache. So hopefully that answered that question. Yeah, it’s great. So another question is you talked about how to set up the integrations and so how easy it is to manage the integrations? Do I need to maintain technical stack? The short answer is no, you don’t need to add any technical staff. What we often find is whoever your ERP admin is, so be it Acumatica or NetSuite, because that’s usually one end of the endpoint that’s being connected to, it’s good they understand the objects and then things that are going on but they don’t need to be a programmer. There are certain mapping rules and other things that it’s no more difficult than doing an Excel spreadsheet type of logic to understand how a mapping might work. But most time we find that nobody has to add an additional FTE as long as they do have an admin person and the nice thing about the integrator.io is any user can have a free account but they can subscribe to a particular data flow. So for example, if a invoice error is out for whatever reason, perhaps your finance or your accounts receivable department needs to be notified rather than somebody in IT to handle that error, understand why there was a problem there, so it does allow you to have control over notifications and what visibility and who is the owner that has to handle that error rather than everything always falling on IT. Okay. Great. And so one question we have is so as you said no 3PL integration is the same, so how does Celigo help its customers with onboarding? So the business processes are usually the same. The only thing that usually changes is perhaps the underlying technology as far as the data formats. So what we like to think is Celigo– because we do sort of hide some of that through our technology that you don’t have to do a lot of heavy lifting as far as the data transformations. For the technical folks out there, we essentially turn everything into with Integrator.io so when a message comes in it turns it’s JSON, we can transform that data, and then transform that Jace onto whatever the outbound message is. So we have a lot of ability to do some heavy lifting underneath the covers there but for the end-users, we really do just provide guidance on what is the business processes? What are the accounting impacts to your financial system? And as far as the endpoint, what documents do they need to be able to properly fulfill an order, ship it, and also receive inventory. So we try to take a top-down approach most the time because, to be honest, it is all about the business side of the business. [laughter] That’s silly, the business side of the business. But the business side and the accounting that drives the way the I.T. should be supporting that, those different business rules. So that’s why I mentioned– that’s usually what the differences are is just how a business runs, what different products are selling, how they’re selling it, and just adjusting the different data flows and the business logic that may be inside of those data flows to accommodate those business rules is what we often have to deal with. I’m not sure if that fully answered it but as I say we could provide a lot of guidance because we’ve been doing this a long, long time. And again we try and provide best practices as well as try and put you in contact with other customers who have already been down this road before. So we often try to broker those calls between our customers to collaborate together because you’re going to know better than anyone else about your own business and it’s best you talk to somebody else who’s already but down the road before. And thus why we have these kinds of summits to be able also to share some of that information. Thank you, Chris. So another question is I have multiple e-commerce storefronts and also I’m working with multiple 3PLs. So with integration, can I get a real-time view into my inventory across these 3PLs with a NetSuite and can I also make sure my inventory levels are updated across all my storefronts. Yes. Absolutely. The trick here is each 3PL is a little bit different of how they describe what is available inventory because I think at the end the day that’s really what you want to know is what inventory is available to sell and hasn’t been allocated for another or committed to another order. So to be able to get that information out of the 3PL is what’s part of that and that was that inventory snapshot I talked about but each system is usually keeping track of those in and outs of the different orders and inventory. And so it’s important to be able to centralize that information which can be done within your ERP system. And what I’ve seen some folks do is actually when they syndicate out the inventory to their different multi-channel stores you can either utilize safety stock as one strategy to be able to adjust– Even though you may have 100 units available you really only want to display 90 to keep some safety stock, so you don’t have any stockout situation. So you have that ability to be able to adjust that. I’ve seen some customers actually have custom calculated fields on the item record for different inventory amounts because they may have situations where they may have a warehouse that has a certain stock but they have a dropship vendor who has additional stock. So if they run out, they may want to actually send that order as dropship rather than through their own warehouse. And so this is a decision that needs to be made but it’s still just a matter of adjusting your save searches within that NetSuite, for example, to be able to say what is your stock that you’re actually going to syndicate out and be able to do that. So you may want to have a different amount on Amazon versus eBay versus your own web store. So you do have that discreet ability to be able to adjust that. But again, it really is up to you how you do that. But it is all technically possible to do. Okay. Another question is you mentioned EDI integration. Are there any limitations with integrator.io EDI flows? I’m not sure. Yeah. Limitations, I think limitations as if we don’t have something in our library for a particular trading partner. There might be a delay to get that one published for you though we have a lot of different generic EDI layouts. We also do have for Europe. We do have EDIFACT templates available so we’ve been able to support both of those EDI protocols. And it’s a set part of our services if you do bring us a partner that we don’t have in our current library, we will produce that. We just need to get a file specification and a file sample that we can test against and be able to publish that out to you. But again, you can take any of the existing 850s for example for a purchase order and make those adjustments yourselves to the file templates if you wish. But that is one of the services that we do offer for free. Okay. And another question is how easy is it to add in more 3PLs into the existing NetSuite 3PL integrations once I have one up and running. Oh, it’s very simple. All you need to do is set up that new 3PL location obviously of the inventory that’s available in that location and then everything else kind of happens. Now if we need to route that order to a new 3PL, most of the time what we’ll do is set up a clone of that previous data flow so we’ll just filter on that inventory location. So even on the same order if two lines are being shipped by one 3PL and the third line’s being shipped to the others, it’s very easy to split that order and route it to the right location or right 3PL based on the location that’s at the line level. So all that is fairly straightforward and can be easily handled with an integrator.io. So within a couple of weeks, you can actually have that up and running with the new 3PL. And if you happen to be using the same warehouse management system is, I guess what I really should mention is, it all depends on their warehouse management system if they’re the same then it’s a piece of cake. Okay. Great. Thank you so much, Chris. So a few of the other things I would like to mention are if you’re new to Celigo, you can go to our website on celigo.com and sign up for a free integrator.io account and start building your first flows. And then after today’s session, if you have more questions, you can email us at [email protected] Also if you’re currently experiencing challenges with your integrations, you can let us know and our teams would be happy to chat with you further and help you out. And so we ran some polls here and let me share the results with you. Okay. And now before we move to the next session, we actually have some giveaways. So attendees of the session will be automatically entered in a drawing for a Celigo gift card giveaway. And now, we will be showing you a video. How does your company automate it’s business processes? When your company was young, you had few processes. Most of which could be managed in ad hoc ways. But as your company matured, new systems, applications, and departments were added each with their own unique operational needs. At some point, manual processes break down slowing your company with costly errors and delays. You need integration to automate and keep growing. But how do you keep up? After all, coding your own API integrations is slow and expensive. Native or direct integrations have limited configuration options beyond most common use cases. And typical integration platforms are heavy and require a lot of technical resources to build and maintain. There’s a better way, introducing Celigo. The complete integration platform built for both I.T. and business users that automates your business processes across applications. With Celigo’s guided visual interface, building powerful integrations is a breeze. Our platform offers advanced orchestrations, transformations, and customizations. But there’s no need to reinvent the wheel. You can leverage hundreds of pre-built connectors, templates, and even integration apps to automate key business processes across popular applications because they are built on the Celigo iPaaS. These integrations are fully configurable and expandable for your company’s needs. Best of all because the platform is designed for technical and business users, you can even choose to hand off certain integrations to be managed by less technical users, leaving your team to focus on more strategic initiatives that drive the bottom line. The result, an agile company set for growth. Companies of all sizes need integration to scale. Celigo. Integration starts here. Visit celigo.com to get started.