3g Pacejet

[Channing Rupnick]

Pacejetwhich secured $4.0 million in growth funding from SaaS Capital, is a provider of enterprise cloud-based, multi-carrier shipping software. 3Gtms develops and delivers the next level in transportation and logistics software. The companies had the following to say:

Pacejet Shipping Software offers fully connected shipping with live carrier connections and smart ERP integration for midsize enterprises. Its flexible, scalable platform uses advanced cloud technologies to streamline processes across the entire shipping ecosystem, increasing shipping efficiencies, reducing time and costs, improving the customer experience, and creating a new competitive advantage. Pacejet solutions provide rapid return-on-investment and may be deployed incrementally as agile improvements over time. Visit www.pacejet.com to learn more.

I'm currently working on a NetSuite integration project for a client that uses Pacejet for its shipping and fulfillment operations. The integration requires accessing the package information that Pacejet generates. If you've been following my blog for awhile, it will probably come as no surprise to you that I used SuiteQL to access that data.

In this post, I'll share a few of the queries that I worked up as part of the project. I'll start with a query that shows how to get Item Fulfillment data, then show how to access the Pacejet data, and wrap things up by combining the two queries.

There isn't too much involved with that query, with two exceptions. First, there's the use of the BUILTIN.DF function, which maps the transaction's entity from a numeric value (the entity's ID) to a text value (the entity's name). Second, I'm using a correlated subquery to get the Sales Order that the Item Fulfillment was generated from. That subquery involves the PreviousTransactionLineLink table, which serves as a join table between a transaction and its previous and/or next transaction type as it moves through its lifecycle. For example, it joins a Sales Order to an Item Fulfillment, an Item Fulfillment to an Invoice, and so on.

This is another simple query, with the exception of the WHERE clause. Pacejet assigns CustRecord_Pacejet_Package_ID values based on the ID of the transaction that the packages are associated with, followed by a dash and sequential value. For example, a package for Item Fulfillment 1204394 would be stored as "1204394-001." Therefore, in the WHERE clause, I'm taking the transaction ID, converting it to a text value, and appending the "%" wildcard to it - and then using that value with a LIKE predicate.

Combining the queries requires adding two JOINs. The first one joins the Transaction table to a join table named "MAP_customrecord_pacejet_package_info_custrecord_pacejet_transaction_link." The second joins the MAP_customrecord_pacejet_package_info_custrecord_pacejet_transaction_link table to the CustomRecord_Pacejet_Package_Info table.

The query can be used to get all Item Fulfillments and Pacejet Packages that occurred in a specified date/time range. But you could easily modify the query to return packages for a specified sales order, customer, and so on.

This is one of the SuiteQL queries that I'm using for my client's integration project, but it's an important one. It was interesting to have an opportunity to use SuiteQL to query a custom table from a third party developer.

Summary: To start off the people at PaceJet all really did seem like for the most part that they do care & they are trying to run a reputable business. However, that is where the good comments unfortunately end. Their company from the top down is very confusing. One person just points blame at the next all the way up to the Vice Presidents and the CEO pointing fingers at other companies or their counterparts. Our project was completely messed up with PaceJet. We asked a lot of pre-sales questions which included going over what shipping carriers we use. We outlined our business goals and needs then were sold on PaceJet by their staff into a multi-year solution. Kicking off the project with kick-off coordinator was straight forward they went over our info again and then we went into the integration phase. By this point now 3-4 people from PaceJet had spoken with us regarding our project. The issue there was months later PaceJet then confirms that about half of the things on our list of issues that came up could not be fixed and its due to the way pacejet was designed. Things that their staff should have instantly said to us prior to even purchasing pacejet! Their staff literally configured business rules for us then that would not work at all due to the way pacejet's software flow works. So we wasted months setting things up and configuring things ultimately that would not work. Also they keep pointing fingers about giving us a refund! A nightmare stay away from them

Negative: Absolutely no user flow! PaceJet expects users to click keyboard buttons or scan 3-4 barcodes just to do a simple task, there is ZERO flow, meaning that when a warehouse employee completed shipping an order, there is no flow. A Normal system would pop-up an input box for your next order to ship, well not with pacejet and this is just one of many fundamental things you will find out when you try to do business with them. You have to scan barcodes and click buttons about 7-9 times just to do a single order if you are using scan pack verification and rate quoting, they overcomplicated the process completely and have no user flow directing the user to what step is next! They have fundamental business flow/setup things not built into their software correctly and then to make matters worst half of their staff understands the way their software works than the other half and your project will be stuck in the middle!. Software CRASHES and does not work. More than 2 times during a 3 month period multiple computers would not be able to print labels from PaceJet. The one time it took their support staff over 2.5 weeks to fix the issue and we made zero changes! Every other software we use printed labels fine, it was only pacejet that crashed multiple times and it was on different computers with different printers, so its not like they could blame the computer type/printer type. This made us very uncomfortable using their software as it was very very buggy.

COLUMBUS, Ohio, April 1, 2019 /PRNewswire/ -- RestaurantEquipment.com has achieved a competitive advantage in their industry by integrating e-commerce functionality into their buying experience. Looking to external partners known for expertise with NetSuite customers, Pacejet shipping software and Tavano Team successfully partnered together to give RestaurantEquipment.com the technology they needed to make e-commerce, freight, and parcel shipping all work together seamlessly.

RestaurantEquipment.com chose NetSuite early on as their enterprise resource planning system and then their e-commerce system (also known as NetSuite SuiteCommerce), as it unified e-commerce with their backend systems. SuiteCommerce helps them meet customer expectations while maximizing profitability.

The experience of buying goods is important, but the shipping and fulfillment is just as critical. RestaurantEquipment.com had experience working with Pacejet and knew that the platform could meet the demands of their business. Thankfully, Tavano Team was able to connect SuiteCommerce and Pacejet for a unified experience, bringing together two award-winning platforms in one integration.

"The biggest problem we have in our business is always going to be shipping, because many people in the industry offer it for free, and that's not possible for us. Pacejet helps RestaurantEquipment.com be competitive by offering real-time shipping rates to ensure the lowest cost, no matter what the shipping method," said Jacob Oelsner, Web Development Manager, RestaurantEquipment.com. "We're thankful Tavano Team and Pacejet worked together to give us the solution we needed that wasn't overly complicated and kept business moving."

Pacejet was the 2017 NetSuite SuiteCloud Partner of the Year and maintains a reputation for excellence as a Built for NetSuite solution. Pacejet helps NetSuite customers ship billions of dollars' worth of shipments each year, whether through parcel, freight, or 3PL. Part of why RestaurantEquipment.com chose Pacejet was due to the real-time rate-shopping abilities provided that went beyond basic carriers. Now, RestaurantEquipment.com customers have the ability to choose any type of carrier and find the best rate, which has opened up a host of new options for carrier connections.

"RestaurantEquipment.com is a prime example of a NetSuite and Pacejet customer looking to grow their business with increased efficiency and lower shipping costs. Pacejet is known for providing fully connected shipping solutions and now we've added NetSuite SuiteCommerce to Pacejet's offerings, thanks to our partnership with Tavano Team," said Bill Knapp, CEO, Pacejet.

Tavano Team is also an award winner, being named 2018 NetSuite SuiteCommerce Partner of the Year. The company is known as a premier SuiteCommerce digital agency, helping brands big and small build online presences. They were instrumental in delivering a professional e-commerce website with a consistent look and feel that met RestaurantEquipment.com's expectations and timeline. Some of the biggest parts of delivering a functional e-commerce experience for RestaurantEquipment.com were completing vital customizations and integrating Pacejet with NetSuite SuiteCommerce Advanced. Tavano Team helped increase efficiency in the process, making sure the customer's needs were met, while maintaining high standards for user experience.

"Working with Pacejet, we were able to take complex shipping needs and make things simple for RestaurantEquipment.com's e-commerce experience on RestaurantSupply.com and on their additional sites. The process of building out multiple sites with NetSuite SuiteCommerce Advanced is not easy, but Pacejet and RestaurantEquipment.com worked together as great partners, helping us achieve the goal of excellent shipping functionality while we also optimized the e-commerce customizations," said Diego Isola, President, Tavano Team.

3a8082e126