Forum Discussion
Solved
Best solution for facilitating data entry on a collaborative spreadsheet
We are looking at upgrading an existing spreadsheet that has been in use for quite some time for entering customer orders and related details. Currently we have three potential ideas: 1) create a use...
- The less manual/repeated input, the better I'd say. I would investigate if there is a way to automate the export of orders from woocommerce to -e.g.- a CSV. If need be, you could even ask a php developer to create an automated export task. Then use Power Query to import that csv (those csv-s) on a regular basis.
Re:our new WordPress site that has a WooCommerce plugin is where clients will enter details about their orders, so potentially we could import those orders and format them to match the spreadsheet's columns
I think B/S architecture is a useful solution.
https://club.excelhome.net/forum.php?mod=viewthread&tid=1520437&mobile=
I think B/S architecture is a useful solution.
https://club.excelhome.net/forum.php?mod=viewthread&tid=1520437&mobile=