How to find and replace product title using sql queryHow to import product excel data list into magento databaseUpdate Product Prices and Images Using SQL QueryHow to run direct SQL query on magento and bind WHERE IN params?Retrieve product status query optimization in core magentoMagento orm model and direct SQL queryHow to optimize the query: the product qty bought with each of the productsMagento 2: How to get product name by sql query using product IDMagento 2: Get Product URL and SKU using SQL QueryConvert a sql query to magentoSQL query kills entire server
Bridge building with irregular planks
Quasinilpotent , non-compact operators
User Story breakdown - Technical Task + User Feature
Why does AES have exactly 10 rounds for a 128-bit key, 12 for 192 bits and 14 for a 256-bit key size?
Does IPv6 have similar concept of network mask?
Can I still be respawned if I die by falling off the map?
Yosemite Fire Rings - What to Expect?
Creepy dinosaur pc game identification
Does Doodling or Improvising on the Piano Have Any Benefits?
What does "Scientists rise up against statistical significance" mean? (Comment in Nature)
Probability that THHT occurs in a sequence of 10 coin tosses
What to do if you miss a job interview (deliberately)?
Electoral considerations aside, what are potential benefits, for the US, of policy changes proposed by the tweet recognizing Golan annexation?
How do you make your own symbol when Detexify fails?
Is this toilet slogan correct usage of the English language?
Fear of getting stuck on one programming language / technology that is not used in my country
What features enable the Su-25 Frogfoot to operate with such a wide variety of fuels?
Does an advisor owe his/her student anything? Will an advisor keep a PhD student only out of pity?
Quoting Keynes in a lecture
Angel of Condemnation - Exile creature with second ability
Can disgust be a key component of horror?
Are Captain Marvel's powers affected by Thanos' actions in Infinity War
Shouldn’t conservatives embrace universal basic income?
15% tax on $7.5k earnings. Is that right?
How to find and replace product title using sql query
How to import product excel data list into magento databaseUpdate Product Prices and Images Using SQL QueryHow to run direct SQL query on magento and bind WHERE IN params?Retrieve product status query optimization in core magentoMagento orm model and direct SQL queryHow to optimize the query: the product qty bought with each of the productsMagento 2: How to get product name by sql query using product IDMagento 2: Get Product URL and SKU using SQL QueryConvert a sql query to magentoSQL query kills entire server
I am having a magento store with English and Arabic language store view.
I am having more than 5000 products(both simple & configuable products). All the products starts from Style now i want to modify the text "Style" into "Model"
Same as well as for Arabic language store view.
I want to know, how to find the product title and replace my required text using sql query.
product database sql query
edited Nov 3 '16 at 6:51
Amit Bera♦
59.3k1675177
asked Nov 3 '16 at 6:39
XproecommerceXproecommerce
287
bumped to the homepage by Community♦ 5 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am having a magento store with English and Arabic language store view.
I am having more than 5000 products(both simple & configuable products). All the products starts from Style now i want to modify the text "Style" into "Model"
Same as well as for Arabic language store view.
I want to know, how to find the product title and replace my required text using sql query.
product database sql query
edited Nov 3 '16 at 6:51
Amit Bera♦
59.3k1675177
asked Nov 3 '16 at 6:39
XproecommerceXproecommerce
287
bumped to the homepage by Community♦ 5 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am having a magento store with English and Arabic language store view.
I am having more than 5000 products(both simple & configuable products). All the products starts from Style now i want to modify the text "Style" into "Model"
Same as well as for Arabic language store view.
I want to know, how to find the product title and replace my required text using sql query.
product database sql query
edited Nov 3 '16 at 6:51
Amit Bera♦
59.3k1675177
asked Nov 3 '16 at 6:39
XproecommerceXproecommerce
287
I am having a magento store with English and Arabic language store view.
I am having more than 5000 products(both simple & configuable products). All the products starts from Style now i want to modify the text "Style" into "Model"
Same as well as for Arabic language store view.
I want to know, how to find the product title and replace my required text using sql query.
product database sql query
product database sql query
edited Nov 3 '16 at 6:51
Amit Bera♦
59.3k1675177
asked Nov 3 '16 at 6:39
XproecommerceXproecommerce
287
edited Nov 3 '16 at 6:51
Amit Bera♦
59.3k1675177
asked Nov 3 '16 at 6:39
XproecommerceXproecommerce
287
edited Nov 3 '16 at 6:51
Amit Bera♦
59.3k1675177
edited Nov 3 '16 at 6:51
Amit Bera♦
59.3k1675177
edited Nov 3 '16 at 6:51
Amit Bera♦
59.3k1675177
59.3k1675177
asked Nov 3 '16 at 6:39
XproecommerceXproecommerce
287
asked Nov 3 '16 at 6:39
XproecommerceXproecommerce
287
asked Nov 3 '16 at 6:39
XproecommerceXproecommerce
287
287
bumped to the homepage by Community♦ 5 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 5 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
In ,default magento product details page title has been set from meta_title attribute.
This attribute is a varchar attribute and it attribute code can be found at eav_attribute.
select * from eav_attribute where attribute_code = 'meta_title' and entity_type_id =4
As this a varchar attribute then it value, is saved catalog_product_entity_varchar table.
So, you need to run your query at this table
Query
UPDATE value
SET value = Replace(url, 'Style', 'Model')
WHERE attribute_id = (SELECT attribute_id
FROM eav_attribute
WHERE attribute_code = 'meta_title'
AND entity_type_id = 4)
AND store_id = your_store_id
answered Nov 3 '16 at 7:01
Amit Bera♦Amit Bera
59.3k1675177
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%2f143885%2fhow-to-find-and-replace-product-title-using-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
In ,default magento product details page title has been set from meta_title attribute.
This attribute is a varchar attribute and it attribute code can be found at eav_attribute.
select * from eav_attribute where attribute_code = 'meta_title' and entity_type_id =4
As this a varchar attribute then it value, is saved catalog_product_entity_varchar table.
So, you need to run your query at this table
Query
UPDATE value
SET value = Replace(url, 'Style', 'Model')
WHERE attribute_id = (SELECT attribute_id
FROM eav_attribute
WHERE attribute_code = 'meta_title'
AND entity_type_id = 4)
AND store_id = your_store_id
answered Nov 3 '16 at 7:01
Amit Bera♦Amit Bera
59.3k1675177
add a comment |
In ,default magento product details page title has been set from meta_title attribute.
This attribute is a varchar attribute and it attribute code can be found at eav_attribute.
select * from eav_attribute where attribute_code = 'meta_title' and entity_type_id =4
As this a varchar attribute then it value, is saved catalog_product_entity_varchar table.
So, you need to run your query at this table
Query
UPDATE value
SET value = Replace(url, 'Style', 'Model')
WHERE attribute_id = (SELECT attribute_id
FROM eav_attribute
WHERE attribute_code = 'meta_title'
AND entity_type_id = 4)
AND store_id = your_store_id
answered Nov 3 '16 at 7:01
Amit Bera♦Amit Bera
59.3k1675177
add a comment |
In ,default magento product details page title has been set from meta_title attribute.
This attribute is a varchar attribute and it attribute code can be found at eav_attribute.
select * from eav_attribute where attribute_code = 'meta_title' and entity_type_id =4
As this a varchar attribute then it value, is saved catalog_product_entity_varchar table.
So, you need to run your query at this table
Query
UPDATE value
SET value = Replace(url, 'Style', 'Model')
WHERE attribute_id = (SELECT attribute_id
FROM eav_attribute
WHERE attribute_code = 'meta_title'
AND entity_type_id = 4)
AND store_id = your_store_id
answered Nov 3 '16 at 7:01
Amit Bera♦Amit Bera
59.3k1675177
In ,default magento product details page title has been set from meta_title attribute.
This attribute is a varchar attribute and it attribute code can be found at eav_attribute.
select * from eav_attribute where attribute_code = 'meta_title' and entity_type_id =4
As this a varchar attribute then it value, is saved catalog_product_entity_varchar table.
So, you need to run your query at this table
Query
UPDATE value
SET value = Replace(url, 'Style', 'Model')
WHERE attribute_id = (SELECT attribute_id
FROM eav_attribute
WHERE attribute_code = 'meta_title'
AND entity_type_id = 4)
AND store_id = your_store_id
answered Nov 3 '16 at 7:01
Amit Bera♦Amit Bera
59.3k1675177
answered Nov 3 '16 at 7:01
Amit Bera♦Amit Bera
59.3k1675177
answered Nov 3 '16 at 7:01
Amit Bera♦Amit Bera
59.3k1675177
answered Nov 3 '16 at 7:01
Amit Bera♦Amit Bera
59.3k1675177
59.3k1675177
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%2f143885%2fhow-to-find-and-replace-product-title-using-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
