Turn a supplier's price list into a Shopify import file

A file in Shopify's product import format, priced with your markup and written up, and a list of the rows that need you.

  • No connector needed

I've attached my supplier's price list. Turn it into a CSV file I can import into Shopify, priced at cost plus 40% with prices ending in .99, and with a title and a short description for each product. Tell me which rows you had to skip.

Needs

Your supplier's price list (Excel or CSV)

Before sending
Attach the file. The result goes into Shopify through Products, then Import.

What you get back

Example answerSample data, to show what comes back

I've attached my supplier's price list. Turn it into a CSV file I can import into Shopify, priced at cost plus 40% with prices ending in .99, and with a title and a short description for each product. Tell me which rows you had to skip. price_list.xlsx

Your Shopify import file: 7 products ready

Prices are cost plus 40%, rounded up to end in .99. One row had no cost, so it is left out.

Products
7
Skipped
1
Markup
40%
SKUTitleCostPrice
KT-1041Bamboo Cutting Board, 18 x 12 in$9.40$13.99
KT-1052Measuring Cups and Spoons, 8 Pieces$6.20$8.99
KT-1063Silicone Utensil Set, 12 Pieces$11.75$16.99

Download products_import.csv and upload it in Shopify under Products, then Import.

What the assistant does

  1. 1

    Reads the file: names, SKUs, costs and stock.

  2. 2

    Prices each product at cost plus your markup, ending as you asked.

  3. 3

    Writes a title and a short description for each.

  4. 4

    Builds the file in Shopify's import format, and lists the rows it skipped.

With SellerClaw connected

Skip the copy and paste

Claude adds the products to your Shopify store itself, with photos, prices and stock, after you check the preview: there is no import file to build.

Listings
  • Makes changes

Publish your catalog file to Shopify

Using SellerClaw, here's my product catalog in Excel. Publish these products to my Shopify store with their photos, descriptions, prices and stock, and show me a preview first.

A Shopify store and your catalog as an Excel or CSV file

More prompts

All prompts
Listings
  • No connector needed

Write a listing from a product photo

Here's a photo of a product I want to sell on eBay. Tell me what it is, then write the title, the item specifics and a description. Ask me about anything the photo can't show, like size or flaws.

A photo of the product

First five minutes
  • No connector needed

Turn an orders export into a sales review

I've attached my Shopify orders export for the last 90 days. Which products bring in most of the money, which are slowing down, and what should I stop restocking? Give me a short table and three things to do this month.

An orders export from your store (CSV)

Listings
  • No connector needed

Find what stops buyers on your listing

Read my Amazon listing below as a shopper comparing it with two others. What would make you buy somewhere else? Then rewrite the title and the first lines a buyer reads to fix it.

Your listing, pasted in or as a screenshot