Products and stock
Import products from a spreadsheet
Add many products at once, or update prices and stock, from a CSV or Excel file. Check a preview before anything is saved.
Before you start
Importing needs the Owner or Manager role and a paid plan. It's on the web: open Products and click Import.
Get a file
- New products: click Download template and fill in one row per option. Rows with the same product_name become one product, for example one row for each size.
- Change products you have: click Export my products, then edit the CSV. Keep the product_id and variant_id columns: they tell FOM which product each row is.
You can do both in one file: rows with IDs update, rows without IDs add new products.
The columns
| Column | What to put |
|---|---|
| product_name | The product's name. Needed for new products. |
| description | Optional. |
| option_1_name, option_1_value | An option and its value, like Colour and Red. Leave empty for a product without options. |
| option_2_name, option_2_value | A second option, like Size and M. |
| sku | Your own code, optional. |
| price | Whole number in kyat, like 12000. Needed for new products. |
| cost_price | What it costs you. Only if your role can see costs. |
| stock_qty | How many you have. |
| track_stock | yes or no. |
| low_stock_at | Warn when stock reaches this number. |
| show_on_shop_page | yes or no. |
- An empty cell leaves that value as it is. Nothing is deleted or archived, and products missing from the file are left alone.
- A product without options has one row. Use the same option names on every row of a product.
- To add an option to a product you have, add a row with its product_id, an empty variant_id, the option value and a price.
Check and import
Under Upload and check, choose your file (CSV or .xlsx, up to 5 MB and 2,000 rows).
The preview shows how many products and options will be added or changed, and how many stock counts will change. Nothing is saved yet.
If there are problems, the table lists each one with its row and column. Fix those rows in your file and choose it again.
When there are no problems, click Import. Your products update when it finishes.
Good to know
- Stock: a new stock_qty is saved as a stock count, so stock history shows it with the note "Spreadsheet import".
- Archived products and options can't be changed by import; restore them first.
- Photos aren't imported. Add them on the product.
- The same file twice: importing the exact same file again is refused. If an import fails, nothing is saved and you can try the file again.
- A new product with the same name as one you have adds a second product. The preview warns you; use the product_id to update the existing one instead.