Skip to main content

Export Orders Automatically

  • Jun 12, 2023 12:00 PM UTC
  • 5 replies
  • 3 views

Is it possible for Shipstation to set Automation Rules that allow the user to export orders automatically to a csv file on a specific time with set criteria for filter?

Or is it possible to Orders to be synced to a Google Sheet and allow export of orders automatically without logging in the Shipstation and doing manual work of exporting orders which is a redundant process done every day?

Dev team please help!

5 replies

  • Jun 12, 2023 12:43 PM UTC

Hi,

To automatically have your orders synced to a GoogleSheet, I would suggest that you use the Shipstation Webhooks

You would need to develop a program which would reside somewhere on the cloud (AWS etc) which Shipstation will call whenever a new order is created on Shipstation (via the Shipstation webhook)

Your program would then need to parse out the data sent by Shipstation and update the GoogleSheet with the new order data (via the GoogleSheet API)

Hope this helps!


  • Author
  • Jun 12, 2023 12:54 PM UTC

AWS is expensive.

Can Zapier do the automated exporting of orders?


  • Jun 12, 2023 1:29 PM UTC

Yes, you could even use Zapier.


  • Jun 16, 2023 5:00 AM UTC

Hello Puffy,

You can use Shipstation webhooks, and they can be developed with the help of any developer.
We also support custom integrations, in case you need any help, we are reachable via email from here - help@constacloud.in

thank you!


PT_Shipping
  • Employee
  • Jun 20, 2023 5:45 PM UTC

I use make.com (instead of Zapier) I have a workflow built where it creates a new spreadsheet with the current time stamp, adds the headings to the file, list my shipstation shipments based on a criteria (I use products but it could be any variable) and have it add those matching shipments to the google sheet. I only have it populating the recipient name, shipment cost and tracking number but again you can pull anything out of the database.