Syncing db between local & live site (only specific tables)

[HaCos]

Hello,

I am looking for a way where the data entry of products, features, attributes, categories, manufacturers, attachments & images can happen in a local clone of production  a prestashop site and then synced / pushed to live site. 
 

 

Edited March 16, 2018 by HaCos (see edit history)

[HaCos]

up up

*looking for workflow updates

[orotoi]

On 3/16/2018 at 12:40 PM, HaCos said:

up up

*looking for workflow updates

ok.. 5 years later

But I searched for the exact situation and don't know how to approach it.

How did you resolved it? if you are willing to share will be  helpful

[ps8modules]

Hello.
It seems simple, but it is not.
Prestashop is prone to any kind of error.
It is necessary to have something in the local installation (wamp or other) that creates lists of required tables in XML or JSON format.
These then need to be sent to the live eshop via cURL, for example. There again, some script must read the data from XML or JSON. Go through data to see if it should be updated or added.
And transfer images as well.
What will happen ? One or the other side will fall because these are demanding processes.
Another option is to export the necessary tables from localhost and import them into the live eshop (nonsensical) and to transfer the product images is also very demanding because one product image has several thumbnails.
It is reasonable to make adjustments directly in the live eshop.

[HaCos]

9 hours ago, orotoi said:

ok.. 5 years later

But I searched for the exact situation and don't know how to approach it.

How did you resolved it? if you are willing to share will be  helpful

You can use a module to export a csv/xml of new products from dev prestashop upload it to production server & use a module to map fields & imports products.