Zoho Inventory - Inventory Integrity when utilizing third party platform to Ship

Zoho Inventory - Inventory Integrity when utilizing third party platform to Ship

Good Day! I have a unique situation and wanted to see if anyone has any ideas on this. 

Diving in, I don't currently use Zoho Inventory as it does not quite fit my needs. The reason for this is that I Ship Externally from Zoho but utilize Zoho using Zoho Books to bill weekly. When the Invoices are created it does deduct Inventory but since we do this just once per week this puts us a week behind on Inventory counts.

The platform I use to ship is Shipstation. That is where all of my commerce channels are connected and I created a Custom Report in there of which I utilize for a manual Billing/Invoice creation process in Zoho Books. Despite this being manual I do not want to swap more into Zoho and ship out of here. I need to keep the process with Shipstation and Zoho Books. 

What I initially tried was to create a Zoho Flow between Shipstation and Zoho Inventory. In theory it could work but I did find some significant roadblocks. Those roadblocks are:

1)- Can only have one Store connection per Shipstation Flow
2)- Item ID in Zoho Inventory will only allow me to select one Item per Inventory Flow

To also elaborate on the Flow the Shipstation trigger would be 'Order Shipped' and the Zoho Inventory Action would be 'Create Inventory Adjustment'. This would keep Inventory accurate as I would remove the Books Integration and upon each Shipstation order shipped would make the necessary Inventory adjustment on the item to keep Inventory Integrity.

Now I do understand that I can create multiple Flows but is not really feasible in my case. While doing a different Flow per Shipstation Store is not ideal but no too adverse, the limitation on just one item per Inventory Flow is. I really wish they would allow all items to be selected as an option. Without that this makes it so that I would need a couple hundred Flows per the different items, potentially even more Flows as I would have to duplicate that per each store. (Not really sure if that amount would be seamlessly supported)

While this is somewhat of a 'solution' I have yet to try it due to running into a bug where not all of my Inventory Items are visible in the Flow, as I have quite a few. I have reported this to the Flow team and am awaiting a response to move forward.

I was then looking into Zapier as a possible Integration that could be made but they unfortunately do not support the Inventory Adjustment action in Zoho Inventory.

This to me seems like a unique situation and while other systems/platforms may support my use case, at this time I am not able to swap to those. I would be happy to hear any ideas one would have on this to get accurate Inventory daily.

Much appreciated!

    Access your files securely from anywhere

        Zoho Developer Community




                                  Zoho Desk Resources

                                  • Desk Community Learning Series


                                  • Digest


                                  • Functions


                                  • Meetups


                                  • Kbase


                                  • Resources


                                  • Glossary


                                  • Desk Marketplace


                                  • MVP Corner


                                  • Word of the Day



                                      Zoho Marketing Automation


                                              Manage your brands on social media



                                                    Zoho TeamInbox Resources

                                                      Zoho DataPrep Resources



                                                        Zoho CRM Plus Resources

                                                          Zoho Books Resources


                                                            Zoho Subscriptions Resources

                                                              Zoho Projects Resources


                                                                Zoho Sprints Resources


                                                                  Qntrl Resources


                                                                    Zoho Creator Resources



                                                                        Zoho Campaigns Resources


                                                                          Zoho CRM Resources

                                                                          • CRM Community Learning Series

                                                                            CRM Community Learning Series


                                                                          • Kaizen

                                                                            Kaizen

                                                                          • Functions

                                                                            Functions

                                                                          • Meetups

                                                                            Meetups

                                                                          • Kbase

                                                                            Kbase

                                                                          • Resources

                                                                            Resources

                                                                          • Digest

                                                                            Digest

                                                                          • CRM Marketplace

                                                                            CRM Marketplace

                                                                          • MVP Corner

                                                                            MVP Corner





                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now