Is ERPNext Suitable for Handling High Order Volume and 3000 Stock Items?

ERPNext
1

Title: Is ERPNext Suitable for Handling High Order Volume and 3000 Stock Items?

Body:

Hello everyone,

I’m considering implementing ERPNext for my company and would appreciate some advice based on your experiences.

Our Situation:

  • We receive a few hundred online orders each day.
  • We manage approximately 3,000 stock items.
  • Currently, an order manager prints out each order on paper and assigns them to multiple pickers.
  • Pickers collect the items and pass them to packers, who then box and ship them.
  • Orders come in throughout the day, and the same products may appear in multiple orders.

What I’m Looking For:

  • Scalability: Can ERPNext efficiently handle high order volumes like ours?
  • Order Fulfillment Workflow:
    • Best Approach: What is the most efficient way to manage order picking with multiple pickers in ERPNext?
      • Are Pick Lists the best option for our scenario?
      • Should we consider transferring items to a central location where each order is split into its own bin for packing and shipping?
      • Is it feasible to use the Sales Order document directly for picking and packing?
      • Are there other approaches or best practices within ERPNext that would suit our workflow?
    • Assignment of Orders:
      • Should the manager create individual pick lists for each order and assign them manually?
      • Is it better to bulk create pick lists and assign them to pickers?
      • Can the system automatically create and assign pick lists as orders come in?
  • Stock Management:
    • How does ERPNext handle the same item appearing in multiple pick lists without causing stock allocation conflicts?
    • What’s the best way to manage stock levels to prevent over-picking or stockouts?
  • Challenges and Tips:
    • Are there any potential pitfalls we should be aware of when transitioning to ERPNext?
    • Any best practices for setting up the system to suit our needs?
    • How can we optimize ERPNext for a high-volume, multi-picker environment?

I’d love to hear from anyone who has managed similar operations using ERPNext or has insights into optimizing it for a business like ours.

Thank you in advance for your help!

Best regards,

David klein

2

ERPNext can handle your requirements. In fact most ERPNext instances in the wild handle such volume or way more. Few hundred orders per day and 3,000 stock items is relatively small compared many implementations.

  • Frappe on which ERPNext is build, has the basic scaling handled out of the box with redis, db level indexing, etc… This can further be improved during implementation based on your specific pattern.
  • Pick Lists seems as an ideal approach for managing multiple pickers. ERPNext has this out of the box.
  • Bulk creation of pick lists and automated assignment is feasible and recommended for your scenario. This reduces manual effort and speeds up processing as orders come in .
  • ERPNext’s FIFO method ensures that stock items are allocated efficiently without conflicts when multiple pick lists involve the same item .
  • Be cautious with database performance as order volumes grow. Customisation done not considering your usage pattern and underlying server resource can create issues.

In short, ERPNext is safe for your use-case as long as you do the implementation right. Picking Frappe Cloud for hosting will help you avoid some problems easily.

1 Like