Quick perl hack that uses QODBC to read the item list from quickbooks, and upload it to yoru oscommerce site.
You need to install qodbc from www.qodbc.com (the free version is all thats needed), and then create a system DSN which the program can connect to.
Next, set the host, username, password at the top of the script to suit your database. I run and developed the script under cygwin. It may work under ActiveState's perl as well.
If you define Custom fields in Quickbooks for "WebProductId", "Manufacturer" and "HideFromWeb", it will automatically use those as the keys for future updates, rather than trying to match on the title. The "HideFromWeb field isn't implmented yet.
The script supports a single level heirachy, creating categories as appropriate when the Purchase Descriptiob containts the word "category".
When QODBC supports updating the Custom Fields, I will fix it so it automatically updates the codes, but at the moment, you must do it manually.
The second included script makes this easier by identifying the ones that dont have a code.
Top 4 Download periodically updates information of Import Stock from Quickbooks script from the developer, but some information may be slightly out-of-date.
Our script download links are directly from our mirrors or publisher's website. Import Stock from Quickbooks torrent files or shared files from free file sharing and free upload services, including Rapidshare, MegaUpload, YouSendIt, MailBigFile, DropSend, HellShare, HotFile, FileServe, MediaMax, zUpload, MyOtherDrive, SendSpace, DepositFiles, Letitbit, LeapFile, DivShare or MediaFire, are not allowed!
Free Download
