Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Quickbooks IIF


Guest

Recommended Posts

Posted

Anyone Tried the contribution? If you have

does this file exist for 2.2?

 

10) Replace admin/includes/classes/product_info.php with:

 

or what will subsititute it?

  • 3 weeks later...
Posted

We are looking at implementing the QB addon for a customer but have a few questions before we burn alot of time.

 

We will be setting this up on a Linux webserver, the customer will then retreive the .iff files via ftp or we will add a download area to the current OSC gui and let him retrieve the files there (most likely).. over the Internet, not on a local network like it appears you were doing.

 

I assume the 2 (customer and sales) iff files are updated/overwritten every time a new customer either signs up and/or makes a purchase???? So if my customer downloads the iff files... let's say once a day... then he will save them to a local directory and then use an import function within QB, thereby updating (not overwriting) his QB files/checkbook/invoices..etc.

 

Looking through your notes it seems that you say to remove the iff files from the server so I am assuming that when you download the iff files they merely update QB.. adding the latest customer signups/registrations and any sales that have been made by current or new customers.

 

Please clarify.

Posted

hello

 

i wrote some php code to interface qb from a custom shopping cart i developed about a year ago.

 

i didn't actually save the iif files on the server, they were generated on demand. the accountant would log in, see a list of new transactions, and "uncheck" ones they didn't want (just in case). then they would hit "download" and it would magically feed them an iif file.

 

there was a link on the accountant page to select previously downloaded transactions, so that they could pull old data if they wanted to.

 

i can post the code if you are interested.

 

take care

Posted

Please do, it would be interesting to take a look at.

 

Thanks,

Posted

Hi there,

I am by no means what you would term PC literate, so I'm entering this discussion somewhat naively - But I do run Quickbooks and if there was some way I could daily download osCom Cart sales to my accounting software (quickbooks) I would be absolutely thrilled. It alleviates double entry accounting. Is this what you guys are talking about. If so will this code you are going to provide enable this. Also what is the oldest version of quickbooks would it work on.

 

Always presumptuous.

Ken

Posted

hello!

 

this expects an array of db keys in $dload[]. this script also has extra stuff in it, like fax people their invoices when downloaded by the accountant. (you would probably want to remove ;-) ) also, it doesn't work with the oscommerce cart as is, it is part of a custom shopping application i wrote awhile ago.

 

http://phpical.com/index.php?page=xgetiif

 

enjoy.

Posted

hmmm, not sure about the oldest version it would work with, however it does work with qb 2000, 2001 probably 2002.

 

if you are using qb2002 then it would probably be better to look at different options, since they opened up the api and you can interface qb data directly (at the cost of incessant spam and popup ads from the manufacturer ;-) )

 

take care

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...