Import Line Items

Import Line Items

When raising an order, as explained on this help article – How to create a purchase order – you can import your line items. You may have all of the items you wish to buy on a spreadsheet. Provided they are in our format, you can import them into the order. You can also bulk import purchase orders. 

 

How it works

When creating a purchase order, click into the Line Items panel. You will see this: 

Click the link “Import from CSV”

You will see the import box as below, and this has the option to download the template 

Once the template is downloaded, you will see these fields in the spreadsheet: 

Note: 

  • Even if the discount is zero, add a 0
  • Tax percentage – enter the amount without a % sign 
  • Nominal, Project & Cost Code are all codes – not descriptions 
  • Division name – be exact, no spaces
  • Required date – use your date format as set in Business Settings 

When importing back in, tick the header box if the CSV has a header row as above: 

 

Unforgiving Import

The import isn’t forgiving. It needs everything to be perfect so make sure you have your codes correct and indeed all other values correct. Anything unexplained will cause a rejection of the importing and you will need to edit and retry. 

    • Related Articles

    • Custom fields on line items

      Introduction You can create custom fields on the line items of both Purchase Orders and Invoices. These fields can be text based, a date or a select list of options. The values are then stored with the document and can be seen in the line-item ...

    • Import Invoices from Xero

      This feature is designed for those Xero users that use Dext, Auto Entry, EzzyBills or in fact anyone that created purchase invoices on your behalf. These services will export the invoice into Draft in Xero. From here the invoices can be imported into ...

    • Creating a purchase order

      If you haven’t used purchase orders before, we have a useful article on “what is a purchase order” which has some background information. This article explains how to create a purchase order in Zahara. Creating an order You can create a purchase ...

    • Xero gross up

      If you aren’t VAT registered and you wish to post all invoices into Xero as Gross against a Zero rated tax code, then this feature is for you. We recommend you send your Zahara orders to your suppliers in a “True” nature – ie £100 + VAT – so use the ...

    • Why isnt my invoice linked to an order?

      For an invoice to be matched with an order, the line items from the Order have to be imported. Please review this help article: