How to Use Canva Bulk Create With Your Big Cartel Product Images
Draft — Post #23 · Target keyword: canva bulk create big cartel · Meta: Big Cartel stores hold product image URLs, but Canva Bulk Create ignores them. Here's the full workflow to turn your Big Cartel
Draft — Post #23 · Target keyword: canva bulk create big cartel · Meta: Big Cartel stores hold product image URLs, but Canva Bulk Create ignores them. Here's the full workflow to turn your Big Cartel catalog into batch graphics.
You run a Big Cartel store because it stays out of your way. You sell prints, vinyl, tees, enamel pins, or whatever your craft is, and you do not want a bloated platform with a hundred settings. Big Cartel fits makers who want to ship product, not manage software.
The trade-off shows up the moment you need to market the shop. You have 40 products, each with a photo, a title, and a price. You want a clean batch of social posts, a lookbook, and a few "back in stock" graphics. The right tool for that is Canva Bulk Create. So you pull your product data out of Big Cartel, drop the image URLs into a spreadsheet, upload it to Canva, and get back 40 designs with empty image slots.
This post covers the full Canva Bulk Create Big Cartel workflow, the one step Canva cannot do on its own, and a repeatable rhythm for a working maker who restocks and drops new products on a regular schedule.
Why Canva Bulk Create Stalls for Big Cartel Sellers
Your Big Cartel product data is mostly URLs. The product photo lives at an address like https://images.bigcartel.com/... or on your own CDN. When you export or pull that data, the image is a link, not a file.
Canva Bulk Create handles the text columns without complaint. Product name, price, drop date, edition size, material — drop those into your spreadsheet and Canva merges them into your template cleanly.
Image URLs are where it breaks. Canva Bulk Create only reads images that are physically embedded inside the XLSX file as binary data, in a format called DrawingML. A URL is just a string of text to Canva. It either prints that string literally inside your design or leaves the image frame blank. We covered the technical reason in full in Why Canva Bulk Create Ignores Image URLs.
For a Big Cartel seller this is the whole ballgame. Your products are visual. A batch of product posts with the prices merged but the photos missing is useless. The images have to be embedded inside the XLSX before Canva ever sees the file.
The Manual Workaround Most Makers Try First
The first instinct is to do it by hand in Excel. Open the spreadsheet, click an image cell, use Insert > Picture > Place in Cell, point to the downloaded photo, repeat for every product. This works if you have already downloaded every product photo to your laptop, sized it, named it to match the row, and put it in the right order.
In practice you are jumping between your Big Cartel admin, a folder of downloads, and a half-named pile of JPGs. By product 15 you have lost track of which photo goes with which row. For a 40-product shop you have spent an afternoon and made three mistakes.
The other common attempt is the =IMAGE() formula in Google Sheets. It looks like it embeds the photo because the image appears in the cell. It does not. =IMAGE() is a live cell reference, not embedded image data, so Canva reads nothing when it parses the file. We broke this down in Why =IMAGE() Doesn't Work for Canva Bulk Create. Short version: skip it.
What You Need Before You Start
Two things.
A Canva template per graphic type. Most maker shops cycle through a handful of recurring designs: a product post with photo, name, and price; a "new drop" announcement; a "back in stock" graphic; a lookbook tile. Each template needs Bulk Create placeholders for the text fields like {{product_name}} and {{price}}, plus an image element for the product photo.
One source-of-truth spreadsheet. One row per product, one column per data field, and a single column holding the direct image URL for each product photo. The same clean-sheet rules apply that we use for Etsy sellers and Shopify stores: one row per output, one column per field, image URLs in their own column.
Step 1: Get Your Big Cartel Product Data Out
Big Cartel does not center its product workflow on a one-click CSV the way a larger platform does, so you have two routes.
Admin export. Big Cartel's admin includes export tools. Depending on your plan and current admin layout, a product export may include titles, descriptions, prices, and image URLs. If your export already has a usable image URL column, you are set. (Flag for review: Big Cartel's exact export fields vary by plan and have changed over time, so confirm what your own export actually contains before relying on it.)
The products.json route. This is the reliable way to capture image URLs. Open https://yourstorename.bigcartel.com/products.json in a browser. Big Cartel returns a JSON feed of your products, including the photo URLs. Save that file, then convert it to CSV with a free online JSON-to-CSV converter or a spreadsheet tool, and keep the columns you care about: product name, price, status, and the image URL.
Either way, the goal is one spreadsheet with a clean column of direct image URLs, one per product.
Step 2: Build the Product Spreadsheet
A typical Big Cartel maker's bulk sheet looks like this.
| product_name | price | status | material | image_url |
| Midnight Bloom Print | $28 | In stock | Giclée A3 | https://images.bigcartel.com/.../bloom.jpg |
| Static Hum Vinyl | $35 | Back soon | 180g LP | https://images.bigcartel.com/.../static.jpg |
| Good Grief Enamel Pin | $12 | In stock | Hard enamel | https://images.bigcartel.com/.../grief.jpg |
Save it as CSV or XLSX. Your column names do not have to match Canva exactly, since you map them in the Bulk Create panel, but matching names lets Canva auto-connect in one click.
Step 3: Convert the Spreadsheet With Postprep
This is the step Canva refuses to do. Go to postprep.app, upload your CSV, and pick the column that holds the image URLs. Postprep fetches each URL, downloads the photo, and embeds it inside the XLSX as DrawingML, the binary format Canva actually reads. Every other column passes through untouched.
A 40-product sheet takes under a minute. The free tier covers 100 rows with no account required, which is more than enough for most Big Cartel shops in a single pass.
Step 4: Bulk Generate in Canva
Open your product post template in Canva. Make sure you are on a plan that supports Bulk Create. (Flag for review: Bulk Create is part of Canva's paid tiers and is run from the desktop app; confirm current plan eligibility on Canva's site, since their plan names and limits change.)
In the left panel click Apps, then Bulk Create. Click Upload data and select your converted XLSX. Drag each column onto its matching placeholder, or use Auto-connect if your column names already line up.
Click Generate designs. Canva produces one finished design per product, photo and price already merged. If you run three template types off the same sheet, a product post, a back-in-stock graphic, and a lookbook tile, take the same XLSX into each template and run Bulk Create three times. One dataset, three sets of branded assets. Download the batch as a ZIP and you have a full set of product graphics ready to post.
A Realistic Big Cartel Workflow
Here is the rhythm for a maker who restocks and drops new work on a schedule.
New drop day. Add the new products to your master sheet with their image URLs. Run the sheet through Postprep. Generate "new drop" announcements and individual product posts in Canva. Schedule them across your launch week.
Restock. When sold-out items come back, flip the status column to "In stock" and re-run the same sheet through Postprep. Generate "back in stock" graphics for just those rows. Two minutes of work.
Seasonal push. For a holiday or sale, reuse the same master sheet, swap to your sale template in Canva, and bulk generate the whole catalog as sale graphics in one job.
For a print-on-demand or merch-heavy maker, the same approach extends to mockups; we covered that angle for print-on-demand sellers too. The whole cycle is about 15 minutes of spreadsheet time per drop, no matter whether you sell 10 products or 100. By hand it is an afternoon every single time.
Frequently Asked Questions
Do I need a paid Big Cartel plan to export my products?
The products.json route works regardless of plan, since it just reads your public product feed in a browser. Admin export depth can vary by plan, so check your own export before counting on a specific field.
My Big Cartel photos are not square. Will they still work in Canva?
Yes. Postprep embeds whatever the URL returns at its original resolution. Inside your Canva template, set the image frame to the crop or fit you want, and every product photo drops into that frame the same way.
Some products have multiple photos. Which one gets used?
Bulk Create pulls one image per image column. Put the URL of your primary product shot in the image_url column. If you want a second angle, add a second image column like image_url_2 and a second image frame in your template.
What if a product has no photo yet?
Leave the image URL cell blank for that row. Postprep skips the embed for empty cells, and Canva leaves the placeholder visible so you can spot which products still need a photo. Re-run once you add it.
Can I use this for a printed lookbook or catalog, not just social posts?
Yes. Canva exports the generated designs to PDF for print or PNG for digital. Because the photos are embedded at full resolution, they hold up at print sizes as long as your Big Cartel source images are high enough quality.
Do I have to redo everything when I add new products?
No. Keep one master sheet and append new rows as you add products. Re-running Postprep on the updated sheet only takes a minute, and you bulk generate just the new designs in Canva.
The Short Version
Big Cartel keeps your store simple, which is the point. But your product data leaves as image URLs, and Canva Bulk Create cannot read URLs. It only reads images embedded inside the XLSX as DrawingML. Postprep is the missing step that does the embedding.
Pull your products via admin export or products.json. Build one master sheet with an image URL column. Convert with Postprep. Bulk generate in Canva. Every product ships its own graphic without another afternoon of dragging photos into cells.
Try it free at postprep.app — 100 rows, no account required.