Search found 59 matches

Search found 59 matches

Re: Simple coding SKU ON INVOICE

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, but it's not suitable for me to show SKU all around.

Thanks.

Jump to post
  • Wed Dec 07, 2011 11:05 am
  • Replies 21
  • Views 6415
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

Jump to post
  • Wed Dec 07, 2011 11:05 am
  • Replies 21
  • Views 6415
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 = '" . (int)$order_id . "'"); r...

Jump to post
  • Wed Dec 07, 2011 11:01 am
  • Replies 21
  • Views 6415
Re: Simple coding SKU ON INVOICE

Apprecaited Teyno.
I will give a try.

I will post if it works for me.

Thank you.

Jump to post
  • Wed Dec 07, 2011 10:23 am
  • Replies 21
  • Views 6415
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 21
  • Views 6415
Re: Simple coding SKU ON INVOICE

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
Thanks for your reply.
I just want to add the SKU to invoice only , NOT other places.
Any simple coding?

Thanks. ;D

Jump to post
  • Wed Dec 07, 2011 9:31 am
  • Replies 21
  • Views 6415
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 on l...

Jump to post
  • Wed Dec 07, 2011 1:28 am
  • Replies 21
  • Views 6415
Re: sku ON INVOICE

felizone wrote:Hello...有誰能告訴我如何把sku 加到invoice 上嗎?

我懂得加到product page 上去, 卻不懂加上invoice 上去...真暈... ???

誰可以春教一下呢, 萬分感謝!

Felizone
希望各位大大可以幫一下....

Jump to post
  • Wed Dec 07, 2011 1:22 am
  • Replies 1
  • Views 1101
sku ON INVOICE

Hello...有誰能告訴我如何把sku 加到invoice 上嗎?

我懂得加到product page 上去, 卻不懂加上invoice 上去...真暈... ???

誰可以春教一下呢, 萬分感謝!

Felizone

Jump to post
  • Wed Dec 07, 2011 1:21 am
  • Replies 1
  • Views 1101
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 8550
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

Jump to post
  • Tue Aug 02, 2011 11:54 pm
  • Replies 1
  • Views 324
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

Jump to post
  • Thu May 05, 2011 12:18 am
  • Replies 8
  • Views 2277
Re: 我开发了支付宝接口,有朋友需要吗?

alex.lin wrote:http://www.tylsoft.net/Alipay

我已经修改了一个适用于1.48和1.49的版本了。有需要的朋友可以去下。
Thanks Alex. O0

Jump to post
  • Wed Oct 06, 2010 4:43 pm
  • Replies 23
  • Views 87570
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

Jump to post
  • Mon Aug 30, 2010 11:21 am
  • Replies 84
  • Views 42560
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

Jump to post
  • Thu Aug 26, 2010 11:54 am
  • Replies 53
  • Views 31392
Re: Missing Orders [1.4.8] [COMPLETED-CLOSED]

Thanks Daniel,

Your word may be help.

Thanks.

Jump to post
  • Sun Jul 25, 2010 8:07 pm
  • Replies 13
  • Views 3385
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, 2010 PDT&payment_status=Completed...

Jump to post
  • Sun Jul 25, 2010 8:05 pm
  • Replies 2
  • Views 1360
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 1360

Search found 59 matches