Hi
I try to import all my orders woocommerce to google sheets. The connection works fine. But dates and prices details are wrong.
I put in Goggle Sheet connector “1.Date Completed”
All my dates are wrong although I edited the time zone in parameters in Google Sheets and format.
I have this as a result : 2024-02-09T09:35:50.000Z
I want only the date of the completed order and not hours. It does not correspond to the date and the format is wrong. I’m French.
My prices also do not correspond to the orders.
Thank you for your help. I’m new to make.
All the best
Sandy
You can use the built-in function formatDate to pass the date variable in the format that you specify.
2 Likes
Hi
thank you for your answer. But where do I put this “formatDate” ? I did that and it’s not working… I have an error.
And I don’t want the hours nor the timezone. I just want the correct date of my shop timezone. For instance for 1st April 2024 I want it written like that : 01/04/2024
And in another row the price they paid for the order.
Do you have an idea why price is not correct?
Sorry I’m new to this.
Thank you
Best
S
According to the Tokens you can use to format a date variable, you can use DD/MM/YYYY.
e.g.: {{ formatDate(1.dateCompleted; "DD/MM/YYYY") }}
Links
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
General
Help Center Basics
2 Likes
Hi
thank you but it’s still not working. Any idea what is going wrong here? I’m new to your tool and before buying a premium I want to be sure It’s doing what I need…
Thanks
Best
S
Welcome to the Make community!
Please provide the screenshot and text of output bundles of the module [1] by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
A.
Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
Uploading them here will look like this:
module-1-input-bundle.txt (12.3 KB)
module-1-output-bundle.txt (12.3 KB)
B.
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:
-
Either add three backticks ``` before and after the code, like this:
```
input/output bundle content goes here
```
-
Or use the format code button in the editor:
Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
This will allow others to better assist you. Thanks!
2 Likes
Hi
There is nothing there. It’s written:
[
null
]
Best
S
Are you sure Woocommerce (module [1]) has no output bundle? Then your Google Sheets module should not be running at all.
2 Likes
I don’t get what’s going on. I run the scenario.
It shows null. Even though I put all good as you told.
I thing the whole thing is too much complicate for me…
Best
S
Ah, there was no new order from the last time you ran the scenario. Either put a new order through, or get an older order data from the scenario execution history.
2 Likes
I’ve made a sell and run once but nothing happens… Still:
[
null
]
And nothing happens on my Google Sheets now.
Best
S
Hi
is there anyone to give me a clue why it’s not working?
Thanks
Best
S
