In addition to creating each product manually in Click & Drop, you can upload multiple products at once via spreadsheet.

To begin, click ‘Products’ on your Click & Drop menu bar, and on the dropdown menu, select ‘Import’ as shown:

10-Click-Drop-Product-Import-Products-Menu_0.jpg

You will be taken to the ‘Product Import’ page. From here, you will be able to upload your spreadsheet and map the fields ready for import.

20-Click-Drop-Product-Imports-Import-Page_0.jpg

 

Step 1: File upload

Click the ‘Upload a file’ button, and a pop up window will appear where you can select the spreadsheet file from your computer or device:

30-Click-Drop-Product-Imports-Drag-File_0.jpg

Spreadsheets can be in CSV, XLS, XLSX, or ODS formats, no larger than 20MB and with no more than 2000 rows. Please ensure your spreadsheets do not contain macros.

Once you have selected your file, The ‘Upload file’ button will turn blue. Click it to proceed to the next step. 

40-Click-Drop-Product-Imports-Upload-File_0.jpg

 You will now be able to see your uploaded file on the ‘Product import’ page:

50-Click-Drop-Product-Import-Settings_0.jpg

Step 2: Import Settings

 In this section, there are two settings:

Check the ‘The first row is a header’ box if you have headers in your spreadsheet, and you do not wish for that row to be imported.

 

In the ‘Import mode’ drop down box, you have the following options:

‘Create’: The products import will be saved as new products

‘Update’: The products you import will update and overwrite your existing products

‘Create and update’: This option will create new products where the product SKU is not already in your saved products, and will overwrite your existing products where the SKU is the same.

 

Step 3: Field mappings

This section will display the columns in your spreadsheet. The next step is to map the columns to the fields in Click & Drop:

60-Click-Drop-Product-Field-Mapping_0.jpg

The fields available for mapping are:

Name

SKU

Stock Location

Initial Inventory

Weight in KG (number only)

Price (in pounds sterling, please do not include £ sign)

Domestic package size (letter, large letter, small parcel, medium parcel, or parcel)

International Package Size (letter, large letter, or parcel)

Image URLs

Please note that SKU is the only required field, all the others are optional.

For Image URLs, please include the https:// or http:// in the URL. For multiple URLs, include the vertical bar/pipe (|) symbol between each URL. Do not leave spaces.

Example for one image: www.yourcompany.com/images/bluetshirt.jpg

Example for two images: www.yourcompany.com/images/bluetshirt.jpg|www.yourcompany.com/redtshirt.jpg

 

When you have mapped your fields, a green tick will indicate the SKU field has been mapped successfully:

70-Click-Drop-Product-products-Mapped_0.jpg

Click the ‘Import Products’ button to finish.

When your product has been imported successfully, you will see the following message:

100-Click-Drop-Product-Import-Complete_0.jpg

When you click ‘Products’ in your Click & Drop menu bar, you will now be presented with your list of products. Clicking an individual product will expand the window to display the product details.

Your new products will be uploaded as shown:

100-Click-Drop-Product-New-Product_0.jpg

Please note that packaging sizes may differ for domestic and international orders.

 

What to do if your import has been created with errors:

If your import was created with errors, you will see a warning message: 

80-Click-Drop-Product-Import-Error_0.jpg

Click the text ‘See errors’ and you will be taken to the ‘Product import history’ page that will explain what caused the error: 

90-Click-Drop-Product-Error-Explained_0.jpg

In our example, the value for ‘Price’ in row 2 of the spreadsheet was not in the correct format.

You would need to correct the values in the spreadsheet and begin the upload process again.