Hi
How big are your images? There's no visual feedback while uploading the images. You have to wait until they appear on the preview.
For your excel import problem: Can you provide some test data? I imported several hundreds of images without problem.
I do not have a clean-db script. I would do backups and rollback on a test environment.

[Edit]
I see you are using a sub portal (portals/1/) and not the default portal (portals/0/) for your shop. I never tested this. As HC was bundled with DNN before there could be a (potential) problem with this setup. Cannot test this atm.
[/Edit]

Hi Reto,
Thank you for you reply.

Images are not that big, majority are around 400 x 400 px at 35kb. this isnt the issue.
I had orginally been able to import images into products via spreedsheet, it had worked the first 5 times I imported (including uploading category images manually). Different portals does not seem to be the issue as I have had this store working fine on other portals.

The issue is that after I had cleared the database of products and categories using the SQL console I could not upload images, as from the error it seems whatever is recreating the images as small and medium is having issues. (hence the error message "System.ArgumentException: Unable to create temporary file: {0}The file exists. at Hotcakes.Web.TempFiles.GetTemporaryFileInfo() at Hotcakes.Web.Images.ShrinkImageFileOnDisk(String originalFile, String newFileName, Int32 maxWidth, Int32 maxHeight) ")

I had used these to clear the database. - This makes me think there is another table i have not cleared yet.
DELETE FROM
{databaseOwner}{objectQualifier}hcc_categoryxproperty
DELETE FROM
{databaseOwner}{objectQualifier}hcc_category
DELETE FROM
{databaseOwner}{objectQualifier}hcc_product
DELETE FROM
{databaseOwner}{objectQualifier}hcc_productimage

I have 1900 products that I've been trying to import, everything but the images are working. (but the images were working before i cleared the database)

I hope im making sense :)

When you deleted the shop data from the database, did you delete the data in the following directories too?
[list][*]"\Portals\0\Hotcakes\Data\products\"
[*]"\Portals\0\Hotcakes\Data\categoryicons\"
[*]"\Portals\0\Hotcakes\Data\categorybanners\"[/list]

Yes, I had removed content from those directories (apart from the categorybanners as there was nothing in this folder).

I've had no progress on this issue so far, so it looks like I might need to uninstall this module and possibly spin up a new instance / database. then reinstall. It is most likley due to removing the Products from the database via SQL console has cause this issue.