Тёмный

Automate your Amazon orders data with SP API, Google Sheets and Python (new method 2023) 

Jakob Wolitzki | Custom Automations for Sellers
Подписаться 8 тыс.
Просмотров 40 тыс.
50% 1

Опубликовано:

 

19 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 111   
@Jakobowsky
@Jakobowsky Месяц назад
!!! NEWS !!! We just launched our first Amazon SP-API course. Check the link in the description now for a limited-time offer!
@lifeofmle
@lifeofmle 3 года назад
Thank you very much for making this video and sharing your code. This has been really helpful for me to understand where I was going wrong with my Amazon SP API setup.
@vikingzeppelin
@vikingzeppelin 2 года назад
This is one of the only videos on using amazon's api. Could you make more videos? Do you know some place i could go to learn alot more specifically about automating retail apis like amazon? (Other than the api docs themselves)
@Jakobowsky
@Jakobowsky 2 года назад
I am planning to do more of them within the next couple of weeks. So stay tuned brother!
@user-ob9tp3jf1j
@user-ob9tp3jf1j 2 года назад
Thank you! Haha, I found Amazon's tutorial understandable up until the request signature part as well! Very glad you gave me the Python library, helping a lot.
@AliRaza786
@AliRaza786 2 года назад
From where did you get the SP_API_REFRESH_TOKKEN ? I got all other values but not this one.
@XBLToig
@XBLToig 2 года назад
You need to authorize your app on seller central, this will then give you the refresh token. Go to: partner network -> develop apps, then on actions click the drop down arrow and click authorise. Then authorise your app for the required region(s) on the next page.
@jason.lackey
@jason.lackey 2 года назад
You got me over my authorization issue. Thanks a million.
@deanmajidy6197
@deanmajidy6197 2 года назад
can you do a tutorial with the npm amazon-sp-api? I'm more familiar with javascript and nodeJs
@Jakobowsky
@Jakobowsky Год назад
If you want to migrate your old MWS app to the new SP API let me know! We can help you at Deltologic.
@amazonmentorspodcast7555
@amazonmentorspodcast7555 Год назад
This is great content! Keep it up Jakob 🙌
@Jakobowsky
@Jakobowsky Год назад
thanks!
@julia.vasilieva
@julia.vasilieva Год назад
Thank you. How to do to that with Google Apps Script, anyone can help?
@Jakobowsky
@Jakobowsky Год назад
Send us email contact@deltologic.com I am sure we can help
@julia.vasilieva
@julia.vasilieva Год назад
@@Jakobowsky Thank you, I am sending it.
@hafeezkhan553
@hafeezkhan553 2 года назад
where to get the refresh token? sorry, someone already answered this question in the comments. thank you😅
@jaimendaywell
@jaimendaywell 3 года назад
Do you have steps to obtain my Amazon MWS ACCESS KEY?
@manuknath1084
@manuknath1084 2 года назад
Where do I find refresh token for SP API?
@feedback6905
@feedback6905 Год назад
Hi man, i have one question, i want to get my orders from Amazon means the items which i purchased on Amazon via API , I'm searching on google but still nothing I only find the option to download as excel on my account
@Schlumbucketreturns
@Schlumbucketreturns Год назад
Not possible. Only option is to download order history reports files.
@cocoma5974
@cocoma5974 2 года назад
Thanks for your code. But I have a followup question. How do I get the sku for an order? I printed out the response json, but there is no key that relates to sku of an item in the order. Thanks in advance!
@qmart647
@qmart647 Год назад
I'm inside the vscode terminal I get error Attribute Error module gspread has no attributes models
@jiemingli6163
@jiemingli6163 2 года назад
The Api returns an error message with unauthorized: Does somenone has a solution for that problem?
@sreejithsreedhar05
@sreejithsreedhar05 2 года назад
This is really interesting,however, I would like to check with you how the SP data (orders or revenue)can be loaded to a redshift table using this SP-API ,eventually from redshift that data may be use to generate dashboards based on the requirement. I have ETL tool talend to support data pipeline activity , do you know something that can be achieved using talend.
@rhiothelab5251
@rhiothelab5251 2 года назад
Thanks for sharing this , could you please tell me how to take dump of complete inventory ?
@miruiwang8818
@miruiwang8818 Год назад
Thanks for the video. can i use this just to ordering product from Amazon?
@vishalshrivastav2831
@vishalshrivastav2831 Год назад
Hey Jakob, Amazing video. Just one thing is there any way I could extract years worth of data?
@Jakobowsky
@Jakobowsky Год назад
yes, you just have to iterate over it
@vishalshrivastav2831
@vishalshrivastav2831 Год назад
@@Jakobowsky Thanks for your reply, Jakob. I would really appreciate it if you make a video on that! Thank you!
@thomasguo9905
@thomasguo9905 2 года назад
great job
@naveenshetty2891
@naveenshetty2891 3 года назад
Hi, this is nice work , are all the endpoints available only for query purpose? or is there any available for updates , such as updating order shipment etc...
@Jakobowsky
@Jakobowsky 3 года назад
Nope, API gives us a lot of other options as well.
@rohitdobariya2727
@rohitdobariya2727 3 года назад
We need to use feed API to update tracking information
@naveenshetty2891
@naveenshetty2891 3 года назад
Hi Rohit, can you help me on this ? can u please provide me your email address
@pexasllc8896
@pexasllc8896 3 года назад
Totally new to programming and APIs. Even after looking through the documentation. I'm unsure of where to grab the refreshtoken information for my config. Please help
@Jakobowsky
@Jakobowsky 3 года назад
Please send me email and explain problem, we can get on the call and do consultations. contact@deltologic.com
@andyoh6523
@andyoh6523 2 года назад
@@Jakobowsky can you please explain how you obtained the refresh token and saved it in the env file?
@snehachaurasia8862
@snehachaurasia8862 10 месяцев назад
How do you manage the NextToken , I am getting the below error when i use the NextToken with getorders api : { "errors": [ { "code": "InvalidInput", "message": "Invalid Input", "details": "" } ] }
@julianmurillo5965
@julianmurillo5965 Год назад
What happens if I need to get this data on an hourly basis? How do I regenerate the refresh token upon a refreshed request from SP-API? This works for a static/manual set up?
@ztsE7NKQ
@ztsE7NKQ 2 года назад
Only 100lines? I want 3manths all data.
@xkcracka9xs
@xkcracka9xs 2 года назад
Love this, thank you! How come it only imports 100 orders maximum?
@jc6569
@jc6569 Год назад
czy jest jakiś patent na to zeby Getorders nie gubił zamówień? mam automat ktory co 10 min pobiera zamówienia z amazona i nie ma dnia żeby kilku nie ominał...robie dokladnie jak na poradniku z amazona i nic... mam wrażenie że po migracji na nowe API z AWS jest jeszcze gorzej
@morschlesinger7081
@morschlesinger7081 2 года назад
What requirements do you need in place in order to publish your app to the public?
@Jakobowsky
@Jakobowsky Год назад
I may do a video about this topic as its complex
@Desoltech
@Desoltech 8 месяцев назад
Hi, thanks for this video. Can I make a request to get info about stock?
@Jakobowsky
@Jakobowsky 8 месяцев назад
Stock is a tricky topic. One way of checking it is to add to the cart and check how many units you can pick. I never saw any endpoint in API. And I did it using selenium.
@abhijitno1
@abhijitno1 3 года назад
Hello how to update inventory?
@Jakobowsky
@Jakobowsky 3 года назад
There is an API for it as well :)
@rishidixit9661
@rishidixit9661 2 года назад
Loved your tutorial sir. Is there any way by which we can extract order data of any order placed by a customer through our Android application's web view???
@siddhantroy09
@siddhantroy09 2 года назад
How to solve this error? -: def _get_sheet_object(self) -> gspread.models.Worksheet: AttributeError: module 'gspread' has no attribute 'models'
@XBLToig
@XBLToig 2 года назад
I had the same error. It appears the gspread models no longer exists with the most recent version. I ran "pip uninstall gspread" and then used the same version as the tutorial by running "pip install gspread==3.7.0"
@ztsE7NKQ
@ztsE7NKQ 2 года назад
@@XBLToig YES!!
@chrisder1814
@chrisder1814 2 месяца назад
hello Do you use custom GPT
@stevenclark5062
@stevenclark5062 2 года назад
Anyone know how to change listing images programmatically using the SP-API? I've scoured the documentation, and I'm having a hard time making any progress. There is a section that mentions you need to have the image uploaded to an S3 bucket, but they don't tell you how to format the body of the patch request, or what parameters to use.
@TheWellington1997
@TheWellington1997 2 года назад
Can you do a tutorial how to update price and stock of an item?
@Jakobowsky
@Jakobowsky 3 года назад
Feel free to reach out and book a free consulting session with us - we will examine your business and find the best solution to your problem.
@maxiedp
@maxiedp Год назад
@Jakobowsky how can I get reviews of any product using python-amazon-sp-api or url requests? Pls help
@rohitreshi4114
@rohitreshi4114 2 года назад
Hi can you let us know how to use the "Next Token" as well in this python script. That would be helpful.
@javidtaghiyev4628
@javidtaghiyev4628 3 года назад
This is awesome. Can you connect SP_API directly to Data Studio?
@radomirs3389
@radomirs3389 3 года назад
Fajnie jak by był jakiś szybki poradnik na temat API PPC raport - API Google sheet, połowa kodu napisana jest?(CHYBA)👍:-D
@Jakobowsky
@Jakobowsky 3 года назад
Never did, but I don't think its a problem ;)
@rohitdobariya2727
@rohitdobariya2727 3 года назад
Yes we can connect data studio as well using some automation connector
@GermanRodriguezqndq
@GermanRodriguezqndq Год назад
@@rohitdobariya2727 hi, do you mind pointing me to the right direction to get more information about it, thank you
@zakirayub3267
@zakirayub3267 2 года назад
Could you please make a video on how to use the sandbox? I have a lot of confusion and the document is not helping
@hamzafayyaz5369
@hamzafayyaz5369 2 года назад
how can we get the labeling fee, preparation fee and placement fee based on shipment id ?
@sachinchakravarthys1807
@sachinchakravarthys1807 2 года назад
dear sir , may I know sandbox host for vendor to call SP API end point . i have access token and refresh token
@CarmelJeanMadanguit
@CarmelJeanMadanguit 3 года назад
Hello, May I ask if you can track returns using the Amazon SP-API? I have browsed their documentation and I haven't found an API endpoint yet which gets the returns
@Jakobowsky
@Jakobowsky 3 года назад
check merchant-fulfillment-api/merchantFulfillmentV0.md or finances-api/financesV0.md
@TechiesKitchen90
@TechiesKitchen90 2 года назад
Hi, where are get demo details for my app development? As I am not a seller. Some sandbox account.
@VallenatosKrucom
@VallenatosKrucom 2 года назад
tks
@danielacamento9659
@danielacamento9659 3 года назад
I got error like {'message': 'Access to requested resource is denied.', 'code': 'Unauthorized', 'details': ''} please help me to solve this .
@alperarkan6495
@alperarkan6495 3 года назад
same here..
@danielacamento9659
@danielacamento9659 3 года назад
@@alperarkan6495 Fix my script it just remove marketplace from Orders object, ex. (res = Orders(credentials=client_config))
@MuhammadHaroonPK
@MuhammadHaroonPK 2 года назад
I am getting this error: KeyError: 'access_token_8b22048192de1e76a9967cc5f6b3d64f' Can you help please
@caiobassetti2423
@caiobassetti2423 2 года назад
@@MuhammadHaroonPK on the LWA_APP_ID try passing the Client ID instead of App ID.
@jiemingli6163
@jiemingli6163 2 года назад
If you requests top mich entries oder a top long timespan, the api can return this error.
@electroniquehi-fi7289
@electroniquehi-fi7289 Год назад
Hi, thanks for your video, this help me a lot. I cant connect, I have keyerror: 'access_token_..." but in the script, we dont any access_token, can you help me on this please? I have a question, where is the list of what is it possible to fetch, for example, I want the order number, customer name, item ordered, phone number and address of customer... Is it possible or not? Thanks to take your time to asnwer me.
@johannesg.4599
@johannesg.4599 2 года назад
How can I add some demo orders without actually selling something? Is this possible?
@prostotakwo
@prostotakwo 2 года назад
cześć, Jakub ;)
@Jakobowsky
@Jakobowsky 2 года назад
Hej :)
@atulkumarjain514
@atulkumarjain514 Год назад
After get access token but order get api in Authorization failed error,why?
@glowsharpie9076
@glowsharpie9076 Год назад
Same thing here. I even deleted everything and tried again just following Amazon’s documentation and still received a 403 error and access denied….
@PlanetPathfinder
@PlanetPathfinder 2 года назад
Hi I want to upload bulk products from one of the perfume site and want to put that products in Amazon by using API. Can you do it for me ? if you do it for me then how you charge for that ?
@atulkumarjain514
@atulkumarjain514 Год назад
Sp api hit local setup
@shiekhshan8948
@shiekhshan8948 2 года назад
i'm getting error: Exception has occurred: AuthorizationError ('invalid_client', 'Client authentication failed', 401)
@vinitchavan25
@vinitchavan25 2 года назад
Same
@rohitreshi4114
@rohitreshi4114 2 года назад
Check the credentials you are providing in .env file. Also in LWA_APP_ID provide the client identifier instead of Application ID.
@krishj8011
@krishj8011 2 года назад
can you help about how do we get app id ?
@bouhnassim9068
@bouhnassim9068 Год назад
so we have to write those scripts every time we want to update the data ?
@Jakobowsky
@Jakobowsky Год назад
Could you explain?
@Psytranz1
@Psytranz1 23 дня назад
doesn't seem to work anymore
@Jakobowsky
@Jakobowsky 23 дня назад
@@Psytranz1 I have updated this video, check my channel
@maximilianrast5050
@maximilianrast5050 3 года назад
Thank for sharing this. Do you know where I can get the actual referral fee (Amazon Commission) and FBA fee for each order item from?
@makapakatv4196
@makapakatv4196 2 года назад
it's 15% of the selling price
@tuppyglossop1122
@tuppyglossop1122 2 года назад
@@makapakatv4196 not that simple. Different by market and product line.
@Miche781
@Miche781 2 года назад
From payments report
@noumaannadeem2038
@noumaannadeem2038 2 года назад
"WorksheetNotFound" Please advice?
@deanmajidy6197
@deanmajidy6197 2 года назад
make sure it's the name of the actual sheet and not the excel file
@ahmadkamalmughal6349
@ahmadkamalmughal6349 2 года назад
how amazon will charge an amazon seller if he wants to use this SP-API??
@cameronyoung8058
@cameronyoung8058 2 года назад
does anyone know how to fix this error? - Error: [{'message': 'Access to requested resource is denied.', 'code': 'Unauthorized', 'details': ''}] I believe all my credentials are correct and I followed the guide exactly
@ztsE7NKQ
@ztsE7NKQ 2 года назад
same...
@xkcracka9xs
@xkcracka9xs 2 года назад
for me, it fixed by changing the date from 2017 to more current (Amazon doesn't allow you to access old orders). I changed date to this and it worked res.get_orders(CreatedAfter='2022-03-30'
@anshuvishwakarma6020
@anshuvishwakarma6020 2 года назад
How to get all orders list from Amazon seller api.
@silver_glow
@silver_glow 2 года назад
The same, I'm looking for a method for getting all orders reports and payments reports through sp api
@vinayakgupta931
@vinayakgupta931 3 года назад
Is it possible to get the name of the product ordered?
@makapakatv4196
@makapakatv4196 2 года назад
I think you can generate a spreadsheet that includes the product name as well
@atulkumarjain514
@atulkumarjain514 Год назад
Php Amazon sp api not call
@dnz_muzik
@dnz_muzik Год назад
SELAM
@Schlumbucketreturns
@Schlumbucketreturns Год назад
Amazon sucks.
@julia.vasilieva
@julia.vasilieva Год назад
Thank you. How to do to that with Google Apps Script, anyone can help?
Далее
GIANT Gummy Worm Pt.6 #shorts
00:46
Просмотров 14 млн
Scraping Amazon's best Black Friday DEALS with Python
41:50
Google Sheets API Automation in Python
26:36
Просмотров 91 тыс.
How to Automate Amazon Seller Central with Make.com
8:26
Easily Automate Business Tasks - No-Code Automation Course
3:00:39