Mryntu

Professor being mistaken for a grad student

Why doesn't using two cd commands in bash script execute the second command?

Site Collection Administrator has left the building

Is a party consisting of only a bard, a cleric, and a warlock functional long-term?

What are substitutions for coconut in curry?

AG Cluster db upgrade by vendor

how to write formula in word in latex

Instead of Universal Basic Income, why not Universal Basic NEEDS?

Most cost effective thermostat setting: consistent temperature vs. lowest temperature possible

Who is flying the vertibirds?

Can I use USB data pins as power source

My adviser wants to be the first author

How to write cleanly even if my character uses expletive language?

Are all passive ability checks floors for active ability checks?

Pólya urn flip and roll

Are ETF trackers fundamentally better than individual stocks?

What's causing this power spike in STM32 low power mode

Why would a flight no longer considered airworthy be redirected like this?

Equilateral triangle on a concentric circle

A link redirect to http instead of https: how critical is it?

Life insurance that covers only simultaneous/dual deaths

Logical notation

How to create the Curved texte?

How to terminate ping <dest> &

How can I remove all products images for a specific store/website?

How to optimize the query: the product qty bought with each of the productsmagento 2 web rest api - Get all products with a specific attribute codeProducts not showing up when disabled on All Store Views and enabled on Specific Store ViewMagento 2 import products with imagesHow to remove products linked to another store view?Override Store View … “Enable Product” with “Use Default Value” for all ProductsCan't remove or hide product images with CSV importSupplier,Brand,Category Name fetch of all products from sql ? magento2Magento 2.2 - Need same images for different productsMagento 2: SQL select all attributes for all products

3

When I import CSV file for products I got every time duplicate products images.

I must import the CSV file every time with products images value for all products there for I got duplicate products images.

Now, I must remove all products images for a specific store/website before import same products with CSV.

magento2 magento2.3

share|improve this question

edited 5 mins ago

Efex

asked Mar 11 at 21:47

EfexEfex

296

add a comment | 

3

When I import CSV file for products I got every time duplicate products images.

I must import the CSV file every time with products images value for all products there for I got duplicate products images.

Now, I must remove all products images for a specific store/website before import same products with CSV.

magento2 magento2.3

share|improve this question

edited 5 mins ago

Efex

asked Mar 11 at 21:47

EfexEfex

296

add a comment | 

When I import CSV file for products I got every time duplicate products images.

I must import the CSV file every time with products images value for all products there for I got duplicate products images.

Now, I must remove all products images for a specific store/website before import same products with CSV.

magento2 magento2.3

share|improve this question

edited 5 mins ago

Efex

asked Mar 11 at 21:47

EfexEfex

296

share|improve this question

edited 5 mins ago

Efex

asked Mar 11 at 21:47

EfexEfex

296

share|improve this question

edited 5 mins ago

Efex

asked Mar 11 at 21:47

EfexEfex

296

asked Mar 11 at 21:47

EfexEfex

296

asked Mar 11 at 21:47

EfexEfex

296

2 Answers
2

active

oldest

votes

1

The following SQL will remove all images and labels from the database

DELETE FROM catalog_product_entity_varchar
WHERE attribute_id IN (SELECT attribute_id
 FROM `eav_attribute`
 WHERE store_id = REPLACE_WITH_STORE_ID and attribute_code IN (
 'small_image', 
 'small_image_label',
 'image',
 'image_label',
 'thumbnail',
 'thumbnail_label' )) 

Also run the following to remove the images from the server

