Guest Posted February 20, 2007 Share Posted February 20, 2007 Hi - I have a client that uses the OSC for her gift baskets store. She's pretty busy - probably shipping about 150 baskets a month, and then over Christmas about 1000 baskets. She does not use OSC for __anything__ else except to sell her product. She uses Quickbooks to control inventory, customer accounts, accounting, invoicing, customer email etc. My question is this : Is there a way for her inventory to go from Quickbooks to OSC ? Quickbooks controls all the *contents* of the gift baskets. For example if she sells a basket with a bag of cookies in it, she tells Quickbooks she sold that particular basket, and the cookies quantity inventory decrements. Does OSC have this type of detailed inventory control ? If not - and she needs to continue to use Quickbooks and OSC together - what is the optimal way to "associate" the two applications to reduce paper work, ease of client interaction, and inventory control ?? Is this crazy ? Is my question clear ? lol. Thanks! Corrina Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2007 Share Posted February 20, 2007 If you are in the USA you can use http://www.oscommerce.com/community/contributions,2847 which is very good from what I hear. If you are in another part of the world try http://www.oscommerce.com/community/contributions,3384. The second one works with QBSDK where you can transfer any info you want from osC to QB. It will take a bit to learn it and set up but once done it works well. Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2007 Share Posted February 20, 2007 If you are in the USA you can use http://www.oscommerce.com/community/contributions,2847 which is very good from what I hear. If you are in another part of the world try http://www.oscommerce.com/community/contributions,3384. The second one works with QBSDK where you can transfer any info you want from osC to QB. It will take a bit to learn it and set up but once done it works well. Hi Peter - thank you for the information. Quickbooks is very foreign to me - but I will check these out for sure! Thank you! Corrina Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2007 Share Posted February 20, 2007 I hope they are close to you because you WILL need a copy of their QB program (software) and Chart of Accounts in order to make it operational and trouble shoot. QBSDK5.0 is available from the QB web site and will need to be installed, it is the program that allows other software (ie osC) to import stuff into QB. Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2007 Share Posted February 20, 2007 I hope they are close to you because you WILL need a copy of their QB program (software) and Chart of Accounts in order to make it operational and trouble shoot. QBSDK5.0 is available from the QB web site and will need to be installed, it is the program that allows other software (ie osC) to import stuff into QB. Hmmm - good point Peter. Very good point. I'll ask her for the install disks - and hopfully can install it locally without any permission or software key issues. Corrie Link to comment Share on other sites More sharing options...
jasonabc Posted March 2, 2007 Share Posted March 2, 2007 Is there a way for her inventory to go from Quickbooks to OSC ? The mods listed above are for exporting *from* OSC into Quickbooks - not the other way around. Jason My Contributions: Paypal Payflow PRO | Rollover Category Images | Authorize.net Invoice Number Fix Link to comment Share on other sites More sharing options...
jfrey Posted March 3, 2007 Share Posted March 3, 2007 The mods listed above are for exporting *from* OSC into Quickbooks - not the other way around. I don't know Quickbooks, but assuming that the product model number is the same in QB and Osc, what you need to do is get comma separated output from QB and use that to update the products_quantity field into the products table of the Osc database. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.