197 replies to this topic

[~Kira]

magicandmischief182, 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

[magicandmischief182]

~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!

[magicandmischief182]

~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'],
......................................................

[~Kira]

magicandmischief182, 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.

[Tross]

~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.

[~Kira]

Tross, 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. : )

[~Kira]

bpopa, 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?

[MoisesZaragoza]

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

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

[MoisesZaragoza]

i was wondering how i import orders into the QuickBooks


Thanks

[~Kira]

MoisesZaragoza, 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.

[MoisesZaragoza]

~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?

[~Kira]

MoisesZaragoza, 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.

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

[bpopa]

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

~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.

[~Kira]

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

[scottp]

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.

[stargzr]

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

Thanks in advance.

stargzr, 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!

[xecutech]

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?

[adam5532]

Hi,

xecutech, 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.

[stargzr]

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.

[Halfhidden]

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.