Import products from Excel on Shopify

1. Log in with your Click2Sync account here

If you don't have a Click2Sync account create one here

2. Add your Excel products

Click on the "add backend..." drop down and select de option marked as "Excel"Excel Step 1

A pop-up will appear, drag and drop the "Excel" file you wish to use for the import (Currently we support file types: csv, xlsx)Excel Step 2

The new pop up window will ask you to map your "Excel" columns. By default we provide a suggested mapping but please change it to match the appropiate information. If you don't want to include a column you can select "ignore"Excel Step 3

On the lower right corner you will see a notification indicating that the process is running, wait until you see the notification change to "first time load complete". After it finishes you can view your products on Click2Sync. (Note: The first time load can take a considerable amount of time)Excel Step 4

3. Connect your Shopify instance

This steps assume you already developed your custom integration to our API, if you want to know more about how to integrate to Click2Sync click here.

Click on the "add storefront..." drop down and select de option marked as "Custom"New Shopify connection Step 1

A pop-up asking for the API endpoints and URL will appear. Fill in the textboxes, press the "Generate Key" (this will be used authentication mechanism) then press the "Scan Products" button to start the import of your productsNew Shopify connection Step 2

You will see a notification in the lower right corner indicating that the process is running, wait until you see the notification change to "first time load complete". After it finishes you can view your products on Click2Sync. (Note: The first time load can take a considerable amount of time)New Shopify connection Step 3

4. Now send the products from Excel to Shopify

Select a product from Excel that you want to import and enter the description pageImport Step 1

The product detail page will show up, the tabs marked with a "1" on the image represent the different places that your product is on. In this example(The image) the product is only on "prestashop" and you can add it to the different connections by pressing the tab that is semi transparent representing the connection where you want to add the product.Import Step 2Import Step 3

The new product equivalence for the selected connection is created, information of the product now is in green text, this means the data is going to be added. You can make specific modifications to this version of the product here.Import Step 4

When you are done click on the "save" buttonImport Step 5

To send the product to your Shopify instance click on the "sync" buttonImport Step 6