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.

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, select Products from the menu, click on the three dots on the top right corner, select Import then Products.

The Import Products form will open.

2

Download the Template

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

3

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

4

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.

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.

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, Creating a Production Product.

5

Export the File

Once you have completed the file you should export the file as a CSV file. Please ensure you are exporting the file with comma as the separating value.

6

Upload the File

You can then upload the CSV using the steps using the guidance below:

Upload CSV File [required]

Allows you to select the CSV file to upload. After selecting the file please ensure you wait for the file to successfully upload before importing.

7

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.

8

Import the File

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

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

Last updated