Jump to content
Latest News: (loading..)
Sign in to follow this  
admin2

Update Inventory Automatically OS Commerce

Recommended Posts

Currently we have client that need we update inventory on his os ecommerce platform so we need to know how to get access to this platform to update the inventory in an automatically way. thank you for your support and save status.

Preferably MS SQL 2012 or I listen to suggestions.

Share this post


Link to post
Share on other sites

Nothing to do with osC! Like any database driven cart you simply need access to your clients database. Then as you would with any db simply run sql query to update inventory as required.

Or if you prefer simply export db in any format (csv) using phpAdmin, then update inventory using any tool you wish and import updated db.

If you mean hands off update then you need to write a simple php file which can be run using cron job to do this at any set time.


 

Share this post


Link to post
Share on other sites

Look at "add-ons" such as Easy Populate, which read a CSV file to update osC's database. To do this automatically, you would have to come up with some way to get the CSV file to the server running osC, but running osC to execute Easy Populate should simply be a "cron job" on the server. That should be sufficient information to get you going.

It sounds like you (and perhaps your client) know very little about osC. They should take measures to ensure that they are up-to-date on their platform. If they are not already running at osC 2.3.4.1BS Edge (a.k.a. CE, Frozen) they should be making plans to migrate to that latest release. Anything else is so old that there is great danger of the system suddenly failing when the host does an upgrade of any kind. See my signature below for the location of the upgrade (it's NOT the official release found on this site -- don't use that one).


If you are running the "official" osC 2.3.4 or 2.3.4.1 download, your installation is obsolete! Get (stable) Frozen or (unstable) Edge. See also the naming convention and the latest community-supported responsive "Edge" release

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×