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:
Edit or test your own Amazon Seller Central fields (live converter)
02 / THE 4 SELLER CENTRAL TRAPSWhy Amazon Inventory Reports break when imported directly into Shopify.
- Tab-delimited
.txtformat & Excel UPC corruption: Amazon exportsAll Listings Reportsas tab-separated.txtfiles. Simply renaming.txtto.csvfails Shopify’s header check (see header rules), while opening directly in Excel destroys leading-zero UPCs! - Blank
quantityonAMAZON_NAFBA SKUs: Seller Central’s standard All Listings Report leavesquantitycompletely empty for FBA items (fulfillable stock lives in the separate FBA Amazon Fulfilled Inventory Report). Mapping blank cells blindly sets stock to0(check required numeric fields). product-id-typemixes ASINs with GTIN barcodes: Amazon uses1 = ASIN,3 = UPC, and4 = EANinside the sameproduct-idcolumn. PuttingB0...ASINs into Shopify’sVariant Barcodetriggers Google Shopping GTIN disapproval—route ASINs to a product metafield or tag instead!- Non-buyable
parentvariation 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 useparent-skuas the shared ShopifyHandleacross child rows!
03 / HEADER DICTIONARYAmazon Seller Central report columns to canonical Shopify CSV headers.
| Amazon Report column | Shopify CSV header | Required 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-name | Title | Emit clean parent title on Row 1 of each handle; leave blank on child rows 2..N. |
item-description + bullet points | Body (HTML) | Wrap plain-text description and bullet_point1..5 in clean <p> and <ul> HTML. |
seller-sku | Variant SKU | Preserve exact merchant SKU string for 3PL / MCF / FBM sync. |
product-id + product-id-type | Variant Barcode / Tags | Map type 3 (UPC) & type 4 (EAN) to Variant Barcode as text; move type 1 (ASIN) to tag/metafield. |
price | Variant Price | Format numeric decimal (e.g., 28.00); never import priceless parent shell rows. |
quantity + fulfillment-channel | Variant Inventory Qty | Use integer stock for DEFAULT (FBM); merge FBA Fulfillable Report before tracking AMAZON_NA stock. |
image-url (+ other_image_url1..8) | Image Src | Emit 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.
- 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.
- Import
.txtvia Data → From Text/CSV (All Text Columns): Never double-click the.txtfile—import with UTF-8 encoding and markproduct-idandseller-skuas Text before exporting as comma-separated UTF-8.csv. - 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.
- Verify Barcodes & FBA/MCF Inventory Before Publishing: Import a 5-product batch as
draftin 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?
IMAGE1–IMAGE10 columns and split comma-packed Etsy variations.
Gallery Rows
Multi-Image CSV Row Expander
Turn Amazon other_image_url1..8 URLs into clean continuation rows.
50k–500k+ SKUs · $9
12-Platform CSV Kit & Offline CLI
Audit massive Amazon/pos CSVs offline + 12 verified UTF-8-BOM golden templates.
SKU Diff Checker
Compare Two CSV Files Online
Match Old vs. New Seller Central or Shopify exports by SKU and audit changes.
Storefront CSV
WooCommerce → Shopify Converter
Invert Regular vs. Sale price columns and inspect parent/variation types.
Ready to preflight your Amazon-to-Shopify CSV?
Map Seller Central headers, check prices, and audit barcodes 100% locally in your browser.
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 ↗