Powerful new features, services and plugins for your Shopify store

All Apps / Tools / Bulk Import Export Update with Excel

Bulk Import Export Update with Excel

Bulk Import Export Update with Excel

Developed by Excelify.io

48 reviews
Get
Price: $20.00 – $200.00 / month More info
  • Use Excel files to import, export or update your store data: Products, Collections, Customers, Discounts, Orders, Pages, 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.


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?


Export to other Marketplaces



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

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

Bulk Import Export Update with Excel reviews

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

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

This is by far the best app to import large data sheets! Not only does it work as simply as described, it has the best documentation explaining everything you need to know. The icing on the cake is the customer support! This is the best customer support that anyone could ask for. He goes above and beyond the normal!
Do not hesitate about getting this app; it really is great!

posted

Excellent App !!! Extremely solid app and full of features. Probably the best app for bulk import and update of metafields.

posted

I have been working with Maris and his team with this App for 6 months...it has been amazing.
1. they are extremely responsive and helpful and also keep adding new capabilities to the app as we need them!!!!
2. The app - product, collections, Amazon, Google Shopping upload is extremely easy. Had 49k products to upload to one store and just under 10K for another store but they make it easier to upload than with the Shopify capability. And actually being able to sort out the collections whether smart or custom...priceless.
3. Updating products is easy and to make some products inactive - EASY!
I know 'easy' is a buzz word here, but that is the only word that I can think of because after so many months of frustration - There was MARIS!

posted

A++ Support!
They helped me in seconds, fast response and most of all kind support!
Support staff clearly knows their stuff to assist with any question.

Go ahead and give this app a try!

posted

I am awful with spreadsheets and have had a very manual process uploading products from Shopify to Amazon. This app changed all of that. I had a little tough time figuring out a small uploading portion so I contacted support... They not only fixed the issue, which was totally my fault, but they also went WAY PAST the expected help to make sure every product was uploaded. This is resulting in literally doubling the sales for my Shopify store.

posted

So I posted a 4 star review and the app developer reached out to me immediately to resolve my speed issue, on a Sunday no less. The customer service from the developers deserve well beyond five stars!

Thanks Excelify!

posted

The Excelify app is going to be a game changer for our store. We've been uploading manually individual products mainly because I've not had success using file formats in the past. As I was going through the training I noticed a webinar with Maris. He took the time to help me fully understand what I was doing wrong and gave me some additional pointers that will surely double, maybe triple my work!

posted

Fast and friendly customer support. App does exactly what it is intended to do -- make importing and exporting data to your Shopify store easier. Improvements are always being developed, including being able to schedule exports so I can save the file for backup of product data.

posted

Maris was super fast at answering all my questions! Awesome App and a 5 star customer service!

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
WhatsApp +37129123034
support@excelify.io
excelify.io
not provided
Get Support

Screenshots

  • Large
  • Thumb
  • Thumb
  • Thumb

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