Ggtkuk

Gantt Chart like rectangles with log scale

Are ETF trackers fundamentally better than individual stocks?

Opacity of an object in 2.8

How can I track script which gives me "command not found" right after the login?

Why do Australian milk farmers need to protest supermarkets' milk price?

Why is the President allowed to veto a cancellation of emergency powers?

Python if-else code style for reduced code for rounding floats

How to explain that I do not want to visit a country due to personal safety concern?

What should tie a collection of short-stories together?

How to create the Curved texte?

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

Employee lack of ownership

Sailing the cryptic seas

Does Mathematica reuse previous computations?

What did Alexander Pope mean by "Expletives their feeble Aid do join"?

Awsome yet unlucky path traversal

Existence of subset with given Hausdorff dimension

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

Interplanetary conflict, some disease destroys the ability to understand or appreciate music

Do I need to be arrogant to get ahead?

Could the Saturn V actually have launched astronauts around Venus?

Happy pi day, everyone!

What is the significance behind "40 days" that often appears in the Bible?

How to deal with a cynical class?

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

Products not showing up when disabled on All Store Views and enabled on Specific Store ViewHow to set using default value from “Main Website” for product?Include in Menu for all store views in Magento 2Importing Product image in Magento 2How to remove products linked to another store view?Override Store View … “Enable Product” with “Use Default Value” for all ProductsHow can I move all customers to a different Website in Magento2?Magento 2.2 - Need same images for different productsMagento2 How to remove SID when I have multi-website running in one installationImporting product images from URL problem

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 hours 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 hours 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 hours ago

Efex

asked Mar 11 at 21:47

EfexEfex

296

share|improve this question

edited 5 hours ago

Efex

asked Mar 11 at 21:47

EfexEfex

296

share|improve this question

edited 5 hours 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
  Mar 13 at 0:58
  

  
  
  
  

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
  Mar 13 at 0:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please check with 'catalog_product_entity_media_gallery_value' this table.
  
  – Anas Mansuri
  21 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
  Mar 13 at 0:58
  

  
  
  
  

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
  Mar 13 at 0:58
  

  
  
  
  

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
  Mar 13 at 0:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please check with 'catalog_product_entity_media_gallery_value' this table.
  
  – Anas Mansuri
  21 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
  Mar 13 at 0:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please check with 'catalog_product_entity_media_gallery_value' this table.
  
  – Anas Mansuri
  21 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