Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Inventory Control ? Quickbooks ?


Guest

Recommended Posts

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

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

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

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

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

  • 2 weeks later...
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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...