Updating Configurable price in the databaseMagento Configurable Product Price Overriding Simple Product...
What materials can be used to make a humanoid skin warm?
How to draw dashed arc of a circle behind pyramid?
In the late 1940’s to early 1950’s what technology was available that could melt a LOT of ice?
How do we create new idioms and use them in a novel?
How exactly does an Ethernet collision happen in the cable, since nodes use different circuits for Tx and Rx?
Has a sovereign Communist government ever run, and conceded loss, on a fair election?
What is Tony Stark injecting into himself in Iron Man 3?
Should I take out a loan for a friend to invest on my behalf?
What is better: yes / no radio, or simple checkbox?
Is a piano played in the same way as a harmonium?
Was it really inappropriate to write a pull request for the company I interviewed with?
Do I really need to have a scientific explanation for my premise?
Are small insurances worth it?
Determining optimum shared school bus route to a single destination from multiple origin points
Shifting between bemols (flats) and diesis (sharps)in the key signature
When a wind turbine does not produce enough electricity how does the power company compensate for the loss?
Source permutation
Why aren't there more Gauls like Obelix?
Trig Subsitution When There's No Square Root
I can't die. Who am I?
Which situations would cause a company to ground or recall a aircraft series?
Can I negotiate a patent idea for a raise, under French law?
Getting the || sign while using Kurier
What do *foreign films* mean for an American?
Updating Configurable price in the database
Magento Configurable Product Price Overriding Simple Product PriceHow can I delete configurable product attributes?Updating Configurable Products Constraint ExceptionGetting The Configurable Front End Product To Display The Cheapest Simple Product Price As A 'From' PriceCreate categories through installerHow to create/update bulk of products at a time programmaticallyHelp with script to convert bundle products to configurableHow to get the price of all simple products assigned to configurable products in magento 2?Get Configurable Product Price When Using Lowest Price Simple ExtensionFatal error: Uncaught Error: Call to a member function getId() on null in
I need to update the Price for all configurable products in the database but I am not sure what table or column to use within my query.
I am almost there as I can enter the lowest priced simple product Price for all configurable products in a new table I created but what I need is to update the current price of the configurable products.
require_once('app/Mage.php');
umask(0);
Mage::app();
include 'pathtocredentials.php';
$con = mysqli_connect ($host, $username, $password, $dbname);
$configurable = Mage::getResourceModel('catalog/product_collection')->addAttributeToFilter('type_id', array('eq' => 'configurable'));
foreach ($configurable as $_configurableproduct) {
$product = Mage::getModel('catalog/product')->load($_configurableproduct->getId());
$id = $product->getId();
$price = $product->getFinalprice();
mysqli_query($con,"UPDATE some_table SET some_column=$price WHERE id=$id";
}
mysqli_close($con);
php configurable-product database simple-product
add a comment |
I need to update the Price for all configurable products in the database but I am not sure what table or column to use within my query.
I am almost there as I can enter the lowest priced simple product Price for all configurable products in a new table I created but what I need is to update the current price of the configurable products.
require_once('app/Mage.php');
umask(0);
Mage::app();
include 'pathtocredentials.php';
$con = mysqli_connect ($host, $username, $password, $dbname);
$configurable = Mage::getResourceModel('catalog/product_collection')->addAttributeToFilter('type_id', array('eq' => 'configurable'));
foreach ($configurable as $_configurableproduct) {
$product = Mage::getModel('catalog/product')->load($_configurableproduct->getId());
$id = $product->getId();
$price = $product->getFinalprice();
mysqli_query($con,"UPDATE some_table SET some_column=$price WHERE id=$id";
}
mysqli_close($con);
php configurable-product database simple-product
add a comment |
I need to update the Price for all configurable products in the database but I am not sure what table or column to use within my query.
I am almost there as I can enter the lowest priced simple product Price for all configurable products in a new table I created but what I need is to update the current price of the configurable products.
require_once('app/Mage.php');
umask(0);
Mage::app();
include 'pathtocredentials.php';
$con = mysqli_connect ($host, $username, $password, $dbname);
$configurable = Mage::getResourceModel('catalog/product_collection')->addAttributeToFilter('type_id', array('eq' => 'configurable'));
foreach ($configurable as $_configurableproduct) {
$product = Mage::getModel('catalog/product')->load($_configurableproduct->getId());
$id = $product->getId();
$price = $product->getFinalprice();
mysqli_query($con,"UPDATE some_table SET some_column=$price WHERE id=$id";
}
mysqli_close($con);
php configurable-product database simple-product
I need to update the Price for all configurable products in the database but I am not sure what table or column to use within my query.
I am almost there as I can enter the lowest priced simple product Price for all configurable products in a new table I created but what I need is to update the current price of the configurable products.
require_once('app/Mage.php');
umask(0);
Mage::app();
include 'pathtocredentials.php';
$con = mysqli_connect ($host, $username, $password, $dbname);
$configurable = Mage::getResourceModel('catalog/product_collection')->addAttributeToFilter('type_id', array('eq' => 'configurable'));
foreach ($configurable as $_configurableproduct) {
$product = Mage::getModel('catalog/product')->load($_configurableproduct->getId());
$id = $product->getId();
$price = $product->getFinalprice();
mysqli_query($con,"UPDATE some_table SET some_column=$price WHERE id=$id";
}
mysqli_close($con);
php configurable-product database simple-product
php configurable-product database simple-product
edited Feb 2 '16 at 23:09
Mike Tim Turner
asked Feb 2 '16 at 23:02
Mike Tim TurnerMike Tim Turner
559421
559421
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I am unable to comment currently, however I can guide you:
Price is stored on the catalog_product_entity_decimal table linked to product ID (called entity_id)
So your query would now be
mysqli_query($con,"UPDATE catalog_product_entity_decimal SET value=$price WHERE entity_id=$id");
You might want to try and see if this works for you.
Note: Please take database backup before doing this.
I will try this soon thanks. I'm curious. Would it be "WHERE entity_id=$id" ?
– Mike Tim Turner
Feb 3 '16 at 8:17
That's right. Updated my answer.
– Shivani
Feb 3 '16 at 8:37
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%2f100124%2fupdating-configurable-price-in-the-database%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
I am unable to comment currently, however I can guide you:
Price is stored on the catalog_product_entity_decimal table linked to product ID (called entity_id)
So your query would now be
mysqli_query($con,"UPDATE catalog_product_entity_decimal SET value=$price WHERE entity_id=$id");
You might want to try and see if this works for you.
Note: Please take database backup before doing this.
I will try this soon thanks. I'm curious. Would it be "WHERE entity_id=$id" ?
– Mike Tim Turner
Feb 3 '16 at 8:17
That's right. Updated my answer.
– Shivani
Feb 3 '16 at 8:37
add a comment |
I am unable to comment currently, however I can guide you:
Price is stored on the catalog_product_entity_decimal table linked to product ID (called entity_id)
So your query would now be
mysqli_query($con,"UPDATE catalog_product_entity_decimal SET value=$price WHERE entity_id=$id");
You might want to try and see if this works for you.
Note: Please take database backup before doing this.
I will try this soon thanks. I'm curious. Would it be "WHERE entity_id=$id" ?
– Mike Tim Turner
Feb 3 '16 at 8:17
That's right. Updated my answer.
– Shivani
Feb 3 '16 at 8:37
add a comment |
I am unable to comment currently, however I can guide you:
Price is stored on the catalog_product_entity_decimal table linked to product ID (called entity_id)
So your query would now be
mysqli_query($con,"UPDATE catalog_product_entity_decimal SET value=$price WHERE entity_id=$id");
You might want to try and see if this works for you.
Note: Please take database backup before doing this.
I am unable to comment currently, however I can guide you:
Price is stored on the catalog_product_entity_decimal table linked to product ID (called entity_id)
So your query would now be
mysqli_query($con,"UPDATE catalog_product_entity_decimal SET value=$price WHERE entity_id=$id");
You might want to try and see if this works for you.
Note: Please take database backup before doing this.
edited 17 mins ago
Teja Bhagavan Kollepara
2,98641947
2,98641947
answered Feb 3 '16 at 7:55
ShivaniShivani
51125
51125
I will try this soon thanks. I'm curious. Would it be "WHERE entity_id=$id" ?
– Mike Tim Turner
Feb 3 '16 at 8:17
That's right. Updated my answer.
– Shivani
Feb 3 '16 at 8:37
add a comment |
I will try this soon thanks. I'm curious. Would it be "WHERE entity_id=$id" ?
– Mike Tim Turner
Feb 3 '16 at 8:17
That's right. Updated my answer.
– Shivani
Feb 3 '16 at 8:37
I will try this soon thanks. I'm curious. Would it be "WHERE entity_id=$id" ?
– Mike Tim Turner
Feb 3 '16 at 8:17
I will try this soon thanks. I'm curious. Would it be "WHERE entity_id=$id" ?
– Mike Tim Turner
Feb 3 '16 at 8:17
That's right. Updated my answer.
– Shivani
Feb 3 '16 at 8:37
That's right. Updated my answer.
– Shivani
Feb 3 '16 at 8:37
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%2f100124%2fupdating-configurable-price-in-the-database%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