With the help of CSV files DHL, GLS and DPD are connected.

Separator

The entries are separated with a |.

header data

The header line consists of:

The header data is not output in the standard configuration.

Content

The content can look like this:

Note the last column here: this can also contain the | character as a separator symbol for the customs declaration.

Application

The CSV files are available for DHL Easylog, DPD Delisprint and GLS Gepard. An XML file is generated for the connection to UPS Worldship. DPD, DHLand Internetmarke are also directly connected via the respective web service. In addition, Wemalo provides a connection to Shipcloud, in which all common shipping service providers are contained in one interface.

Example

Example 2

Contents Auto Reports

The following auto reports are available in Wmealo. The setup is done via the menu item Reports and Auto Reports.

wemalo assumes that the base64 document about {“data”: {“pdfDocument”:”base64 “}} can be retrieved……..

Format: xls

ID;Name;SKU;EAN;Weight;Shipping Weight;Group;Pitch;Serial Number;Active;Ready for Shipment;Parts;Width;Height;depth

Packages and countries

Format: csv

Shipping date;Country;Order ID;Order No.;Parcel ID;SKU;Quantity;Parts;Weight;Hanging goods;Category;Client;Profile;Package

Incomplete orders

Format: xls

Client;Order ID;Order No.;Created;Reason;SKU;Parts;Prio;Reserved

Tracking

Format: xls

CreatedJob ID;Job No.;Handover Date;Tracking Number;Profile;Name 1;Name 2;Name 3;Zip;City;Street;House Only;Country;Alt. Recipient; Alt. Name 1;Alt. Name 2;Alt. Name 3;Alt. ZIP;Alt. City;Alt. Street;Alt. House no.

WA-Order ETD

Format: xls

Client;Status;Created;ETD;Orders;Positions;Parts;Updated

Packs per user

Format: xls

Posting date;Hanging goods; Packs; User

WE per user

Format: xls

Posting date;Client;WE;User

goods receipt orders

Format: xls

SKUOrder No.PartsETAScanned

Product Lifecycle

Format: xls

SKU;WE;Relocated from WE;Picks; Packs; Sent;EAN;ID;Name

Daily closing

Format: Email report

Output Characteristic Std.: 0

Output all others: 0

Reported returns: 90

WE: 23

Refurbishment: 0

The remaining interface of WeClapp can be connected via wemalo-connect. The steps and information required for this are listed below.

Create client in wemalo

The client is created in wemalo in the usual way. For the client’s other facilities in wemalo-connect, the client ID and the warehouse ID must be known.

Create user in wemalo-connect

A new shop user is created in wemalo-connect and linked to the previously created client in wemalo using the client ID. The warehouse ID is also stored.

The creation of a REST-Key is not necessary!

Set up WeClapp interface

The WeClapp interface is created in the “Generic REST Interfaces” area. These interfaces use wemalo’s REST interface to communicate with the back end. However, the creation of a remaining token is not necessary.

A new interface can be defined by clicking on the “New entry” button. After selecting the system, the configuration of the system can be loaded via the button “System-Template”. Using the WeClapp example, key-value pairs are loaded for storing the required settings (URL, token, WeClapp ID, etc.). An overview of the required settings follows in the next subchapter.

You can also select the wemalo instance (previously set up by linking wemalo and the client ID) and the synchronization interval.

A warehouse must be created via Settings- >Basic settings- >Warehouse.
As soon as this is done you can open the warehouse via the edit function (pen symbol) and see the warehouse ID in the browser bar at the end (entityId=XXXX).
This is required in the WeClapp settings.

WeClapp Settings

The following settings must be provided by the customer:

• Token: here you have to enter the token from the WeClapp shop, (My settings- > API Token) which has to be created.
• url: the URL to the API interface of WeClapp. (Shop URL/webapp/api/v1)
  Example: https://4elements.weclapp.com/webapp/api/v1
• (WeClappId: 1)
• (storageLocationId: 1)
• warehouseId: the ID of the warehouse in WeClapp.

The following settings are made by us:

• extendedLog: true must be entered here to activate extended logging.

subscriptions

The following subscriptions can be activated/deactivated:

