Bulk Import

[kessock]

Hi All,
I want to do a bulk import as I have one before, however for the image to date I have had to go into the image column of the CSV and manually type the file path.
What I really want is to have the product code in the image column so I can basically mirror productcode to image name.
If trying to do this actinic is obviously thowing shed loads of falures on upload due to there being no file path just a product code.
Is there a way of doing this as this will save me hours?
Thanks.
Mark

[leehack]

Use a formula like so:

="TYPE IN YOUR IMAGE PATH HERE"&CELL REFERENCE THAT CONTAINS THE PRODUCT REFERENCE&".jpg"

Things in green you leave as they are, things in red you change to suit your situation.

Once you have this formula in the cell, simply use the drag down facility to repeat it.

A finished formula would look like this for example:

="ProductPictures/Traxxas/"&A2&".jpg"

If cell A2 contained the product reference "3098" for example, you would end up with the following in the cell:

ProductPictures/Traxxas/3098.jpg

[kessock]

Reply

Hi Lee,
Thanks for that it is just what I want.
Regards.
Mark

[los_design]

Or you could use the concatenate function.

Works a treat on our bulk imports...and saves oodles of time.

[kessock]

function

Thanks,
Not heard of that before, where do I read up on it?
Thanks.

[leehack]

The formula i provided you with is using concatenate, it is signified by the '&' in an excel formula.

[kessock]

Got it

Cheers Lee,
God knows how you lot get your head around this, just glad you know what's what.
Cheers.
Mark

[kessock]

Other Link

Hi All,
Can you please tell me if I can make my spreadsheet link to another sheet.
Basically what I really want to do is have my own price list which I use for my site import, but I need this to link to my suppliers price lists (not just 1) so if they send me an updated price list mine will automatically change my import sheet if there is a price change.
I can workout the very basics that if I put in the formula that points to a cell in the other price list, however I would have to do every cell manually whereas I want it to point to the correct cell related to a product number without having to do each of the thousands of products as a copy and paste or drag copy i.e.
cell 4F for the price cell relates to product 4A.

Please keep in mind that the cell number may not always eb the same when a new price list comes through and this is why it must relate to a cell within a product row.

Hope that makes sense as I am running blind.

Cheers.
Mark

[leehack]

You are probably best to use the function wizard in excel, it will guide you on how to set up a formula, as explaining that on a forum is something i don't think possible to explain. Have a look through the functions you can use and look for soemthing to do a 'compare'. Probably a 2 minute job to physically do, a 60 minute job to explain in a forum.

[kessock]

wizard

Thanks,
I will take a look.
Cheers.
Mark

[kessock]

Function

Hi,
What name of function am I looking for a look up or which type.
The wizrd does not seem to exist in either version of Excel I have.
Any help would be great.
Thanks.

[Duncan Rounding]

In Excel this will link a local spreadsheet cell to another spreadheet cell for example:
=[OtherSpreadsheet.xls]Sheet1!B1

[leehack]

EXACT will do what you want and compare two cells.

[kessock]

Function

Thanks for the input.
The formula you wrote duncan is the sort of thing I have managed to do before.
However, I really need to to look for a part number in say row A and then input the data price the price column say E.
Is there a way of doing this.
Otherwise it means going through and creating every single formula.
I realise I can drag and drop but the spreadsheets provided to me by suppliers are not in a sensible order so this would make an import messy and time consuming to do meaning that manually creating the sheet as I have before would be better.
Cheers.
Mark

[Duncan Rounding]

Look at making a simple macro in Excel that looks for an EXACT match then moves across and copies the data to another location.

Macros are easy in Excel - just make a simple sample, record it and then edit it.