Search found 19 matches

Page 1 of 1

Search found 19 matches

Export Sales / Orders, Import Outright Financial Software

If you use Outright Financial Software for keeping business records and reporting, here's an SQL query that will return a result suitable for import into Outright. Very handy for tax season. Export OpenCart Sales / Orders for Import into Outright Financial Software: https://gist.github.com/jhauraw/5...

Jump to post
  • Thu Mar 07, 2013 10:24 am
  • Replies 0
  • Views 1007
Find Customers who ordered Product

I need to find all the customers who ordered a particular product, without laboriously drudging through each order.

If this can't be done on the front end, does anyone have a query I could run on the DB?

Thank you.

Jump to post
  • Wed Oct 31, 2012 3:24 am
  • Replies 2
  • Views 292
Re: Retrieve Single Latest Product for Blog Front Page

Hi a2z. Yes it can. It already pulls all the related product info including images. However to show these items in a standard RSS reader, someone needs to reformat the xml tags from google base/shopping (the ones with g:) into standard rss 2.0 elements. I don't have time right now...sorry.

Jump to post
  • Wed Jul 25, 2012 4:03 am
  • Replies 6
  • Views 705
Re: Google Analytics Ecommerce Tracking

Sorry haven't upgraded yet.

Jump to post
  • Sat Jul 21, 2012 3:19 am
  • Replies 139
  • Views 100239
Vqmod and success.tpl with Analytics Transactions

Is there a way to use vqmod on the </head> (closing head tag) in the case of a successful purchase? I need to insert a Google Analytics Transaction in just above the </head> between my trackPageview and async function if the page is the Success page after an order. I've got the vqmod all working, bu...

Jump to post
  • Thu Jul 19, 2012 1:07 am
  • Replies 1
  • Views 2742
Re: Google Analytics Ecommerce Tracking

UPDATE July 20, 2012: Fixed a bug in Product Name for some users. I've made some fixes and improvements. This version confirmed working on 1.5.2.1 Mainly, * Added $orderDetails['store_name'] for Affiliation instead of hard-coded * I don't use product price + tax as Price in addItem because tax is sh...

Jump to post
  • Tue Jul 17, 2012 7:14 am
  • Replies 139
  • Views 100239
Re: Retrieve Single Latest Product for Blog Front Page

Hi avvici, Thank you. I've read all those, but none address my question. Thanks anyway. I figured it out on my own. I created a "Latest Items" feed that lets you limit the # of items returned. The use PHP SimpleXML to grab one item in Wordpress. I've attached the feed file. To install in OC, simply ...

Jump to post
  • Thu Jun 21, 2012 6:34 am
  • Replies 6
  • Views 705
Retrieve Single Latest Product for Blog Front Page

What's the best way to retrieve the latest product (desc, price, image) from OpenCart for display on our Wordpress blog front page? I assume it's via RSS on the Product Feeds. If so, how can you pull just one single item from the feed without loading the whole thing? Is there a variable you can add ...

Jump to post
  • Wed Jun 20, 2012 2:47 am
  • Replies 6
  • Views 705
Re: Free Shipping not working all the time

Any news on when Free Shipping will work correctly? Esp the issue with basing the calc on SUBTOTAL, it needs to be based on TOTAL AFTER DISCOUNTS but before tax and shipping.

Jump to post
  • Tue May 15, 2012 1:04 am
  • Replies 3
  • Views 1450
Manual Order Entry, Can't Add Product

Hi guys, I've received a handful of online orders, everything is running smoothly. Today, I needed to enter a manual order via the backend. I created a new customer. Then created a new order. I added addresses etc. But when I get to the Add Product Tab, I get an ajax error: XMLHttpRequest cannot loa...

Jump to post
  • Tue Apr 03, 2012 3:44 am
  • Replies 2
  • Views 1362
SOLVED! Re: Authorize.net AIM Module Error OC 1.5.2.1 - HELP

