Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OSCommerce / API


mferry

Recommended Posts

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?

Link to comment
Share on other sites

there is no standard API

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

Link to comment
Share on other sites

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

:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 !

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 1 month later...

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...