Thanks for your reply.uksitebuilder wrote:Not so simple because the Invoice gets it's data from the Order_product table which doesn't store the sku only:
order_id
product_id
name
model
quantity
price
total
tax
I see the SKU is not be stored same place as Product code, it only stored in "PRODUCT" table.felizone wrote:Thanks for your reply.uksitebuilder wrote:Not so simple because the Invoice gets it's data from the Order_product table which doesn't store the sku only:
order_id
product_id
name
model
quantity
price
total
tax
I just want to add the SKU to invoice only , NOT other places.
Any simple coding?
Thanks.
Code: Select all
public function getOrderProducts($order_id) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");
return $query->rows;
}
Code: Select all
$product_data[] = array(
'name' => $product['name'],
'model' => $product['model'],
'option' => $option_data,
'quantity' => $product['quantity'],
'price' => $this->currency->format($product['price'], $order_info['currency_code'], $order_info['currency_value']),
'total' => $this->currency->format($product['total'], $order_info['currency_code'], $order_info['currency_value'])
);
Code: Select all
'sku' => $product['sku'],
, back-ups are advised.Code: Select all
public function getOrderProducts($order_id) {
$query = $this->db->query("SELECT a.*, b.sku FROM " . DB_PREFIX . "order_product a LEFT JOIN " . DB_PREFIX . "product b ON a.product_id = b.product_id WHERE order_id = '" . (int)$order_id . "'");
return $query->rows;
}
and also try if it works when a product has no SKU.. thats why I didn't do an INNER JOIN.Oops....Teyno wrote:Got you the query, tested in in phpmyadmin and works OK
Let me know if it worksCode: Select all
public function getOrderProducts($order_id) { $query = $this->db->query("SELECT a.*, b.sku FROM " . DB_PREFIX . "order_product a LEFT JOIN " . DB_PREFIX . "product b ON a.product_id = b.product_id WHERE order_id = '" . (int)$order_id . "'"); return $query->rows; }
It works perfect.
Thanks, but it's not suitable for me to show SKU all around.nosecret wrote:I am release extension SKU in INVOICE, perhaps that suitable for you. Please check link below:
http://www.opencart.com/index.php?route ... on_id=2646
A good site for e-commerce advice.
works like a charm. I have created an very complicated way see post http://forum.opencart.com/viewtopic.php ... 878#p90940Code: Select all
<modification>
<id>SKUs on Invoice</id>
<version>1.0.0</version>
<vqmver>1.0.8</vqmver>
<author>Bedo & Teyno :)</author>
<file name="admin/model/sale/order.php">
<operation>
<search position="replace"><![CDATA[$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");]]></search>
<add><![CDATA[
$query = $this->db->query("SELECT a.*, b.sku FROM " . DB_PREFIX . "order_product a LEFT JOIN " . DB_PREFIX . "product b ON a.product_id = b.product_id WHERE order_id = '" . (int)$order_id . "'");
]]></add>
</operation>
</file>
<file name="admin/controller/sale/order.php">
<operation>
<search position="after"><![CDATA['model' => $product['model'],]]></search>
<add><![CDATA[
'sku' => $product['sku'],
]]></add>
</operation>
</file>
<file name="admin/view/template/sale/order_invoice.tpl">
<operation>
<search position="before"><![CDATA[<td><b><?php echo $column_product; ?></b></td>]]></search>
<add><![CDATA[
<td><b><?php echo 'SKU'; ?></b></td>
]]></add>
</operation>
<operation>
<search position="before"><![CDATA[<td><?php echo $product['name']; ?>]]></search>
<add><![CDATA[
<td><?php echo $product['sku']; ?></td>
]]></add>
</operation>
<operation>
<search position="replace"><![CDATA[<td align="right" colspan="4"><b><?php echo $total['title']; ?>:</b></td>]]></search>
<add><![CDATA[
<td align="right" colspan="5"><b><?php echo $total['title']; ?>:</b></td>
]]></add>
</operation>
</file>
</modification>
using oc 1.5.6
Donate here to show support if you think I have helped you today!
Opencart Documentation
All files with the mods indicated by teyno works for me on 1.5.6.4 on a heavily customised theme
Users browsing this forum: No registered users and 86 guests
