CSV Import & Export (Compatibility Page)
Last Updated: June 30, 2026
For stores with large catalogs — anywhere from 50 to 50,000 SKUs — typing compatibility tags one product at a time in the admin isn't practical. The CSV workflow lets you export the current data, edit it in a spreadsheet you're already comfortable with (Excel, Google Sheets, Numbers), and re-import the updated file in a single click. The app matches each row by Shopify product ID, so reordering rows or sorting in your spreadsheet is safe. This is also the fastest way to bulk-correct compatibility data after running an initial AI fill.
🎬Watch: CSV import & export workflow
Open on YouTube →
Go to the Compatibility Section
Open PC Builder: MW from your Shopify admin. Click into your widget, then click “Edit Config” on any step to land on its Compatibility page.
The Compatibility page shows every product in that step's collection, with editable columns for each compatibility tag (cpu_brand, cpu_socket, cpu_generation, cpu_tdp_watt, and so on). Each step has its own Compatibility page — so if you have CPU, Motherboard, and RAM steps, you'll repeat this CSV workflow for each one.
Export Existing Data
In the top-right of the Compatibility page, click “Export CSV” . Your browser immediately downloads a .csv file containing every product on the current page with its tags.
Each row is one product; columns are the compatibility tags. The first columns (product ID, product name) are read-only matching keys — don't edit those. If your catalog spans multiple pages, click through each page and export them separately, then either merge them in your spreadsheet or import them one at a time.
Update the CSV File
Open the downloaded file in Google Sheets, Microsoft Excel, or any spreadsheet tool. Fill in or update the compatibility columns for each product.
Use realistic values — for example, cpu_socket = "AM5" for AMD Ryzen 7000-series CPUs, "LGA1700" for Intel 12/13/14th gen. cpu_tdp_watt should be a number (105, 125, 170). Leave blank for products where the tag doesn't apply. When saving, choose .csv (not .xlsx) format — Excel sometimes defaults to xlsx, which the importer won't accept.
Import the Updated CSV
Back on the Compatibility page in PC Builder: MW, click “Import CSV” in the top toolbar. Select your edited file from the file picker.
The import runs immediately. You'll see a confirmation showing how many products were updated and whether any rows failed (typically due to a missing product ID match). If rows fail, the most common cause is that you accidentally edited the product ID column — re-export, paste the original IDs back, and try again.
Data Gets Auto-Filled
All compatibility fields update with the values from your CSV. Refresh the page once to see the new data in the table.
From this point compatibility rules kick in automatically — a shopper who selects an "LGA1700" CPU will now only see motherboards tagged with the same socket in the next step, and incompatible boards are filtered out before they can even be selected. Test this on your storefront by opening the widget and trying a few combinations.
Best approach for catalogs over 50 products