Skip to main content
Question

Connecting Hubspot to Shipstation

  • September 22, 2020
  • 4 replies
  • 74 views

Here is what we are trying to do:

  • User submits address and t-shirt size and fit
  • Zapier creates a new order in Shipstation

Not sure how to populate certain fields in Shipstation that HS won’t have:

  • Order #
  • Unique ID

What is the best way to use Formatter to convert HS form choices on size and fit into preexisting SKUs in Shipstation?

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31252 replies
  • September 22, 2020

What is the best way to use Formatter to convert HS form choices on size and fit into preexisting SKUs in Shipstation?

Formatter has a Lookup Table: https://zapier.com/help/doc/how-use-formatter-functions#using-the-lookup-table

Otherwise you could use a GSheet as a Lookup Table via the Lookup Row action.

 

Not sure how to populate certain fields in Shipstation that HS won’t have:

  • Order #
  • Unique ID

Are these required fields or would those be system generated by Shipstation?

If required, then could populate these with the Object ID from HubSpot to create a relationship between apps.


Yes, the Order # and Unique ID are required by the integration. Order # would be created by ShipStation when you start a manual order, no idea why Zapier expects that to be populated by the trigger app.

The google sheet is interesting. I’m wondering if I instead write HS form → Google Sheet (new row) and then to ShipStation. I could use “1000” + [row number] = order number

 

 


nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • 2115 replies
  • December 9, 2020

Hi @Rick_At_Honeycomb!

I see that you reached out to our Support team about a ShipStation Zap. Did they end up helping you solve this issue? If not, please let us know!


I went in a different direction.