Powerful new features, services and plugins for your Shopify store

All Apps / Tools / Excelify: Bulk Import Export Update

Excelify: Bulk Import Export Update

Excelify: Bulk Import Export Update

Developed by Excelify.io

57 reviews
Get
Price: $20.00 – $200.00 / month More info
  • Use Excel or CSV files to import, export or update your store data: Products, Collections, Customers, Discounts, Orders, Pages, Blogs, Metafields.
  • Import and Export custom formats like Google Shopping, Amazon, SAP, AoB, migrate from other platforms.
  • Schedule and auto-repeat imports and exports.


This app is for you if you manage Shopify store data, you like precision, and you need to control the outcomes of
your work. Beneficial is if you know how to use Excel (or similar spreadsheets apps), or at least are willing to
learn those things.


Have you maxed out Shopify CSV file import and export capabilities?



If you have used Shopify CSV export and import feature, then this is your next level tool. If you feel like CSV
files and manual data entry limit you in any way - it is very likely that you will find your solution here.


Excelify.io gives you great control over your store data



  1. Feed data to your store from any of your data sources.

  2. Update your existing store data by individual fields, without having to re-import
    everything.

  3. Copy your store data to your other stores with just one Excel file.

  4. Schedule and auto-repeat your imports or exports.



You import the same structure Excel file as you export.

Download this Excel file
and use it as an example and as a template.



The app is updating your Store data on Shopify database, so you own your data at all times. Even after
you uninstall the app.


Just this one feature to import Collections in bulk will save you days of manual work



We know you spend too much time on creating and updating your Collections of products. You might be even paying
somebody to do that for you, and then re-check it yourself anyway, because of potential errors.



If you use Excelify.io for just this one thing - you have bought your precious time and sanity back. You will be
able to import and export collections yourself, if you decide to do so; and have a clear overview - what's inside
each of those collections by doing an export.


But this app does so much more than that



Whatever fields you see in your Shopify Admin, you are able to export and import them with Excelify.io.
You can bulk-update any of those fields individually or all together.


Orders, baby!



Yes, you can export and import Orders now, and you can copy them from one store to another with the same
export/import file.


Metafields still drive you crazy?



Having Metafields as just additional columns along with items they are attached to, makes your data whole, and you
can edit, add or delete them just as any other field values.


Those include also Variant Metafields.



SEO metadata is also there.

File formats that can be handled



Load enormously large volumes of data


The upload file size limit is 2 GB. Excel files are compressed - you will never hit this limit. If you import
CSV files - you can zip that CSV file and upload the zip file. Such file can hold several million rows.

Import from locations



  • Upload the files directly into the App

  • Web link to the file

  • FTP

  • Dropbox

  • Google Drive

  • Google Sheets


Schedule and repeat your imports and exports



  • Schedule exports to use as store backups or data snapshots, done at regular intervals.

  • Schedule the import or export to run later, repeat them automatically.

  • Setup the import to be done just in time for your campaign.

  • Setup the repeated automated import from FTP server, Dropbox, Google Drive, or Google Sheets link.

  • For example: Schedule to update sale price on every Monday and put it back on Wednesday, or any other
    combinations.


Your store language is not plain English?



If you tried to import products or customers with CSV files in other language with special language encoding, you
know the pain. With Excel files your data will be imported correctly.


Some of additional results you can get with this same app:



Copy your whole store to another



All your exported store contents fit into that one exported Excel file. You can easily copy your store by just
importing that same exported Excel file to your other store.



Whichever plan you choose, you have one additional store included in the same price. Send your both store URLs to
our Support, and we will put them on the same plan.



See the tutorial: How
To Clone Your Shopify Store?


You are in charge!



  • Specify, what data you want to export.

  • Track the progress - see the time it takes to finish any of your jobs, and how many items were created, updated
    or failed.

  • Cancel the process any time if you see you messed up something.

  • See detailed result for each item by downloading the file after the import has finished.

  • Backup your whole store by doing full export.


Tutorials


Detailed Format Documentation

Latest Updates

May 13, 2018: Blog Posts.


Import, Export and bulk update your Blogs, Blog Posts and their Comments.

Apr 27, 2018: Import Products from Shopify CSV format


You can directly import any of Shopify Product CSV files, of size virtually unlimited (zip file size limit is 2
GB).

