Unable to Create Order

GraphQL API
1

Hi we are not able to create an order to our production account. We have checked on our end and validated that the order number that we provided does not exist yet on our records.
Can you help us to resolve this?

Please find the following details below:

Request Body Params

mutation CreateOrder {
  order_create(data: {
    order_date: "2022-09-28",
    required_ship_date: "2022-09-30",
    order_number: "DO92592892215854O",
    shop_name: "Zoho - Order",
    packing_note: "INTERNAL NOTES:\\nITEMS IN 43 KEPPEL \\nVictoria Ong: 83281336\\n\\n- send office the 12 digit unique code \\n\\n1 x APRIL 22 Skin Energy Perfecting Eye Mask(5mlx10pairs) - SKU: Skin Energy Perfecting Eye Mask(5mlx10pairs) - Ref: 17\\n1 x APRIL 22 Skin Energy Perfecting Eye Cream 15ml - SKU: Skin Energy Perfecting Eye Cream 15ml - Ref: 18\\n1 x APRIL 22 Rose Energy Cream 30g - SKU: Rose Energy Cream - Ref: 7\\n2 x APRIL 22 Acne Rescue - SKU: Acne Rescue - Ref: 5\\n\\nCUSTOMER NOTES:\\nKindly send us 12 digit unique codes, thanks",
    profile: "default",
    email: "daniel_khai@hotmail.com",
    tags: "UID9259",
    fulfillment_status: "pending",
    skip_address_validation: true,
    priority_flag: false,
    shipping_address: {
      first_name: "Victoria Ong",
      last_name: "",
      address1: "Yishun Avenue 6",
      address2: "#02-1030",
      city: "Singapore",
      state: "Singapore",
      zip: "760391",
      country: "SG",
      phone: "83281336"
    },
    shipping_lines: {
      price: "0",
      title: "Manual Order Shipping Method",
      method: "genericlabel",
      carrier: "Generic"
    },
    line_items: [
      {
        partner_line_item_id: "DO92592892215854O_Skin Energy Perfecting Eye Mask(5mlx10pairs)",
        quantity: 1,
        sku: "Skin Energy Perfecting Eye Mask(5mlx10pairs)",
        product_name: "Ref17: APRIL 22 Skin Energy Perfecting Eye Mask(5mlx10pairs)",
        warehouse_id: "V2FyZWhvdXNlOjgwMjMw",
        price: "0"
      },
      {
        partner_line_item_id: "DO92592892215854O_Skin Energy Perfecting Eye Cream 15ml",
        quantity: 1,
        sku: "Skin Energy Perfecting Eye Cream 15ml",
        product_name: "Ref18: APRIL 22 Skin Energy Perfecting Eye Cream 15ml",
        warehouse_id: "V2FyZWhvdXNlOjgwMjMw",
        price: "0"
      },
      {
        partner_line_item_id: "DO92592892215854O_Rose Energy Cream",
        quantity: 1,
        sku: "Rose Energy Cream",
        product_name: "Ref7: APRIL 22 Rose Energy Cream 30g",
            warehouse_id: "V2FyZWhvdXNlOjgwMjMw",
            price: "0"
          },
          {
            partner_line_item_id: "DO92592892215854O_Acne Rescue",
            quantity: 2,
            sku: "Acne Rescue",
            product_name: "Ref5: APRIL 22 Acne Rescue",
            warehouse_id: "V2FyZWhvdXNlOjgwMjMw",
            price: "0",
        }
    ]
  }) {
    complexity
    request_id
    order {
			id
      legacy_id
      order_number
      fulfillment_status
      line_items(first: 300) {
          edges {
              node {
                  id
                  sku
                  quantity
                  quantity_pending_fulfillment
                  quantity_shipped
                  quantity_allocated
                  warehouse_id
                  warehouse
                  fulfillment_status
                  tote_picks {
                      picked_quantity
                      quantity
                      created_at
                      updated_at
                  }
              }
          }
      }
    }
  }
}

Error Response

{
  "data": null,
  "errors": [
    {
      "code": 6,
      "field": "order_create",
      "message": "An order with order_number 66806  and shop_name zoho  already exists",
      "operation": "order_create",
      "request_id": "6335060fb0631a0168887827"
    }
  ]
}

Looking forward for your response.

Kind Regards,
Altair

2

Hey @Altair,

Thanks for reaching out!
I’ll look into this and get back to you with an update.

Best,
RayanP

3

Hey @Altair,

Thanks for hanging in there. I was able to find the order in appdot: https://app.shiphero.com/dashboard/orders/details/299455554.

According to our logs the order was created at exactly 9/28 0:00 UTC but not imported until 9/29 3:18 UTC. The mutation you made above was done at 9/29 2:42 UTC. So the issue was that the order did exist at the time of the mutation but it wasn’t imported till about 40 minutes later. Looking into why this order took so long to import.

Is this happening to multiple orders or just this one?

Please let me know if you have any questions or concerns.

Best,
RayanP