Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

EZ QuickBooks Integration Contribution


197 replies to this topic

#141 ~Kira

  • Community Member
  • 181 posts
  • Real Name:Starlight Design
  • Gender:Female
  • Location:USA

Posted 30 April 2009, 14:48

View Postmagicandmischief182, on Apr 30 2009, 09:44 AM, said:

[img]http://i108.photobucket.com/albums/n23/performanceoffroadcenter/wrong.jpg[/img]
Is it supposed to look like this?

no you're missing some definitions somewhere.

you're missing step ix) admin/includes/languages/english.php
☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆

#142 magicandmischief182

  • Community Member
  • 180 posts
  • Real Name:Jeffrey Rosen.

Posted 30 April 2009, 15:49

View Post~Kira, on Apr 30 2009, 10:48 AM, said:

no you're missing some definitions somewhere.

you're missing step ix) admin/includes/languages/english.php
Thank you!

#143 magicandmischief182

  • Community Member
  • 180 posts
  • Real Name:Jeffrey Rosen.

Posted 30 April 2009, 15:55

View Post~Kira, on Apr 30 2009, 10:44 AM, said:

yeah the instructions aren't really too clear, but just take it step by step and make sure your code looks like what he's showing and you should be fine.
Specifically I'm having trouble understanding this:

In the same function, in the $this->info array,
"
$this->info = array('currency' => $order['currency'],
'currency_value' => $order['currency_value'],
...................................
"
add some lines, to look like this:
"
$this->info = array('order_id' => $order_id,
'currency' => $order['currency'],
'currency_value' => $order['currency_value'],
......................................................

#144 ~Kira

  • Community Member
  • 181 posts
  • Real Name:Starlight Design
  • Gender:Female
  • Location:USA

Posted 30 April 2009, 16:07

View Postmagicandmischief182, on Apr 30 2009, 10:55 AM, said:

Specifically I'm having trouble understanding this:

In the same function, in the $this->info array,
"
$this->info = array('currency' => $order['currency'],
'currency_value' => $order['currency_value'],
...................................
"
add some lines, to look like this:
"
$this->info = array('order_id' => $order_id,
'currency' => $order['currency'],
'currency_value' => $order['currency_value'],
......................................................


ok just search for the first chunk and replace it with the 2nd chunk. only difference is that he added

'order_id' => $order_id,

into the array, so if you just wanted to insert that in the middle or something you could probably get away with that. i don't think it has to be in order. i always try to make it like they have it though.
☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆

#145 Tross

  • Community Member
  • 6 posts
  • Real Name:Tross
  • Gender:Male
  • Location:UK

Posted 30 April 2009, 23:41

View Post~Kira, on Apr 28 2009, 06:21 PM, said:

ok wait i'm having a strange problem. this worked for one store just fine, but the other store is heavily modded and is having tax problems. she says the orders with taxes still will not export into quickbooks, that it's giving her the same error. I exported an order myself and it has a blank for the sales tax. also, taxes aren't showing up when you view orders in the admin panel. they're there, and they get charged, but it's not showing up anywhere. see below:

ORDER PAGE IN ADMIN PANEL:

[img]http://27moons.com/hotlinked/ordertotal.gif[/img]

ORDER EXPORTED INTO IIF (used excel to view):

[img]http://27moons.com/hotlinked/orderexport.gif[/img]

Is the tax amount appearing in the value field of the orders_total table in the database? If not you could try pulling it from the text field instead.

#146 ~Kira

  • Community Member
  • 181 posts
  • Real Name:Starlight Design
  • Gender:Female
  • Location:USA

Posted 01 May 2009, 13:07

View PostTross, on Apr 30 2009, 06:41 PM, said:

Is the tax amount appearing in the value field of the orders_total table in the database? If not you could try pulling it from the text field instead.

No it wasn't but now it is. Thanks for your suggestion though. That might have been a good fix if I hadn't already gotten it working properly. : )
☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆

#147 ~Kira

  • Community Member
  • 181 posts
  • Real Name:Starlight Design
  • Gender:Female
  • Location:USA

Posted 08 May 2009, 13:00

View Postbpopa, on Apr 22 2009, 06:46 AM, said:

It's a method of the box class

ok so why isn't it defined? i'm not understanding this. can anybody help?
☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆

#148 MoisesZaragoza

  • Community Member
  • 894 posts
  • Real Name:Moises Zaragoza
  • Gender:Male
  • Location:Ft Lauderdale

Posted 12 May 2009, 14:35

has any one tryed this contrib with the new alpha vertion 3.0a5

Edited by MoisesZaragoza, 12 May 2009, 14:37.

at the end of the day the code will be good

#149 MoisesZaragoza

  • Community Member
  • 894 posts
  • Real Name:Moises Zaragoza
  • Gender:Male
  • Location:Ft Lauderdale

Posted 12 May 2009, 16:32

i was wondering how i import orders into the QuickBooks


Thanks
at the end of the day the code will be good

#150 ~Kira

  • Community Member
  • 181 posts
  • Real Name:Starlight Design
  • Gender:Female
  • Location:USA

Posted 13 May 2009, 12:15

View PostMoisesZaragoza, on May 12 2009, 11:32 AM, said:

i was wondering how i import orders into the QuickBooks


Thanks

first you have to export orders through your admin panel in oscommerce. then you save it somewhere like your desktop or whatever (it's an .iif file). then you import that into quickbooks.
☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆

#151 MoisesZaragoza

  • Community Member
  • 894 posts
  • Real Name:Moises Zaragoza
  • Gender:Male
  • Location:Ft Lauderdale

Posted 13 May 2009, 22:34

View Post~Kira, on May 13 2009, 08:15 AM, said:

first you have to export orders through your admin panel in oscommerce. then you save it somewhere like your desktop or whatever (it's an .iif file). then you import that into quickbooks.

would you know if this will work with the the free vertion of Quickbooks?
at the end of the day the code will be good

#152 ~Kira

  • Community Member
  • 181 posts
  • Real Name:Starlight Design
  • Gender:Female
  • Location:USA

Posted 19 May 2009, 14:29

View PostMoisesZaragoza, on May 13 2009, 05:34 PM, said:

would you know if this will work with the the free vertion of Quickbooks?

no, i don't use quickbooks. but if it reads .iif files, you should be ok, although you might not be able to define custom fields that you might need since there is an apparently unfixable undefined method in the code.

:angry:

Edited by ~Kira, 19 May 2009, 14:30.

☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆

#153 bpopa

  • Community Member
  • 23 posts
  • Real Name:Bogdan Popa
  • Gender:Male
  • Location:Bucharest, Romania

Posted 20 May 2009, 08:22

Hi Kira,

That should work fine.I don't know why it does not work for you the same.
Maybe we can have a chat on that.
My email is bpopa83@gmail.com or IM: moroienius@yahoo.com

Regards,
Bogdan

View Post~Kira, on May 19 2009, 03:29 PM, said:

no, i don't use quickbooks. but if it reads .iif files, you should be ok, although you might not be able to define custom fields that you might need since there is an apparently unfixable undefined method in the code.

:angry:


#154 ~Kira

  • Community Member
  • 181 posts
  • Real Name:Starlight Design
  • Gender:Female
  • Location:USA

Posted 20 May 2009, 15:17

I sent you a PM. Thanks for trying to help. I'm frustrated!
☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆

#155 scottp

  • Community Member
  • 7 posts
  • Real Name:Scott Parsons

Posted 22 May 2009, 20:40

I have installed the contribution and everything went without a hitch. Thank you for sharing this. It is very handy.

I have one issue with inventory of Quickbooks assemblies not being transferred to OSC. Has anybody figured out how to bring over the assembly inventory into OSC. The inventory counts are in the IIF file but they are not being read into OSC. All the inventory items are working fine, it's just the assemblies.

#156 stargzr

  • Community Member
  • 9 posts
  • Real Name:PJ

Posted 27 May 2009, 02:18

Still wondering about this. Is there any way to do account number matching? Am I missing something?

Thanks in advance.

View Poststargzr, on Feb 19 2009, 11:24 PM, said:

I installed this contribution and everything works great! Thank you SO much for all your hard work!

I do have a question from a client:

Do you know if you can assign all sales product items to 46000 merchandise sales and shipping to 47000 shipping in Quickbooks?

Thanks!


#157 xecutech

  • Community Member
  • 85 posts
  • Real Name:Tom Featherstone
  • Gender:Male
  • Location:Nashville

Posted 03 June 2009, 15:24

I am currently using QBI and it has worked well for us, but we need it to be able to handle item custom fields, for the same reason the OP started this version; to be able to have a bin/shelf location for the products.

I implemented the script to add a custom field to oscommerce for this, and have the custom field set up in quickbooks.

So, I can either start using this script or hire a programmer to make QBI work. Did you decide to do a custom script because of any limitations on QBI? Seems it would make more sense to have QBI tweaked by a programmer?

Could you pm me your programmer's contact information?

#158 adam5532

  • Community Member
  • 678 posts
  • Real Name:Adam Liberman
  • Location:California, USA

Posted 05 June 2009, 06:13

Hi,

View Postxecutech, on Jun 3 2009, 08:24 AM, said:

I am currently using QBI and it has worked well for us, but we need it to be able to handle item custom fields, for the same reason the OP started this version; to be able to have a bin/shelf location for the products.
This is easy to do in QBI. The EZ contribution was written by someone who wanted to create their own QB add-in, which is fine, but it does not do anything that QBI doesn't do.

Quote

I implemented the script to add a custom field to oscommerce for this, and have the custom field set up in quickbooks.

So, I can either start using this script or hire a programmer to make QBI work. Did you decide to do a custom script because of any limitations on QBI? Seems it would make more sense to have QBI tweaked by a programmer?
The commercial version of QBI, currently 3.80 at http://www.qbisoftware.com, uses output template files that are completely separate from the main program code, which makes it very easy to add custom fields. You can do the same thing in QBI 2.10, it's just that the output lines are within the code and not separated.

Thanks
Adam
(Creator of QBI)

Edited by adam5532, 05 June 2009, 06:13.


#159 stargzr

  • Community Member
  • 9 posts
  • Real Name:PJ

Posted 07 July 2009, 00:29

I've posted this in the past, but haven't received a reply. I have installed this
contribution and had no errors. However, when the import is done into QuickBooks
it doesn't apply the shipping and tax to the correct accounts in QB. Please tell
me how I can do this. Can I use the category matching to assign these items
to the correct Accounts in QB?

Thanks in advance.

#160 Halfhidden

  • Community Member
  • 20 posts
  • Real Name:Steff
  • Gender:Male
  • Location:Penzance, Cornwall UK

Posted 24 July 2009, 19:10

Hi Everyone! I've been trying to get this code up and running but have come across an error. I have read and read this thread and can see that a few members have also had the same error..... but instead of posting an answer they have posted "never mind I've fixed it"
Anyway I would really appreciate a little help if someone was kind enough to help.

I have this code error:
Parse error: syntax error, unexpected T_DOUBLE_ARROW
And it is caused by this code:
'payment_method' => $order['payment_method'],
Can anyone please advise me.
Thanks

Sorry forgot to mention that this is in the order.php

Edited by Halfhidden, 24 July 2009, 19:11.