Import stock levels brings a stock-on-hand list into Phase as products and opening stock. Use it when you move to Phase and want your chemical, fertiliser, seed or parts stock across in one go, from your previous farm software, your own spreadsheet or a PDF stock report.
The quick answer. Yes, you can upload your existing inventory from a spreadsheet. Open Inventory → Chemicals (or any product section), choose Actions → Import stock levels, and pick a CSV, Excel (.xlsx) or PDF file up to 12 MB. Check each row, then select the Import button, which shows how many rows (such as Import 48 rows). Supplier invoices and statements go through Upload invoice instead (see Import a supplier invoice or statement).
Before you start
Importing needs permission to edit Inventory. Without it, Phase says "You do not have permission to import inventory for this farm."
An import adds stock. It does not replace or reset what Phase already holds. If these products already have stock in Phase, or show negative balances, sort that out first (see the next section).
Export your stock levels or product list from your previous system as a CSV, Excel or PDF report.
Clear old stock first (if you need to)
Phase has no button to reset all stock to zero. If your products already hold stock you don't want, or show negative balances:
Open Inventory and the product's section.
Select Actions → Use / adjust.
Choose the product. Phase shows its current stock under it.
Under What happened?, choose Stocktake correction.
In Quantity, enter the difference from what Phase shows. To take stock off, put a minus in front: -200 takes 200 off.
Select Save movement. Repeat for each product.
If there are a lot of products to clear, email support@phase.ag and the team can zero them for you. Then import your current stock.
Import a stock list
Open Inventory and choose a product section (Chemicals, Fertiliser, Seed, Livestock or Parts & other). On a phone, tap the section name at the top of the page to change section.
Select Actions → Import stock levels. You can also select Add fertiliser or Add seed (Add on a phone), then Import a stock list. Add chemical asks one question at a time and has no Import a stock list: use Actions → Import stock levels in Chemicals.
Select Choose a stock list and pick your file. Phase reads the table, on your device where it can and in the cloud where it can't, then suggests a match for each row from your products and the Phase library.
Work through the rows. The tabs narrow the list to Check, Matched, New or Skipped, and Search rows finds one. Open a row to check or change it:
Record as: Your product (one already in Phase), Phase library (a library product, added for you) or New product.
Quantity, Unit and Cost per unit. Check pack sizes and converted units carefully.
Batch, Storage location and Expiry. Choose an existing location, + Create a new location… (then type its name), or leave it Not assigned yet.
Use each row's Import / Skip switch to leave out rows you don't want.
If some rows have no location, use the footer's "rows with no location" box to put them all in one location, or choose Leave unassigned.
Check Stock as at in the footer against the report's date. If Phase couldn't read a date, it starts at today.
Check the footer totals: stock lots, products without stock, new products and stock value.
Select Import (the button says how many rows, such as Import 48 rows).
Nothing is saved until you press Import. Phase then shows "Stock list imported" with how many opening stock lots and new products it added, and how many existing products it updated.
The import takes every kind of product at once, whichever section you start from. Each product lands in its own section.
Rows with nothing on hand, or below zero
Zero stock. Rows with nothing on hand are skipped. To bring those products across without stock, choose Add them as products without stock.
Negative balances. Phase can't hold negative stock. Skip the row, or add the product without stock.
If the stock list needs more checking
Use the Check tab to go through the rows Phase was unsure of.
Wrong columns. Where Columns shows, select Change and choose which column holds the product, quantity, unit and so on. Select Done, then review the rebuilt rows.
Lines Phase couldn't read. Select the link "Show … lines Phase could not read" and compare those lines with the original report, so nothing is missed.
A price that looks per tonne. A row priced like $825/kg is held back until you choose. Each button names its price: Record in tonnes at … if the stock was counted in tonnes, Use … for the per-kg price Phase works out, or Keep … to leave the price as it is.
Units that don't match your stock. If the product already holds stock in a unit this row can't be converted into, such as bags against kg, Phase asks you to import in the existing unit so the on-hand total keeps adding up.
Rows Phase won't import yet. Every selected row needs a product name and a stock unit, and a new location needs a name. The line beside Import says which, and pressing it jumps to the first row to fix. Fix those rows or skip them.
What an import changes
Opening stock. Each selected row with stock becomes an opening stock lot dated Stock as at. It adds to any stock already in Phase.
Existing products. Matching a row to one of your products fills in details that are missing. It doesn't overwrite details already recorded.
Converted units and costs. When a quantity is converted into the unit you hold the product in, its cost converts with it. 15.1 t of urea at $825/t, joined to urea you hold in kg, is saved as 15,100 kg at $0.825/kg. $400 for a 20 L drum, counted in litres, is saved as $20/L.
The same file twice. Rows already imported from the same file show as Already imported and are skipped, so re-uploading it doesn't add that stock twice. A renamed or changed export may be treated as new stock.
The file is kept. Each lot records the file it came from. Phase also files the list in Documents. If the finish screen says the list couldn't be filed in Documents, the stock was still imported: keep your original file and don't import again.
Uploaded the stock list through Upload invoice?
If you pick a stock list in Upload invoice, Phase says "This looks like a stock levels list … not an invoice or statement. Use Import stock levels instead."
Select Import it as stock levels. Invoice import closes and the stock-level review opens with the same file. You don't need to choose it again.
Review the rows and press Import as above. Taking the hand-off adds nothing on its own.
If that button doesn't show, close invoice import and use Actions → Import stock levels.
Good to know
You can import up to 500 selected rows at a time. Skip some, import, then import the rest.
To fix a balance after importing, use a stocktake correction (Actions → Use / adjust → Stocktake correction). Don't change the file and import it again.
Every kind of product can come across in one file: chemicals, fertiliser, seed, livestock products and parts.
If something doesn't look right
The file won't read. Try a clearer PDF, or a CSV or Excel export of the same report. Split a file over 12 MB or over 500 rows.
Stock doubled after importing. The products already held stock, and the import added to it. Correct each one with a Stocktake correction.
A product came in twice. A row was saved as New product when you already had it. Join the two with Merge products (see Find, merge or delete a product).
You imported the wrong file. Don't import a corrected copy on top. Fix each balance with a Stocktake correction, or email support@phase.ag for help.