Uploading your products to the Programa Trade Portal? Great! Let’s break down what data is required, step by step.

📝 Template for Product Upload

You can view the [CSV Template] here. It contains four sheets:

Product Import Sheet: Enter your product data here.
Data Quality Guidelines: A guide with field-by-field instructions and examples to help you input your data.
Input List: Extra guidance on filling in specific fields referenced in the Data Quality Guidelines.
Hint: Tips, tricks, and shortcuts for entering your product data.

🧠 How Programa understands your products

There are two levels to your product data:

Base product: The main product listing.
Variants: Different sizes, colours, finishes, or other options.

Each row in your CSV should be either:

A base product, or
A variant of a base product

✅ What your CSV needs

For base products (main listings), required:

Field	Description
product_id	A unique ID for each product (don’t repeat!)
product_name	The name of the product
brand_name	Your brand name (must match your Programa profile)
category_key	The category that best fits the product

Optional but recommended:

Field	Description
description	A summary or overview of the product
primary_image	Filename of the key image (images provided separately)
lead_time	e.g. “4–6 weeks”, “In stock” (select from dropdown options)
product_rrp	The RRP (in AUD) for the base product
color_value	Select the closest matching colour (from dropdown)
materials	The main material of the product
finish	The main finish of the product

For variants (product options), required:

Field	Description
variant_of	ID of the base product
+ at least one of:	width, height, length, depth, colour_name, colour_value, finish, materials

Optional but recommended:

Field	Description
sku	Internal code or SKU if applicable
product_rrp	The RRP (in AUD) for the variant
primary_image	Filename of the variant image (provided separately)

⚠️ Important:

If two variants are identical across all attributes (e.g. same size, finish, colour), only one will be imported. Make sure each variant row describes a truly unique option.

🔥 Hot Tip:

These fields are used to filter search results on the Trade Portal: Brand, Price, Colours, Materials, Finishes, and Lead Time. The more complete your data, the better your visibility.

🗂 Accepted category_key values

Assigning each of your products to the correct category helps designers find what they need, exactly when and where they need it. On the Programa Trade Portal, we use a standardised set of category keys to ensure consistency and discoverability. You can select the appropriate category key from the drop-down menu within the CSV - refer to the Input List tab or find the full list of category keys here: [Category Keys Reference Guide]

✅ Tip: If you’re unsure which category to use, pick the one that best reflects how designers would search for your product.

🖼️ Images and Documents

Place all image and document files in a separate folder.
Images must be .jpg format and 800 x 800 pixels with a maximum file size of 2MB each.
File names must match the values in your CSV exactly.
File names are case sensitive and must include the file extension (e.g. abc_123.jpg).

💡 Final Tips

Before sending us your data and files, make sure to:

Double-check category_key values - they must match our official list exactly.
Avoid duplicate variants - each one must be unique.
Check all file names match those entered in the CSV exactly.

⏭️ What happens next?

Once you send us your CSV file along with the relevant image and document files, our team will begin the import process to upload your products into your account on the Programa Trade Portal.

If the import is successful, we’ll notify you that your products are available in your account with a ‘Draft’ status (unpublished) for your review. From there, you can either:

Review and publish each product individually, or
Request that we bulk-publish all your products at once.

If the import encounters any issues, we’ll send you a dry run report. This report outlines specific errors by line item in the CSV so you can easily identify and correct them. Once the errors are resolved, simply send the updated file back to us and we’ll reattempt the import.

👉 You can find a breakdown of the dry run report errors and how to resolve them in our [Dry Run Report Error Guide].