Import your stock list from a spreadsheet

Coming from a spreadsheet or another reseller tool? Import stock brings your whole stock list into Inventory in one go: each row becomes a stock item, or restocks one you already have, with what it cost, how many you have, when and where you bought it and where it is kept.

Before you start

Export or save your list as CSV, Excel or OpenDocument. One row per item, with a heading row. You need at least:

• a product name or a SKU, and
• what it cost (per unit, or for the whole row).

These columns are used too when the sheet has them: Quantity (1 when there is none), Date bought, Where you bought it, Storage location, Category, Brand and Label.

Import your list

1. Go to Inventory and click Import stock. In the app, tap Import stock in the Stock tab: it opens the website.
2. Choose your file and click Upload.

3. Match the columns: ProfitClerk guesses which column is which from the headings. Check each one; Cost is the only one you must set.

4. Choose whether the cost is per unit or for the whole row, and what happens to a SKU already in Inventory: Restock it or Leave it as it is. 5. Click Preview. Each row shows New item, Restock, Already in Inventory or what is missing. Nothing has changed yet.

6. Click Add … items.

Rows missing a name and SKU, a quantity or a cost are skipped. A row without a SKU gets one made from its product name, marked (made from the name) in the preview.

After the import

• Every item gets a FIFO lot dated with its Date bought, so Sourcing and how long stock takes to sell work from day one.
• Items without SKUs on eBay: open Inventory › eBay listings and link each listing to its item. See Give eBay listings without a SKU their cost.

Undo an import

Under Recent imports, click Undo next to the import. It removes the items it added that nothing has happened to since (no sale, restock or change by hand). Restocks of items you already had, and items that changed, are kept; the message says how many.