This page explains how both producers can import product details, and distributors can set up their hub inventory, in bulk.
The product and inventory import tool lets you upload a .csv file to add and update your stock. This can be much quicker and efficient than adding or updating products one by one. For producers who already update a catalogue of their products in an Excel spreadsheet regularly, this can save a lot of time!
The product and inventory import tool can be found by clicking Products in the horizontal blue menu, and product import in the green menu.
There's four main ways you can use the tool:
Update existing product details
Update products in a shop/hub inventory
In all cases the process involves downloading a CSV template, filling in the fields and then uploading your CSV file back into OFN.
We hope to include these in future developments.
Use these instructions if you want to add new products to a producer's profile.
You can simultaneously upload new products and update existing products with a single CSV upload. The instructions in this guide are separated for clarity but you can combine new products and updates in the same spreadsheet.
You'll see that the template gives all the column headings required to successfully import a product. Each row is for a new product or variant. Below is a description of how to fill in each column.
N.B. All fields are case sensitive e.g. you must use mL and Dairy, not ml or dairy.
In the import process, variants are distinguished by the units (such as raspberries sold in 200g and 500g packs) or display_name fields (such as apples sold in multiple varieties). As long as the product name is the same, the rows will be imported as variants. For products sold as items, the unit_type must be the same across variants (e.g. rolls below).
The image below shows how these products will display in the shop. Note that the 'name' field becomes the primary heading, and the 'display_name' field and/or the units becomes the secondary heading.
Below are some examples to show how products with different units (g, ml, kg and items) should be uploaded.
Once you have filled out the Product List Template CSV you are ready to upload it into OFN.
Go to Products > Product Import.
Select import type: Product List
Select a spreadsheet to upload: select the CSV file you've updated with your product info.
Because you are uploading new products, you can leave the 'Set stock to zero for all exiting products not present in the file' checkbox unchecked (see next section for an explanation of this feature).
Click Upload.
You'll be shown a summary of your upload, including any errors. You'll also be told how many products you are creating and how many you are updating. If you're happy with the upload results, click save.
It's good practice to check that the products uploaded/updated as you intended.
You can then upload another spreadsheet or go to the products page to view your new products.
The instructions below relate to updating the details of an existing product. This tool is intended as a quick way to update product prices and stock levels.
The system requires seven fields to correctly identify the product you want to update. There are four fields which can be updated and four fields which cannot using this tool.
^ if you try to update these fields you'll see an error message
*If you try to update these fields you'll actually create new products or variants, rather than update an existing product.
Firstly, download the Inventory Template CSV file from the Product Import page.
You'll see that the template gives all the column headings required to successfully import a product. Each row is for a new product or variant. Below is a description of how to fill in each column.
Once you have filled out the Inventory Template CSV you are ready to upload it into OFN.
Go to Products > Product Import.
Select import type: Select Inventories
Select a spreadsheet to upload
Click Upload.
You'll be shown a summary of your upload, including any errors. You'll also be told how many products you are creating and how many you are updating. If you're happy with the upload results, click save.
It's good practice to check that the products uploaded/updated as you intended.
N.B. All fields are case sensitive so you must use the exact category and unit_type names, e.g. 'mL' and 'Dairy' instead of 'ml' or 'dairy'.