Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database synchronization


Psytanium

Recommended Posts

so what accounting package do you use,

and what kind of sync do you exactly need ?

where do you invoice weborders ?

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

easypopulate can import and export products data

depending on your number of products, you can import all or with a little modification a selection of the stock

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

I recall that the issue of keeping the osC online store database in synch with a brick-and-mortar store (or other, such as selling on eBay) database has been discussed a number of times. You might want to look through those discussions to see if there's anything useful there. The basic problem is that osC is architected to think that it owns the whole thing, and there is no clean and easy way to let it know that others are selling out of the same inventory (or tell others that osC has sold something). Unless you can bend one or the other system to share the same database (or at least, the same inventory table), you will have to resort to various kludges to synch up separate databases. One is for the osC database to trigger a notice to the other system whenever the inventory changes. Another is to have the other system read the sales confirmation emails that osC sends out, and post to the its database. In either case, you still have to deal with going in the other direction. For that, something like Easy Populate might be the easiest solution.

 

Unless you can get everyone to play in the same inventory database, you will always have the risk of overselling (running out of inventory) in the time slice between database updates. This is especially a problem with a physical store, where merchandise can be taken out of storage and put on display, and someone forgets to keep all the databases in synch. One solution is to physically separate inventories (in the warehouse), and allow transfer between stores only under strict rules. This way, one store or the other might temporarily run out of inventory, resulting in a lost sale, but merchandise can be moved from one side to the other fairly quickly.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...