Hjdcti

Getting Stale Gas Out of a Gas Tank w/out Dropping the Tank

Aggressive Under-Indexing and no data for missing index

Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico

Cannot shrink btrfs filesystem although there is still data and metadata space left : ERROR: unable to resize '/home': No space left on device

From jafe to El-Guest

Players Circumventing the limitations of Wish

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

Why don't programming languages automatically manage the synchronous/asynchronous problem?

TikZ: How to fill area with a special pattern?

How to use ReplaceAll on an expression that contains a rule

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

Audio Conversion With ADS1243

Physiological effects of huge anime eyes

How do I fit a non linear curve?

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

IC has pull-down resistors on SMBus lines?

Purpose of level-shifter with same in and out voltages

Film where the government was corrupt with aliens, people sent to kill aliens are given rigged visors not showing the right aliens

Why did early computer designers eschew integers?

Free fall ellipse or parabola?

Is there a reasonable and studied concept of reduction between regular languages?

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

Why am I getting "Static method cannot be referenced from a non static context: String String.valueOf(Object)"?

Man transported from Alternate World into ours by a Neutrino Detector

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♦ 6 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♦ 6 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