.csv

Search services

Search tools and open pages quickly

Guia do produto · 7 min de leitura

Shopify order and product CSV: metafields, tags, and inventory rows

DTC brands review Shopify exports before ERP sync: line-level orders, multi-location inventory, and metafield columns.

Publicado em 19 de março de 2025 · Table

Shopify admin exports are the lingua franca between merchants, agencies, and back-office systems. Product CSVs list variants, options, pricing, and inventory by location. Order CSVs are line-level: one row per line item with duplicated order-level fields. Metafields appear as extra columns when exposed in the export profile.

Gotchas

  • Financial status and fulfillment status on each line should align with how your ERP books revenue.
  • Discounts and taxes may need allocation logic when rolled to order grain.
  • Inventory quantities are per location; summing without checking location columns double counts.
  • Tags and comma-heavy titles require proper CSV quoting from Shopify; broken quotes point to manual edits.

Table in the Shopify stack

Download the CSV, open it in Table, sort by SKU or order name, use search for a customer segment, and trim columns before you sync to NetSuite, Cin7, or a custom warehouse loader. Your data stays in the browser session on your device.

← Todos os artigos

Usado e confiado por equipas líderes

Logótipos num carrossel (cada um abre o site da marca num novo separador): Google, Apple, Meta, GitHub, Stripe, Shopify, Databricks, Snowflake, Notion, Vercel, Intel, NVIDIA, Netflix, Spotify, Airbnb, Yale, Harvard University, Massachusetts Institute of Technology, Stanford University, University of California, Berkeley, Princeton University, California Institute of Technology, Columbia University, University of Chicago, Cornell University, Duke University, Carnegie Mellon University, Georgia Institute of Technology, Johns Hopkins University, Northwestern University, University of Toronto, McGill University, University of Oxford, University of Cambridge, Imperial College London, University College London, ETH Zurich, EPFL, Technical University of Munich, Sorbonne University, KU Leuven, National University of Singapore, Nanyang Technological University, Tsinghua University, Peking University, The University of Tokyo, KAIST, Seoul National University, University of Melbourne, Australian National University, University of Sydney, The University of Hong Kong.