Exporting to CSV or Excel files

It is possible to export the values for your defined custom fields. Values are exported in either CSV or Excel (XLSX) format ready to open in your favorite text editor or spreadsheet program.

As an example, exporting two products "pro-1" and "pro-2" to a CSV file will produce a file with this content:

pro-1;This is product 1;value-1;value-2;value-3
pro-2;This is product 2;value-1;value-2;value-3

The first line (or row in case of an Excel file) is a required  header line with two fixed columns "_id" and "_info" followed by one or more custom field names (with any user-defined namespace).

The actual value for an _id column on subsequent rows depends on the exported object type -  handles are used for products, pages, blogs, articles and collections while skus are used for variants, email addresses for customers and order numbers for orders.

The _info column is a bit of 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.

Third column and onward contain the custom field value associated with the object instance.

For CSV files, all values are separated with semicolons ( ; ). If a value itself contains semicolons ( ; ) or double quotes ( " ), the value will be surrounded with double quotes and any contained double quoted will be "escaped" as two double quotes, e.g. the value Hi "there" becomes "Hi ""there"""

For Excel files, all values will be in separate columns as you would expect.

Accentuate also allows for export of a subset of either products, customer or order custom field values via 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 fields. Then select the "Actions" menu and click "Export Custom Fields". This export will always be in XLSX format. Note that this 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 will change to a spinning "gear" (or "cog") icon. You are encouraged not to start any additional exports or imports until the current job has finished.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us