Updating products using Excel

[Redrosemobility]

Hi,

I'm hoping someone on the forum might be able to help me.

My main supplier has just changed their stock range and made price increases across my whole product range. Also, they have introduced new products and discontinued some.

They have provided me with an excel spreadsheet with all the information on, but I was wondering if there was an easy way of importing this into Bluepark, but updating the products that I already have on my site?

They have also provided me with with a disc of images named with the product codes, is there a better way of linking the images to my products than going into Bluepark and individually uploading them for each product?

Any help with both problems would be really appreciated.

Thanks in advance

Matt
Red Rose Mobility

[Red Devil]

Using the Product Import facility you can update your products using a CSV file, so in Excel just save the file as a CSV file.

If the SKU numbers on the CSV file are the same as those on your site, the import will update those and only those on your site. It will not create any new products unless you provide a product title as well. So, for example, to update only the products you want with their new prices, your CSV file should only contain the SKU and the Selling price.



SKU

Price



1

10.00






As with all updates, make sure you take a full backup of all your products first using the Complete Export template in the Product Export facility.

With regards to uploading multiple images for your products, it is best to do this using FTP. FTP your images to the user/products/large folder. Then using another CSV file (created in Excel) you can generate the corresponding main, thumbnail and basket images and also resize the large image if it is too big using the following command.

Try it with a few products to start with until you perfect the process. You can repeat the process as many times as you like on the same products and each time it will resize the images based on the "large" image.



SKU

Image

Large

Main

Thumb

Basket



1

products/large/photo1.jpg

create (600,600)

create (300,300)

create (100,100)

create (50,50)

[Redrosemobility]

Many thanks Red Devil,

I've uploaded all the images using FTP, and I've now managed to update the products that I have on my website. Just wondering if I can pick your brain again?

On the example you've given for the images using excel, is there a quicker way of getting the photo1.jpg at the end of the image path, rather than typing each image name at the end of the line? The images are the same name as the SKU code. I have about 2000 to do so you can see why I'm trying to save the time.

Many Thanks!

Matt
www.redrosemobility.co.uk

[Red Devil]

In Excel you can use the CONCATENATE command to join cells together to produce another cell containing the data you want.

Copy the command down all the rows for column "C"

e.g

Column "C" will contain the command =CONCATENATE(B1&A1&".jpg")



A (SKU)
B (Path)
C (Result)


1
products/large/

products/large/1.jpg

[Redrosemobility]

Thank you, you're an absolute star!

I've never been too good on Excel.....better get learning fast I think :-)

Thanks again.

Matt