We currently have a python script running that imports our invoices from our OSCommerce shop, into SQL Ledger. This has been working very well for the last 4 years. However we need some adjustments to it and one new script import done. It currently runs on a cron job every hour during the working week to do the import.
What we need is the following:
1. Adjustment to currnet script. The script breaks if there is no TAX on a sale, and at times there is as overseas sales and we do not charge tax (GST). We would like it to import with or without tax.
2. The script does it's own tax calculation (I think?) - and so when it imports often the invoice total is not equal to the receipt amount, making for a small adjustments that have to be done manually in SQL Ledger. Just very annoying! So we have GST and the GST is incorrect on import.
3. The old Script has involved using a field called model/part number. This model number has to exist in the Ledger as well as in OSCommerce for the script to import correctly. We are adding new and different model numbers in OSCommerce now and we would like the new model numbers to be auto imported into SQL Ledger along with the invoices.
We are happy to send over the current script to anyone who is interested in doing this task. As we are happy for you to hack it to work with the above adjustments. I just dont want to upload it as it has some connection data that we dont want to paste for the public.
Hope someone can help. We are eager to get this done in the next week. Thanks.
Both softwares that we use are GNU - [url removed, login to view]
and OSCommerce [url removed, login to view]