Mort-lemur Posted June 3, 2015 Share Posted June 3, 2015 I was pondering today, and wondered if anyone had ever looked into something like this? The scenario I was imagining, was that in this day and age, everything syncs with everything else, so I was thinking that a shops inventory could be held on an access / excel database and modified as needed on a desktop - then at the push of a button, this would syncronise with the OSC server database. I know there are things like easy populate etc, but they are all rather clunky and steam driven. Maybe one day osc will have 3 parts - The Shop, The Admin, and The Desktop all linked and talking to each other........ Damn, there goes another flying pig.......... (w00t) Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members. Link to comment Share on other sites More sharing options...
♥kymation Posted June 3, 2015 Share Posted June 3, 2015 MySQL to Access is a PITA. However, MySQL will run on the desktop, so I would stick with that. Then you just need to set up MySQL Replication. Regards Jim See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
♥bruyndoncx Posted June 3, 2015 Share Posted June 3, 2015 the backoffice accounting, stockcontrol, pos program I use is osfinancials (turbocash in the uk), where the desktop (or client/server) can act as your central hub to control inventory, maintain your catalog and push the data to different webshops (oscommerce or others). but it more like finding out changes since X and pushing updates, it does not replicate whenever each change occurs. 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 More sharing options...
clustersolutions Posted June 4, 2015 Share Posted June 4, 2015 I did more than looked into it. I have one running for nearly 10 yrs to accommodate our fulfillment requirements. I imagine you are thinking of Access as it is easy to develop and utilize; however, it would be good if you already have a functioning piece of software for your accounting and inventory needs. You know, I had done ODBC over the network before. So it can be done and it may be easier than MySQL replication as it very likely that you will need a 2-way replication to get what you need. Your right that "data" really had need to talk with each others now-a-day, and you can sense this if you are submitting a Google PLA feed. We are beginning to cut out vendors that cannot provide us an inventory feed as order cancellation is getting very expensive...economy is still soft and profit's lean and technology is gonna have to help in running a tighter supply chain... I am in the process of building a demo b2b platform for vendors who had shown interest and you are welcome to take it for a test drive. I am almost done with all the back-end fulfillment logistics. OSC talks to the ERP and shipping software (i.e. endicia, fedex ship manage, ups) and customer/sales order/inventory/shipping/tracking/paperless invoice are fully automated so you just need to pick/pack/scan/print label and ship once an order has arrived...inventories are automatically set by the generation of AR/AP invoices...the ERP is web based so you can use it while on the road... epixcommerce dot com demo & epixcommerce dot com demo financial PM me and I'll get you a login to play when it's ready... Oh, the front page is managed by SmartSlider2 ($19) for WP...I will write up a how to on that soon...Tim Link to comment Share on other sites More sharing options...
clustersolutions Posted June 4, 2015 Share Posted June 4, 2015 My other business just got of the phone with target dot com...yeah, EDI is required to sell through them and they do just in time supply chain also...much like when we were speaking to shophq early this year...shophq fee to connect to their EDI was EXPENSIVE... Link to comment Share on other sites More sharing options...
MrPhil Posted June 5, 2015 Share Posted June 5, 2015 In an ideal world, you could specify MySQL (or Postgresql, or Oracle, or...) everywhere and be done with it. However, an established business with an established database is not going to change over just to be consistent with your osC installation. So, even if they use (yecch) Access on the desktop, you may just have to accommodate them. That would mean each database sending changes to the other, to keep in synch, or designating one to be the master and all others to be shadows/duplicates/slaves. Once in a while you might want to replicate, in case a glitch caused them to get out of synch, or at least be alerted that the DBs are not consistent. However, a full replication is probably going to be too expensive to do multiple times a day. Link to comment Share on other sites More sharing options...
clustersolutions Posted June 6, 2015 Share Posted June 6, 2015 That's how software people make money it is a non-ideal world. You need the right tool for the right job. It's hard to define expensive, I was approached by a company as it needs a fully functional online ordering/fulfillment system to replace probably half its sales staffs...it sux...also, the right tool would have the right setup to get the job done...for me, more than 8 years Postgres/Slony "two-way" replication with a watchdog daemon was cheaper than having an employee copy and paste sales order and shipping labels. Stable and zero human error. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.