The formats that can be imported:
- Excelify: Excel
- Excelify: Google Sheets
- Excelify: CSV (zipped or not zipped)
- Shopify: CSV (zipped or not zipped)
Other external 3rd party formats that can be imported:
- Shopify Products CSV
- The Art Of Books
- Banggood (ask Support)
- Brandsdistribution (ask Support)
- Turn14 API
“Excelify: Excel” Format
Excelify Template is a single Excel file that can hold all your whole store data.
That data is organized in clear and human-readable tables, as several sheets.
The same file can be exported and imported.
Sheets inside Excel file
One Excel file can hold several kinds of Shopify data items like Products, Customers, and so on.
Inside the Excel file, there are sheets (tabs at the bottom). Sheet names tell the app what kind of data is inside each sheet.
Recognized sheet names
- Smart Collections
- Custom Collections
- Draft Orders
- Blog Posts
Sheets must be named precisely as that – also big/small letters matter, so be sharp when giving those names, or better just use the exported file, or the template.
All the other sheets are ignored, so you can keep your reference data sheets also in the same file.
Columns and rows
In each sheet, the data is arranged in columns and rows.
Those columns are basically the same data fields as you fill through Shopify Admin. For example, Product columns would be Handle, Title, Vendor, and so on.
Imports don’t need to have all columns – the app will update only those fields, which columns you are importing. If you have the column with an empty value, the app will set that field value to empty. So if you don’t want to change a field value, then remove the column from the import.
When you are updating data, sometimes you want to update just one field, like for example, product price. In that case, you can remove all the other columns, and the app will update only this one field, and leave other fields unchanged.
Column order doesn’t matter.
You can have your own additional columns – the app will just ignore the columns it doesn’t know.
Rows correspond to items in Shopify. Basically, one row is one item in Shopify (except, when you need more rows for one item).
Values in cells correspond to appropriate field value for that item. Sometimes values are text, sometimes numbers, sometimes TRUE or FALSE (which means yes or no).
Usually, when you enter that data into Excel, it will automatically understand, what is a text, what is a number, and what is TRUE or FALSE.
Items that need several rows
For example, for Products, you might need several rows per product, if the product has several images or several variants. For Customers, you can have several rows, because one Customer can have several addresses. Smart Collections can have several Rules. And so on.
In case of Products, each new variant and each exported image will go in its own row. However, you can import several images by splitting them with the semicolon (;).
For the app to know that the row belongs to the same item, it needs to have either the same ID value, or the same Handle value (if ID is empty), or the same Title (if Handle is empty).
The ID is the unique number that Shopify generates for each item. When you create new items, leave it empty – Shopify will generate them for you. The ID is used when you need to update existing items – this ID will allow the app to identify which item you need to update.
When you repeat rows, you can just copy them down with all the values also for those columns, where only one value per item is needed. For example, if you will copy the same Title value for all the Variants rows, the app will use the only value from the first row and will ignore the rest.
You can tell by the column color and by its starting name that it belongs to repeated row. For example, all variant columns start with “Variant …” and are the same color.
When importing, the file must be sorted so that repeated rows for the same item are together (sorted by ID, Handle, or Title). Because, as soon as ID or Handle, or Title will change, it will be treated as next item.
Columns have colors, and those are visual indicators for you how those columns group logically together. When importing, the column colors are ignored.
When viewing import results, it will also color those columns. The columns that have white color means that those were ignored, the app didn’t know what that is.
Don’t have Excel?
If you don’t have Excel, you can use Google Sheets, and then go to File -> Download as -> Microsoft Excel (.xlsx).
Or you can just import directly from the Google Sheets URL – like in this tutorial: Schedule import to Shopify from Google Sheets.
Or you can edit the Excel file in other apps, like, Numbers (for MacOS), OpenOffice, LibreOffice, etc.
The filename of the import file doesn’t matter, name it as you need. To be able to import that file, it must be real Excel (.xlsx) file and must contain at least one sheet with the proper name that app can recognize.
When exporting, the file name is always “Export_<date>_<time>”. The date is in format “YYYY-MM-DD” and time is in the format “HHMI”. That guarantees that when you sort the exported files by name, they will always be in the order as they were exported. So your latest export is always the last one.
Maximum file size that you can upload is 2 GB (ask Support if you need more).
Excel format itself can hold up to 1 million rows. But it is advised that if your data might be larger than some 600’000 rows, then use the “Excelify: CSV” format.
“Excelify: Google Sheets” Format
You can prepare your Google Sheets file in the exact way as you prepare the “Excelify: Excel” file.
Then share this sheet to be accessible as view only by the public. And paste that URL in the app.
Read more in this tutorial: Schedule import to Shopify from Google Sheets.
“Excelify: CSV” Format
If your store is so large that Excel file doesn’t fit all the data, you can use the “Excelify: CSV” format, which has no size limitation at all – it can hold data well exceeding several millions of rows.
This format is organized the same way as Excelfy Excel file, with the following differences:
- It is a zip file that contains CSV files.
- Each sheet inside the zip file is a separate CSV file. For example “Products.csv”, “Smart Collections.csv”, and so on. In this case, the CSV file name inside the zip file matters – the same as the Sheet names in the Excel file. It’s the way how you tell the app, what data in which file.
- CSV file column delimiter is the comma (,), and all text values are in double quotes (“). Files are UTF-8 encoded. That ensures that Excel will always open them correctly without any special conversion.
- When importing, it is best that you zip the CSV file(s). That way they become more than 10x smaller and as a result – your upload is 10x faster. But you can import also plain CSV files – just they should be named according to Excelify sheet naming rules.
“Shopify: CSV” Format
The app can import the Shopify CSV file of Products which you can export from the Admin.
To make it smaller, you can zip it and upload the zipped file.
CSV file and zip file can have any file name, just the file extension of the CSV file needs to be .csv.
CSV file column delimiter is the comma (,), and all text values are in double quotes (“).