FAQ
For guidance to Create Google API settings. Go through Video Tutorial
1. Can I sync existing WooCommerce orders to Google Spreadsheet?
Yes, You can synchronize the existing WooCommerce orders by clicking “Click to Sync” button at WPSyncSheets For Woocommerce settings page.
2. What should I do, error: The site is experiencing technical difficulties. Please check your site admin email inbox for instructions?
There are the following ways to resolve this error:
- Revoke token at Google API Settings Page.
- Check the Google Drive API must be Enable
3. What should I do, Google Sheets API limit reached?
Please visit the link Click Here.
4. Can I reorder/add/edit the sheets header columns in Google Spreadsheets?
No, We can’t reorder/add/edit the sheet header columns because it will be a miss match the orders data.
5. What If I See a Screen Saying “This app isn’t verified”?
Google might display a screen that says “This app isn’t verified. This app hasn’t been verified by Google yet. Only proceed if you know and trust the developer.” There’s no need to worry, though — the message is only referring to the app that you just created in your own Google account (so you are actually the developer in this case).
To bypass this message, you’ll need to click Advanced and then Proceed.
6. Range (‘Completed Orders’!A2302) exceeds grid limits. Max rows: 2301, max columns: 45» ?
Please add 2000 more rows to your sheets. Please check with the below screenshot.
7. How can we change the date format in spreadsheet?
If you want to change the date format of a particular spreadsheet.
The sequence you need to follow is, Firstly navigate to Admin dashboard >> Left menu settings >> General >> Select Date Format
8. Spreadsheets float values format issues?
We have provided 2 options within Row Input Format Option, i.e, RAW and User Entered.
For more details, you can navigate to the given link: https://developers.google.com/sheets/api/reference/rest/v4/ValueInputOption
9. Error: Please make sure you have removed the Product Id from the 1st column of the spreadsheet.
10. How to add custom fields?
To add custom fields write the ‘wpsyncsheets_’ prefix to your custom field name.
11. What should I do if I see a 403 Error?
- Make sure you have allowed all the checkboxes when generating the authentication code.
- Make sure you publish the app.
