Get all orders with python

VictorFerrer_95
Visitor
3 0 0

Hello everyone!

 

I'm using this python code to get all orders from my shop, but I'm only getting the Open orders, and I want all the orders I have completed. Does anyone know what I'm missing?

 

HERE THE PYTHON CODE

def get_all_orders():


secret = XXXX
api = XXXX
password = XXXX
hostname = XXXXX
version = '2021-10'
resource = 'orders'

last=0
orders=pd.DataFrame()

while True:
url = f"https://{api}:{password}@{hostname}/admin/api/{version}/{resource}/.json?limit=250&since_id={last}"
response = requests.request("GET", url)

df=pd.DataFrame(response.json()['orders'])
orders=pd.concat([orders,df])

last=df['id'].iloc[-1]
if len(df)<250:
break

return(orders)

 

df=get_all_orders()

 

HERE THE ORDERS I GET: (I want the Closed Orders)

VictorFerrer_95_0-1637687760682.png

VictorFerrer_95_1-1637687831035.png

 

 

 

 

 

Thank you!

Replies 3 (3)

tewe
Shopify Partner
244 46 102

Hi @VictorFerrer_95 ,

 

maybe your app does not have the correct permission. For all orders you need the permission read_all_orders, see https://shopify.dev/api/usage/access-scopes

 

Regards

Thomas

• Was my reply helpful? Click Like to let me know!
• Was your question answered? Mark it as an Accepted Solution
• Check out our Price Updater App
VictorFerrer_95
Visitor
3 0 0

Hi @tewe ,

 

Thanks for your reply.

 

It is the Private App the app you mean? I created a Private App inside the shop and I granted to the app all the read accesses regarding orders and products:

 

VictorFerrer_95_0-1637746113383.png

Don't know why I'm only getting the Open orders...

Noitseuq
Visitor
2 0 0

Thanks!