We are a web development company and will regularly be moving sites from Dev to Staging to Live.
Using the wordpress multi-site tables this really painless as we just grab their site id with everything it ie; wp_xx_tablenames
We have decided to adopt MarketPress as an ecommerce platform and after considerable development we are finding today that the product tables for an individual site are not clearly separated like core wordpress is.
This is concerning on lots of levels as it sems to mean everyone's data is intertwined.
I am guessing to do a backup this means a query needs to be sent to all marketpress tables searching for the linked data of a single site and then exported appropriately.
On the restore side I would imagine a similar select that deletes all existing data for that site and then runs the import command mentioned above.
It's a bit scary but frankly coding our own store is a bit scarier :wink: and woocommerce prices themselves out of the market and frankly, is not as friendly to programming solutions.
So the million dollar question: What is the export / import query I can run to get this job done for site id XX. I am dealing with this problem right now.
There is 'tied in' issue. If I delete a site, I can use this query to delete an outgoing sites existing product data, category and attributes
Thanks in advance.
What sayeth the group?
P.S. I have seen references to Snapshot as a potential solution. However, I do not need a solution for all other tables, filesystem files etc. Only Marketpress. In a perfect world I would like to see you guys fall into line with the wp_xx_tablenames for all 'Site Specific' data.
For the record, all my sites are setup as theirdomain.com and NOT theirdomain.mymultisite.com