Page cover

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.

Bulk importing products into Supply’d is a quick and efficient way to add multiple products to your account at once. Instead of entering each product manually, you can upload all your product details using a CSV file. This saves time, reduces data entry errors, and ensures your product catalogue is accurate and up to date.

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:

  1. Manually add products to Supply'd 👉 For instructions on how to do this see the Adding & Updating Products document.

  2. 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.

1

Open the Import Products Form

To start an import, or to get the template:

  1. Select Products from the menu.

  2. Click on the three dots on the top right corner

  3. Select Import then Products.

The Import Products form will open.


2

Download the Template

Click on Download the template to download our base template containing some sample products for your guidance.

The Export Products form will open.


3

Export Sample Data

Select Sample Data from the Data Source menu.

circle-check

Fields

The Fields section lets you select the types of data to include in the export.

  • Product Info: Includes basic details about the product such as its name, description, SKU, category, and tags.

    circle-check

  • Purchasing Info: If you buy this product, these fields cover supplier-related details, cost prices, minimum order quantities, and other purchasing data.

    circle-exclamation

  • Label Info : Contains information used for food product labelling, including place of ingredients, allergens, and nutrition details. Helps with printing labels and regulatory compliance.

    circle-exclamation

  • Sales Channel Info: Includes data related to what sales channels the product is sold on, pricing for different channels, inventory availability, and channel-specific settings. Useful for managing multi-channel sales.

    circle-info

    Each product can be sold through multiple sales channels.

Click .

Once the data export is complete, you can open the downloaded template in any spreadsheet application, such as Excel or Numbers.

circle-exclamation
circle-info

The more selections you make in the Fields section, the more data fields will be included in the spreadsheet. For clarity, we will break these down into sections, under their respectable tabs, in the next step. However, when multiple selections are made, the order of fields on the spreadsheet may vary slightly, as some selections share the same fields, such as Name and Size.


4

Complete the Spreadsheet

Complete the template by following the instructions provided in each tab - Product Info, Purchasing Info, Label Info and Sales Channel Info. Make sure to click through all the tabs for each set of details you want to import, as each tab contains specific fields and examples needed to complete the template correctly.

Product Info

The Product Info fields contain all the basic details about a product, including its name, description, SKU, category, and tags. This information helps identify, classify, and organise the product within Supply’d, making it easier to manage inventory, track items, and support accurate reporting and search functionality.

Id

The ID is the unique identifier of a product in Supply’d.

  • For existing products: Enter the product’s ID to update it.

  • For new products: Leave this tab blank so Supply’d can assign a new ID automatically.

This ensures Supply’d correctly matches updates to existing products while preventing conflicts for new products by letting the system generate a unique ID.

SKU

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

The brand or the manufacturer of the product.

In the example of : 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

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

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

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.

circle-info

Size & Size Measure

These fields determine how items are tracked in Inventory and depends on how you want to manage them.

For example, if you buy a 15 kg bag of sugar:

  • If you want to track it as a single 15 kg bag, enter 15 kg.

  • If you want to track it in 1 kg units, enter 1 kg.

It’s best to keep this consistent across your inventory, especially if you switch suppliers or use multiple suppliers with different package sizes, to avoid confusion and simplify reporting.

Barcode

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

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

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

Enter any tags that suit the product, separated by a comma.

Supply’d provides a set of predefined tags used to classify and match specific product attributes, such as whether a product is vegan, vegetarian, nut-free, or gluten-free. These tags help customers filter and search for products more effectively. For example, customers can use tags to find all vegan products that match a specific search query.

Available options are:

  • Biodegradeable

  • Compostable

  • Gluten Free

  • Vegan

  • Vegetarian

  • Dairy Free

  • Nut Free

  • Egg Free

circle-check

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

The type of product this is.

Types are:

  • Standard

  • Bundled

  • Recipe

  • Shipping Carton

  • Gift Note/Card

  • Production

👉 For more details on Product Types, refer to the Product Types Overview document.

Sell Product

Whether or not you sell this product. Type Yes or No.

Price

The default sell price for this product, including tax.

Sale Price

If this product is on sale, enter the sale price here. Leave blank for no sale price.

Tax Type

If tax, such as GST, is applicable to this product when selling, type the tax type, eg. "GST".

Leave blank if tax does not apply.

Unit Rrp

The recommended retail price (RRP), including taxes, for a stockist to sell one unit of this product.

Avg Unit Cost

The average cost for one unit of the product.

Pack In Carton

Whether or not this item should be packed in a shipping carton when shipped.

Type Yes or No:

  • Yes: The item would be packed in an aggregated shipping carton during packing.

  • 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 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.

circle-info

This field will only appear if you’ve set up optional Departments within your Locations.

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.

circle-check


5

Export/Save the File

Once you have completed filling out the spreadsheet, ensure that you save or export it as a CSV file as this format is required for successful import into Supply’d.


6

Upload the File

On the Products page, click on the 3 dots in the top right and select Import, then Products.

The Import Products form will open.

In the Upload CSV File field, click on to select the CSV file you just completed.

circle-exclamation


7

Select Options

Select the options to apply during the import.

Update Existing Products

Select whether or not to update existing products in Supply'd.

circle-info

This option will only appear if you already have products in Supply'd.

  • Yes: Select "Yes" if you want existing products to be updated when the SKUs match.

  • Skip: Select this option if you want products with matching SKUs to be ignored.

circle-check

Advanced

Optional data you would like to be used to populate the export.

Auto Extract Data

Choose whether or not to enable automatic data extraction.

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.

Run Other Product Importers

Select whether or not to let Supply’d detect and automatically map CSV files from other platforms (such as Shopify or Square), making it faster to import products without reformatting your file.


8

Import the File

Once the file has successfully uploaded and you have selected your options, click to begin the import.

circle-info

Products will be imported immediately into Supply'd. If you have a lot of products, please be patient.

circle-check

Last updated