StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14346192
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-01-15T20:23:19.430
FavoriteCount
0
LastActivityDate
2013-01-15T20:23:19.430
LastEditDate
LastEditorUserId
0
OwnerUserId
1649043
ParentId
14344218
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Here is my method for a C# version for doing it using soap... You may be wondering how I got to this.. Read the whole post. <pre><code>private void RemoveImagesFromProduct() { try { List<catalogProductImageEntity> imageList = this.mageObject.catalogProductAttributeMediaList(this.VendorProductId, null, "sku").ToList(); // execute the soap call to remove each one foreach (catalogProductImageEntity catProdImg in imageList) { this.mageObject.catalogProductAttributeMediaRemove(this.VendorProductId, catProdImg.file, "sku"); } } catch (Exception exception) { this.SetProgressErrUpdate("Remove Image Handler Error"); this.SetProgressErrUpdate(exception.Message); } } </code></pre> After determining where the soap call points to, I find that these methods are used in Core Magento: (app/code/core/Mage/Catalog/Model/Product/Attribute/Media/Api.php) <pre><code> public function items($productId, $store = null, $identifierType = null) { $product = $this->_initProduct($productId, $store, $identifierType); $gallery = $this->_getGalleryAttribute($product); $galleryData = $product->getData(self::ATTRIBUTE_CODE); if (!isset($galleryData['images']) || !is_array($galleryData['images'])) { return array(); } $result = array(); foreach ($galleryData['images'] as &$image) { $result[] = $this->_imageToArray($image, $product); } return $result; } public function remove($productId, $file, $identifierType = null) { $product = $this->_initProduct($productId, null, $identifierType); $gallery = $this->_getGalleryAttribute($product); if (!$gallery->getBackend()->getImage($product, $file)) { $this->_fault('not_exists'); } $gallery->getBackend()->removeImage($product, $file); try { $product->save(); } catch (Mage_Core_Exception $e) { $this->_fault('not_removed', $e->getMessage()); } return true; } </code></pre> At this point, I know everything that must be done to delete an image, only now a function that stands alone must be written. <pre><code>// Set the product ID here, or load a collection and foreach it and use $product->getId() $prodId = 4967; // Reload here. Collections in magento are just unpredictable sometimes! $loadedProduct = Mage::getModel('catalog/product')->load($prodId); $attributes = $loadedProduct->getTypeInstance(true)->getSetAttributes($loadedProduct); if (isset($attributes['media_gallery'])) { // From this point forward, the gallery is represented by $attributes $gallery = $attributes['media_gallery']; $galleryData = $loadedProduct->getData('media_gallery'); if (!isset($galleryData['images']) || !is_array($galleryData['images'])) { die('no images for this product'); } $result = array(); foreach ($galleryData['images'] as &$image) { $data = array( 'file' => $image['file'], 'label' => $image['label'], 'position' => $image['position'], 'exclude' => $image['disabled'], 'url' => Mage::getSingleton('catalog/product_media_config')->getMediaUrl($image['file']), 'types' => array() ); foreach ($loadedProduct->getMediaAttributes() as $attribute) { if ($loadedProduct->getData($attribute->getAttributeCode()) == $image['file']) { $data['types'][] = $attribute->getAttributeCode(); } } $result[] = $data; } // At this point all the media info will be displayed for the product // From this point forward you just need to call the same parts of the remove soap api call foreach ($result as $galleryResult) { // if the image exists, delete it. if($gallery->getBackend()->getImage($loadedProduct, $galleryResult['file'])) { $gallery->getBackend()->removeImage($loadedProduct, $galleryResult['file']); } } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POmagento delete additional images
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USCarComp
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. CODoes this code remove the additonal images?
 singulars
 PostPostId
 PO
 UserUserId
 USuser822179
2. COYes, see the part at the bottom that says "foreach ($result as $galleryResult)"? That means that it goes through each picture attached to the document and deletes it. I expect you'll just copy and paste this, so i tested it, however if you look at my entire explanation, it outlines the fundamentals how to discover the way ANY of magento's built in soap calls work by reverse engineering them. Also, set your username to something other than 'user822179'.
 singulars
 PostPostId
 PO
 UserUserId
 USCarComp

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.