Synchronize / update products from external CSV, Excell

Phoca Cart - complex e-commerce extension
immcom
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 04 May 2020, 12:59

Synchronize / update products from external CSV, Excell

Post by immcom » 08 Mar 2021, 18:01

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!

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 43748
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Synchronize / update products from external CSV, Excell

Post by Jan » 09 Mar 2021, 17:56

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 :idea:

Jan
If you find Phoca extensions useful, please support the project

User avatar
dmlwebal
Phoca Professional
Phoca Professional
Posts: 188
Joined: 18 Sep 2019, 12:49

Re: Synchronize / update products from external CSV, Excell

Post by dmlwebal » 12 Mar 2021, 22:56

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
Phoca Professional
Phoca Professional
Posts: 189
Joined: 31 Dec 2020, 09:46

Re: Synchronize / update products from external CSV, Excell

Post by jpeters » 13 Mar 2021, 08:06

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

User avatar
dmlwebal
Phoca Professional
Phoca Professional
Posts: 188
Joined: 18 Sep 2019, 12:49

Re: Synchronize / update products from external CSV, Excell

Post by dmlwebal » 13 Mar 2021, 15:21

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
Phoca Professional
Phoca Professional
Posts: 189
Joined: 31 Dec 2020, 09:46

Re: Synchronize / update products from external CSV, Excell

Post by jpeters » 13 Mar 2021, 17:42

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
Phoca Professional
Phoca Professional
Posts: 189
Joined: 31 Dec 2020, 09:46

Re: Synchronize / update products from external CSV, Excell

Post by jpeters » 13 Mar 2021, 18:06

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.

User avatar
dmlwebal
Phoca Professional
Phoca Professional
Posts: 188
Joined: 18 Sep 2019, 12:49

Re: Synchronize / update products from external CSV, Excell

Post by dmlwebal » 13 Mar 2021, 21:30

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.

User avatar
dmlwebal
Phoca Professional
Phoca Professional
Posts: 188
Joined: 18 Sep 2019, 12:49

Re: Synchronize / update products from external CSV, Excell

Post by dmlwebal » 15 Mar 2021, 15:51

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

User avatar
dmlwebal
Phoca Professional
Phoca Professional
Posts: 188
Joined: 18 Sep 2019, 12:49

Re: Synchronize / update products from external CSV, Excell

Post by dmlwebal » 15 Mar 2021, 15:57

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

Post Reply