Forum
Export shop products to another database
OK, so my client has just managed to log into her TEST server rather than her LIVE server and add a load of products to the shop! Tsk! [rolls eyes] I have removed her admin account now so she can't do it again!
Anyway rather than getting her to start all over again in the correct server [rolls eyes again] I want to just export teh relevant tables from the database and overwrite them in the database on the liver server. There are no product options or variants, so would you mind confirming that the folowing tables are all I need?:
shop_index shop_products shop_search
have I missed any?
What about brands?
She didn't add any new ones
Ok. As long as the only difference is the new products that should be fine.
Keep backups.