For Products, the CSV file name needs to contain the word “Products”, for example, “my shopify products.csv”.If your file is not over any of the known excel limits, such as the maximum of 1 million rows or 16 000 columns, then we strongly suggest NOT to use the CSV file, but use the Excel as XLSX format file before starting to work on it.Basically, the only real reason to use CSV files, is if you are generating them automatically from some other system.

Do you have a data file from which you need to import Products to Shopify? Here you can list public and direct links to your images which will then be downloaded by the Shopify for your Products.Same as with Variants, you can list one row for each Image and the app will use Handle and/or Title to see what rows are from the same Product.As previously mentioned – for Excelify to count a row as Variant, you need to have at least one column filled that starts with “Let’s add 8 images to the example file to see how it would work within the Excelify:As you can see in the screenshot above – all rows have the same Note that the image rows don’t match up with variant rows – “Images will appear in the product in the same order as they appear in the file, but you can change that with the “Image Position” column to specify the positions for each image.Your file already might have all Product images listed in a single cell, and Excelify also supports that!You will need to make sure that the images are separated by a ; (semicolon) as you can see in the example below:Thru the Products import, you can also assign and even create Do not worry if for a product with multiple rows the Collection names repeat.

Column Description / Example Value; ID. But if you are working manually with spreadsheets, then definitely use the Excel XLSX files.Note that Excelify can import file up to 2 GB in size, and you can zip the CSV file to make it smaller. Press Import button: Press Browse button: Pick up the . Looking at the Options we can see that I have “Then we can fix the error, and since all other items imported “OK” I can delete them from the file, and now only import 1 Product – only that one product which was You can fix the issue right there in the Results file and import that instead of the original file.If working with the Excel XLSX file, then the results file will also be returned in the Excel file.In this file, you can go over all the column headers. Join for free and access educational resources, developer preview environments, and recurring revenue share opportunities.Alternatively, you may be working on a design concept for a client and need some quality product images before you start writing a line of code. With CSV imports there are a few details you need to make sure of for the import to complete correctly.

We’ve compiled a set of product CSVs which contain high quality images and product data, such as variants, that you can import into a Shopify store. Those attached to the whole Product and those attached to specific Variant.Product level Metafields are set one Metafield for the whole Product. How to Import CSV File on Shopify: After updated the CSV Template with correct information, you have to import the file on Shopify.
The file name for XLSX files does not matter.If you don’t have an Excel, you can use the Google Sheets, and paste the link to the Excelify app as well – that will work the same as the Excel file (see this tutorial on The import CSV file needs to have CSV file structure, it needs to be a comma-separated CSV file.To tell the app what you are importing you need to rename the file correctly. You can hover over the “?” mark symbol to see small explanation about the Options checkbox.Once everything is set up, you can click on the “Import” button.Now you can see how far the app is with the import, how many items have been imported, if any items have failed, updated, created new, or deleted.You can also see all the details about the job on this page, including what Options were applied, and the adjusted remaining time, and what is the import speed – You can leave this page at any time and find it in the “All Jobs” list in the app.After an import will be finished, you will see the job status as “At this stage, the job is no longer running and all items created will already be in your store.If some of the items failed to import then you can download the “Import Results” file to find the issue.In this column, you can see the general status of the whole item. The import CSV file needs to have CSV file structure, it needs to be a comma-separated CSV file. By following the 5 simple steps stated below, you can easily import the file on Shopify: Shopify admin >> Products >> Import >> Choose File >> Upload . Jamie Shiers Jamie Shiers. If a column header is not colored – that means the app ignored this column. An example CSV can be found in the import model. One way to make that process even quicker is importing products via CSV. As previously discussed you can specify what you are importing by having Next, you can check the total count of the items that Excelify will import and make sure that it matches the number of items there should be in the file.

What sort of changes are you looking to make to your products with the CSVs? One way to make that process even quicker is importing products via CSV.