Flipns Guides
Selling

Import and export a stock sheet

Download your stock as a spreadsheet, update counts and deliveries, and bring the changes back in one go.

Updated 2026-11-12

A stock sheet is a CSV file with one row for each item and option you stock. Export it, fill in what you counted or received, then import it to update many items at once. You review every change before anything is saved. Import and export need a connection. If stock tools aren't on your account yet, see Keep track of your stock.

Export a stock sheet

  1. Open Your listings.
  2. Choose More, then Export a stock sheet or summary…. To export only some items, select them first and choose Export in the bar that appears.
  3. Under What to export, choose Stock sheet (CSV). Product summary (CSV) is a one-row-per-item file to read or share; it can't be imported.
  4. Under Also include, tick Your cost or Archived items if you want them. Only share a file with your cost in it with people who may see what you paid.
  5. Choose Export. The file downloads when every row is ready.

Fill it in

Open the file in a spreadsheet app. For each row you want to change:

  • Enter what you counted in Counted On Hand, or what arrived in Received Quantity. Use one or the other in a row, not both.
  • Change SKU, Barcode or Threshold (the low-stock level) if you need to. Enter [default] in Threshold to use your shop's level again.
  • Leave every other column as it is, including the ones you don't recognise. Available Quantity and the other figures are for reading; changing them changes nothing.

Type numbers, not formulas. Save the file as CSV (comma delimited); a workbook file can't be read. A stock sheet can have up to 5,000 rows and be up to 2 MB.

Import it

  1. Choose Import on Your listings.
  2. Under What are you importing?, choose Update stock from a stock sheet.
  3. Choose your file. Flipns checks every row and nothing changes yet.
  4. Review the rows. Filter them by Ready, Changed since export, Conflict, Can't import and No change.
  5. Choose Apply to save the rows you kept. The button says how many counts and receipts (stock received) it will record.

Rows that need a decision

  • Changed since export: the item's stock changed in Flipns after you downloaded the file, for example because something sold. These counts are skipped unless you choose Count anyway for a row; Skip these skips them all.
  • Conflict: two rows change the same item differently, or a code or level changed both in Flipns and in your file. Choose which row to keep, or Keep current or Use file.
  • Can't import: the row says why, such as an item that no longer exists or a code another item uses. Fix the file and import it again, or leave the row out.

If you import a file you already imported recently, Flipns asks before recording it again, so deliveries aren't counted twice. Choose Import again only if you mean to.

After importing

The results list every row with what happened. Each item's Stock history shows the changes as imported.

Undo this import is offered for ten minutes. It takes back the counts and deliveries; changes to codes and levels stay.

To make further changes, export a fresh stock sheet rather than importing the same file again.

On this page