Working With Images For Bulk Upload Files in Excel

OK, you have performed the challenging function. Your product database is complete. You have the titles, descriptions and the correct costs all in location. The categories for your shop have been set and we are ready to upload.

But what about the pictures to sell the product?

excel to jpg, xlsx to image

For those who are dipping the toe into bulk uploading for the initial time, you do not want to invest hours adding images by the lengthy hand technique so we advise on the following to help. Please note that we are utilizing MS Excel as an example, but this will function in Works (so we have been informed)

1 crucial note before you get started. Save your master file at least TWICE as a distinct named file (one back up and 1 working)

OK lets go.

Initial of all your items. Give them all a item reference number, either alpha numeric or numerical (AB0001 or 000001). In Excel add the first one into your new column for the reference number. Then drag and fill all your items with their quantity. This will guarantee all items have been numbered in sequence. Please disregard this step if your suppliers images have item references on them (see point two below)

When that is completed, you can start work on your images. This will vary depending on the source of your pictures and whether it is a
or not, but it will inform you of the gist of the operation.

In your image folder, do one of the following

1. give item 000001's image the identical name (ie 000001.gif or jpg) and repeat for all your images.

two. give your suppliers image reference quantity to turn out to be your items own reference number

Once this is complete and ALL your images have the similar name as the product reference (or vice versa) you can now set to work on obtaining them into your database (or excel spreadsheet)

The actions are set out below.

1. insert a column and name it image_file and inside add your image file reference such as images/my_products/

two. insert a different column and name it image_name (or something comparable just as lengthy as you know what it refers to)

3. choose the first cell in this column then click on the fx or formula bar

four. pick COCATENATE from the choice box (commonly at the top or listed alphabetically)

5. in the TEXT 1 box click on the very first cell of the image file reference column (point 1)

6. in TEXT BOX 2 click on the very first items reference number (or component quantity)

7. in TEXT BOX 3 sort your image extension (either.jpg or.gif etc)

8. click ok

9. now drag down to fill in all your items in this column

10. Critical save this as an EXCEL WORKSHEET. If you save directly to.csv you will have the results, but you will want to recreate entirely if you wish to change the references.

11. Now save it as a.csv with a new name (such as sheet1_live)

There you have it. All your items now have images added to them.

You can then configure your spreadsheet to match your outlets specific import requirements.

Hope this assists you.