• serviceLoadProducts: load product master data from WeClapp and transfer to wemalo.
• serviceLoadGoodsOrders: load WA orders from WeClapp and send them to wemalo.
• servicePushPackages: return sent packets from wemalo to WeClapp.
• servicePushInventoryBookings: Transmission of inventory entries (entries and withdrawals).
• servicePushIncomingBookings: Transmission of incoming goods bookings
• servicePushSentBookings: Transmission of outgoing goods bookings.
• servicePushReturnBookings: Transmission of return bookings.

Annotations

Due to API limitations, the following tasks must be performed manually in the shop.

In order to successfully create a delivery of an order, the order must be confirmed by clicking manually.

The dispatch of the delivery and the creation of the invoice must also be confirmed here by a manual click. The stock is not updated until the delivery was shipped.

The return of the order cannot be generated until the delivery has been sent.

The goods from the returns can be posted back to the warehouse by selecting “Post all items to warehouse” under “Goods receipts and workflow” in Weclapp.

Posting history reports or reports using the REST API output posting reasons with an internal ID.

The IDs include:

• 1: shipped item
• 2: Reservation cancelled
• 3: Reserved
• 4: Goods receipt
• 5: Returns
• 6: Stock transfer
• 7: Packed
• 8: Inventory input
• 9: Inventory output
• 10: Inventory stock transfer

introduction

Any number of price lists can be created per client in wemalo. Price lists are divided into 8 categories, which are shown below.

Price lists are created via the client master ->Client – > Config-Tab Accounting– > Submenu item Price lists.

categories

The available categories are:

• Received goods
• warehouse
• dispatch
• Shipping B2B
• packaging material
• return
• lump sums
• services

Received goods

Includes billable goods receipts.

• Number of cartons: is entered manually for inbound deliveries and is the sum of the cartons received.
• Number of pallets: is entered manually for deliveries and is the sum of the received pallets.
• Number of goods received: scanned goods in pieces.
• Number of unique SKUs: scanned goods grouped by SKU (each product has its own SKU).

storage

Contains the occupied storage volume and storage locations.

• Number of parking spaces: the number of different parking spaces occupied during the accounting period.
• Number of shelving racks: only the number of normal parking spaces occupied during the accounting period.
• Number of pallets: the number of pallets occupied in the billing period.
• Storage charge (per m³): the sum of the occupied storage volume in the settlement period calculated using the shipping dimensions in the product master data.

dispatch

Determines the shipping costs (pick, pack, shipping) for normal shipping.

• Number of sent orders: Displays the number of sent orders in the settlement period.
• Number of sent packages with threshold: the number of sent packages in the accounting period with number of parts below the defined threshold.
• Number of packages sent with threshold: as before, but can be used to define a second threshold value. For the previous position, the threshold < 2 (i.e. all packets with one piece) and the threshold < 5, for example, could be stored here. All packages containing between 2 and 4 parts would be listed here.
• Each additional article: all articles exceeding the second threshold are listed here. In the above example, if a package contains 5 parts, the package will be listed with 4 parts in the previous position and an additional part in that position.
• Parcels per country: List of parcels shipped to their destination countries together with their weight. This setting is only suitable for clients in which the target countries are restricted and the package weights are relatively the same. Otherwise the listing will quickly become confusing and the shipping matrix would have to be used.
• Total Items: the total number of items shipped. It should be noted that the sum of the items sent may differ from the sum of the picked items. This is the case, for example, if picked goods can no longer be packed in time before the parcel service picks up the parcels. Thus, the packed goods could only be completed and dispatched the following day. If there is a billing period change between the two days, the picked goods are billed in the previous period and the shipped goods in the new period.
• Pick category: wemalo distinguishes between up to 10 different pick categories. Different pick prices can be displayed depending on dimensions and weight. It is important to note that a pick category must always be set up as a collecting basin in which the max dimensions and max weights fall.
  No container picks are listed in the pick category. If there are also container picks for a client, the corresponding position container unit must also be defined.
• Shipping costs: determines whether the shipping costs are to be calculated on the basis of the shipping costs matrix.
• Fast Send: if fast send is used, the billing can be analogous to the pick categories (i.e. also according to dimensions and weight).
• Container unit: if container unitsare used, the containers can be billed separately. Container-picks are not issued in the pick category.

Shipping B2B

The content of B2B shipping does not differ from that of normal shipping from the point of view of the items. However, other prices can be stored for B2B. For this purpose, a distinction must be made in the outgoing goods orders between B2B and normal shipping.

packaging material

Consists of a list of packaging materials available to the client.

return

Returns processing is recorded in a separate price list category.

