PV
Asked
Hello support team,
we have a problem of finding the product and making report because the sale report when we export there is no item code mentioned or included in the excel exported, so it make us a bit hard to check against stock count.
--> please see my attachment --> it is hard for us to check cause no item code mentioned in the list
is there a way that we can also include item code in the exported sale report?
thanks.
we have a problem of finding the product and making report because the sale report when we export there is no item code mentioned or included in the excel exported, so it make us a bit hard to check against stock count.
--> please see my attachment --> it is hard for us to check cause no item code mentioned in the list
is there a way that we can also include item code in the exported sale report?
thanks.
- EGAnsweredI have done similar modification for a client. You will need to modify the following scripts `Report.php`, `core.js`, and sales report view file `themes/default/admin/view/reports/sales.php`.
In Report controller `app/controllers/admin/Report.php` modify `getSalesReport` method by adding product_code to the concatenated `item_nane` alias.
In Core js script `themes\default\admin\assets\js\core.js` you will need to create a replicate of `pqFormat` method/function as other scripts depend on the function.
Then modify the replicated function to include value for product code in the concatenated variable `item_nane` alias. See the example below.
function pqcFormat(x) {
if (x != null) {
var d = '',
pqc = x.split('___');
for (index = 0; index < pqc.length; ++index) {
var pq = pqc[index];
var v = pq.split('__');
d += v[0] + ' (Qty: ' + formatQuantity2(v[1]) + ') (Code: ' + v[2] + ')<br>';
}
return d;
} else {
return '';
}
} - MSAnsweredHello,
There is no option to add item code as you want. You will need to modify the item code to get desired results.
Thank you - Login to Reply