cancel
Showing results for 
Search instead for 
Did you mean: 

PSA: You can accomplish automation for MULTIPLE ITEM ORDERS by using hashes in product weight.

JakeM
Contributor

Hi,

 

I realized this was possible a while ago, and have been using it to great effect since that time, but neglected to share this with the community. So, here:

In short, shipstation allows you to enter in product weights up to 2 digit precision, and then make automation decisions based on that 2 digit precision of total order weight. If you carefully pick the weights of item classes, you can use this to create automation rules for multiple item orders (I have used certain prime numbers) as each total order weight will be unique. You can use this for anything that can be set with automation. There are some caveats:

 

  • You cannot specify more than 1 weight in a single rule (eg no 43.32;21.76 etc as you can with strings) 
  • The two digit precision is set when you create/import products using csv, or enter it manually within a product page. If you export products, shipstation will round this number; this doesn't come up often, but make sure if you are downloading and then reuploading to accomplish updates that you are setting the weight again, and not using the weight shipstation provides. 

To work with the single weight specified per line, I have been setting all rules to set a flag for a particular weight combo, and then afterwards using that flag to automate what I wish all such matching orders to do. 

I have create a google sheet that details this and will allow you to easily copy and paste to create automation rules (unfortunately you have to use the GUI to set automation rules.)

Here:

https://docs.google.com/spreadsheets/d/1nneF2dGZPjBP47nOm0AISvzFdC6qMRIOae8RNL9qsRc/edit?usp=sharing

Hope you enjoy!
Mike

2 REPLIES 2

JakeM
Contributor

And here is the process in the automation side:

ss_automation.jpg


Each of those lines is checking a particular unique weight, and then applying a flag. For instance, each flatPadded_## rule is setting a 'flat_padded' flag. I can then use the 'flat_padded' flag for other automation further down.

Hey there @JakeM

 

Thank you for providing this workflow you've worked on! The creative solutions and knowledge of the community continue to impress! 

 

I'm sure that this type automation setup will be beneficial to many users now and down the road when they come across this post. 

From Moderator Davis, May the force be with you!