Our first app, Migrato, is live on the Shopify App Store - free plan, no credit card. Take a look
Home / Documentation / Template Documentation
Companies Import/Export

Template Documentation

Every column in the Companies template, what it holds and the values it accepts.
6 min read Updated 14 October 2026 Applies to Migrato on all plans

Company Template Documentation

Migrato uses a structured template for importing and exporting Shopify Company data.

The template defines the columns that can be used to transfer Company information between Migrato and Shopify.

You can use the template to:

  • Prepare Company data for import.
  • Understand exported Company data.
  • Modify exported Company data before re-importing.
  • Migrate Company information.
  • Manage Company locations and linked customers.
  • Maintain a consistent Company data structure.
★
Before preparing your file

Download the available Company Demo CSV/XLSX file or export a sample Company file from Migrato to understand the current template structure.

Company Template Structure

Company data is organized into several groups in the Migrato template.

Company Template Groups 1
Company Template Groups 1
Company Template Groups 2
Company Template Groups 2
Company Template Groups 3
Company Template Groups 3

The following sections describe the supported Company template fields.

1. Basic Columns

The Basic Columns group contains the primary information used to identify and describe a Company.

Basic Columns
Basic Columns
Column Description Allowed Values / Examples
ID Unique Shopify identifier of the Company. Number / Shopify Company ID
Name Name of the Company. Text — Example Company
External ID External identifier associated with the Company. Text or identifier
Notes Additional notes associated with the Company. Text
Customer Since Date associated with the Company's customer relationship. Date
Lifetime Duration Lifetime duration associated with the Company. Numeric value / duration
Created At Date and time when the Company was created. Date and time
Updated At Date and time when the Company was last updated. Date and time
Main Contact: Customer ID Shopify Customer ID of the Company's main contact. Number / Customer ID
Main Contact: Customer Email Email address of the Company's main contact. Email address
Contact Count Number of contacts associated with the Company. Number
Location Count Number of locations associated with the Company. Number
Order Count Number of orders associated with the Company. Number
Total Spent Total amount spent by the Company. Numeric amount
Row # Row reference used in the template structure. Number
Top Row Indicates the top/header row structure used by the template. Template value

2. First and Last Order

The First and Last Order group contains information about the Company's first and most recent order.

First and Last Order
First and Last Order
Column Description Allowed Values / Examples
First Order: ID Shopify ID of the Company's first order. Number / Order ID
First Order: Name Name or order number of the Company's first order. Text — #1001
First Order: Processed At Date and time when the first order was processed. Date and time
First Order: Price Total Total price of the Company's first order. Numeric amount
Last Order: ID Shopify ID of the Company's most recent order. Number / Order ID
Last Order: Name Name or order number of the Company's most recent order. Text — #1050
Last Order: Processed At Date and time when the most recent order was processed. Date and time
Last Order: Price Total Total price of the Company's most recent order. Numeric amount
i
Note

First and Last Order fields are primarily useful for exported Company data and may not be used as primary Company creation fields during import.

3. Locations

The Locations group contains information about locations associated with a Company.

A Company can have multiple locations. Location information may include contact details, addresses, tax settings, checkout settings, and other supported location information.

Locations
Locations
Column Description Allowed Values / Examples
Location: ID Unique Shopify identifier of the Company location. Number / Location ID
Location: Name Name of the Company location. Text — New York Office
Location: External ID External identifier assigned to the location. Text or identifier
Location: Phone Phone number associated with the location. Phone number
Location: Notes Notes associated with the location. Text
Location: Created At Date and time when the location was created. Date and time
Location: Updated At Date and time when the location was last updated. Date and time
Location: Locale Locale associated with the location. Locale code
Location: Tax ID Tax identifier associated with the location. Text / tax ID
Location: Tax Setting Tax setting associated with the location. Supported Shopify value
Location: Tax Exemptions Tax exemptions associated with the location. Supported Shopify value
Location: Allow Shipping To Any Address Indicates whether shipping to any address is allowed. Yes / No
Location: Checkout To Draft Indicates whether checkout is configured to create a draft order. Yes / No
Location: Checkout Payment Terms Payment terms configured for checkout. Supported value
Location: Checkout Pay Now Only Indicates whether checkout is limited to pay-now transactions. Yes / No
Location: Shipping First Name First name used for the shipping address. Text
Location: Shipping Last Name Last name used for the shipping address. Text
Location: Shipping Recipient Shipping recipient name. Text
Location: Shipping Phone Phone number for the shipping address. Phone number
Location: Shipping Address 1 Primary shipping address line. Text
Location: Shipping Address 2 Additional shipping address information. Text
Location: Shipping Zip Shipping postal or ZIP code. Text
Location: Shipping City Shipping city. Text
Location: Shipping Province Code Shipping province or state code. Code
Location: Shipping Country Code Shipping country code. ISO country code
Location: Billing First Name First name used for the billing address. Text
Location: Billing Last Name Last name used for the billing address. Text
Location: Billing Recipient Billing recipient name. Text
Location: Billing Phone Phone number for the billing address. Phone number
Location: Billing Address 1 Primary billing address line. Text
Location: Billing Address 2 Additional billing address information. Text
Location: Billing Zip Billing postal or ZIP code. Text
Location: Billing City Billing city. Text
Location: Billing Province Code Billing province or state code. Code
Location: Billing Country Code Billing country code. ISO country code

4. Location Catalogs

The Location Catalogs group contains catalog information associated with Company locations.

Location Catalogs
Location Catalogs
Column Description Allowed Values / Examples
Location: Catalogs Catalogs associated with the Company location. Supported catalog data

5. Linked Customers

The Linked Customers group contains customers associated with the Company and their Company location role.

Linked Customers
Linked Customers
Column Description Allowed Values / Examples
Customer: ID Shopify ID of the customer linked to the Company. Number / Customer ID
Customer: Email Email address of the linked customer. Email address
Customer: First Name First name of the linked customer. Text
Customer: Last Name Last name of the linked customer. Text
Customer: Location Role Role assigned to the customer for the Company location. Supported Company location role

6. Metafields

The Metafields group contains supported metafield information associated with the Company.

Metafields
Metafields
Column Description Allowed Values / Examples
Metafield Additional Company information stored using Shopify metafields. Metafield data
!
Important

The metafield structure should match the metafield definitions configured for the Company in your Shopify store.

7. Location Metafields

The Location Metafields group contains supported metafield information associated with Company locations.

Location Metafields
Location Metafields
Column Description Allowed Values / Examples
Location Metafield Additional information stored using metafields associated with a Company location. Location metafield data
!
Important

Make sure the location metafield structure matches the corresponding metafield definitions configured in Shopify.

Preparing a Company Import File

When preparing a Company import file:

  1. Download the Company Demo CSV/XLSX file, if available.
  2. Review the Company Template Documentation.
  3. Keep the required column names unchanged.
  4. Enter Company information according to the expected format.
  5. Add location, customer, catalog, and metafield information where required.
  6. Save the file as CSV or XLSX.
  7. Upload the file to Migrato or provide its publicly accessible URL.
  8. Review the selected import operation.
  9. Review the import data and available options.
  10. Start the import.
★
Tip

For the safest workflow, use a Migrato-generated Company export as a starting point when preparing data for a subsequent import.

Ready to run this on your own store?

Migrato's free plan handles 25 items per job - enough to follow any page in these docs end to end before you pay anything.

Free plan forever No credit card 2-minute setup Uninstall anytime