Apr 22, 2018: Import from Dropbox, Google Drive, Gogle Sheets


Import manually or schedule, or auto-repeat imports from files from Dropbox, Google Drive or Google Sheets.

Apr 17, 2018: Import from URL


Schedule the import from a file that is found on URL - to always load your up-to-date data from that file. That
URL can be an FTP path too, like ftp://user:password@your-server.com/path/to/file.xlsx.

Apr 8, 2018: Tags Command


You can specify the "Tags Command" for Products and Customers - to MERGE, DELETE or REPLACE the Tags.

Apr 4, 2018: Variant Metafields


Export and import Product Variant Metafields with column name prefix "Variant Metafield:". Works the same as
"Metafield:" columns.

Mar 24, 2018: Filter Products export by Collection


Export products that belong to a certain Collection.

Mar 24, 2018: Export to custom file name


Specify custom file name for the export, so that auto-repeated exports can have the same URL - use for further
automation.

Mar 22, 2018: Scheduled exports


Schedule and repeat exports at certain time intervals. Use for backup and for taking automated data
snapshots.

Mar 20, 2018: Export and Import stores with over 1 million products


New format "Excelify: CSV" to export your whole store to zipped CSV files, allows virtually unlimited data
volumes. And you can import that too.

Mar 17, 2018: Schedule and repeat imports


Set the import to start at a certain date and time, and repeat it at given time intervals.

Mar 7, 2018: Export and import "Image Alt Text" for Collection images


Each collection can have one image. You can import and export "Image Alt Text" for those images - great for your
store SEO.

Mar 3, 2018: Export and import Line Item Properties for Orders


You know those additional attributes that you can pass from product and checkout pages? You can export and import
them now, too.

Feb 14, 2018: Filter Products by SKU fragment


You can filter Products – to export only those, which contain fragments of SKU.
To filter by several fragments, split them by comma.

Feb 12, 2018: Update and Delete Products by SKU


You can identify Products by having just the "Variant SKU" column - to bulk update or delete Variants or entire
Products.

Feb 5, 2018: Command: NEW, UPDATE, REPLACE, DELETE


In the "Command" column you can specify for each item what to do with it: NEW, UPDATE, REPLACE, DELETE. Now you
can
bulk-delete anything.

Feb 1, 2018: Orders import


You can now not only export, but also import Orders to your store.

Jan 16, 2018: Option to remove images from Body HTML descriptions when importing


If you need to remove images from product descriptions, check the box under Options button when importing.

Jan 13, 2018: Fixed mysterious errors that were appearing time after time


Field [metafields.key]: must be unique within this namespace on this resource; product_id prefix_option is
missing;
end of file reached.

Jan 10, 2018: Update Product Variants by SKU, by Barcode or by Variant Options


When you need to update variant data, you just need Product Handles, and then - SKU, Barcode, or just option
values
that are used for variant - smart MERGE will find that variant and update its fields.

Jan 9, 2018: Export to Amazon


Export your Shopify products to Amazon Inventory Flat File, which you can import in Amazon Seller Central and
sell
your Shopify products there.

Jan 5, 2018: "Image Command" for Product images


Never lose images by accident. You can provide the command for each image to tell, what to do with that: MERGE,
DELETE, REPLACE. MERGE is the default.

Dec 28, 2017: "Variant Command" for Product variants


You can provide the command for each variant to tell, what to do with that variant row: MERGE, DELETE,
REPLACE.

Dec 19, 2017: Pages Export & Import


You can export and import Pages in bulk.

Dec 15, 2017: Increased import speed 5x for Big, and 10x for Enterprise Plan


Now the 5x speed is even more faster than before, and 10x for Enterprise Plan is well 10x faster than Basic.

Dec 5, 2017: Export as Google Shopping Data Feed


Export Products in Google Shopping Data Feed format. Exports only published products. Can use the filter to
export
just needed.

Nov 27, 2017: Filter export of Products and Orders


Filter Products export by Handle, Title, Vendor, Type, and Tags.
Also, filter Orders export by dates.

Nov 23, 2017: Update Image Alt Text


You can export and import Imate Alt Text field for Products, and update alt text by importing that back.

Nov 23, 2017: Export only details that you need to


Now you can choose finer details what data to export for each item so that you don't have to delete unneeded
columns and rows when updating data.

Nov 15, 2017: Show warning about failed image import


