Gsyfuy

When a wind turbine does not produce enough electricity how does the power company compensate for the loss?

Counting all the hearts

UART pins to unpowered MCU?

PTIJ: Should I kill my computer after installing software?

Reversed Sudoku

Does the nature of the Apocalypse in The Umbrella Academy change from the first to the last episode?

Single word request: Harming the benefactor

Is it "Vierergruppe" or "Viergruppe", or is there a distinction?

Why does liquid water form when we exhale on a mirror?

Does "Until when" sound natural for native speakers?

Filtering SOQL results with optional conditionals

How can I ensure my trip to the UK will not have to be cancelled because of Brexit?

Good for you! in Russian

They call me Inspector Morse

Contract Factories

PTIJ: wiping amalek’s memory?

What are some noteworthy "mic-drop" moments in math?

What's the "normal" opposite of flautando?

What wound would be of little consequence to a biped but terrible for a quadruped?

What does "the touch of the purple" mean?

Why the color red for the Republican Party

What problems would a superhuman have whose skin is constantly hot?

Definition of Statistic

Are there historical instances of the capital of a colonising country being temporarily or permanently shifted to one of its colonies?

How can I remove all products images for a specific store with SQL query?

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

1

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 need a SQL query for remove all products images for a specific store.

magento2 magento2.3

share|improve this question

edited 46 secs ago

magefms

1,298221

asked 6 hours ago

EfexEfex

196

add a comment | 

1

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 need a SQL query for remove all products images for a specific store.

magento2 magento2.3

share|improve this question

edited 46 secs ago

magefms

1,298221

asked 6 hours ago

EfexEfex

196

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 need a SQL query for remove all products images for a specific store.

magento2 magento2.3

share|improve this question

edited 46 secs ago

magefms

1,298221

asked 6 hours ago

EfexEfex

196

share|improve this question

edited 46 secs ago

magefms

1,298221

asked 6 hours ago

EfexEfex

196

share|improve this question

edited 46 secs ago

magefms

1,298221

asked 6 hours ago

EfexEfex

196

edited 46 secs ago

magefms

1,298221

edited 46 secs ago

magefms

1,298221

asked 6 hours ago

EfexEfex

196

asked 6 hours ago

EfexEfex

196

1 Answer
1

active

oldest

votes

0

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

answered 4 hours ago

gabehougabehou

18511

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-with-sql-query%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

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

answered 4 hours ago

gabehougabehou

18511

add a comment | 

0

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

answered 4 hours ago

gabehougabehou

18511

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

answered 4 hours ago

gabehougabehou

18511

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

answered 4 hours ago

gabehougabehou

18511

answered 4 hours ago

gabehougabehou

18511

answered 4 hours ago

gabehougabehou

18511