Bulk Importing of Products
Products within Supply'd can be used to buy, sell or produce. There is a large amount of information and functionality you can set to configure the products to be used for their various purposes.
Products in Supply'd use a "Simple Product" methodology, meaning for each size, colour or flavour of product you would create a new product.
There are 2 ways to import products to Supply'd:
Manually add products to Supply'd (For instructions on how to do this, see the Adding & Updating Products document.)
Bulk import products to Supply'd from a CSV template.
This document will guide you through bulk adding of products to Supply'd.
Bulk Import/Add Products
Supply'd makes it easy to import large sets of product from a spreadsheet. There is a specific template you will need to follow to do so in order to allow Supply'd to import the values correctly.
Export Products
If you have already started adding products to Supply'd you will be given the options to export existing catalogue as a template, this will export all your existing products in Supply'd in the template format. This is particularly useful if you want to bulk update the catalogue with additional information.
Supply'd Product Data:
Tick this to export the core details of your product in Supply’d - like name, SKU, categories, barcode, units of measure, and stock settings. It’s the main info used across purchasing, inventory, and sales.
Food Products Details:
Export food-specific information such as:
Ingredients
Nutrition info
Allergens
Country of origin
Shelf life and storage
This is especially important for food labelling and compliance.
Product Supplier's Lists:
Will export details about the suppliers linked to each product, including:
The supplier
Supplier product codes
Buy prices
Pack sizes or units
Sales Channels Settings:
Will export product data about how the product is listed and sold through your connected sales channels (like Shopify, Square, etc.), including:
Channel-specific product names or codes
Prices
Visibility (active/inactive)
Any sales rules for each channel
Complete the Spreadsheet
Fill out the template using the guidance below:
SKU
Defines the SKU of the product. This should be a unique identifier for the product. The same SKU cannot be used on multiple products. The SKU is used to match products when updating so it is strongly recommended not to leave blank.
Brand
Defines the brand or the manufacturer of the product.
In the example of Sungold Full Cream Milk 2lt, the brand would be "Sungold". The brand is optional if you do not sell the product. Brand is required for product you sell.
Name
Defines the product name. As the brand and size can be entered in alternative field you would enter it without the extra details.
For example if you have a Sungold Full Cream Milk 2lt you would simply put the name as "Full Cream Milk".
Size
Defines the unit size of the product to be used in conjunction with the Size Measure field.
For example, with our product Sungold Full Cream Milk 2lt we would define the size as "2".
Size Measure
Defines the unit size measurement of the product to be used in conjunction with the Size Unit field.
For example with our product Sungold Full Cream Milk 2lt we would define the size measure as "Litres" or "l".
Possible values are:
"Grams" or "g"
"Kilograms" or "kg"
"Millilitres" or "ml"
"Litres" or "l"
"Ounces" or "oz"
"Pounds" or "lb"
Any alternative measures will be ignored.
Barcode
Defines the barcode of the product. This should be the barcode of an individual item in the carton. This allows customers to scan an item to find it quickly in Supply'd for ordering or re-ordering.
Carton Barcode
The barcode on the carton of this product (if different to the unit barcode).
Description
Allows you to enter a detailed description of the product. This is useful to give customers extra information to assist them with making their purchasing decisions. For example you may include any allergen information and/or ingredients as well as descriptive details of the product.
Category
Defines the category on your supplier profile that you would like this product to sit under. Supply'd is flexible with categories to allow you to define your own so you can group your products in any way you choose.
For example with our product Sungold Full Cream Milk 2lt, if you are a milk distributor you may opt to have a "Full Cream Milk" category, or if you sell lots of other products not just milk you may opt to have the category as simply "Milk".
Tags
Allows you to enter a number of tags that suit the product separated by a comma. Tags are predefined by Supply'd and are used to match particular product types. For example whether the product is vegan, vegetarian, nut free, gluten free etc. Customers can use tags to find all vegan products that match a given search query. To see a full list of tags click here.
Width
The width of the carton in centimetres when shipped.
Height
The height of the carton in centimetres when shipped.
Depth
The depth of the carton in centimetres when shipped.
Weight (kg)
The weight of the carton in kilograms when shipped.
For our example product, "Sungold Full Cream Milk 2L", each bottle weighs 2 kg and comes in a crate of 9, so the total weight would be entered as "18". This is used for third-party applications such as Shippit to provide live quoting on products.
Type
Defines the type of product this is. For example, if it is a Standard product, Bundled or Recipe.
Types are:
Standard
Bundled
Recipe
Shipping Carton
Gift Note/Card
Production
For more details on Product Types, refer to the Product Types document.
Sell Product
Whether or not you sell this product. Type Yes or No.
Price
The default sell price for this product, including GST.
Sale Price
If this product is on sale, enter the sale price here. Leave blank for no sale price.
Tax
If GST is applicable to this product when selling, type "GST", if not leave blank.
Pack In Carton
Whether or not this item should be packed in a shipping carton when shipped. Type Yes or No. If Yes, the item would be packed in an aggregated shipping carton during packing. If No, the item would ship as is with no additional cartons.
Version Of
This field links a new product to an existing one when you're creating an updated version (like a recipe or packaging change). It helps you track changes while keeping the product history clear.
Is Discontinued
Whether or not this item is discontinued. Type Yes if the product is discontinued.
Notes
Add any desired notes about this product - for internal reference only.
Departments
The department(s) this product belongs to.
Custom - Ambient Shelf Life
This is an example of a custom field. The shelf life of this product.
Custom - Ticket Name
Another example of a custom field. The name that will appear on the shelf ticket for this item.
Custom fields are additional fields you can create for yourself, and they may differ from those in our example above. See the Product Settings document on how to add these.
If you have chosen to export Food Products Details, Product Supplier's Lists or Sales Channels Settings in the Export Products form in step 3, there will be additional fields. Refer to the relevant documents for details on these fields - Adding & Updating Products, Food Product Details*.
Select Options
Auto Extract Data
Auto Extracting Data helps speed up product imports by automatically matching columns in your CSV to the correct fields in Supply’d.
It looks for common headers like “Product Name” or “SKU” and maps them for you, saving time and reducing errors, especially with large product lists.
Select Yes or No from the drop-down menu.
Update Existing Products
This option will only appear if you already have products in Supply'd. Select "Yes" if you would like products to be updated if the SKU's match, select "Skip" if you'd like matching SKU's to be ignored/skipped. Selecting "Yes" is useful to bulk update products in Supply'd.
Run Other Product Importers
This option lets Supply’d detect and auto-map CSV files from other platforms (like Shopify or Square), making it faster to import products without reformatting your file.
Select Yes or No from the drop-down menu.
Last updated