If Shopify will not be able to import all Product images, the app will issue a warning about that in Import
Results
file
"Import Comment" column.

Nov 14, 2017: Variant position import to reorder variants


Product variant reordering can now be done by changing "Variant Position" number and importing that column in as
update.

Nov 11, 2017: Base rows/columns filled in export


When exporting, all the base rows like Title, Vendor, Tags, etc.
are filled also for duplicated rows, so that you can filter and group them easier in Excel.

Nov 10, 2017: Metafields import


Speed: Metafields import speed doesn't depend on Metafield count anymore. Even for 100 Metafields per
item, it
will import as quickly as with no Metafields.


Delete: You can delete Metafields for items just by clearing values in that Metafield column, and
importing.


Set type: Metafield can have "string" or "integer" type, which is now auto-detected from Excel cell type,
and
set correctly when you do the import.


Read more of release history

Excelify: Bulk Import Export Update reviews

57 reviews
  1. 5 stars (57 reviews)
  2. 4 stars (0 reviews)
  3. 3 stars (0 reviews)
  4. 2 stars (0 reviews)
  5. 1 star (0 reviews)

Great Product. Worlds ahead of Shopify's built in import/export tool.

This tool was especially important for us b/c of synchronizations/integrations we have running.

This allows for importation of variant info w/o breaking the connection with the synchronizer. great!

posted

By far the most important app for stores with many products. The app allows for complex changes through a simple interface. Get the app before you start any big jobs in Shopify, you will be glad that you did! Maris and support team are the best!

posted

This is an excellent app!!! I can get a lot of bulk work done a in a few minutes because of this app. Also this shows the shopify ID which is not accessible with the native export feature of shopify. Shopify ID is important to other vendors because this this becomes the reference ID to connect with our products.

posted

Excelify did something for me asap and they are amazing! A+ :)

posted

This App saved me many days of work! Working just like a clock!
In addition they have a very helpful support.
If you want to clone or sync the Shopify stores this is the best choice.
Recommended!

posted

5 STARS!

This app saved countless hours of work and delays on our migration of 15k+ products. It's a must-have app for stores with large databases that need to make changes to products and variants in bulk. Importing/exporting is a breeze with excelify and the app lets you know how much time to expect actions to take with great accuracy.

Maris' support was fantastic, as he spent a fair amount of his valuable time ensuring that our project was a success. His knowledge and problem solving skills are spectacular, and we really enjoyed working with him. This is not like other apps where it's impossible to get ahold of someone and fix issues. Thanks Maris!

posted

The best APP I have never seen before, Maris give excellent support, he offers more of you can expect, we teach you other thinks even if are not of his app,

This App will help you to solve any problem you have with your inventories, or any issue you have, easy to use in excel, you can manage all the information, make any filter and edit everything.

Very recommendable, I fix all the problems I have and still with the app for any inconveniences I could have, I can set very quickly.

App does many things that today shopify store owners are doing buying several app being yours alone doing the same thing.
initially I thought to use it for a couple of months, but now that I know it a little more, it is indispensable for me, and I will never stop using it, unless I close my store

Congratulations to Maris an all his staff 1000% Customer Service, much more than you expect

posted

This app is awesome! It does exactly what it's supposed to do, there's a small learning curve but it's worth it.

posted

Great app! Easy to use and quick, helpful response from developer when something is not clear.

posted

This one is a must have on Shopify.
No other import-export offers so many options (believe me, I have tried many of them!)
I have been using for over 6 months Excelify on a daily basis to backup all the data of my store, and to do sales and tax reporting (yes, it does all that).
I have also used Excelify to do a 50,000 orders + 3,500 products migration from WooCommerce, and once the mapping was done, the App handled that super easily.
The development is very active, it gains new functionnalities every month, with no price increase so far.
Last but not least, the support is stellar!

posted
Get
$20.00 – $200.00 / month

Plans:
    ➤ Demo:        Free
    ➤ Basic:         $20/month
    ➤ Big:             $50/month
    ➤ Enterprise: $200/month
Pricing Details

Support & Sales

Excelify.io
+371-29123034
support@excelify.io
excelify.io
excelify.io/privacy-policy
Get Support

Screenshots

  • Large
  • Thumb
  • Thumb
  • Thumb

Are you a developer? Become a Shopify Developer or submit your app.