Accounting

Automation of the Ordering and Shipping Process

The constantly growing demand required a more efficient handling of the ordering and shipping processes of a specialist retailer for wood-burning stoves in order to meet the challenges of digital commerce.

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.

Food Delivery
  • Benutzerkonten erstellen;
Du kannst deinen Workflow auch über eine API mit Zapier und Make erstellen - wenn du Hilfe benötigst, beraten wir gerne.

#FFF7F1

Automation of the Ordering and Shipping Process

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.

Food Delivery
  • Benutzerkonten erstellen;
Du kannst deinen Workflow auch über eine API mit Zapier und Make erstellen - wenn du Hilfe benötigst, beraten wir gerne.

#FFF7F1

Background: Time-Consuming, Manual Processes

A leading specialist retailer for wood-burning stoves, which operated its sales via various online marketplaces, was faced with the challenge of optimizing its time-consuming ordering and shipping processes. Orders received via several online marketplaces were processed manually and the associated shipping information was also managed manually. This not only took a lot of time, but was also prone to human error.

The company received the invoices for customer orders placed via several online platforms, whereupon the information was recorded manually and forwarded to the carriers. They delivered the products and sent back the shipping information, which was in turn manually forwarded to the online stores. Finally, the customers received a shipping confirmation – also created manually.

Easybill was used for invoicing, while communication with the freight forwarders mainly took place by email. The lack of a central database and the lack of automation made administration considerably more difficult.

Goal: Automated Ordering and Shipping

The old process was characterized by enormous administrative effort and a high susceptibility to errors. Different data formats used by the freight forwarders led to confusion, and the time delay in customer communication impaired customer satisfaction. Process optimization was unavoidable in order to meet the increasing requirements.

The company therefore wanted to fully automate the ordering and shipping process. A central and uniform overview of all orders was to be created and the need for manual data entry was to be minimized. The aim was to improve communication with forwarders and customers and reduce sources of error.

Solution and Implementation

By implementing new tools such as Airtable and Make, we were able to automate the entire process. Airtable served as a central database for orders and shipping status, while Make enabled the automation of order and shipping processes. APIs were also used to efficiently integrate the online stores' order confirmations, and 0CodeKit allowed individual customization of the online store interfaces.

The new automated process began with the transfer of order data from easybill to Airtable. All information, including invoices, items and contact details, was automatically recorded and linked. Stock levels were also updated. E-mails were also sent under certain conditions.

The process in Make that transfers order data from easybill to Airtable.

The orders were automatically assigned to the appropriate forwarders and the corresponding shipping information was transmitted in the required formats.

The process in Make where orders are assigned to the appropriate forwarders.

The forwarders sent back shipping confirmations, which were automatically passed on to the online stores so that customers received their shipping confirmation promptly. All files sent by the carrier were uploaded to Airtable in an overview and then, depending on the carrier, the next process was triggered. After our client received the information that orders had been dispatched, they were also automatically marked as dispatched in the various stores. In the event of problems, an automatic damage report was also sent to the forwarders by email.

The process in Make whereby orders are automatically marked as shipped in the various shops after dispatch.

Differing Data Formats

The implementation encountered various challenges, particularly due to the different data formats and structures (e.g., csv, excel, etc.) between freight forwarders and online stores. Some online stores did not have standard interfaces, which made it necessary to develop individual API calls.

A process in Make that required individual API calls, as some online shops did not have standard interfaces or their own app in Make.

Accelerated Order Processing

By using Airtable, Make, 0CodeKit, and the corresponding API integrations, the company was able to take a significant step towards efficiency and customer focus. The automation of the previously manual processes enabled a uniform and transparent overview of all orders, which also drastically reduced the manual workload. This led to a minimization of errors and faster order processing. Communication between our client, the freight forwarders and online stores improved considerably, which also made customer information about the shipping status faster and more reliable.