Import products Excel files into your Shopify store!
You can import any size of files: we tested that on 10GB size Excel.
How it works
1. You import products Excel AS IS to yfifx as supplier products without any changes.
2. You define margin rules for repricing.
3. You select all products or any subset of supplier's categories / products what you want to import to Shopify.
4. yfifx updates selected products with new prices at MainFEED.
5. Your MainFEED you can export to your Shopify store via API or direct SQL db calls or you can access data via API.
- SKU,ID,MPN,UPC,BARCODE,Ref etc,
- Price, SalePrice, OldPrice, Discount,
- Options,Variants (Colors,Sizes etc),
- Dimensions: L x W x H, and Weight,
- Images ,
Contact us and get a 14 day free demo
Import Excel files into your Shopify store using yfifx tool!
yfifx allows you to do full automation for products update and sync from any Excel files for your Shopify stores.
You can add new suppliers to Excel files itself, or to ask us to do that for you by request.
How to work with yfifx
Step 1. Create a new account. It will take 2 minutes and you will get your login/password for your private area at yfifx.
Step 2. You can test and ask questions to support for FREE during 14 days! Login into yfifx. Support will help you to solve all your issues with the yfifx.
Step 3. Import products into yfifx. Read manual or contact support team with your questions - it is FREE.
Step 4. If any issue - create a ticket in the App for Support.
Find below how it looks inside our software for Shopify dropshipping.
Step 1 – Feed configuration for Shopify Excel import
There are several options exist how to upload Excel file
— from PC
— from URL, FTP, Dropbox, Google sheets etc.
— from Email
— sometimes it is necessary to download file from supplier website under client's login & password (it is possible but will require custom development)
Video instructions – creating a supplier's feed and uploading a file
Step 2 – Excel format selection during Excel Shopify import
— by default, the system does not know the format of file you defined,
— clever algorithm tries to detect format itself (in your case Excel file) for Shopify
— if you see any issue with format detection, you can set the right variant manually
Step 4 – Columns definition for Excel file
— each file for Shopify import has columns
— user has to define what column contains names, what column contains prices. It is columns matching
— there are 2 ways how to do that for Excel file at yfifx
1) via column definition
2) via product model fields definition(advanced mode – extended settings)
Step 4.1 — Loading categories during Shopify Excel import
1) If the categories and subcategories are located in different columns, then to load them, you need to define the name of the columns as Category1, Category2, etc.
2) If the categories and subcategories are located in the same cell, then we define the column name as CategoryMultivalued. Then go to the Extended Settings in the Categories tab, in the CategoryDelimiter line, enter the separator between the category and the subcategory. In my example, this is a slash.
Video instructions – Loading categories during Shopify Excel import
Step 4.2 — Loading basic product data during Shopify Excel import
Basic information about the product – SKU, Name (required fields for downloading), Price, Quantity, etc. To load them, you need to correctly match the column names.
Video instructions – Loading basic product data during Shopify Excel import
Step 4.3 — Uploading images during Shopify Excel import
1) If the links to the images are located in separate columns, then you need to define the name for each column as “Image 1 (URL)”
2) If all links to images are located in one column in one cell, we define the column name as “Image1 (URL)”. Next, go to the Extended Settings → Images tab, in the "ImagesDelimiter" line, enter the separator between the images.
Video instructions – Uploading images during Shopify Excel import
Step 4.4 — Loading features during Shopify Excel import
1)Bulk loading of features. If the columns with features in the file go one after the other, then for the first column with the feature, we define the name as "FeatureFirst", the names and values of the remaining columns will be loaded automatically.
2) If the columns with features are out of order in the file, then the columns with features are defined as "Feature1", "Feature2" and so on. And enter the name of the feature in the "FeatureName" lines in the Extended Settings in the Features tab.
Video instructions – Loading features during Shopify Excel import
Step 4.5 — Loading products with variants during Shopify Excel import
1)To load products with variants, there must be a column with an SKU in the file that will combine all the variants (we define it as an SKU) and for each variant a column with its own unique SKU (we define the column as a CombinationSku). In the Extended Settings → the Combinations tab, we enter from which columns to take values for Price, Quantity, Image, etc.
2)Be sure to download the options variants — this is what distinguishes one product variant from another, for example, it may be the size or color of the product. To do this, we define columns with options as "Combination. Option1", "Combination. Option2”, etc., and in the Extended settings → the Combinations tab, in the "OptionName" lines, enter the name of the options.