Sly Connect V2

August 4, 2022

What is Sly Connect in the first place?

Sly Connect is a powerful tool that facilitates B2B cart creation from structured documents, mostly coming from ERP systems. Sly Connect is powered by a smart parsing algorithm that detects the format of your customers' ERP-generated orders, saves the format for future use and automatically fills the shopping cart in your webshop. But what are the benefits of using Sly Connect? Small and medium businesses don’t have to worry about costly EDI or e-procurement integrations, which only big companies can afford due to their high implementation costs.

In contrast, integrating Sly Connect into a webshop requires just a few lines of code. Furthermore, it takes new customers around 2 minutes to configure and save their import format for future use. The onboarding can be done without any support from the shop owner. Every subsequent order takes less than 10 seconds. As a result, Sly Connect saves time, increases customer loyalty and reduces churn.



‍

‍How does Sly Connect work?

The customer's order can be selected via drag and drop or by clicking on the highlighted field. The file is parsed and the preview opens automatically, so the setup for a new customer can begin.

(Sly Connect PDF upload)

To select the first field, Order Number, the customer clicks on the corresponding button. Afterwards, the customer selects the corresponding value for the Order Number by clicking on the parsed PDF. The following fields, Article Number, Quantity and Article Reference, are selected in the same way. For these fields, the customer only needs to select the first item in the PDF. The remaining items are automatically recognized and marked. If the selection is not applied correctly, for example if too few or too many items are selected, the sensitivity of the parsing algorithm can be adjusted via the "less" and "more" buttons. Once all mandatory fields are selected, the initial setup is complete.

__wf_reserved_inherit
(Screenshot: Sly Connect in action)

The parsing algorithm calculates the positioning of values based on the position of the field values of the first product. Based on the selected values, the algorithm reapplies the format of previously parsed orders. Since the formats of a customer's documents are usually similar, the algorithm can recognize and extract the products independently for future orders. Consequently, all subsequent orders can be placed in a very short amount of time: less than 10 seconds. Currently, Sly Connect supports orders in PDF, XLS, CSV, IDoc and XML format.


‍

‍Improvements

‍

1. Algorithm

Although Sly Connect has a rich set of capabilities and our customers are very satisfied with the tool, we always try to set the bar higher and further improve our tools to fit customers’ needs even better. Sly Connect is integrated by several customers. Thanks to user feedback, we noticed that some PDF files have structures which were challenging to parse automatically. Article numbers were, for example, positioned on one page while the other relevant data of the same product had already wrapped to the next page.

In rare cases, the parser couldn’t properly match these distributed values to each other and identify them as a single product.

In another case, the position of the same kind of data (Article Number) varied from page to page within the same PDF. Therefore, the parser missed some occurrences and could not process all the order items properly.

For us at Sly, this was a motivation to make our algorithm even better and solve many more edge cases. During a brainstorming session, we came up with the idea of introducing the concept of a “row” in the algorithm to mitigate these edge cases.

The concept of a “row” means: other fields (e.g. Quantity or Article Reference) are related to an article number and cannot be positioned before or after the row in which their article number is placed. With this concept, fields can span multiple pages and different positions in the PDF, but if they belong to the same “row”, they are still matched in the final selection. The image below shows the Article Number (page 2) and the Quantity and Article Reference (page 1) of item 03 on different pages. With the new algorithm, the selection was nevertheless correct: Quantity and Article Reference are related to the Article Number of item 03. The red square represents the “row”.

__wf_reserved_inherit
(Screenshot: updated Sly Connect algorithm with the “row” concept)

As a result of our improvements, Sly Connect can handle these “imperfect” PDF files much more reliably.


‍

2. Flexibility

One of Sly's core values is flexibility. Therefore, we also wanted to provide more flexibility for Sly Connect customers and not restrict them to the four predefined selection fields originally provided by Sly Connect (Order Number, Article Number, Quantity, Article Reference). Since different customers have different requirements, we made the fields super flexible. Now we allow up to 8 completely customizable fields! Customers can define the field labels (in different languages), the minimum field length, whether a field is mandatory, a regular expression for allowed field content and many more options.

__wf_reserved_inherit
(Screenshot: Sly Connect with custom fields)

‍

‍Evaluation

To evaluate the new algorithm, we performed intensive testing to compare the old and the improved algorithm. After some iterations, the new algorithm performed better in all test cases. Some tests showed that the new algorithm could correctly select all fields where the previous one could not. In other tests, both algorithms selected all fields correctly, but the improved algorithm provided a better user experience, since fewer adjustments with the “less” and “more” buttons were required. Our customers also had a chance to test the improved algorithm, and their favorable feedback confirmed our test results. Customer satisfaction is very important to us and motivates us to further improve our solutions.

__wf_reserved_inherit
(Screenshot: the updated algorithm (left) selects all fields correctly, while the old algorithm (right) selects the Article Reference fields incorrectly)

‍

‍Summary

Sly is thrilled to improve its services and to provide solutions that best fit customers’ needs. Once we saw the potential for improvement in Sly Connect, we were determined to find solutions. To resolve the issue of page wrapping within one product, we introduced the concept of a “row”, meaning that fields (e.g. Quantity or Article Reference) which are related to an article number must be positioned in the same row as that Article Number.

Furthermore, we made custom fields fully customizable, allowing customers to define which values they want to extract from their PDF orders. This provides greater flexibility and expands the potential application of Sly Connect into all kinds of business domains.

We performed intensive testing of the new algorithm, and our customers were very satisfied with the improvements, and so were we! We will not stop here. We already have many ideas and will keep the same pace and focus on creating the best software for our customers. If you are interested in testing or getting more information about Sly Connect, don’t hesitate to contact us. Sly Connect website / Request a Sly Connect demo / Contact us by email