After 48 grueling hours of debugging, I found and resolved the issue. The problem is LINE 103 in: /catalog/controller/payment/authorizenet_aim.php curl_setopt($curl, CURLOPT_POSTFIELDS, http_build_query($data)); Per PHP manual commenter: http://www.php.net/manual/en/function.http-build-query.php#102...

Jump to post
  • Thu Mar 29, 2012 2:12 am
  • Replies 5
  • Views 1319
Re: Authorize.net AIM Module Error OC 1.5.2.1 - HELP!

Proof that it is OpenCart Code. I just ran an approved trans with the AIM SDK on my own and it worked perfect. I tend to think it might be in the jquery or ajax on the Checkout page that is messing it up. require_once INC_PATH . 'anaim.fnc.php'; $an_aim_data = array( 'x_login' => 'XXX', 'x_tran_key'...

Jump to post
  • Thu Mar 29, 2012 1:29 am
  • Replies 5
  • Views 1319
Re: Authorize.net AIM Module Error OC 1.5.2.1 - HELP!

Really need some help here.

I've heard that if you are using a domain name that hasn't AIM'd to the gateway before sometimes you have to reset the login_id as well? Do you think that could be it?

Jump to post
  • Thu Mar 29, 2012 12:43 am
  • Replies 5
  • Views 1319
Authorize.net AIM Module Error OC 1.5.2.1 - HELP!

Opencart 1.5.2.1, fresh install, browser cleared, full SSL with curl. Ok, I fixed the earlier error from earlier post and added the solution. Now here's the next error that followed it :( I'm having a nightmare getting Authorize.net AIM module to work. I have a valid sandbox account with Anet and co...

Jump to post
  • Wed Mar 28, 2012 9:57 am
  • Replies 5
  • Views 1319
Re: Authorize.net "Please Wait" Hangs

Fixed:

In the Authorize.Net Merchant Gateway you have to go to

Account -> Settings -> Direct Response

and set the 'Delimited Response:' to YES

Per #2 here:
https://support.authorize.net/authkb/in ... &actp=LIST

Jump to post
  • Wed Mar 28, 2012 2:50 am
  • Replies 7
  • Views 2128
Re: Authorize.net "Please Wait" Hangs

Update:

doing $this->log->write($response); on line 121 yields:

2012-03-27 11:37:10 - <HTML><BODY><H3>The following errors have occurred.</H3>(92) The gateway no longer supports the requested method of integration.<BR></BODY></HTML>

Jump to post
  • Wed Mar 28, 2012 2:38 am
  • Replies 7
  • Views 2128
Re: Authorize.net "Please Wait" Hangs

Bump. Can someone please help with this. It's a re-download from opencart site, 100% fresh install with ssl enabled. Still getting same error. I realize it should be a csv list, but my question is what to do to fix the error. Is the AIM module messed up? You can try an order yourself on my test site...

Jump to post
  • Wed Mar 28, 2012 1:57 am
  • Replies 7
  • Views 2128
Authorize.net "Please Wait" Hangs

Opencart 1.5.2.1 Error: 2012-03-27 XX XX XX - PHP Notice: Undefined offset: 4 in /catalog/controller/payment/authorizenet_aim.php on line 157 In my file line 157 is: $json['error'] = $response_data[4]; If I do a: $this->log->write(print_r($response_data, true)); It shows the html of a successful ord...

Jump to post
  • Tue Mar 27, 2012 4:18 pm
  • Replies 7
  • Views 2128
Re: SEO URLs for System Pages

I patched the file and added most of the key aliases to the DB. Here they are to make it easier for somebody: 1. Backup your orig seo_url.php file. 2. FTP over the patched version attached here. 3. Backup your url_alias DB table. 4. Add these aliases to the DB: INSERT INTO `url_alias` (`url_alias_id...

Jump to post
  • Fri Mar 16, 2012 10:53 am
  • Replies 6
  • Views 8150

Page 1 of 1

Search found 19 matches