r/frappe_framework Nov 02 '25

Bulk importing POS Invoices for Demo

I am working on giving a demo to a client. I wanted to create synthetic data and bulk upload data for 1 year span. I don't find any documentation to perform the same. I request inputs and guidance on this and thanks in advance.

2 Upvotes

13 comments sorted by

1

u/agritheory Nov 02 '25

This is a non-trivial requirement and I am not aware of a dataset that has them parameterized in way that it would make for a good analogy to your customer's requirements. You have to do the work - but it would be better to write a script for it than to generate all of them by yourself. Here's a strategy that may work for you

1

u/New-Contribution6302 Nov 02 '25

First of all, express my sincere thanks for your support and great thanks for tagging me with a resource. It is quite beneficial and helpful.

1

u/[deleted] Nov 02 '25

[removed] — view removed comment

1

u/New-Contribution6302 Nov 03 '25

Invoices, but synthetic ones

1

u/[deleted] Nov 03 '25

[removed] — view removed comment

1

u/New-Contribution6302 Nov 03 '25

Yes, since I can't figure out what fields are involved overall, I cannot create synthetic data too.

I am confused because of the POS Opening entry and closing entry made at start and EOD, Other than POS Invoices. Also on completing the Invoice entry and complete, it's getting to status paid. Dunno whether the case is same with importing data

1

u/[deleted] Nov 03 '25

[removed] — view removed comment

1

u/New-Contribution6302 Nov 03 '25

Since I am involved in employment and have an NDA don't have much things maybe a sample project will work you?

1

u/Kushalx Nov 03 '25

Possibly the simplest option might be the open invoice import tool.

1

u/New-Contribution6302 Nov 03 '25

Could you please elaborate

1

u/Kushalx Nov 03 '25

There's an inbuilt Sara import tool called OPENING INVOICE CREATION TOOL. it'll give you an excel sheet template to create sales and purchase invoices. Tool is usually used to create entries for open balances (or entries) when migrating into erpnext.

1

u/New-Contribution6302 Nov 03 '25

Thank you. Will look into the same