Automotive Fitment CSV Cleaner for Shopify

Shopify Year Make Model (YMM) CSV cleaner and automotive fitment data mapper. Turn messy supplier CSV/JSON into Shopify draft-product imports, structured vehicle fitment records, and diagnostic reports. No scraping, proxies, supplier-account access, or store credentials required.

Fits and supersessions are supplier-supplied assertions, NOT validated against OEM reference catalogs. Vehicle fitment CSV is vendor-neutral and is not advertised as directly importable into Globo, Searchanise, EasySearch, or other YMM plugins. Manufacturer and plugin-specific templates may require a separate mapping step.

Try a free demo in 30 seconds

1. Open the Actor's Input tab.
2. Enable Run FREE 50-SKU synthetic demo and run.
3. Open Output → Download all converted files (ZIP).
4. Inspect 5 exports: shopify_products.csv, vehicle_fitments.csv, supersession_relations.csv, issues.csv, report.json.
5. For your own authorized supplier file, disable Demo, upload a CSV/JSON, choose its shop currency, and run.

The 50-row demo is fabricated and deliberately includes dirty records. Do not publish demo part numbers or fitment assertions to a shop.

What it cleans

• Supplier column-name changes: handles aliases such as Item_Number, Part#, Manufacturer, Unit_Price, and YMM_Compatibility. Specify a field_mapping JSON object when aliases don't match.
• Vehicle ranges: parses MY18-22, 2018-2022, 15-20, and semicolon-separated multiple fitments (Make|Model|Years|Engine).
• SKU/price quality: flags duplicates, unrecognized dates, empty SKU or title, cross-currency prices, supersession cycles and replacement targets missing from the batch.
• Safety: exports Shopify products as draft/unpublished, keeps images off by default, never performs currency conversion or contacts manufacturer portals.

Five outputs

File	What it contains
shopify_products.csv	Shopify product import with vendor, SKU, price, draft status
vehicle_fitments.csv	SKU ↔ Make/Model/Year-range/Engine associations marked UNVERIFIED
supersession_relations.csv	Original part → supplier-stated replacement relations
issues.csv	Invalid years, empty values, duplicate SKU, currency mismatches and other warnings
report.json	Mapping decisions, row counts and a quality summary

The output ZIP is also available as a key-value store record named RESULTS_ZIP, with direct links in the Actor Output tab.

Input examples

CSV (for demonstration only):

Item_Number,Manufacturer,Item_Description,Unit_Price,Money_Ccy,YMM_Compatibility
TEST-001,Land Rover,Demo Brake Pads,99.00,USD,Land Rover|Demo Model|MY18-22|V6

Nested JSON:

[
  {
    "sku": "TEST-001",
    "brand": "Land Rover",
    "part_name": "Demo Brake Pads",
    "price": 99,
    "currency": "USD",
    "fitment": [{"make": "Land Rover", "model": "Demo Model", "years": "MY18-22"}]
  }
]

Optional source column override: {"sku":"Item_Number","fitment":"YMM_Compatibility"}.

Pricing transparency

This Actor uses pay per event pricing: the catalog-batch-100 custom event costs $0.25 per 100 source rows, rounded up. For example, 1–100 input rows = $0.25; 101–200 rows = $0.50; 1,000 rows = $2.50. These are custom processing charges; always check the live price breakdown before running. The entirely synthetic 50-row demo emits no custom processing event. Invalid or duplicate source rows still count toward batch size.

Apify may also charge for platform usage or other automatically enabled events depending on the actual listing setup. Always check the price breakdown and max charge on the Actor page before running. Failed/missing rows still count toward input-size batches, but the quality report explains exclusions.

Limits and important compatibility notes

• Max 3 MB uploaded file; 10,000 source rows; 50 fitments per SKU. UTF-8 CSV / JSON only.
• No ACES 5.0/PIES 8.0 XML parser, no licensed VCdb/TecDoc part fitment database, no VIN validation.
• Shopify product-level metafields may be imported through supported CSV headers; variant-level metafields cannot be imported using the product CSV.
• Import formats vary between YMM apps and often require a Shopify Product ID allocated after product import; SKU is not a Shopify Product ID. Vendor-neutral vehicle_fitments.csv is provided for a later approved adapter, not as a finished Globo/Shopify Searchanise import.
• Input files and results live in your Apify run's storage subject to its retention/privacy and permissions. This Actor does not send input to third-party services.
• The tool is a pre-import cleaning and mapping product, not an OEM compatibility certification or a guarantee of successful Shopify/plugin import. Test on a draft/sandbox store first.

Who can use it

Shopify auto-parts merchants, catalog import consultants, B2B suppliers and operations teams preparing their first Shopify product import. No proxy or anti-bot configuration needed.

Documentation:

• Shopify official product CSV fields
• Auto Care Data Standards
• Apify pricing and costs

Before choosing a YMM app

Use this tool to clean an auto-parts catalog before a Shopify import. The product CSV and the vehicle fitment CSV are separate exports. EasySearch, Convermax, and other Year Make Model search apps have their own import requirements; a separate mapping step may be needed. This Actor does not provide a ready-made importer for those apps.

For eBay Motors, SEMA, or ACES/PIES source feeds, first export the relevant fields to supported CSV/JSON. This Actor does not parse ACES/PIES XML or validate fitment against a licensed vehicle database.

Need a larger migration?

Have 50,000+ SKUs, custom supplier feeds, or complex ACES/PIES files? Contact heihaha001@gmail.com for custom data cleaning, feed normalization, or a full Shopify catalog migration. This Actor is a pre-import cleaner; it does not certify OEM compatibility or replace licensed ACES/PIES data services.