Guest Posted February 23, 2007 Posted February 23, 2007 Hi all, I've downloaded all my stock info from osC to TC wich seems to work fine. But if, at a later time, I want to re-sync the stock again from osC to TC it only downloads new products. <_< As far as I can tell the sql (ZQProducts.txt) selects and writes the correct information to the xml-file (DLZQProducts.xml). But for some reason TC don't update the info if the product is allready in TC's database. Does anyone know how to make TC to allways update every product (especially the stock qty) when the button "Sync all items" is pressed? Thanks! /Magnus
Velveeta Posted February 24, 2007 Posted February 24, 2007 Hi all, I've downloaded all my stock info from osC to TC wich seems to work fine. But if, at a later time, I want to re-sync the stock again from osC to TC it only downloads new products. <_< As far as I can tell the sql (ZQProducts.txt) selects and writes the correct information to the xml-file (DLZQProducts.xml). But for some reason TC don't update the info if the product is allready in TC's database. Does anyone know how to make TC to allways update every product (especially the stock qty) when the button "Sync all items" is pressed? Thanks! /Magnus I've never used TC myself, but if TC is ignoring any existent products, it sounds like an issue with TC rather than osc... Do they have any forums where you might post this question? Maybe they know of some kind of option string you can send to it to force it to do an update of all products... Richard. Richard Lindsey
♥bruyndoncx Posted February 24, 2007 Posted February 24, 2007 the design of the TC <-> osC link is to take the quantity field only for the new products. the flow is that TC holds the true inventory data and that inventory is reduced when you create your invoices in TC. In TC, when you purchase items, the inventory goes up again. After you have processed all orders, and purchase documents, you should push the inventory numbers back to the osCommerce database, you have a single button for that pretty much in the middle of the screen. KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
Guest Posted February 24, 2007 Posted February 24, 2007 I've never used TC myself, but if TC is ignoring any existent products, it sounds like an issue with TC rather than osc... Do they have any forums where you might post this question? Maybe they know of some kind of option string you can send to it to force it to do an update of all products... Richard. Yes I think this is an issue with TC and yes they have a forum and yes I've posted there. The problem is that they hardly answer any questions unless you pay them... :angry: the design of the TC <-> osC link is to take the quantity field only for the new products.the flow is that TC holds the true inventory data and that inventory is reduced when you create your invoices in TC. In TC, when you purchase items, the inventory goes up again. After you have processed all orders, and purchase documents, you should push the inventory numbers back to the osCommerce database, you have a single button for that pretty much in the middle of the screen.Richard. Yes, I know that. But I would like to have the "true" inventory in the osC database since this is the "core" of the business. That's why i would like TC and osC to communicate the other way around. Or why not give the user a choice? /Magnus
Velveeta Posted February 24, 2007 Posted February 24, 2007 Yes I think this is an issue with TC and yes they have a forum and yes I've posted there. The problem is that they hardly answer any questions unless you pay them... :angry: Boooo! :) Do you have access to the source of this TC app? Like is it just a web-based solution or is it a desktop item? If it's a web-based solution and you have access to the files that make it up, you could probably dredge through the code to see if there's an option you can send it to force a total update... Richard. Richard Lindsey
Guest Posted February 24, 2007 Posted February 24, 2007 Yes, TC is open source (at least they say so...) but it's not written in php and its DB is not mysql so my limited coding skills won't do :'( Is there anyone out there who knows anything about the coding of Turbocash? Please! /Magnus
Velveeta Posted February 24, 2007 Posted February 24, 2007 Yes, TC is open source (at least they say so...) but it's not written in php and its DB is not mysql so my limited coding skills won't do :'( Is there anyone out there who knows anything about the coding of Turbocash? Please! /Magnus Do you know what it is written in? What's the file extension on it? Richard. Richard Lindsey
♥bruyndoncx Posted February 25, 2007 Posted February 25, 2007 Turbocash is written in delphi and makes uses of some proprietary delphi components which are not compilable by Lazarus (see below). I'm using osFinancials which is a derivative of turbocash, also still written in delphi, but with opensource firebird db and the code moving to object pascal so that it can eventually be compiled using opensource pascal compiler, ie lazarus. I have looked at that piece of code and didn't see a way to change that behaviour without recompiling the code (ie create your own executable). KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt
Guest Posted February 25, 2007 Posted February 25, 2007 I see... Not what I was hoping for but still, thank you for at least giving me an answer! :thumbsup: In my opinion the "direction of communication" between TC and osC should be entirely up to the user to decide. :angry: Is it possible to make osC to wright files that TC can read? Would it be possible to handle the "communication" from within osC Admin? I know that this isn't the case right now but maybe someone can wright i contribution to make it possible. Unfortunately my knowledge of php is still far too limited... /Magnus
Guest Posted March 7, 2007 Posted March 7, 2007 Hello again, I have another question for those who have some knowledge of TurboCash (and preferrably Delphi): TC have 3 columns for products price and imports 'products_price' from osC to all three of them. I also have 'products_retail_price' in my osC and I would like to import that column to become Price2 in TC. Does anyone know how to do this? Please?! :'( /Magnus
Guest Posted March 7, 2007 Posted March 7, 2007 Hello again, I have another question for those who have some knowledge of TurboCash (and preferrably Delphi): TC have 3 columns for products price and imports 'products_price' from osC to all three of them. I also have 'products_retail_price' in my osC and I would like to import that column to become Price2 in TC. Does anyone know how to do this? Please?! :'( /Magnus
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.