How can I remove all products images for a specific store with SQL query?
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
edited 8 mins 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
edited 8 mins 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
edited 8 mins ago
magefms
1,298221
asked 6 hours ago
EfexEfex
196
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
magento2 magento2.3
edited 8 mins ago
magefms
1,298221
asked 6 hours ago
EfexEfex
196
edited 8 mins ago
magefms
1,298221
asked 6 hours ago
EfexEfex
196
edited 8 mins ago
magefms
1,298221
edited 8 mins ago
magefms
1,298221
edited 8 mins ago
magefms
1,298221
1,298221
asked 6 hours ago
EfexEfex
196
asked 6 hours ago
EfexEfex
196
asked 6 hours ago
EfexEfex
196
196
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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/*
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
});
}
});
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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/*
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/*
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/*
answered 4 hours ago
gabehougabehou
18511
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/*
answered 4 hours ago
gabehougabehou
18511
edited 4 hours ago
answered 4 hours ago
gabehougabehou
18511
answered 4 hours ago
gabehougabehou
18511
answered 4 hours ago
gabehougabehou
18511
18511
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
