To be honest - it took a lot of back and forth and alpha testing with the Make dev team to get the Amazon signature authentication to work with the regular Make modules. :) BUT... We're here now, and you can use it!! 🚀🚀
@@sergey5734 we have our own highly supportive community and Live Q&As to answer these kinds of questions quickly whenever they come up for our course members. You can find more information about it here: makesimplified.com
Did you copy my setup exactly including all parameters etc? That's very important or it won't work. Feel free to send me a loom video of your setup to info@techflow.ai and I'll review it for you.
Hello, I have set it up the same way as you. So only orders with the status shipped. But now the problem is that not all orders are transferred to the google sheet. It seems that when a new day begins and the orders from the previous day do not yet have the status shipped, as soon as a new day begins with a shipped order, the orders from the previous day that were shipped later are not entered. In the Google table I only have about 50% of the actual orders. How does it work for you? Are all your orders, including those that are shipped later, entered into your Google Sheets?
If you want to get the "Shipped" orders you should use the "Watch Orders Updates" module instead of the "Watch New Orders" module. The "Watch New Orders" module only watches when an order was created in a chronological order. That means, once it has been processed, it will not appear again within that module. That's why it's missing orders for you as you pre-filter the "newly created orders" by "Shipped" status. 50% of the orders aren't shipped yet at the time your scenario is processing them.
Thank you for the feedback! Which custom request are you specifically looking for? You can make an API call available on SP-API with the Make an API Call module on Make. Here is the full documentation by Amazon: developer-docs.amazon.com/sp-api/docs/
Do you have a video on researching Amazon products to produce and sell? I want to make an automation that researches different categories or keywords and makes suggestions on new products to produce or sell based on the data. I'm a bit new to this so not sure how to do it. Thanks for the vid!
That's a good question but not really our specialty. We help with all sorts of integration but don't do product research or sell ecommerce products at all. I'm pretty sure there are tons of videos out there how to research products. Check them out and see if you can automate any of these methods in combination with Make. For example the Amazon Product Advertising API might help with getting details about products and researching good performing ones. BUT - in order to access that API, you need some sales via your own Amazon affiliate link. Here is the link to the API documentation: webservices.amazon.com/paapi5/documentation/
I'm sorry about that. Apparently we cut off that part while editing the video. Please refer to this other tutorial I did which shows the full body: th-cam.com/video/s45bRh6x9RI/w-d-xo.html Let me know if that helps. :) Cheers, Manuel
Thank you for such a prompt reply but that video just goes so fast I cannot see what you click on to input the body. The last shot is too blurred to read what is typed in the body box.
Great video, has anyone managed to create a full automation for and Amazon merchant fulfilment order. I’m striving to extract the full address, and phone number required for deliveries. Impressed down to data regulation. Is there a way to get around this by generation a report which does extract this info
Not all data is available via API right away. Especially regulated data like personal address and phone number. You'd need the RDT token by Amazon in order to display that data as well as a Seller. Reach out to Amazon support in order to get access. If you're a Vendor, there is no way to access that data at all.
hey, for a business, i have set up developers profile from seller central account, my employer wants to automate the downloading of reports so that data integrity is maintained and there is no chance of error. can you guide me ?
For sure! Here is the official Make documentation to establish a connection to your Amazon Seller Central account: www.make.com/en/help/app/amazon-seller-central Please go through the steps to establish the connection. Then you can start using the "Report" modules accordingly.
Hello, why you not showing how you made the second and third step? I don't know how you did it exactly. When I chose List Orders lines, it will have an Order ID.... But this make no scene, I do not want list one special order, I want all orders... I am a bit confused. Can you pleas help. Thanks
Thank you for your input. Actually I'm showing the setup of the third module at minute 1:53. For the "List Order Lines" it just requires the Order ID so I thought it's not necessary to show that in the video. "List Order Lines" just works with 1 specific order. You need to "Watch Orders" to get all orders - then "List Order Lines" (this is PER Order) and then do whatever you want with that.
Thank you for your request. Can you please ellaborate your use case a bit more so I can make a proper recommendation. What do you mean by "ChatGPT table product posts created?"
You'd have to initially work with a real order, then copy the RAW Output Bundle and transfer it into a "Parse JSON" module. Then you can use this module to test and set up your scenario with the same order data over and over again. Once you're done, unlink the "Parse JSON" module and link the "Watch New Orders" module to your scenario again as a trigger and use the "Integromat DevTool" to remap all variables from "Parse JSON" to "Watch New Orders". This is a nice process that we use for extensive testing in many cases. Hope it helps!
Hi ! Maybe you can help with downloading this file not for google sheets, like for other reader ( like excel for example ). Problem is with text agregator, how i can use delimeter to make excel see rows and tables? Thank you !
I'm not sure what you mean by "tab" misses. You can use the Google Drive - Download a File module to download it as .xlsx file. There is an advanced setting to define the output/conversion of Google Sheets into another format (like Excel) when downloading. Then you can send it as an attachment via Email or store it somewhere else. Hope this helps. :)
@@just5019 thank you for jumping in. Yes, that's absolutely correct. Not all data is available via API. You'd need the RDT token by Amazon in order to display that data as well as a Seller. Reach out to Amazon support in order to get access. If you're a Vendor, there is no way to access that data at all.
Hello, I'm from Brazil and have been researching for a year how to integrate Amazon, for example, when a sale arrives on Amazon, will the shipping label automatically go to the supplier's WhatsApp?
Bom dia! Tudo bem? Yes, that's totally doable. You'd have to get a WhatsApp messaging template approved for the shipping notification. Then you'd have to request the shipping label and forward it together with the details to the supplier. I'm not sure if WhatsApp allows sending files though via templates. You might have to use a download link for the supplier instead so he can get the label from there.
Can you help please? It says RuntimeError and that The requested URL /v4/[my spreadsheet url]/values/New%20Amazon%20Orders%20US!A:K:append?valuesInputOption=RAW was not found on this server. That’s all we know.
This looks like you're trying to batch append data to a Google Sheet? Your spreadsheet URL variable needs to be replaced with the actual spreadsheet ID of your Google Sheet which you can find in the browser bar when accessing your Google Sheet document.
What did you always want to get out of Amazon Seller Central on autopilot and can finally achieve now?
Is there a module for Amazon Affiliate program? found a buch around sellers and aws .
I waited for months for this integration. Thank you for the vid
To be honest - it took a lot of back and forth and alpha testing with the Make dev team to get the Amazon signature authentication to work with the regular Make modules. :)
BUT... We're here now, and you can use it!! 🚀🚀
@@TechflowAI Love it. Thank you for the hard work! :)
You're most welcome! Enjoy all the new possibilities. :)
Are the emails that Amazon supplies you the actual emails of the customers or are they like the Amazon emails?
They're Amazon emails and not the actual ones.
Sending an email to those email addresses will forward them through the Amazon system to the customer.
how would you send data in batch but set UNIQUEID() for every new row?
You could use the {{uuid}} variable available in Make to generate a unique ID for every single item in your array.
thank you for quick reply! what's best place to ask questions like that? TH-cam is probably not the right platform
@@sergey5734 we have our own highly supportive community and Live Q&As to answer these kinds of questions quickly whenever they come up for our course members.
You can find more information about it here:
makesimplified.com
Hello sir, Loved your video. But i had a problem in spreadsheets .Data isn't displayed .What can be done?
Did you copy my setup exactly including all parameters etc?
That's very important or it won't work.
Feel free to send me a loom video of your setup to info@techflow.ai and I'll review it for you.
Hello,
I have set it up the same way as you. So only orders with the status shipped.
But now the problem is that not all orders are transferred to the google sheet.
It seems that when a new day begins and the orders from the previous day do not yet have the status shipped, as soon as a new day begins with a shipped order, the orders from the previous day that were shipped later are not entered. In the Google table I only have about 50% of the actual orders.
How does it work for you? Are all your orders, including those that are shipped later, entered into your Google Sheets?
If you want to get the "Shipped" orders you should use the "Watch Orders Updates" module instead of the "Watch New Orders" module.
The "Watch New Orders" module only watches when an order was created in a chronological order.
That means, once it has been processed, it will not appear again within that module.
That's why it's missing orders for you as you pre-filter the "newly created orders" by "Shipped" status. 50% of the orders aren't shipped yet at the time your scenario is processing them.
Hi, thanks for the great video!
Can you do a video on how to make custom requests with amazon?
Thank you for the feedback!
Which custom request are you specifically looking for?
You can make an API call available on SP-API with the Make an API Call module on Make.
Here is the full documentation by Amazon:
developer-docs.amazon.com/sp-api/docs/
Do you have a video on researching Amazon products to produce and sell? I want to make an automation that researches different categories or keywords and makes suggestions on new products to produce or sell based on the data. I'm a bit new to this so not sure how to do it. Thanks for the vid!
That's a good question but not really our specialty.
We help with all sorts of integration but don't do product research or sell ecommerce products at all.
I'm pretty sure there are tons of videos out there how to research products.
Check them out and see if you can automate any of these methods in combination with Make.
For example the Amazon Product Advertising API might help with getting details about products and researching good performing ones.
BUT - in order to access that API, you need some sales via your own Amazon affiliate link.
Here is the link to the API documentation:
webservices.amazon.com/paapi5/documentation/
@@TechflowAI thanks!
You're most welcome! 😊 Hope it helps!
I can't read what should go in the Body box of the Google Sheets setting as you did not scroll down low enough. Could you tell me what it is please.
I'm sorry about that.
Apparently we cut off that part while editing the video.
Please refer to this other tutorial I did which shows the full body:
th-cam.com/video/s45bRh6x9RI/w-d-xo.html
Let me know if that helps. :)
Cheers, Manuel
Thank you for such a prompt reply but that video just goes so fast I cannot see what you click on to input the body. The last shot is too blurred to read what is typed in the body box.
I'm sorry about that.
Even at minute 5:40?
It's clear on my end. :/
Feel free to send me an email to info@techflow.ai and I can send you the raw body.
Great video, has anyone managed to create a full automation for and Amazon merchant fulfilment order. I’m striving to extract the full address, and phone number required for deliveries. Impressed down to data regulation. Is there a way to get around this by generation a report which does extract this info
Not all data is available via API right away. Especially regulated data like personal address and phone number.
You'd need the RDT token by Amazon in order to display that data as well as a Seller.
Reach out to Amazon support in order to get access.
If you're a Vendor, there is no way to access that data at all.
hey, for a business, i have set up developers profile from seller central account, my employer wants to automate the downloading of reports so that data integrity is maintained and there is no chance of error. can you guide me ?
For sure!
Here is the official Make documentation to establish a connection to your Amazon Seller Central account:
www.make.com/en/help/app/amazon-seller-central
Please go through the steps to establish the connection.
Then you can start using the "Report" modules accordingly.
Hello, why you not showing how you made the second and third step? I don't know how you did it exactly. When I chose List Orders lines, it will have an Order ID.... But this make no scene, I do not want list one special order, I want all orders... I am a bit confused. Can you pleas help. Thanks
How about you pay him? Or do you send him your products for free?
Thank you for your input.
Actually I'm showing the setup of the third module at minute 1:53.
For the "List Order Lines" it just requires the Order ID so I thought it's not necessary to show that in the video.
"List Order Lines" just works with 1 specific order.
You need to "Watch Orders" to get all orders - then "List Order Lines" (this is PER Order) and then do whatever you want with that.
Thanks! Is there a way to automate in make, the AWS Wordpress plugin to show on chatGPT table product posts created? Chers!
Thank you for your request. Can you please ellaborate your use case a bit more so I can make a proper recommendation.
What do you mean by "ChatGPT table product posts created?"
This doesn't seem to work for Inventory reports (at least for North America)
Where are you stuck exactly?
how would you generate a fake order to test “Watch New Orders” ?
You'd have to initially work with a real order, then copy the RAW Output Bundle and transfer it into a "Parse JSON" module.
Then you can use this module to test and set up your scenario with the same order data over and over again.
Once you're done, unlink the "Parse JSON" module and link the "Watch New Orders" module to your scenario again as a trigger and use the "Integromat DevTool" to remap all variables from "Parse JSON" to "Watch New Orders".
This is a nice process that we use for extensive testing in many cases.
Hope it helps!
Hi !
Maybe you can help with downloading this file not for google sheets, like for other reader ( like excel for example ).
Problem is with text agregator, how i can use delimeter to make excel see rows and tables?
Thank you !
and is your "tab" misses in text agregator means something ?
I'm not sure what you mean by "tab" misses.
You can use the Google Drive - Download a File module to download it as .xlsx file. There is an advanced setting to define the output/conversion of Google Sheets into another format (like Excel) when downloading.
Then you can send it as an attachment via Email or store it somewhere else.
Hope this helps. :)
@@TechflowAI i mean , how i can show rows and tables like you in this video to tolls agregator?
If u r okay, i can write you an email with screenshots ?
@@peptolunchbox yes, feel free to send an email to info@techflow.ai
why doesnt it pull my buyers full shipping info like name and address?
Restricted pii data
@@just5019 thank you for jumping in.
Yes, that's absolutely correct.
Not all data is available via API.
You'd need the RDT token by Amazon in order to display that data as well as a Seller.
Reach out to Amazon support in order to get access.
If you're a Vendor, there is no way to access that data at all.
Hello, I'm from Brazil and have been researching for a year how to integrate Amazon, for example, when a sale arrives on Amazon, will the shipping label automatically go to the supplier's WhatsApp?
Bom dia! Tudo bem?
Yes, that's totally doable.
You'd have to get a WhatsApp messaging template approved for the shipping notification.
Then you'd have to request the shipping label and forward it together with the details to the supplier.
I'm not sure if WhatsApp allows sending files though via templates.
You might have to use a download link for the supplier instead so he can get the label from there.
This didn’t say how to set it up
I'm sorry that information is missing.
Can you please provide more context for your request?
What are you struggling to set up?
Can you help please?
It says RuntimeError and that
The requested URL /v4/[my spreadsheet url]/values/New%20Amazon%20Orders%20US!A:K:append?valuesInputOption=RAW was not found on this server. That’s all we know.
This looks like you're trying to batch append data to a Google Sheet?
Your spreadsheet URL variable needs to be replaced with the actual spreadsheet ID of your Google Sheet which you can find in the browser bar when accessing your Google Sheet document.