Gsyfuy

In the "Harry Potter and the Order of the Phoenix" video game, what potion is used to sabotage Umbridge's speakers?

Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?

Is it professional to write unrelated content in an almost-empty email?

My ex-girlfriend uses my Apple ID to login to her iPad, do I have to give her my Apple ID password to reset it?

How to get the last not-null value in an ordered column of a huge table?

Is it okay to majorly distort historical facts while writing a fiction story?

What connection does MS Office have to Netscape Navigator?

What would be the main consequences for a country leaving the WTO?

Is there such a thing as a proper verb, like a proper noun?

Which one is the true statement?

Which Pokemon have a special animation when running with them out of their pokeball?

Towers in the ocean; How deep can they be built?

Inductor and Capacitor in Parallel

Defamation due to breach of confidentiality

What are the unusually-enlarged wing sections on this P-38 Lightning?

What happened in Rome, when the western empire "fell"?

Is there a way to save my career from absolute disaster?

How did Beeri the Hittite come up with naming his daughter Yehudit?

Raspberry pi 3 B with Ubuntu 18.04 server arm64: what chip

What CSS properties can the br tag have?

Aggressive Under-Indexing and no data for missing index

What was Carter Burke's job for "the company" in Aliens?

TikZ: How to fill area with a special pattern?

Reshaping json / reparing json inside shell script (remove trailing comma)

Change Lifetime Sales Statistics in backend

0

I'm in a serious need of help as I need to alter the lifetime sales figure on my store's backend. It's for taxation purpose and I'm clueless about how I can reduce the digits mentioned in the stats. Please help me.

magento-1.9 admin backend sales

share|improve this question

asked Jul 31 '15 at 16:31

Mohit SinghMohit Singh

51113

bumped to the homepage by Community♦ 13 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 | 

0

I'm in a serious need of help as I need to alter the lifetime sales figure on my store's backend. It's for taxation purpose and I'm clueless about how I can reduce the digits mentioned in the stats. Please help me.

magento-1.9 admin backend sales

share|improve this question

asked Jul 31 '15 at 16:31

Mohit SinghMohit Singh

51113

bumped to the homepage by Community♦ 13 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'm in a serious need of help as I need to alter the lifetime sales figure on my store's backend. It's for taxation purpose and I'm clueless about how I can reduce the digits mentioned in the stats. Please help me.

magento-1.9 admin backend sales

share|improve this question

asked Jul 31 '15 at 16:31

Mohit SinghMohit Singh

51113

share|improve this question

asked Jul 31 '15 at 16:31

Mohit SinghMohit Singh

51113

share|improve this question

asked Jul 31 '15 at 16:31

Mohit SinghMohit Singh

51113

asked Jul 31 '15 at 16:31

Mohit SinghMohit Singh

51113

asked Jul 31 '15 at 16:31

Mohit SinghMohit Singh

51113

1 Answer
1

active

oldest

votes

0

To alter the lifetime sales, you can do this :

<?php



/**** Database Connection ****/

$servername = "localhost";

$username = "your_db_user";

$password = "Your_Db_Pass";

$dbname = "your_db_name";



try {

    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password, array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true));

    // set the PDO error mode to exception

    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    echo "Connected successfully<br/>";

} catch (PDOException $e) {

    echo "Connection failed: " . $e->getMessage() . "<br/>";

    exit;

}

/**** End Database Connection ****/





$getQuery = "SELECT qty_ordered, product_id FROM sales_flat_order_item";



$result = $conn->query($getQuery);



foreach ($result as $row) {

    // To reduce by 10%, for example

    $newQty = ceil($row['qty_ordered'] * .90);

    echo "ID = " . $row['product_id'] . " Original Qty = " . $row['qty_ordered'] . "<br/>";

    echo "New Qty = $newQty<br/>";

    $setQuery = "UPDATE sales_flat_order_item SET qty_ordered = $newQty WHERE product_id = " . $row['product_id'];

    $conn->exec($setQuery);

}

Put that into a script in your magento root and navigate to it in your browser. After you run, in the Magento backend go to Reports->Refresh Statistics and reindex all reports. I'm not sure how much you want to reduce the figures by, but if you manipulate this line $newQty = ceil($row['qty_ordered'] * .90); you should be able to get the result you are looking for.

share|improve this answer

answered Aug 1 '15 at 1:06

AreDubyaAreDubya

1,22911022

add a comment | 

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%2f76300%2fchange-lifetime-sales-statistics-in-backend%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

To alter the lifetime sales, you can do this :

<?php



/**** Database Connection ****/

$servername = "localhost";

$username = "your_db_user";

$password = "Your_Db_Pass";

$dbname = "your_db_name";



try {

    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password, array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true));

    // set the PDO error mode to exception

    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    echo "Connected successfully<br/>";

} catch (PDOException $e) {

    echo "Connection failed: " . $e->getMessage() . "<br/>";

    exit;

}

/**** End Database Connection ****/





$getQuery = "SELECT qty_ordered, product_id FROM sales_flat_order_item";



$result = $conn->query($getQuery);



