Update Inventory Automatically OS Commerce

[admin2 0]

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.

[♥JcMagpie 729]

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.

[MrPhil 559]

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

[admin2 0]

thanks