Hello team
Is there any way to import discounts with the CSV import wizard?
I am importing sales from my ecommerce CSV and it has a discount value that would lower the total amount of the invoice.
I could not find any variable to import this within the invoice and applying it manually it’s impractical as it’s hundreds of transactions (invoices)
Is there a workaround or a correct way to do this?
Hello @Simo_84
This is not possible I’m afraid, you would have to import the invoices then apply the discounts afterwards.
Please feel free to raise a feature request on the forum, that way other users can add their vote.
You’d have to write some sort of script to process the CSV and generate a second row for each discounted invoice with a negative value for the amount of the discount. If both rows have the same invoice number it would import as a single multi-line invoice.
Hi Ian, thanks but I have already tried that and it won’t accept negative values!