Forum Discussion
TragicReindeer
Aug 27, 2024Copper Contributor
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...
- Aug 27, 2024The 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.
JKPieterse
Aug 27, 2024Silver Contributor
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.