foreach ($result as $row) {

    // To reduce by 10%, for example

    $newQty = ceil($row['qty_ordered'] * .90);

    echo "ID = " . $row['product_id'] . " Original Qty = " . $row['qty_ordered'] . "<br/>";

    echo "New Qty = $newQty<br/>";

    $setQuery = "UPDATE sales_flat_order_item SET qty_ordered = $newQty WHERE product_id = " . $row['product_id'];

    $conn->exec($setQuery);

}

Put that into a script in your magento root and navigate to it in your browser. After you run, in the Magento backend go to Reports->Refresh Statistics and reindex all reports. I'm not sure how much you want to reduce the figures by, but if you manipulate this line $newQty = ceil($row['qty_ordered'] * .90); you should be able to get the result you are looking for.

share|improve this answer

answered Aug 1 '15 at 1:06

AreDubyaAreDubya

1,22911022

add a comment | 

0

To alter the lifetime sales, you can do this :

<?php



/**** Database Connection ****/

$servername = "localhost";

$username = "your_db_user";

$password = "Your_Db_Pass";

$dbname = "your_db_name";



try {

    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password, array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true));

    // set the PDO error mode to exception

    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    echo "Connected successfully<br/>";

} catch (PDOException $e) {

    echo "Connection failed: " . $e->getMessage() . "<br/>";

    exit;

}

/**** End Database Connection ****/





$getQuery = "SELECT qty_ordered, product_id FROM sales_flat_order_item";



$result = $conn->query($getQuery);



foreach ($result as $row) {

    // To reduce by 10%, for example

    $newQty = ceil($row['qty_ordered'] * .90);

    echo "ID = " . $row['product_id'] . " Original Qty = " . $row['qty_ordered'] . "<br/>";

    echo "New Qty = $newQty<br/>";

    $setQuery = "UPDATE sales_flat_order_item SET qty_ordered = $newQty WHERE product_id = " . $row['product_id'];

    $conn->exec($setQuery);

}

Put that into a script in your magento root and navigate to it in your browser. After you run, in the Magento backend go to Reports->Refresh Statistics and reindex all reports. I'm not sure how much you want to reduce the figures by, but if you manipulate this line $newQty = ceil($row['qty_ordered'] * .90); you should be able to get the result you are looking for.

share|improve this answer

answered Aug 1 '15 at 1:06

AreDubyaAreDubya

1,22911022

add a comment | 

To alter the lifetime sales, you can do this :

<?php



/**** Database Connection ****/

$servername = "localhost";

$username = "your_db_user";

$password = "Your_Db_Pass";

$dbname = "your_db_name";



try {

    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password, array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true));

    // set the PDO error mode to exception

    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    echo "Connected successfully<br/>";

} catch (PDOException $e) {

    echo "Connection failed: " . $e->getMessage() . "<br/>";

    exit;

}

/**** End Database Connection ****/





$getQuery = "SELECT qty_ordered, product_id FROM sales_flat_order_item";



$result = $conn->query($getQuery);



foreach ($result as $row) {

    // To reduce by 10%, for example

    $newQty = ceil($row['qty_ordered'] * .90);

    echo "ID = " . $row['product_id'] . " Original Qty = " . $row['qty_ordered'] . "<br/>";

    echo "New Qty = $newQty<br/>";

    $setQuery = "UPDATE sales_flat_order_item SET qty_ordered = $newQty WHERE product_id = " . $row['product_id'];

    $conn->exec($setQuery);

}

Put that into a script in your magento root and navigate to it in your browser. After you run, in the Magento backend go to Reports->Refresh Statistics and reindex all reports. I'm not sure how much you want to reduce the figures by, but if you manipulate this line $newQty = ceil($row['qty_ordered'] * .90); you should be able to get the result you are looking for.

share|improve this answer

answered Aug 1 '15 at 1:06

AreDubyaAreDubya

1,22911022

<?php



/**** Database Connection ****/

$servername = "localhost";

$username = "your_db_user";

$password = "Your_Db_Pass";

$dbname = "your_db_name";



try {

    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password, array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true));

    // set the PDO error mode to exception

    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    echo "Connected successfully<br/>";

} catch (PDOException $e) {

    echo "Connection failed: " . $e->getMessage() . "<br/>";

    exit;

}

/**** End Database Connection ****/





$getQuery = "SELECT qty_ordered, product_id FROM sales_flat_order_item";



$result = $conn->query($getQuery);



foreach ($result as $row) {

    // To reduce by 10%, for example

    $newQty = ceil($row['qty_ordered'] * .90);

    echo "ID = " . $row['product_id'] . " Original Qty = " . $row['qty_ordered'] . "<br/>";

    echo "New Qty = $newQty<br/>";

    $setQuery = "UPDATE sales_flat_order_item SET qty_ordered = $newQty WHERE product_id = " . $row['product_id'];

    $conn->exec($setQuery);

}

share|improve this answer

answered Aug 1 '15 at 1:06

AreDubyaAreDubya

1,22911022

answered Aug 1 '15 at 1:06

AreDubyaAreDubya

1,22911022

answered Aug 1 '15 at 1:06

AreDubyaAreDubya

1,22911022