A lot of data can already be viewed in the JTL-FFN dashboard. This includes order number, shipping information about warehouse and shipping service provider, shipping address, details about the items and order status. This data is usually sufficient for the dealer.
However, there are products with special requirements. For example, at Subke we have distributors who sell products that must be assigned a serial number during picking.
Now, of course, the dealer wants to know which serial number was assigned to which product. In order for this data to be created in a time-controlled and automated manner, a separate program had to be developed.
So our in-house developer Mato has written a custom program that retrieves all the necessary data from the JTL database and creates a report specific to the merchant.
Time controlled database queries
This way the retailer receives the CSV report daily at a certain time and can see in detail which serial numbers were assigned when packing the items.
Of course, this also works if the retailer has already assigned a serial number to the products. Then a report is created which item was packed and shipped to the customer with the existing serial number.
Information about the batches is also important.
Especially if there are problems with the product, it is important to know which batch the product was in. For example, it can be checked whether items in the same batch have the same problem.
With the CSV report, the retailer receives a daily overview from which batch which items are sold and thus also ensures whether the First In First Out (FIfO) method is adhered to.
Individual CSV report
However, other individual data can also be retrieved on request and sent daily as a CSV report.
Our developer Mato will discuss the wishes with you as a customer and customize the program. Just ask us for the CSV report you want!