Affiliate Links Quick Start

Upload your affiliate links so your AI can recommend the right products to your followers — automatically.

How It Works

Once your links are uploaded, Lightwell reads your Instagram captions and video transcripts and uses AI to match each product to the posts where it's most relevant. When a follower asks your bot about a topic, it recommends the best-matching products with your affiliate links.

The File Format Lightwell Needs

Lightwell accepts a CSV file (.csv) with a header row and up to 4 columns:

The first row must be the header row with the column names above. Brand Name and Promo Code are optional — if you don't have them, just leave those cells blank.

Preparing Your Upload — ShopMy Example

Most affiliate platforms let you export a CSV. The export will have many columns you don't need — you just need to pull out the right 2 and build a clean upload file. Here's the process using ShopMy as an example. The same steps work for any platform (LTK, Amazon Associates, or any brand affiliate dashboard).

Step 1: Export Your Links from ShopMy

1. Log in to your ShopMy account.
2. Go to My Links or Analytics.
3. Click Export to download your links as a CSV file.

Step 2: Find the Right Columns in Your Export

A ShopMy export has 12 columns. You only need 2 of them:

• Title → becomes your Product Description (Column B)
• Short URL → becomes your Affiliate Link (Column C) — this is your ShopMy tracking link

Step 3: Build Your Upload File

Create a new spreadsheet (separate from the ShopMy export) with all 4 columns — Lightwell reads them by position, so every column must be present even if it's blank:

1. Add a header row: Brand Name, Product Description, Affiliate Link, Promo Code
2. Fill each row by mapping:
   • Column A — Brand Name: leave blank (ShopMy doesn't export a separate brand column)
   • Column B — Product Description: paste from Title
   • Column C — Affiliate Link: paste from Short URL
   • Column D — Promo Code: leave blank
3. Save as CSV (.csv) — in Excel, use File → Save As → CSV (Comma delimited)

Your finished file should look like this:

Column Mapping for Other Platforms

The same 3-step process works for any affiliate platform. Here's a quick reference for what each platform calls these columns:

Uploading Your File

During Initial Setup (Step 3)

1. Complete Step 1 (Creator Info) and Step 2 (Bot Appearance).
2. On Step 3, drag your CSV into the upload area or click Choose File.
3. Lightwell validates the file instantly and shows how many links were found.
4. Click Complete Setup — your links are saved and your bot launches.

Don't have your links ready? Check "Skip affiliate links for now" and add them later from the dashboard.

After Setup — from the Affiliate Links Page

Go to Content → Affiliate Links in the navigation. Click Upload CSV and choose a mode:

• Replace current links: Deletes everything and starts fresh with your new file. Use this when you've updated your whole list.
• Add to current links: Appends the new links without touching existing ones. Duplicates are removed automatically.

Tier Limits

Need more? Upgrade your subscription →

Need Help?