Hi everyone,

I’m looking to automate the sales order creation and confirmation process in Zoho Inventory, along with the automatic generation of picklists with bin-level details.

Here’s what I need:

1. Sales orders should be automatically created and confirmed when an order is placed on Shopify.
2. Picklists should be auto-generated and must include bin numbers for efficient picking.
3. If multiple bins contain the same product, the system should use the following logic:
   • Check expiry dates bin-wise and select the bin where the units have the nearest shelf life.

Has anyone implemented this kind of automation in Zoho Inventory? Are there built-in workflows or custom scripts that can help achieve this? Any insights or guidance would be highly appreciated!

Thanks in advance!