UFA Handbook Watch

What changed in Odyssey's Utah Fits All handbook, and when.

How to Upload Multiple Offerings at Once (Bulk Upload Guide)

Change history

Current text as recorded

Uploading multiple offerings in bulk allows vendors to save time and keep their Marketplace listings organized. This guide walks you through how to use the CSV templates in your Vendor Dashboard to upload multiple products or services at once.


Step 1: Open the Offerings Page

From your Vendor Dashboard, click Offerings.
At the top of the Offerings page, you’ll see several tabs:


Step 2: Review the Upload Guide (Recommended)

If you’re new to bulk uploads, click Upload Guide before getting started.
This guide provides:

  • A complete reference for product, variant, and inventory uploads

  • Formatting examples for each column

  • A list of valid educational categories (there are 80 total)

 

Tip: Category names are case-sensitive and must match exactly as written in the Upload Guide, or your file will return an error.


Step 3: Best Practices Before You Start

Follow these key recommendations before creating your CSV:

  • Save your file using UTF-8 encoding to prevent formatting or character errors.

  • Separate multiple image URLs with a semicolon (;).

  • Keep “product_name” and “offering_details” clear and descriptive.

  • Use unique SKUs for every product and variant.

  • Test first: Start with a small CSV (2–3 rows) before uploading a large batch.

  • Download the template files from your dashboard for correct formatting.

  • For products with variants, upload the parent product first (is_variable = 1) and then upload the variants file.


Step 4: Download the Products Template

Select Products Template from the top bar. This will open the Offers CSV file where you’ll enter your product or service details.

Important:
Do not change or delete the column headers in the CSV. Altering them can cause upload errors.

 

 


Step 5: Fill Out Each Column

Below is a breakdown of the 16 standard columns in the Product CSV:

Column Field Name Description / Example
A marketplace_type “Product” or “Service”
B product_name The title of your offering (e.g., “1-Hour Math Tutoring Session”)
C product_sku A unique identifier (letters/numbers only; must be unique)
D external_url Link to your website or product page (optional)
E category Must exactly match one of the valid categories listed in the Upload Guide
F offering_details Detailed description of the offering (see below for examples)
G min_grade Smallest grade level eligible (optional)
H min_age Youngest eligible age (optional)
I education_level Level served (elementary, middle, high, etc.)
J max_grade Highest eligible grade (optional)
K max_age Oldest eligible age (optional)
L price Total price, including shipping if applicable
M quantity Available units or seats (set a high number for services like tutoring)
N is_variable Enter “1” if product has variants, “0” if not
O video_url Link to an optional video (YouTube, Vimeo)
P images URL to offering image(s); separate multiple links with “;”

Examples for Offering Details

Tutoring Service Example:

Personalized 1-hour math tutoring session with a certified educator covering algebra, geometry, trigonometry, and pre-calculus. Flexible scheduling available via live video conference.

Product Example:

TI-84 Plus Graphing Calculator — high-resolution color display, preloaded math applications, ideal for algebra through calculus.

 

 


Notes:

  • Include shipping cost in the total price for products. It cannot be added later.

  • Quantity: For services, set a high quantity (e.g., 999) to keep your offering visible in the Marketplace.

  • Images: Use direct image URLs only (hosted publicly).


Step 6: Save the File

When your CSV is complete:

  1. Click File > Save As

  2. Under “Save as type,” choose CSV UTF-8 (Comma delimited) (.csv)

  3. Save your file with a clear name, such as:
    OdysseyTutoring_Offerings_Oct2025.csv

     

 


Step 7: Upload Your CSV

Return to the Offerings tab and click Upload CSV.
You can either:

  • Click Add File and choose your file, or

  • Drag and drop the file directly into the upload window.

Once added, click Upload CSV.

 

 


Step 8: Check Your Upload

After uploading:

  • Your new offerings will appear in the Pending section of your Offerings page.

  • Our Marketplace Team will review submissions to ensure they meet program and state guidelines.

  • Once approved, offerings will automatically appear in the Marketplace.


Step 9: Upload Variant Offerings (If Applicable)

If your products have variants—like different colors, lesson lengths, or packages—download and fill out the Variants Template next.

Key Details:

  • Each variant must share the Parent SKU from your first CSV.

  • Each variant needs its own unique Variant SKU.

  • Fill out variant-specific fields (e.g., size, package name, or color).

Then, upload your Variants CSV using the same Upload CSV button.


Step 10: Verify Status and Fix Errors

Once uploaded, refresh your Offerings page to confirm the status.
If any rows fail, review the following common causes:

Error Message Likely Cause Solution
Invalid Category Misspelled or mismatched category name Match exactly as listed in Upload Guide
Duplicate SKU Reused SKU between rows Assign a unique SKU to each offering
Image Error Broken or private link Ensure URLs are public and correctly formatted
Upload Failed File not UTF-8 encoded Re-save file as CSV UTF-8 (Comma delimited)

Odyssey Tip

Start small! Upload 2–3 offerings first to confirm the format before submitting your full catalog. Once confirmed, you can upload hundreds at once with confidence.

You can monitor your offering’s review status directly in your Vendor Dashboard.
If it has been several days without an update, you’re welcome to email vendors@withodyssey.com for assistance.


Related Articles