Posts

Showing posts from November, 2022

Why is ERPNext Database Growing and What Can We Do About It?

Image
Typical cloud systems, unlike ERPNext, where providers do not price based on the resources used but on other criteria, also utilize various resources. The details of these resource usages are often hidden from users.  ERPNext not only transparently developed the FrappeCloud platform, where the amount of resources used by the ERPNext software is visible, but it also equipped ERPNext itself with a report function so that we can see how much space is occupied in the database.  To access the report, you need to append the following URL to your own ERPNext instance domain: /app/query-report/Database%20Storage%20Usage%20By%20Tables   This is useful because it’s simple, and if we find any factors using an unreasonable amount of resources, we can easily change them. The smaller the database, the easier it is to manage tasks such as creating backups or performing updates, which can save us money. For example, we can delete unnecessary versions and disable versioning for certain do...

ERPNext Conference 2021 - November 19-20

Image
The themes of the 2021 ERPNext conference are grouped into four categories by the organizers.  1. Frappe Framework, the underlying system that powers ERPNext and can also operate independent apps, such as a wiki knowledge base.  2. Frappe Cloud, a cloud hosting service available for all software using Frappe Framework. A detailed post about this will be published in the Hungarian  3. ERPNext blog. ERPNext, the main product of Frappe, which is perhaps the world’s most well-known fully open-source and free ERP system.  4. Community, to which both Frappe and ERPNext owe their existence.  I will provide detailed coverage after the conference, but in advance, it is worth mentioning that there have already been comments in various ERPNext forum topics hinting at changes in ERPNext development, which will hopefully result in an even better product. The themes of the conference also show that the community comes first, and this professionalization, enabling the developm...

ERPNext and the New Shopify eCommerce Integration for Webshops

Image
The version 13 of ERPNext brought many new features, including the previously introduced revamped user interface and mobile app. One of the new developments is the enhanced ERPNext - Shopify integration. Until now, it was available as part of the ERPNext’s core features, but it seems that the development processes have been reconsidered and transformed at the Frappe team, which develops ERPNext. This integration, which was previously an integral part of ERPNext, is now available as a separate “Ecommerce Integration” app on GitHub and the FrappĂ© Cloud Marketplace.  This new app supports Shopify as well as the system called Zenoti, but the latter is not widespread in Hungary, so let’s focus on the main features available in the Shopify integration:  1. Syncing orders from Shopify to ERPNext.  2. Syncing customer data along with the order.  3. [Optional] Syncing sales invoice and delivery note.  4. [Optional] Scheduled stock synchronization between the two systems....