Merging "invoice items" with "invoice" for import?

Self-Hosted | v5
1

Hello,

I’m importing invoices as a CSV from my old invoicing service. I’ve got everything mapped and working, except the line items per invoice. My invoice CSV from my old service includes the line items as additional columns, with item names, costs, quantities, etc. (i.e. All information about a single invoice is stored on a single row, including up to 12 line items with their properties)

Is there any way to import this into Invoice Ninja via the single invoices.csv I have? None of the line items currently get read. I even tried mapping all of them to their respective labels (item - product, item - notes, item - cost, item - quantity) I’m not sure how I would separate all of that data from the one CSV and make it into a new functional CSV for all the information of an invoice.

2

Hi,

The CSV import expects each line item for the invoice to be on its own line in the file. I think you’ll need to pre-process the file to make it import correctly.

3

Ugh, I was afraid of that. I’ve got nearly 400 invoices, and most of them have upward of 5-12 line items each. Any way to simplify the pre-process? or am I looking at an all-by-hand endeavor?

4

Maybe this will help:

5

Thanks, Hillel…

Another stretch hope here… is there a way I can just force the import to look at a column I have called Total and Balance, instead of doing the calculations to get those? I don’t necessarily need the line items for old invoices, just the basics of showing the total and that it was paid completely.

6

Sorry, it isn’t supported. You’d need to modify the app’s code.