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

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 in the next step. However, 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 guidelines below.

Product Info

The Product Information section contains 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.

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


Supplier Info

If you purchase this product, these fields provide detailed information about the supplier, including their name, contact details, preferred status, and any other relevant purchasing information.

Supplier Name

The name of the supplier for this product.

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.

Supplier Sku

The SKU or unique identifier for this product to be used when sending orders to the supplier. Leave blank to use the SKU for the overall product.

Barcode

The barcode of the product.

Supplier Barcode

The suppler's barcode for this product used for receiving stock with this barcode. Leave blank to use the overall product barcode.

Brand

The brand or the manufacturer of the product.

Supplier Brand

The brand of the product being bought. Leave blank if the same brand as the product.

This is useful when you have the same product available from different brands or suppliers.

Name

The product name.

Image

Allows you to upload a product image to Supply'd.

We recommend a square image at least 640 x 640px with a transparent background such as a PNG file. JPG uploads are also supported if transparent images aren't available.

Category

The category on your supplier profile that you would like this product to sit under.

Is Discontinued

Whether this item is discontinued. Type "Yes" if the product is discontinued.

Size

The unit size of the product to be used in conjunction with the Size Measure field.

Size Measure

The unit size measurement, eg. g, oz, l etc., of the product to be used in conjunction with the Size Unit field.

Supplier Size

The weight/size of a single unit. Leave blank to ignore if the same size as the product.

Supplier Size Measure

The unit size measurement, eg. g, l, kg etc., of the product to be used in conjunction with the Supplier Size field.

Buy Carton Qty

The number of units in a carton. Applicable to products purchased by the carton.

Buy Price

Enter the wholesale price for a unit or carton, excluding taxes (such as GST), depending on your choice in the Purchase By field.

Buy Tax Type

Whether tax (such as GST) applies to this product when purchasing. If it does, enter the type of tax, eg. GST.

Buy Currency

The currency used to buy this product.

In Preferred

Enter Yes if this supplier is the preferred source for purchasing this product."

If Yes, the system will add this supplier to your favourites, suggest them first when purchasing the product, and use their costs for product cost calculations

Minimum Qty

The minimum order required for this supplier.

You will be unable to order less than this quantity of an item.

Leave blank for no minimum.

Qty Multiple

The quantity multiple set for this supplier.

Orders can only be placed in multiples of this amount. For example if set to "5" you will only be able to order 5, 10, 15, 20 etc.

Leave blank for no order multiple.


Label Info

Adding Labelling Details to your product set up in Supply’d gives you a central place to store and manage everything related to your food products - from ingredients and allergens to nutritional info and shelf life. This helps ensure compliance, supports traceability, and makes it easier to keep product data accurate and up to date across your business.

Country of Manufacture

Select the country the product was made in.

Percentage Australian

The percentage of this items ingredients that are Australian. Applicable to products made in Australia.

Ingredients

Add any ingredients contained in this product. Leave blank if not applicable.

Allergens - Contains

Enter any allergens that are present in this product, separated by a comma (eg. "dairy, nuts"). Don't include leading statements such as "Contains". Leave blank if not applicable.

Allergens - May Contain

Enter any allergens that may be present in this product, separated by a comma. Don't include leading statements such as "May contain". Leave blank if not applicable.

Storage Type

The type of storage required - Ambient, Refrigerated or Frozen.

Recipe Goods Cost

The total cost of all ingredients used in the recipe to produce this product.

Recipe Labour Cost

The cost of labor required to prepare the recipe.

Recipe Total Cost

The combined total of goods cost and labor cost. This gives the overall cost to produce the recipe.

Recipe Size

The total quantity or volume that the recipe produces (eg. number of units).

This helps in portioning and inventory planning.

Recipe Expected Yield

The standard or typical output quantity expected from the recipe.

This is the target amount you plan to produce under normal conditions.

Recipe Min Yield

The minimum quantity the recipe is expected to produce.

This accounts for natural variations in production.

Recipe Max Yield

The maximum quantity the recipe could produce.

This helps set realistic production limits and expectations.

Recipe Unit Cost

The cost to produce a single unit of the recipe.

It is calculated by dividing the Recipe Total Cost (ingredients + labor) by the number of units produced (Recipe Size).

Production Priority

The Production Priority field is used to indicate the importance or urgency of producing a specific product.

Nutrition - Servings Per Package

This is the total number of servings in one full pack of your product.

For example, if a bottle contains 500ml and each serving is 250ml, then Servings Per Package = 2.

Nutrition - Serving Size

This is the amount of product in a single serving. It should reflect the typical portion someone would consume at one time.

Nutrition - Remaining Fields

The remaining fields capture the nutritional values of the product, both per serving and per 100g, as indicated in the field headings.


Sales Channel

Sales Channel Name

Specifies the sales platform(s) where the product will be available, such as Shopify, Square or your Supply'd store(s).

circle-info

You will need to have any third party sales platforms integrated with Supply’d. 👉 See the Integrations documents for instructions on how to integrate each platform.

Sku

The SKU of the product.

Barcode

The barcode of the product.

Brand

The brand or the manufacturer of the product.

Name

The product name.

Image

Allows you to upload a product image to Supply'd.

We recommend a square image at least 640 x 640px with a transparent background such as a PNG file. JPG uploads are also supported if transparent images aren't available.

Size

The unit size of the product to be used in conjunction with the Size Measure field.

Size Measure

The unit size measurement, eg. g, oz, l etc., of the product to be used in conjunction with the Size Unit field.

Category

The category on your supplier profile that you would like this product to sit under.

Is Discontinued

Whether this item is discontinued. Type "Yes" if the product is discontinued.

Sell Active

Is Sellable

Sell Price

The default sell price for this product, including tax.

Sell Sale Price

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

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

Sell Currency

The currency used to sell this product.

Sell Pack in Carton

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

Type Yes or No

Sell Carton Qty

The number of units in a carton. Applicable to products sold by the carton.

Minimum Qty

The minimum order amount of this product required for a customer to buy.

Customers will be unable to order less than this quantity of an item.

Leave blank for no minimum.

Qty Multiple

The quantity multiple set for a customer to buy this product.

Customer orders can only be placed in multiples of this amount. For example if set to "5" customers will only be able to order 5, 10, 15, 20 etc.

Leave blank for no order multiple.

Default Price

The default sell price for this product, including tax.

Channel-specific prices can be set if needed.

Default Sale Price

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

Default Tax Type

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

Leave blank if tax does not apply.

Default Pack In Carton

Indicates whether this item should, by default, be packed in a shipping carton when shipped.

Enter Yes to set the default so this item is packed in a carton.


5

Export/Save the File

Once you have completed filling out the spreadsheet, ensure that you save or export it as a CSV file. Make sure to use commas as the separating values, 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