Quick Rule Summary · Updated November 2026

Amazon Seller Central exports tab-delimited .txt files where FBA listings (AMAZON_NA) leave quantity blank, product-id mixes 10-character ASINs (type 1) with 12-digit UPCs (type 3), and Category Reports include priceless parent shell rows: convert tabs to UTF-8 CSV, strip parent shells while grouping children under parent-sku, and map status = Inactive to draft.

01 / INTERACTIVE AMAZON-TO-SHOPIFY CONVERTERConvert tab-delimited Seller Central rows, guard FBA blank stock & separate ASINs from UPCs.

Click any Amazon Seller Central report scenario below—or open the live field drawer to test your own listing fields—and download a clean UTF-8 Shopify CSV:

Source Lines Inside Amazon All Listings Report (.txt TSV)
Edit or test your own Amazon Seller Central fields (live converter)
Converted Shopify CSV Summary Exports 12 canonical Shopify columns · 0 validation warnings

02 / THE 4 SELLER CENTRAL TRAPSWhy Amazon Inventory Reports break when imported directly into Shopify.

  1. Tab-delimited .txt format & Excel UPC corruption: Amazon exports All Listings Reports as tab-separated .txt files. Simply renaming .txt to .csv fails Shopify’s header check (see header rules), while opening directly in Excel destroys leading-zero UPCs!
  2. Blank quantity on AMAZON_NA FBA SKUs: Seller Central’s standard All Listings Report leaves quantity completely empty for FBA items (fulfillable stock lives in the separate FBA Amazon Fulfilled Inventory Report). Mapping blank cells blindly sets stock to 0 (check required numeric fields).
  3. product-id-type mixes ASINs with GTIN barcodes: Amazon uses 1 = ASIN, 3 = UPC, and 4 = EAN inside the same product-id column. Putting B0... ASINs into Shopify’s Variant Barcode triggers Google Shopping GTIN disapproval—route ASINs to a product metafield or tag instead!
  4. Non-buyable parent variation shells in Category Reports: Amazon Category Listing Reports include a parent row with no price, no quantity, and no barcode. Strip the parent row and use parent-sku as the shared Shopify Handle across child rows!

03 / HEADER DICTIONARYAmazon Seller Central report columns to canonical Shopify CSV headers.

Mapping Amazon All Listings & Category Listing Report columns to canonical Shopify CSV fields
Amazon Report columnShopify CSV headerRequired transformation
parent-sku (fallback asin1 / item-name)URL handle (Handle)Slugify parent-sku so all child size/color SKUs share one Shopify product handle; omit parent shell row.
item-nameTitleEmit clean parent title on Row 1 of each handle; leave blank on child rows 2..N.
item-description + bullet pointsBody (HTML)Wrap plain-text description and bullet_point1..5 in clean <p> and <ul> HTML.
seller-skuVariant SKUPreserve exact merchant SKU string for 3PL / MCF / FBM sync.
product-id + product-id-typeVariant Barcode / TagsMap type 3 (UPC) & type 4 (EAN) to Variant Barcode as text; move type 1 (ASIN) to tag/metafield.
priceVariant PriceFormat numeric decimal (e.g., 28.00); never import priceless parent shell rows.
quantity + fulfillment-channelVariant Inventory QtyUse integer stock for DEFAULT (FBM); merge FBA Fulfillable Report before tracking AMAZON_NA stock.
image-url (+ other_image_url1..8)Image SrcEmit primary HTTPS URL on Row 1; expand extra images onto continuation rows (see image expander).
status (Active / Inactive)Status (active / draft)Map Inactive or Incomplete listings to Status = draft.

04 / SAFE MIGRATION STEPSMove your Amazon catalog to Shopify in 4 clean steps.

  1. Request Category Listing Report + All Listings Report: In Seller Central, request a Category Listings Report (which includes bullet points, parent-child links, and gallery images; ask Seller Support to enable it if hidden) alongside your FBA Inventory Report if using FBA.
  2. Import .txt via Data → From Text/CSV (All Text Columns): Never double-click the .txt file—import with UTF-8 encoding and mark product-id and seller-sku as Text before exporting as comma-separated UTF-8 .csv.
  3. Preflight Locally in Row & Record: Load your UTF-8 CSV into our browser-local preflight workspace to map columns, catch blank prices or duplicate handles, and export a verified Shopify CSV without uploading catalog data.
  4. Verify Barcodes & FBA/MCF Inventory Before Publishing: Import a 5-product batch as draft in Shopify Admin and verify GTIN barcodes and fulfillment location quantities before setting products live.

Common questions.

Why does Amazon Seller Central export a .txt file instead of a .csv file?

Amazon Inventory Reports use tab-separated values (.txt TSV) so product titles and descriptions containing commas do not break legacy spreadsheet parsers. Before importing into Shopify, convert the tab-delimited .txt file into a properly quoted UTF-8 comma-separated .csv file while keeping UPC/EAN columns formatted as plain text.

Why is the quantity column blank for my FBA products in Amazon’s All Listings Report?

Amazon only populates the quantity column in All Listings Reports for Merchant-Fulfilled (fulfillment-channel = DEFAULT) SKUs. For FBA SKUs (AMAZON_NA), export the FBA Amazon Fulfilled Inventory report and join fulfillable-quantity by seller-sku—or leave Shopify inventory untracked until your MCF/3PL app syncs stock.

Where do I get product bullet points and secondary images from Amazon Seller Central?

Standard All Listings Reports only include item-name, item-description, and one main image-url. To export bullet_point1–5, variation themes, and other_image_url1–8 in bulk, download a Category Listings Report (CLR) under Seller Central Reports → Inventory Reports.

Should I put my Amazon ASIN into Shopify’s Variant Barcode field?

No—Shopify’s Variant Barcode field is reserved for global GTINs (12-digit UPC, 13-digit EAN, or ISBN) synced to Google Shopping and POS scanners. Only map product-id to Variant Barcode when product-id-type equals 3 (UPC) or 4 (EAN), and store 10-character B0... ASINs in a custom metafield or tag.

05 / MARKETPLACE & STORE MIGRATION HUBMigrating from another marketplace or platform to Shopify?

Ready to preflight your Amazon-to-Shopify CSV?

Map Seller Central headers, check prices, and audit barcodes 100% locally in your browser.

Open CSV Preflight Workspace ↗

Verified November 2026 against Amazon Seller Central All Listings & Category Listing Report (.txt TSV) field definitions and Shopify’s Product CSV specification.

Shopify product CSV column referenceShopify store migration documentationRow & Record Chrome Extension ↗