> For the complete documentation index, see [llms.txt](https://help.supplyd.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.supplyd.co/supplyd-hub/products/bulk-importing-of-products-supplyd-hub.md).
# Bulk Importing of Products (Supply'd Hub)
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 Products (Supply'd Hub)](/supplyd-hub/products/adding-products-supplyd-hub.md) document.
2. Bulk import products to Supply'd from a CSV template.
This document will guide you through bulk adding and updating of products to Supply'd.
* [#bulk-import-add-products](#bulk-import-add-products "mention")
* [#bulk-updating-products](#bulk-updating-products "mention")
***
## 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.
{% stepper %}
{% step %}
### 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.
***
{% endstep %}
{% step %}
### 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.
***
{% endstep %}
{% step %}
### Export Sample Data
Select **Sample Data** from the **Data Source** menu.
{% hint style="success" %}
If you have already started adding products to Supply'd, you will be given the option to export existing products from your various sales channels. This is particularly useful if you want to bulk update your products with additional information.
👉 See the [#bulk-updating-products](#bulk-updating-products "mention") section below.
{% endhint %}
#### **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.
This information is used to create new products.
* **Label Info :** Contains information used for food product labelling, including place of ingredients, allergens, and nutrition details. Helps with printing labels and regulatory compliance.
This will only update existing products.
* **Sales Channel Info:** Includes data related to what sales channels the product is sold on.\
As you are using Supply'd Hub, the only sales channel is your account name.
Click .
Once the data export is complete, you can open the downloaded template in any spreadsheet application, such as Excel or Numbers.
{% hint style="warning" %}
You should remove the sample products from the file before importing to Supply'd.
{% endhint %}
{% hint style="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 respective 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.
{% endhint %}
***
{% endstep %}
{% step %}
### Complete the Spreadsheet
Complete the template by following the instructions provided in each tab - **Product 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.
{% tabs %}
{% tab title="Product Info" %}
#### 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.
**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:
* Biodegradable
* Compostable
* Gluten Free
* Vegan
* Vegetarian
* Dairy Free
* Nut Free
* Egg Free
{% hint style="success" %}
👉 You can also add custom tags in the [Product Settings (Supply'd Hub)](/supplyd-hub/settings/product-settings-supplyd-hub.md#product-editing) section in your [Product Settings (Supply'd Hub)](/supplyd-hub/settings/product-settings-supplyd-hub.md).
{% endhint %}
**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.
{% hint style="success" %}
The only type in Supply'd Hub is - Standard
{% endhint %}
**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.
{% endtab %}
{% tab title="Label Info" %}
#### 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.
**Id**
The **ID** is the unique identifier of a product in Supply’d.
**SKU**
The SKU of the product.
**Brand**
The brand or the manufacturer of the product.
**Name**
The product name.
**Size**
The unit size of the product to be used in conjunction with the **Size Measure** field.
**Size Measure**
The unit size measurement of the product to be used in conjunction with the **Size Unit** field.
**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**.
**Shelf life**
Specify how long the product remains suitable for use or sale.
**Shelf Life Measure**
Enter how the shelf life is measured - **Days**, **Months**, or **Years**
**Usable Size**
Ignore this field. It applies to functionality available in Supply’d ERP and is not used in Supply’d Hub.
**Usable Size Measure**
Ignore.
**Batch Expiry Type**
Enter the type of expiry date for this product - either **Best Before** or **Use By**.
{% hint style="warning" %}
**Batch / Production / Recipe Fields**
Ignore these fields. They apply to functionality available in Supply’d ERP and is not used in Supply’d Hub.
{% endhint %}
**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.
{% endtab %}
{% tab title="Sales Channel Info" %}
#### Sales Channel Info
**Sales Channel Name**
Specifies the sales platform(s) where the product will be available.
{% hint style="success" %}
As you are using Supply'd Hub, the only platform is your account name.
{% endhint %}
**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**
Indicates whether the product is currently active for sale on this channel.
Type **Yes** if it is active.
**Is Sellable**
Indicates whether the product is allowed to be sold.
This helps differentiate between sellable products and non-sellable items (such as components or internal materials).
Type **Yes** if the product 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 through this channel.
Type **Yes** this item is packed in a carton.
**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.
{% endtab %}
{% endtabs %}
***
{% endstep %}
{% step %}
### 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.
***
{% endstep %}
{% step %}
### 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.
{% hint style="warning" %}
After selecting the file please ensure you wait for the file to successfully upload before clicking Import.
{% endhint %}
***
{% endstep %}
{% step %}
### Select Options
Select the options to apply during the import.
**Update Existing Products**
Select whether or not to update existing products in Supply'd.
{% hint style="info" %}
This option will only appear if you already have products in Supply'd Hub.
{% endhint %}
* **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.
{% hint style="success" %}
Selecting "**Yes**" is useful to bulk update products in Supply'd.
👉 See the [#bulk-updating-products](#bulk-updating-products "mention") section below.
{% endhint %}
#### 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**
Automatically run other product importers (eg. food details, suppliers, sales channel settings) based on the columns present in your CSV.
***
{% endstep %}
{% step %}
### Import the File
Once the file has successfully uploaded and you have selected your options, click to begin the import.
{% hint style="info" %}
Products will be imported immediately into Supply'd. If you have a lot of products, please be patient.
{% endhint %}
{% endstep %}
{% endstepper %}
{% hint style="success" %}
👉 Once imported, the products can be managed as outlined in the [Managing Products](/supplyd-erp/products/managing-products.md) document.
{% endhint %}
***
## Bulk Updating Products
When bulk updating existing products in Supply'd via a CSV file, following a "lean" approach is recommended to prevent data loss or operational disruption.
{% stepper %}
{% step %}
#### Export the Template
Following the steps above, but instead of selecting **Sample Data** in Step 3, select **Supply’d** (or the data source you want to update) to export your current product list. This ensures you have the correct formatting and system IDs before making updates.
***
{% endstep %}
{% step %}
#### Filter Columns
Remove all unnecessary columns from the CSV, keeping only the specific fields you wish to change (eg. Price or Category).
{% hint style="warning" %}
**Preserve Product IDs:** You must keep the ID column for every product you intend to modify. This ID tells the system exactly which existing record to overwrite.
{% endhint %}
***
{% endstep %}
{% step %}
#### Update the Fields
Update the required fields, following the guidelines outlined above for [#bulk-import-add-products](#bulk-import-add-products "mention").
***
{% endstep %}
{% step %}
#### Import with Update
When re-uploading the file, ensure you select "**Yes**" for the **Update Existing Products** field.
{% endstep %}
{% endstepper %}
{% hint style="info" %}
**Why This Method is Best Practice**
* **Avoids User Conflict:** Keeping unnecessary columns in your file can potentially disrupt other team members who may be simultaneously editing those same products in the dashboard.
* **Prevents Data Deletion:** If you leave unnecessary columns in the file but clear the data inside them (leaving them blank), the system will interpret this as an instruction to wipe those fields clean in the database.
* **System Efficiency:** Importing a smaller file with fewer columns reduces processing time and the risk of import errors.
{% endhint %}
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://help.supplyd.co/supplyd-hub/products/bulk-importing-of-products-supplyd-hub.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
