OSCommerce / API

[mferry]

Is there an API built in to OSCommerce that allows inventory/product data to be placed in to OSCommerce database?

My would like my point of sale program to push products out to my new online store.

 

if the API is available, can I pull transacations done in OSCommerce back to my point of sale application?

[♥bruyndoncx]

there is no standard API

[tgely]

osCommerce use csv export by this way. Direct API is not found but no hard to rewrite easy populate for it.

[MrPhil]

Take a look at the "Easy Populate" add-on, which uses CSV files to import bulk data.

 

Do you want to export inventory levels back to another system, or individual sales reports? The first wouldn't be too hard, but the second may take some work. You'll have to explain just what you're looking for.

 

osC was conceived as a completely standalone system that didn't interface with any other accounting or sales system.

[mferry]

I was looking to get transaction level detail sent back. Including: item number, qty sold, price, tax info, shipping charges, etc because the point of sale system in the retail store will track the inventory part, but also will push shipping expenses for example in to the back office accounting system.

 

Remember I have used OSCommerce in the past and its a great product. This situation is an existing retail store trying to expand in to the online market.

The online inventory can be monitored in the OSCommerce interface (Reporting for online sales or pending online orders), but the point of sale system has the "official" records and has very advanced inventory tracking.

 

Thanks for all your comments and replies !

[MrPhil]

I don't think much of that information is stored in the database. Maybe you can look at the email notification of sales (sales receipts), and if the information you need is in there, do something to extract the data from the emails. Of course, an add-on (or built-in) sales report that exports this data to other back-office software would be great...

[Dan Cole]

I was looking to get transaction level detail sent back. Including: item number, qty sold, price, tax info, shipping charges, etc because the point of sale system in the retail store will track the inventory part, but also will push shipping expenses for example in to the back office accounting system.

 

With the expection of the shipping information you can find that information in your orders_product table. You should be able to pull the shipping cost from your orders_total table....maybe you could write a report to pull the data on a daily basis and then create a csv file to import it into your POS....that should be doable without to much effort.

 

Dan

[mferry]

Would someone beable to write an API that gets installed in OSCommerce as an addon?

 

My application would POST/GET certain info from that API to do what I need. The API would know where to get or put info into the OSCommerce database based on OSCommerce version.

 

OR better yet ---

 

Can I write my software to POST/GET (using MySQL queries) to my customers own OSCommerce database directly? They supply my application the database info (server address, username, password, db name)

I would then have my software wrote for that version of OSCommerce, if OSCommerce releases a new verison, then my application would need updated for any schema changes.

 

My customer would not be able to update their OSCommerce to my software update gets completed or risk the automation not working for a period of time.

 

Any pro or cons????

 

Matt

[Praful Kamble]

@@mferry

 

There are many paid addons available on internet. Check for this addon, if it works for you.

[mferry]

Well remember we already have a great POS system. Its been in place since early 2001.

We are just trying to do an online store addon solution.

 

QUESTION --- Where in the interface or in the OSCommerce database is the version number?

[Dan Cole]

QUESTION --- Where in the interface or in the OSCommerce database is the version number?

 

Jack started a thread on finding your version number....have a look at...

 

http://www.oscommerce.com/forums/index.php?showtopic=283185

 

Dan

[jacksonholt]

Is there an API to extract orders from OS commerce to import into quickbooks?

[MrPhil]

No API. Much of the information is in the database, but you will have to write something to extract and present it. It might be easier to extract the information from sales emails -- I would certainly look at that before writing database queries.

[Dan Cole]

There are some SAS apps out there that will do what you want...webgility comes to mind....if you don't want to write a program to do what you want, google is your friend.