Automate creating multiple shipments for an order with a product based criteria

Topic summary

Goal: Automate order fulfilment by splitting orders into multiple shipments based on product type and generating required labels.

Key requirements:

  • Orders contain up to three product types; create one shipment per product type present (e.g., types 1+3 → 2 shipments).
  • For each shipment, generate two labels: a shipping label and a packaging label.
  • Shipping label rule: select the cheapest available rate that is not USPS (United States Postal Service).
  • Store both labels in Google Drive within specified folders.

Context:

  • Applies to an e-commerce store; tags suggest a focus on fulfilment, integrations, and shipping-label workflows.
  • No specific platforms, carriers (besides excluding USPS), or tools for label generation are named, apart from Google Drive for storage.

Status:

  • Problem statement/requirements only; no proposed implementation, decisions, or outcomes yet.
  • Discussion remains open with unspecified details on product-type detection, carrier integrations, and automation workflow.
Summarized with AI on December 20. AI used: gpt-5.

Problem I am solving :

  • An e-commerce store I helped create has 3 types of products

  • An order may have 1 or more product types

  • Need to automatically split order into separate shipments based on product-type. So if only product type one is there create one shipment, If the order has product type 1 and product type 3 - Create 2 shipments

  • For each shipment create Shipping Label and a packaging Label - Criteria of shipping label - Cheapest label that is not USPS

  • Put the shipping Label, Packaging label into Google Drive at specified folders