Tip #4.1 Auto-creating package and shipment records for your offline sales orders

Tip #4.1 Auto-creating package and shipment records for your offline sales orders

Hello,


Hope this post finds you in good health.
Last week we saw how we could automate item weight calculation for your orders. This week we will go a step further and see how you can automate the process of creating packages and shipments for your sales orders. 

To make it easier for the reader, this post has been split into two. Part 1 or tip #4.1 will tell you how you can auto-create package and shipment records in Zoho Inventory for your offline orders while tip #4.2 or part 2 will tell you how to do the same for online orders.

Who is this for?

Any business that ships goods as soon as an order is made and has very less time on their hands for paperwork (same day shipments using a single carrier/by self).


How does this work? 

It all begins with a sales order draft inside of Zoho Inventory. As soon as you email the sales order to a client or manually mark it as confirmed, the system uses this status change as a trigger for creating a package record (with all of the items on your sales order). Once this is done, the system will record a manual shipment record within the system against a preset shipping medium (which can be configured by you as you write the custom function into Zoho Inventory). 

Now, let's see how we can write this custom function for your business.

Setting up the custom function:

Log in to your Zoho account and click on this link to generate an Auth Token which is required to make this work.
  • Open your Zoho Inventory organization.

  • Navigate to Settings using the gear icon from the top-right corner.

  • Select Automation from the sidebar. Now click on the button adjacent to +New Workflow Rule.

  • Out of the four options from the drop-down, select Custom Functions.

  • Now let's add a name for this workflow rule and make sure that there are no spaces between words.

  • Select Sales Orders against module.

  • Add a description if you need one.

  • Now, the workflow type is going to be Event Based.

  • The condition to set shall be, "When a Sales Order is created".

  • And, for the trigger, it will be "When Sales Order status is Confirmed".

  • Now copy and paste this code snippet into the deluge pane:

salesorderID = salesorder.get("salesorder_id"); 

salesorderdate = salesorder.get("date").toDate();

organizationID = organization.get("organization_id");

authtoken = "Copy and paste your authtoken here";

mapper = Map();

customerID = salesorder.get("customer_id").toString();

//package_number = salesorder.get("salesorder_number").replaceFirst("SO","PA");

//mapper.put("package_number",package_number);

mapper.put("customer_id",customerID);

mapper.put("date",salesorderdate);

lineItems = salesorder.get("line_items").toList();

newLineItems = List();

for each lineItem in lineItems

{

lineItemMap = Map();

solineitemID = lineItem.get("line_item_id");

lineItemMap.put("so_line_item_id",solineitemID);

quantity = lineItem.get("quantity");

lineItemMap.put("quantity",quantity);

newLineItems.add(lineItemMap);

}

mapper.put("line_items",newLineItems);

jsonString = Map();

jsonString.put("JSONString",mapper);

response = invokeurl

[

url :"https://inventory.zoho.com/api/v1/packages?authtoken=" + authtoken + "&salesorder_id=" + salesorderID + "&organization_id=" + organizationID

type : POST

parameters:jsonString

];

info mapper;

info response.toMap();

//shipment

pack=response.get("package");

packid=pack.get("package_id");

ship=Map();

ship.put("date",salesorderdate);

ship.put("delivery_method","dhl"); //REPLACE WITH SHIPPING CARRIER NAME OR DELIVERY BY SELF

jsons=Map();

jsons.put("JSONString",ship);

resp = invokeurl

[

url: "https://inventory.zoho.com/api/v1/shipmentorders?package_ids="+packid+"&salesorder_id=" +salesorderID+ "&authtoken="+authtoken+"&organization_id=" + organizationID

type: POST

parameters: jsons

];

info resp.toMap().get("message");


  • Copy and replace your authtoken number with the text on line 4 of the code.

    • authtoken = "copy and paste your authtoken here"to something like, authtoken = "67xxxxxxxxxxxxxxxxx".

  • You can change the carrier name/shipping medium by making changes to line 38 of the code that says: ship.put("delivery_method","dhl"); //REPLACE WITH SHIPPING CARRIER NAME - for e.g., "dhl" can be replaced with "fedex" or something of your choice like say, "delivery_by_self" or "picked_up_by_customer".

  • Note: If you have enabled auto-generation of package numbers for your organization, then you don't need these two lines:

    • //package_number = salesorder.get("salesorder_number").replaceFirst("SO","PA");

    • //mapper.put("package_number",package_number);

  • Once everything is ready, hit Save.


