Adding images to DB via SQL

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
11 years ago
Hello,

I am wondering how can I add images to the database via sql?
I noticed two tables:
[Picture]
[Product_Picture_Mapping]

foe example: I have [ProductId] 1000467

I add to [Picture] record:
ID: 88
PictureBinary: 0x
MimeType: image/jpeg
SeoFilename: 1000467
IsNew: 0

Then I add [Product_Picture_Mapping] records:
ProductId: 1000467
PictureId: 88
DisplayOrder: 0

What should I do next??
0
11 years ago
Anyone?
0
11 years ago
OK, got the thing working.

The image must be uploaded to: Images folder and if picture id is 88, when image name must be 0000088_0.jpeg
0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.