Can AI help when Shopify and Etsy stock stops matching?

The problem, briefly

When Shopify and Etsy stop agreeing on stock, you oversell, issue refunds and stop trusting your numbers. The usual causes are variants that do not map cleanly between the two platforms, listings with no matching SKU, stock tracking switched off on one side, and sync delays. I cover those causes and fixes in my guide to Shopify Etsy sync not working. This page is about the part AI can help with.

The key fact: sync tools match items across platforms by SKU. Craftybase, an inventory app for makers, says it plainly in its setup guide: if a Shopify listing has the SKU CAND-LAV-8 and the Etsy listing for the same candle has no SKU or a different one, the two listings are invisible to each other and stock updates never flow. Etsy does not require a SKU on a listing, so many sellers have never set one.

That is a data-checking problem, and checking lists for mismatches is something AI does well as a first pass.

Where AI genuinely helps

• Comparing two exports. Export your products from Shopify and your listings from Etsy. Paste both into Claude and ask which items have no SKU, which SKUs appear on one side only, and which differ by a space or a capital letter. Craftybase notes that "8oz", "8 oz" and "8OZ" look like three different things to a matching system.
• Proposing one SKU pattern. If your codes are a mess, ask Claude to propose a single pattern such as product, then option one, then option two, and apply it to your list. You review it, then update the listings.
• Checking variant structure. Flag products where Shopify has three options and Etsy has two, or where the option order differs. Mismatched structure is a common cause of stock landing in the wrong slot.
• Finding stock-setting conflicts. Craftybase describes two: Shopify set to keep selling when out of stock while Etsy has a hard quantity cap, and Etsy auto-renewing a listing after the last unit sells. Ask Claude to list every product where those settings could clash, using the columns in your export.
• Making a test-order checklist. After cleaning up, have Claude write a short list of test orders to place on each side, with the stock number you expect afterward.

Each task is narrow with a checkable answer. It does not need special software.

Is there a real example of a shop doing this?

I have not found a published case study of a seller using AI to fix Shopify and Etsy stock mismatches. Most of what is written about this problem comes from inventory app makers and describes manual cleanup of SKUs and settings. I would rather say that than stretch an unrelated example to fit. The method above is sound because it is plain list comparison, but test it on a handful of products before you trust it with the whole catalog.

How to do this yourself with Claude

Claude is an AI assistant from Anthropic that you can use in a browser. Here is a first run.

1. Export both lists. Use the product export in Shopify and the listings or inventory download in Etsy Shop Manager (check each platform's help pages for the current steps). Keep title, SKU, variant options and quantity.
2. Trim the data. Remove customer data (there should be none), images and long descriptions. Smaller pastes give more accurate answers. For a big catalog, work in batches of about 50 products.
3. Paste and ask. A prompt that works: "Below are two lists of the same products, one from Shopify and one from Etsy. Match them by title. Then list: (1) products where either side has no SKU, (2) products where the SKUs differ, even by case or spaces, (3) products where the variant options differ in name or order. Output a table with the product title, the problem, and the fix you suggest. Do not guess matches you are unsure about; list them separately."
4. Fix on the platforms. Change SKUs and variant names yourself in Shopify and Etsy, character for character. Etsy suggests keeping SKUs short and avoiding symbols such as commas or slashes, and it lets you set a SKU on up to 400 option combinations per listing. Claude only points at the problems.
5. Check Shopify tracking. Make sure inventory tracking is on for each variant. If it is off, a sync tool has no number to read.
6. Test. Place a test order on each side and confirm stock drops in both places.

Run the comparison again every time you add products. New listings are where drift starts. If you are choosing how to manage this long term, my inventory management system guide covers when a spreadsheet stops being enough, and AI for ecommerce stores covers other jobs AI does well in a shop.

Where a person still has to check

• Matches. Two products with similar titles may be different items. You decide.
• Real stock. AI sees the numbers in the file, not the shelf. A count on the shelf still beats any export.
• Sync tool behavior. How your app handles delays or limits is in its own settings and support pages. Ask the app maker if stock still drifts after the data is clean.
• Pre-orders. If you take them on purpose, tell Claude, or it may flag them as errors.

If the data is clean and stock still drifts, the setup may have outgrown a sync app. That is the point where a small system that holds one stock number and pushes it to both channels is worth considering. My business process automation guide explains the idea.

How I'd approach this

I would clean the data first, because a sync only repeats whatever your numbers say. Spend an afternoon on SKUs and variant names with Claude's list beside you, then watch for a week. If you want help choosing the first thing to try, the AI Strategy Sprint is a paid 3-day first step where we find where AI could help your business, and you get the exact steps written down. It starts with a free 15-minute AI brainstorm call.

If stock still drifts after cleanup, the next step is a small custom tool that keeps one master stock count and updates Shopify and Etsy from it, with a weekly mismatch report sent to you. I would tell you first if a simpler fix does the job.