Accentuate Custom Fields
  • Welcome!
  • Introduction
    • Getting started with ACF
    • Field scopes
    • How to show fields in your storefront
  • Dashboard
    • Reference Manager
      • Creating a new reference within Reference Manager
    • Filter & Group
      • Filter editor
      • Filter usage
    • Activity log
    • App settings
  • Field Definitions
    • Fields & Sections
    • Deciding on a field type
    • ACF Field types
      • Text
      • Markdown text
      • HTML
      • Checkbox
      • Selection
      • Tags
      • Number
      • Date
      • Color
      • Media v1 (legacy)
      • Media v2
      • Custom Object (JSON)
      • Multi-language Text
      • Reference fields
      • References to Global fields
    • Shopify Field types
      • Shopify » Single line text
      • Shopify » Multi-line text
      • Shopify » Boolean
      • Shopify » Color
      • Shopify » Custom objects (JSON)
      • Shopify » URL
      • Shopify » Date
      • Shopify » Date and Time
      • Shopify » Integer
      • Shopify » Decimal
      • Shopify » Weight
      • Shopify » Volume
      • Shopify » Dimensions
      • Shopify » Reference fields
    • Automatic tagging
    • Large sets
    • Field contexts
    • Field context filters
    • Copy and paste fields
    • Change field name and type
    • Import existing fields
    • Linking multiple stores
  • The Editor
    • Using the editor
    • Promote fields to sidebar
    • Layouts
    • Hide from search
    • Repeatable fields
    • Version control
    • Update value on order creation
  • Bulk Import & Export
    • Export custom field values
    • Import custom field values
    • Metaobject export / import
  • METAOBJECTS
    • What are Metaobjects?
    • Metaobject Definitions
    • Metaobject instances / values
    • Displaying Metaobjects on your storefront
    • Metaobject export / import
  • THEME EXTENSIONS
    • SEO keywords
    • Sticky promo bar
    • Products promotion
  • Liquid Guides
    • Learning Liquid
    • Resize & crop images
    • Check for empty values
    • Access field definitions
    • Order notifications
    • Allow customers to change their field values
  • OTHER
    • Webhooks
    • API
      • Access to custom fields
      • Endpoints
  • Help
    • FAQ
      • Why are one of my products no longer showing in my reference field?
      • I have multiple products/variants with the same name
      • How do I make changes to my field values in bulk?
      • I added a new field definition but it is not showing in my storefront
      • How do I copy my field setup to another store?
      • My fields are still showing after I have deleted their field definition
      • Why are none of my fields showing in the editor?
      • My newly created object in Shopify is not available in ACF
      • Reference lists are empty?
      • Why am I seeing a "value cannot exceed 100,000 characters" error when saving?
      • Why can't I name my field "first", "last" or "size"?
    • Need help?
  • Product
    • Changelog
    • Feedback & Suggestions
Powered by GitBook
On this page
  • What's in the file?
  • Exporting subsets of data
  1. Bulk Import & Export

Export custom field values

PreviousUpdate value on order creationNextImport custom field values

Last updated 10 months ago

Custom field values can be exported in Excel (XLSX) format ready to open in your favorite spreadsheet program. This is done by clicking the Export button above the selected scope's field definitions:

Once the export is complete, the file can then be modified and imported into the same store for doing bulk updates or imported into another store for migration data

An export of custom field values contains only values for the custom fields, not the field definitions themselves. These need to be set up beforehand in the store you are importing to, either by copying & pasting them or by linking your stores and performing a synchronization of the definitions

What's in the file?

The first row in the Excel file is a required header line with columns A and B "_id" and "_info" followed by one or more custom field names (including their namespaces). The actual values for an _id column on rows 2 and onward depend on the exported object type and the options chosen when setting up the export. These are the defaults:

  • Handles are used for products, collections, pages, blogs, articles

  • SKUs are used for variants

  • Email addresses for customers

  • Order numbers for orders.

The _info column contains information associated with the _id - like the product title or the customer's name. This is for information only and changing this value won't have any effect on any later import. The third column (C) and onward contain the custom field values associated with the object instance.

Exporting subsets of data

ACF also allows for the export of a subset of either products', customers' or orders' custom field values from within the Shopify admin. From the relevant object list (such as product list, customer list, etc.), perform a Search or Filter and then bulk select the objects for which you'd like to export the custom field values. Then select the "Actions" menu and click "Export Custom Fields". Export of subsets is currently limited by Shopify for selections of 50 objects or less

Exports run in the background. While an export job is active, the icon next to "Export values" will change to a spinning "gear" icon. Due to Shopify limits, you are encouraged not to start any additional exports until the current job has finished