Henceforth, all your offline sales orders (that have been confirmed) will have packages and manual shipment records created inside of Zoho Inventory.

Please check out the part 2 of this post titled - Tip #4.2 Auto-creating package and shipment records for your online sales orders on our forums.

Until next time.

Your everyday end user,
Ajay Aadhithya Chandrasekaran
Zoho Inventory


    Access your files securely from anywhere









                          Zoho Developer Community




                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts





                                                          Manage your brands on social media



                                                                Zoho TeamInbox Resources



                                                                    Zoho CRM Plus Resources

                                                                      Zoho Books Resources


                                                                        Zoho Subscriptions Resources

                                                                          Zoho Projects Resources


                                                                            Zoho Sprints Resources


                                                                              Qntrl Resources


                                                                                Zoho Creator 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


                                                                                          Zoho Show Resources

                                                                                            Zoho Writer

                                                                                            Get Started. Write Away!

                                                                                            Writer is a powerful online word processor, designed for collaborative work.

                                                                                              Zoho CRM コンテンツ






                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • XML format to import knowledgebase into Zoho Desk

                                                                                                            Hi, We just started to use Zoho Desk and want to import our knowledgebase from our old support system (Freshdesk) to Zoho Desk. Can anyone give us information about the format of xml file to import? There is no explanation on the related page.
                                                                                                          • Arranging Ticket Templates

                                                                                                            Is there any way to arrange our ticket templates? It doesn't look very organised when it's just arranged according to when they were created. We want the list to look more organised, by arranging/grouping them by topics, or even just by alphabetical
                                                                                                          • What they mean with "Portal"?

                                                                                                            I just downloaded this app to take my personal notes on digital art studio because it seemed to me the most comfortable app to do it, I use it very often, what do they mean by “no activity on your portal”? I have about 1 year of work here and I don't
                                                                                                          • favorites no longer listed

                                                                                                            Hello, I can no longer navigate to my Favorites from the pulldown at the top of my grid view (see attached screenshot). I wasn't able to find it anywhere! Please help me display my Favorites. Thank you!
                                                                                                          • Notecards Disappeared

                                                                                                            Got a new phone. Downloaded and signed in Zoho Notebook. Not finding the Note cards. Just Empty Note books. Frustrating.
                                                                                                          • Table Errors

                                                                                                            Hello, I'm new to Zoho Notebook and using it on several Mac/Apple devices. My question is regarding tables: Why do they become broken, and how to fix the error without retyping all my data? (Please see the screenshot attached.)
                                                                                                          • Online Calculator with Zoho Forms?

                                                                                                            I'd like to build a custom calculator on my website. Zoho Forms seems to offer all the fields for basic calculations performed live without pressing any "Calculate" buttons. Unfortunately, there is still that "Submit" button at the bottom. There is nothing
                                                                                                          • Zoho Tables instead of Zoho Creator Spreadsheet reports <3

                                                                                                            That would make my day for sure. Zoho Creator is create, but miss data entering as AirTable/Spreadsheet can. Seeing Zoho putting effort in this makes me think maybe one day we could see a similar interface for Zoho Creator spreadsheet reports. B.
                                                                                                          • Notebook Stack

                                                                                                            Hi Everyone I Hope you´re fine, I´m sorry if this idea was posted before (I made a search but I haven´t find anything related). So, Having the possibility of stacking notebooks would be an interesting way to order notebooks that correspond to the same
                                                                                                          • Writing on sketch cards is bugged when zoomed in

                                                                                                            When zoomed in, it writes a noticeable distance above or to the side of where you're actually trying to write. The further you're zoomed in, the more noticeable it is. Zooming is also entirely absent on the desktop version.
                                                                                                          • Swipe between notes on iPhone

                                                                                                            It'd be convenient if I could move from one note to the next in a notebook simply by swiping left to right.
                                                                                                          • Sales IQ chat is not working in signed android apk

                                                                                                            I have integrated ZOHO sales IQ support chat and i have followed each step and its working fine in my development build but when i create signed APK for it. Chat does not work in it and showing awaiting for detail. I previously asked the same query but
                                                                                                          • COQL order by COUNT not working

                                                                                                            Dear community, I am trying to get a list of deal amounts per planner working on it and sorted to get see who has the least amount of deals. For some reason, I am unable to use sort by in combination with a COUNT. My original code was: query = "select
                                                                                                          • I want to duplicate a report and name it something else

                                                                                                            Hi, I have created a report, and now want to reproduce it and call it something else. so that I will end up with TWO separate reports with different titles. Please tell me how do I copy / reproduce a report please
                                                                                                          • Zoho CRM: Sales Rep Professional Certification Program on Coursera

                                                                                                            We are happy to share that we have published the Zoho Sales Representative Professional Certificate in partnership with Coursera, a leading platform for online learning and career development that offers access to courses and degrees from leading universities
                                                                                                          • OS X Notebook quits immediately upon launch

                                                                                                            NoteBook for OS X (Sequoia, but also under Sonoma) always quits immediately upon launch (so I cannot use the "Attach user log" option). I've restarted my MacBook but the problem persists. If it helps, attached is a diagnostic report from Library>Log
                                                                                                          • Can External users upload files or images to WorkDrive?

                                                                                                            I want to know if it is possible for someone externally through a link and PW be able to upload files and images onto WorkDrive?
                                                                                                          • Multi-line fields character limits

                                                                                                            Is there a way to set the character limit higher on multi-line fields so that we are not losing information pasted into the field? When the text is entered or pasted, there is no error to say that the text is too large. After saving and going back to view most of the text is gone.   Also, when viewing the resume, the text is not wrapped in the multi line fields and can t be read without scrolling across the page.
                                                                                                          • Taz bot not working — What should I do to resolve this issue?

                                                                                                            I am experiencing issues with the Taz bot in Zoho Cliq—not receiving responses or it does not seem to work as expected. Could you please explain why the Taz bot might not be functioning and what steps I should take to resolve this issue? Thank you!
                                                                                                          • OneNote Migration

                                                                                                            I am trying to migrate two notebooks from OneNote. For five days now I have had no notification that migration has completed and the migration page show 50% complete - one notebook completed one not finished. It just stays like this. I am unable to cancel
                                                                                                          • Set various time slot reminders for task and event

                                                                                                            Hi I would like known if there is possibility to set various time reminders for a task or event like we have the possibility to do in google calendar or google task. For example I'am creating an event or task and I want to be alerted before 30min and
                                                                                                          • Zoho Calendar not functioning---cannot edit, add attendees, etc.

                                                                                                            Hello, My calendar is acting strange. I'm using Chrome as my browser and pop ups are not blocked (the calendar worked fine yesterday). When creating an event, I'm not able to "edit" the event and add attendees, etc. The link is non-responsive. I cannot
                                                                                                          • Spilt Axis for stacked column and line graph

                                                                                                            Each month around this time I prepare a business review deck. One of the biggest annoyances I have with Zoho, also happens to be something that most other platforms have provided for a long time now, and that is being able to create a chart with stacked
                                                                                                          • Pin a note on top

                                                                                                            Dear Zoho Notebook Team, Please highly consider adding ability to pin a note on top and arrange pinned notes. I have a lot of notes that I want to pin important ones on top and this feature is missing badly. Thank you.
                                                                                                          • Windows 11 app ver 2.2.8

                                                                                                            I have been trialing Zoho Notes syncing between my PC and iphone. No problems with iphone but the Windows 64 bit app ver 2.2.8 was very buggy and would lock up completely, needing a Control Alt Delete etc to close it down. It seemed to be connected to
                                                                                                          • Deluge Script: Onboarding → Access Form

                                                                                                            Hello everyone, Edit: Sorry, I think I put this topic in the wrong section. I’ve recently run into an issue that’s been giving me a bit of a headache for the past few weeks. Context: This is my first time using Deluge to create a script, but it’s not
                                                                                                          • Windows Device Authentication

                                                                                                            We have recently started using ManageEngine, and my boss saw a device management feature in the Zoho One directory. We thought it would either help give us more intergration into Zoho one through bringing ManageEngine services through Zoho one. Or, it
                                                                                                          • How can I change spell check language?

                                                                                                            I cannot find the way to change spell check language. My "display language" is English, and I want to have the same one for Spell Check, but it is Russian!!! How can I change it? In one of your explanations you mentioned that I have to choose it from
                                                                                                          • Mail is so slow - doesn't even work!

                                                                                                            Mail has been getting slower and slower - and today it's not even pulling up emails in either Inbox or Unread. This is beyond frustrating since email is a big part of business. Sent a request through the useless help portal - no response. Called the useless
                                                                                                          • User marked as SPAMMER. Mail Fetch has also been disabled for any active POP accounts.

                                                                                                            I am the administrator for joelles.com One of our accounts has been blocked saying this: User marked as SPAMMER. Mail Fetch has also been disabled for any active POP accounts. I cannot change the disabled account in the control panel as it says that it
                                                                                                          • My domain did not activate

                                                                                                            Hi, my domain (apsaindustrial.com.ar) did not activate, and the phone verification message never arrived. Please would you solve this problem? Thanks.
                                                                                                          • ME SALE ESTE ERROR: No fue posible enviar el mensaje;Motivo:554 5.1.8 Email Outgoing Blocked

                                                                                                            Ayuda!! Me sale este error al intentar enviar mensajes desde mi correo electronico de Zoho! Tampoco recibo correos pues cuando me envia rebotan. Ayuda, Me urge enviar unos correo importantes!! Quedo atenta MAGDA HERNANDEZ +5731120888408
                                                                                                          • Is there a way to sync Tags between CRM and Campaigns/Marketing Hub?

                                                                                                            I wonder if there is a way to synch the tags between CRM and Marketing-Hub / Campaigns?
                                                                                                          • how to see if a specific contact opened an email in zoho campaign?

                                                                                                            how to see if a specific contact opened an email in zoho campaign?
                                                                                                          • Revenue Management: #8 Revenue Recognition in Educational & Training Institutions

                                                                                                            Educational Institutions and training centres typically collect course fees at the time of enrolment, sometimes for a one-day workshop and sometimes for a year-long certification course. You might also charge separately for course materials or evaluation.
                                                                                                          • How to Customize Task Creation to Send a Custom Alert Using JavaScript in Zoho CRM?

                                                                                                            Hello Zoho CRM Community, I’m looking to customize Zoho CRM to send a custom alert whenever a task is created. I understand that Zoho CRM supports client scripts using JavaScript, and I would like to leverage this feature to implement the alert functionality.
                                                                                                          • Using files from Zoho CRM in Gemini/ChatGPT/Claude

                                                                                                            Hi all, I’ve got subscriptions to Gemini and a few other AI tools which I use for tasks like data enrichment, email composition, etc. In our workflow, we often receive various documents from clients — such as process workflows, BRDs/requirement documents
                                                                                                          • Maximum file limit in zoho people LMS

                                                                                                            Dear Team, I am having approximately 4.9 GB of material, including PPTs and videos for uploading in zoho people LMS course. May I know what is the maximum limit limit for the course files Thanking you, With regards, Logeswar V Executive _ Operations
                                                                                                          • Dynamically prefill ticket fields

                                                                                                            Hello, I am using Zoho Desk to collect tickets of our clients about orders they placed on our website. I would like to be able to prefill two tickets fields dynamically, in this case a readonly field for the order id, and a hidden field for the seller
                                                                                                          • Optimize your Knowledge Base for better visibility by allowing search engine crawling and indexing

                                                                                                            All you need to know about no-follow and no-index in KB. What are article crawlability and indexability? Crawlability and indexability are vital for making an article visible and accessible to search engines. When a search engine crawls an article, it
                                                                                                          • Next Page