Synchronize / update products from external CSV, Excell

[immcom]

Hello Jan,
is it possible to synchronize / update products from a local SQL server
or from CSV, Excell on G.Drive / Drop Box..

Some idea?
Thanks!

[Jan]

Hi, when you import products by CSV or XML, and the products include current ID, then the ID is updated, all other products are added as new product. But for now, there is no option to run some synchronization between e.g. different servers

Jan

[dmlwebal]

I have made a request to RO CSVI to see if they would include Phoca Cart.

The Phoca import/export included is excellent, especially for free.

RO CSVI is a complex Joomla component that could potentially allow such update by allowing for server CRON imports and exports.

I have a specific need that is beyond the scope of Phoca Cart Import/Export (Balancing stock between to separate websites) but RO CSVI may be able to achieve this.

Once I get a reply, I shall post it here. It may be of help to Immcom

David

[jpeters]

Hello David,
are you talking about multiple webshops with the same products, details, prices etc and the sites are both based on Phoca Cart?

[dmlwebal]

Hi JP

Yes, that is exactly right. I almost solved this problem back when working with Virtuemart and RO CSVI about 4 years ago.

If RO CSVI can work with Phoca cart import/export templates then there could be a solution not far away. It may not cover *every* issue of multiple stores, but certainly makes a lot of progress. Stock balance, price updates, CRON jobs...

Regards
David

[jpeters]

Hello,

Because both websites are phoca cart why not arrange the sync on database level
Or a simple cron job to export and import..

[jpeters]

Example
https://serverfault.com/questions/35607 ... r-via-cron

In this treat you read about a tool.. and just a simple mysql cron job to do the trick.

[dmlwebal]

I need to make some of the tasks accessible to some non technical users. Again, from memory I had three databases on VM and an external system set up to Balance stock levels and Import updated prices, SKU from external EPOS to Web Store products.

[dmlwebal]

I have had a reply from Roland D of RO CSVI.

Phoca Cart is on the roadmap and compatibility is expected in version 8. Which is due to be released later in the year.

Regards
David

[dmlwebal]

Hi Jp

Integration of two databases is close to what I was looking for, but in fact, the ideal is to have a master third database that allows CSV imports of prices and SKUs that then links to the two store databases and writes to the relevant tables.

So, if a manufacturer or supplier sends an updated CSV of their products spreadsheet, this can import into the master db, and then write to the store databases. Just to keep a degree of separation and allow each store its own backup.

Then I can show one or two key staff how to maintain the third db.

As stated, I did achieve this with CSVI about 4 years ago - the task being to balance SKU and bar codes between a 3rd party EPOS and a Joomla Virtuemart site.

Regards
David