I’ve managed to import a few products by creating a default product, then exporting that csv, then copy/pasting the data into the right columns.
I’ve come up with a few snags through:
1) When importing the products, they appear in the admin ready to be placed in a category, however, when placing them in a category I have to go into the product and then save it. (Granted, the first product i did this on was missing the weight and short description, so not sure if it was these 2 things stopping it from showing on the front end, anyone else been successful?)
2) When using “http:///www.foo.com/image.jpg” etc for ‘small_image / ‘thumbnail’ / ‘image’ - When it’s imported magento seems to drop these columns, I’m assuming it does a check to see if http:// exists on it, if not then disregard it? or something along these lines.
Is there anyway I can use external images? or does anyone know of any program I could download to fetch hundreds of images from the server, and perhaps some php code to then run through the directory? the images don’t follow suite of any refferencing as there stored across a couple of servers, so would need to use the current sku of the csv + these image columns to download > rename > store > parse back into another csv? But I have no idea how to do this.
3) Categorising, is there any decent / reliable method of categorising here?, the products I have each have a associated category ‘name’ with them, magento seems to use a series of numbers to disctate the category it’s held within, I can live with doing this manually to be honest if i can attach another attribute to show in the admin category products area to show an additional attribute as a fast reference.
4) Additional attributes, manufactor, colour - How does adding new attributes here work? and how do I create a new attribute to be used? can anyone explain or point me in the right direction of what each field means?