• Number of return orders: The sum of the return orders. Each returned package will most likely result in a return order, whereby theoretically several packages could belong to one return order (rather unlikely).
• Number of returned items: the actual quantity of returned items in units.

lump sums

Flat rates such as warehouse flat rates, IT flat rates, administration flat rates etc. can be stored here.

services

A distinction is made here between product services, goods receipt services, goods issue lines and form services.

settings

In order to be able to use all price list items, various settings must be made. The available options are explained in this section. These include

• packaging material
• shipping profiles
• shipping matrix
• Product services in the client base
• form services
• WE and WA services

packaging material

Configuration- >Packaging material is used to store packaging that the packer can use when packing the package. There the settlement price of a package can be indicated directly.

All packaging used and available is listed in the invoice.

shipping profiles

If shipping profiles are to be taken into account in billing, the Relevant to price lists flag must be set.

shipping matrix

Using the shipping costs matrix, you can maintain the prices per shipping profile, recipient country and weight in an Excel file. See also shipping costs matrix.

Product services in the client base

The so-called product services can be activated via the client master. It can be set whether employees are requested to maintain missing weights, product dimensions or EANs in goods receipt.

form services

Via Assign Services – > Select Client – > Goods Issue – >Create Matrix – > Form Services you can store special services that are executed during packing and billed separately.

This includes printing invoices, delivery notes, packing lists, etc.

WE and WA services

The GR services are assigned via Assign services – >Select client – >Assign goods receipt. wemalo distinguishes between product-specific and client-specific services.

WA services can be assigned using services – >Select client – >Define goods issue, whereby the distinction just mentioned also exists here.

The flag “Add to invoice output” must have been set for services to be listed in invoices.

Generate Billing

The settlements are generated via the client master – >Client – >Config-Tab Settlement– >Submenu item Settlement.

Only activated price lists can be used to generate a settlement. To do this, the price list must be activated in the price list overview.

After selecting the start and end date, the settlement can be generated. The figures are determined and an Excel file is generated (the download takes place immediately).

Serial numbers can be stored via the product master, which are checked separately for returns. If a serial number is scanned from the list, a note is displayed that can be entered via the product master.

The following screenshot shows the setting in the product master:

The X button can be used to remove a serial number check. Serial numbers are unique. This means that by entering a serial number that has already been stored, the previous entry is overwritten.

When a return is scanned and a stored serial number is entered, the specified message appears as follows:

To export product data including stock, the following steps are necessary.

• In the menu above products and then via the link on top “Export”. (Located next to “Create” and “Import”.)
• Select columns and select export of metadata.
• Click on the “Generate CSV” button to download a CSV file.

With the help of the Fast Send function, Single Pick outgoing goods orders without storage, Pick & Pack can be booked as packed directly at cross-docking goods receipt. The goods to be scanned must already have been notified. The Single Pick outgoing goods orders waiting in the system for goods can be served via a Fast Send view, in which first the goods receipt and then the WA products are scanned.

Wemalo will then book the goods at a cross-docking location, reserve them for the goods issue order and then pack them. The shipping label is printed and the package can be transferred directly to the goods issue.

In wemalo Fast Send is integrated as a module and must be enabled at user level.

workflow

1. Fast Send view shows notified goods receipts for which there are waiting goods issues
   
2. After Scan WE, the products are scanned
   

When scanning the products, the user first gets a list of all products for which there are waiting orders. In the above example it is only one product. For this product, there are four waiting goods issue orders (identified by the number 1/4 on the right, where the item has already been scanned once).

conditions

• It must be min. a packaging material has been defined for the client. If there is a VP with the name Default, it is used.
• The system only lists notified goods receipt orders for which min. An article matches an incomplete Single Pick goods issue order.
• When scanning the goods receipt, the advised tracking number or the client order number can be scanned. Ideally, one of both codes can be scanned on the WE package.
• The use of serial numbers at product level is recommended for a clear WA assignment. These can be scanned in the 2nd workflow step as an alternative to the product barcode.

The following placeholders can be used:

• product_name
• product_sku
• product_barcode
• product_ean
• product_factorynumber
• product_size
• product_dessign

A customs declaration can also be generated via DHL’s web service.

The following data is used in the product master:

• Country of origin (ISO code (ISO-2- Alpha))
• customs tariff number
• weight
• SKU
• name

The following data from the order items:

• Price per item
• Packed quantity