rm -rf pub/media/catalog/*

share|improve this answer

edited Mar 12 at 0:16

answered Mar 12 at 0:02

gabehougabehou

19511

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It's not working.
  
  – Efex
  2 days ago
  

  
  
  
  

add a comment | 

0

Please try with below query which is remove your primary image.

DELETE FROM catalog_product_entity_varchar WHERE attribute_id IN (87,88,89) AND entity_id='product_id'

second query here

DELETE FROM catalog_product_entity_media_gallery WHERE attribute_id=90 and entity_id='product_id'

Note : Please verify attribute_id in eav_attribute table like value is base, thumnail, small_image.

share|improve this answer

answered Mar 12 at 13:02

Anas MansuriAnas Mansuri

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I need it for a specific store.
  
  – Efex
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please check with 'catalog_product_entity_media_gallery_value' this table.
  
  – Anas Mansuri
  15 hours ago
  
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f265375%2fhow-can-i-remove-all-products-images-for-a-specific-store-website%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

The following SQL will remove all images and labels from the database

DELETE FROM catalog_product_entity_varchar
WHERE attribute_id IN (SELECT attribute_id
 FROM `eav_attribute`
 WHERE store_id = REPLACE_WITH_STORE_ID and attribute_code IN (
 'small_image', 
 'small_image_label',
 'image',
 'image_label',
 'thumbnail',
 'thumbnail_label' )) 

Also run the following to remove the images from the server

rm -rf pub/media/catalog/*

share|improve this answer

edited Mar 12 at 0:16

answered Mar 12 at 0:02

gabehougabehou

19511

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It's not working.
  
  – Efex
  2 days ago
  

  
  
  
  

add a comment | 

1

The following SQL will remove all images and labels from the database

DELETE FROM catalog_product_entity_varchar
WHERE attribute_id IN (SELECT attribute_id
 FROM `eav_attribute`
 WHERE store_id = REPLACE_WITH_STORE_ID and attribute_code IN (
 'small_image', 
 'small_image_label',
 'image',
 'image_label',
 'thumbnail',
 'thumbnail_label' )) 

Also run the following to remove the images from the server

rm -rf pub/media/catalog/*

share|improve this answer

edited Mar 12 at 0:16

answered Mar 12 at 0:02

gabehougabehou

19511

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It's not working.
  
  – Efex
  2 days ago
  

  
  
  
  

add a comment | 

The following SQL will remove all images and labels from the database

DELETE FROM catalog_product_entity_varchar
WHERE attribute_id IN (SELECT attribute_id
 FROM `eav_attribute`
 WHERE store_id = REPLACE_WITH_STORE_ID and attribute_code IN (
 'small_image', 
 'small_image_label',
 'image',
 'image_label',
 'thumbnail',
 'thumbnail_label' )) 

Also run the following to remove the images from the server

rm -rf pub/media/catalog/*

share|improve this answer

edited Mar 12 at 0:16

answered Mar 12 at 0:02

gabehougabehou

19511

DELETE FROM catalog_product_entity_varchar
WHERE attribute_id IN (SELECT attribute_id
 FROM `eav_attribute`
 WHERE store_id = REPLACE_WITH_STORE_ID and attribute_code IN (
 'small_image', 
 'small_image_label',
 'image',
 'image_label',
 'thumbnail',
 'thumbnail_label' )) 

share|improve this answer

edited Mar 12 at 0:16

answered Mar 12 at 0:02

gabehougabehou

19511

answered Mar 12 at 0:02

gabehougabehou

19511

answered Mar 12 at 0:02

gabehougabehou

19511

0

Please try with below query which is remove your primary image.

DELETE FROM catalog_product_entity_varchar WHERE attribute_id IN (87,88,89) AND entity_id='product_id'

second query here

DELETE FROM catalog_product_entity_media_gallery WHERE attribute_id=90 and entity_id='product_id'

Note : Please verify attribute_id in eav_attribute table like value is base, thumnail, small_image.

share|improve this answer

answered Mar 12 at 13:02

Anas MansuriAnas Mansuri

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I need it for a specific store.
  
  – Efex
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please check with 'catalog_product_entity_media_gallery_value' this table.
  
  – Anas Mansuri
  15 hours ago
  
  

  
  
  
  

add a comment | 

0

Please try with below query which is remove your primary image.

DELETE FROM catalog_product_entity_varchar WHERE attribute_id IN (87,88,89) AND entity_id='product_id'

second query here

DELETE FROM catalog_product_entity_media_gallery WHERE attribute_id=90 and entity_id='product_id'

Note : Please verify attribute_id in eav_attribute table like value is base, thumnail, small_image.

share|improve this answer

answered Mar 12 at 13:02

Anas MansuriAnas Mansuri

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I need it for a specific store.
  
  – Efex
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please check with 'catalog_product_entity_media_gallery_value' this table.
  
  – Anas Mansuri
  15 hours ago
  
  

  
  
  
  

add a comment | 

Please try with below query which is remove your primary image.

DELETE FROM catalog_product_entity_varchar WHERE attribute_id IN (87,88,89) AND entity_id='product_id'

second query here

DELETE FROM catalog_product_entity_media_gallery WHERE attribute_id=90 and entity_id='product_id'

Note : Please verify attribute_id in eav_attribute table like value is base, thumnail, small_image.

share|improve this answer

answered Mar 12 at 13:02

Anas MansuriAnas Mansuri

11

DELETE FROM catalog_product_entity_varchar WHERE attribute_id IN (87,88,89) AND entity_id='product_id'

DELETE FROM catalog_product_entity_media_gallery WHERE attribute_id=90 and entity_id='product_id'

share|improve this answer

answered Mar 12 at 13:02

Anas MansuriAnas Mansuri

11

answered Mar 12 at 13:02

Anas MansuriAnas Mansuri

11

answered Mar 12 at 13:02

Anas MansuriAnas Mansuri

11