When you import Products – the “Tags” column value was taken just from the first row.
Now the app will import all the tags that are in all the product rows.
That way you can have even one tag per row if you like.
For example, if you need to put the Option Values as product tags, you can just copy-paste those option column values into Tags column, and use the “MERGE” as the “Tags Command” – that will add those tags to your product existing tags.
You may need to import Shopify CSV file into your Shopify Store. You can easily do it with Excelify App. This is better, to export Products from your Shopify store into Excelify format and then import that file (especially because in any paid plan you have additional store included), but in case you have already Shopify CSV file with your products data, you can import it straight away.
All you need to do is:
Import Shopify CSV file with Excelify app
Open Excelify application. Go to import. Upload your Shopify .csv file. And press Import.
That’s all. Products are imported:
You may also compress the file, if needed and upload and import .zip file:
Good to know
At the moment it is possible to import only Products from Shopify .CSV file
Excel file format is limited to 1 million rows. In case your store has more then 1 million product variants, this is very useful to use .CSV format. You also can export your products to Excelify CSV format, following this tutorial.
Export Products + Inventory / Variants (without images or Metafields)
Find the column “Variant Position” and change the numbers as you like them to be. (no need to change the row order, just change the numbers)
You could just import that same file back but it will update all the columns that you import. So, to make the import smaller and quicker, and to update just the positions and nothing else, you can select just the following columns:
Copy those columns to new empty Excel file.
Set the name of the sheet “Products” (so that the app knows that those are the Products data there).
Import that file. It will just update the variant positions of those variants.
You can, of course, import only the product rows that you really want to change. No need to import all the products back.
To see how to remove duplicated Products from your Shopify store, watch this video or read on.
How to remove duplicate Products from your Shopify store?
So you have this store with your products duplicated for some unfortulate chain of events.
1. Export your Products to Excel file – without any variants or images, just plain Products
This will give you one row per product.
2. Sort your exported Excel file by two columns at the same time: Title, Handle
Take your exported file, open it.
Use the Excel “Sort” feature to sort by two columns at the same time:
This will make all the same titles get together one after the other. And then it will sort those same Titles by Handle – in such a way that your correct product will be the always the first one.
If you have another reason for duplication and you don’t have equal titles then you still can find other factors that could allow you to sort all the rows so that the correct one is always the first one.
3. Make the formula that will show TRUE for duplicated row of the same title, and FALSE for the first one
Now that all your duplicate rows are nicely sorted together with the first row as the correct one, you can proceed to mark – which ones you want to keep, and which to delete.
Add new column with name “Duplicate?” and put the following formula in the row 2 there:
Copy this formula all the way down.
4. Filter Excel rows to show only the duplicate rows
Set the filter to keep only those rows where “Duplicate?” equals TRUE.
5. Copy the columns ID, Handle and Command to the new clear sheet
Select the A, B, C columns and copy filtered values to a new clear file.
Then set the name of the sheet to “Products” so that the app knows that those are Products in this sheet (double-click the “Sheet1” to rename it).
And then change the Command column value to “DELETE” for all those copied products.
Result should look like this:
6. Import that file with Excelify app
Upload that file to Excelify app and press “Import” button.
Watch your duplicate products get deleted.
See in your Shopify Admin – and be pleased by the result that all the duplicates are now gone, and you have just one copy of each product.
It should look like this now:
Good to know
You can de-duplicate also Collections, Customers, Pages, Orders, or anything else – the same way.
If you have the export file with Variants, just first copy your ID, Handle, Command, Title columns to new sheet and use Excel function “Remove Duplicates” – then you will have just one row for each product. And then you can use this tutorial from there.
If you have more advanced situation, our Support can help you remove duplicates.
Scroll down to the “Import” section, and paste the URL there.
Then press the blue “Upload from URL” button – so that the app can upload the file and analyze it.
Don’t worry – it will not import that just yet, you will need to set additional options first.
4. Schedule the regular import from that Google Sheet URL
After the app has finished uploading and analyzing the file, you will see the “Options” button there.
Press that button and set up the import options – the scheduled time for your next import in your Shopify store time zone.
And repeating time interval.
Your eventual options will look like this:
Notice the “Take import file from URL” – that is pointing to your Google Sheet. The app will download the fresh file each time it repeats the import.
Now, press the “Schedule Import” button.
It will schedule the import and if the date and time for the first import have already passed, then the app will start the first import shortly after you schedule it.
Good to know
You can see the progress of all your scheduled imports and exports in the “History & Schedule”. You can also cancel any of those jobs from there. You can download the import results file from there, too.
The scheduled time is in your Shopify store time zone.