CODEWITHSUNDEEP
phpsqldatabasewordpresswoocommerce
Erwin Manalang
Erwin Manalang

Reputation: 347

syncing local site database to live site database

I have a local site which has a POS for woocommerce, how can i sync the database table of woocommerce orders and products to my live website so that the products that has been add or bought will be less to my live site tables.

Upvotes: 0

Views: 59

Answers (1)

Nancy Moore
Nancy Moore

Reputation: 2470

I do not know how your table order and products were set up.

Synching is just very simple. First you will need to loop through the orders and product table based on each product unique identification and in this case an Id to ensure that an existing products or order is not inserted twice.

Finally, you may need to only update a particular item based on date or timestamp that you implement. For instance, if the product timestamp is less than or greater than blablabla...then loop and insert/update.

Upvotes: 1

Related Questions