|
|
|
|
"Actually for 2.2
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.
I've used it to upload to http://shop.iseek.biz/, but you probably shouldn't run it on a production site without fully understanding what it does." |
|
|
|
 |
| For more information, visit the official osCommerce contribution webpage. |
|
|
|
