Excel Import Export by Fuji

BRAND NEW APP!

Import and Export Your Shopify Store Data With Excel File

1. Import unlimited volumes of data as one file.


2. Duplicate your store for testing purposes.


3. Work in multiple markets by moving data between your stores.


4. Backup and save your store data to your own disk.


5. Restore accidentally deleted or damaged Shop data by just re-importing your saved Excel file.


6. Migrate to Shopify from another platform, bring all the data with you.

Sample

Download the
sample Excel Import file, and see what kind of data can be imported and exported.

Install and try the Free version!

Excel File Contents

You will find the following data as separate sheets in your exported Excel file:

• Products


• Smart Collections


• Custom Collections


• Customers

Use the same file with column and sheet structure to create an import file.

Import & Export

Get Detailed Feedback

• Don't guess - just download the Import Results file and see what happened to your import by each row -
  Results columns will be added at the end of your data columns.
  


• See which items were created New, which were Updated, and which Failed.


• If there was an error, the commend column will tell the exact error reason, which helps you to get your data
  right.
  

Products

Columns available:

• Standard fields: Handle, Title, Body (HTML), Vendor, Type, Tags, Published


• Just for you: Template Suffix


• Image fields: Image Src, Image Position


• Options: Option1 Name, Option2 Name, Option2 Value, Option3 Name, Option3 Value


• Variant fields: Variant Position, Variant SKU, Variant Grams, Variant Inventory Tracker, Variant
  Inventory Qty, Variant Inventory Policy, Variant Fulfillment Service, Variant Price, Variant Compare At Price,
  Variant Requires Shipping, Variant Taxable, Variant Barcode, Variant Image, Variant Weight Unit
  

To import several images and variants, just repeat the row with the same Handle.

No need to have empty cells for repeated rows, they can contain just duplicated data.

Shopify exported CSV file, pasted to Excel [Products] Sheet, can be imported as it is without any changes.

Smart Collections

Columns available:

• Standard fields: Handle, Title, Must Match, Sort Order, Template Suffix, Published, Published Scope,
  Body (HTML), Image Src
  


• Rules: Rule: Product Column, Rule: Relation, Rule: Condition


• Exported only: Updated At, Published At

You can have the Rules defined like in those examples:

• [Title] [Contains] "t-shirt"


• [Variant Price] [Less Than] "100"


• [Tag] [Not Contains] "Discount"


• ... and so on

To import several rules for each Smart Collection, just repeat the row with the same Handle, and set the Rule
values.

Custom Collections

Columns available for Export and Import:

• Standard fields: Handle, Title, Sort Order, Template Suffix, Published, Published Scope, Body (HTML),
  Image Src
  


• Linked Product fields: Product: Handle, Product: Position


• Exported only: Updated At, Published At

Customers

Columns available for Export and Import:

• Standard fields: Email, First Name, Last Name, Phone, State, Accepts Marketing, Note, Verified Email,
  Tax Exempt, Tags, Multipass Identifier
  


• Address fields: Address First Name, Address Last Name, Address Phone, Address Company,
  Address Line 1, Address Line 2, Address City, Address Province, Address Province Code, Address Country,
  Address Country Code, Address Zip, Address Is Default
  


• Exported only: Created At, Updated At, Total Spent, Total Orders, Last Order Name, Account Activation URL
  


• Imported only: Send Account Activation Email, Send Welcome Email, Password

Yes, in the export each customer has its primary First/Last name and Phone, and each address has their own First/Last
Name and Phone - for delivery purposes. All this data is exported and imported exactly as you see it in Admin.

If Client will have several addresses, all those will be exported, each address in new Excel row. The same principle
can be used to import Customers with several addresses, keeping the Email field as the unique Customer identifier
(the same as Handle for Products).

Detailed Documentation

For more detailed documentation, see our Web Site.

Stability

Import and Export process automatically retries and does its best to recover from errors, so that eventually your
import or export gets done.