Re: Simple coding SKU ON INVOICE
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
Thanks. Jump to post
- Wed Dec 07, 2011 11:05 am
- Replies 24
- Views 9549
Re: Simple coding SKU ON INVOICE - Solved
It shows nothing there if product has no SKU.
Will this a bug? I think no...
It works perfect for me.
Thank you. Teyno
- Wed Dec 07, 2011 11:05 am
- Replies 24
- Views 9549
Re: Simple coding SKU ON INVOICE
Got you the query, tested in in phpmyadmin and works OK 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 = '&qu...
Jump to post- Wed Dec 07, 2011 11:01 am
- Replies 24
- Views 9549
Re: Simple coding SKU ON INVOICE
Apprecaited Teyno.
I will give a try.
I will post if it works for me.
Thank you.
- Wed Dec 07, 2011 10:23 am
- Replies 24
- Views 9549
Re: Simple coding SKU ON INVOICE
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 Thanks for your reply. I just want to add the SKU to invoice only , NOT other places. Any simple coding? Thanks. ;D I see the SKU i...
Jump to post- Wed Dec 07, 2011 10:13 am
- Replies 24
- Views 9549
Re: Simple coding SKU ON INVOICE
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. Jump to post
- Wed Dec 07, 2011 9:31 am
- Replies 24
- Views 9549
Simple coding SKU ON INVOICE
Dear All, I would appreciated if anyone can let me know what file, and stpes to add SKU code to be displayed on PRODUCT INVOICE. I have tried and added SKY CODE perfectly to product page, however, i got error "Notice: Undefined index: sku in C:\AppServ\www\upload\admin\controller\sale\order.php...
Jump to post- Wed Dec 07, 2011 1:28 am
- Replies 24
- Views 9549
Re: sku ON INVOICE
希望各位大大可以幫一下.... Jump to postfelizone wrote:Hello...有誰能告訴我如何把sku 加到invoice 上嗎?
我懂得加到product page 上去, 卻不懂加上invoice 上去...真暈...
誰可以春教一下呢, 萬分感謝!
Felizone
- Wed Dec 07, 2011 1:22 am
- Replies 1
- Views 1298
sku ON INVOICE
Hello...有誰能告訴我如何把sku 加到invoice 上嗎?
我懂得加到product page 上去, 卻不懂加上invoice 上去...真暈...
誰可以春教一下呢, 萬分感謝!
Felizone
- Wed Dec 07, 2011 1:21 am
- Replies 1
- Views 1298
Re: Opencart招聘
I am in Hong Kong and interested, but..i am not good at programming.
Jump to post- Wed Dec 07, 2011 1:19 am
- Replies 14
- Views 9438
Different min qty for groups in multi store
Dear All,
Is there any way to set the OC to have different minimum order qty in multi store for different customer groups?
E.g, qty 1 for retail customers, qty 5 for wholesale customers.
Thanks,
Feliz
- Tue Aug 02, 2011 11:54 pm
- Replies 1
- Views 538
Re: Add product images on the Orders products
Dear All,
I follow this tutorial , but not success at all.
Anyone can help?
error message:
Notice: Undefined variable: image in C:\AppServ\www\upload1\admin\controller\sale\order.php on line 587".
Thanksm
Feliz
- Thu May 05, 2011 12:18 am
- Replies 8
- Views 3627
Re: [MOD] Facebook Like Button on Product Page
Hello,
I added to my code, but it shows error while i clicked the like button.
The page showed.
http://www.facebook.com/connect/connect ... _error.php
cannot access and cannot find item.
What's the matter?
My server problem or my code error?
Thanks,
Felix
- Mon Aug 30, 2010 11:21 am
- Replies 81
- Views 48206
Re: Facebook Product share
no works for my site, i cannot see the item images attached in the facebook pop up window.
And the link seems not work in facebook.
I cannot see item pages by access the link.
Any one can help?
Thanks,
Felix
- Thu Aug 26, 2010 11:54 am
- Replies 53
- Views 49298
Re: Missing Orders [1.4.8] [COMPLETED-CLOSED]
Thanks Daniel,
Your word may be help.
Thanks.
- Sun Jul 25, 2010 8:07 pm
- Replies 13
- Views 4148
Re: ATTN: NO PAYPAL IPN ORDER ID
Hi Q, Thanks for your reply. My Paypal History : mc_gross=0.10&invoice=51 - Alan&auth_exp=04:05:48 Aug 17, 2010 PDT&protection_eligibility=Ineligible&address_status=unconfirmed&payer_id=Z4S4DDRY7RBCE&tax=0.00&address_street=工???加城大?F3D1&payment_date=03:08:27 Jul 20, 2...
Jump to post- Sun Jul 25, 2010 8:05 pm
- Replies 2
- Views 1773
ATTN: NO PAYPAL IPN ORDER ID
Hi All, I am using 1.4.8b, but with paypal checkout, all order are missing with statu '0' Zero in database. I search around forum, i see Q have solution that said IPN not reach your site. I contacted my host company to check what's matter my Paypal IPN? We both test with sandbox Paypal IPN tools, an...
Jump to post- Fri Jul 23, 2010 5:17 pm
- Replies 2
- Views 1773
Re: Paypal collected payment, but the order is missing
I am also having this.@@
Jump to post- Thu Jul 22, 2010 3:50 pm
- Replies 8
- Views 2296
Re: [Solution 2]: Paypal No Order - More Secure. No lost Ord
I AM ALSO having the missing order problem.
Jump to post- Tue Jul 20, 2010 11:41 pm
- Replies 59
- Views 414551