# Orders related to Appointment Service don't have catalog\_object\_id of taxes

**URL:** <https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770>\
**Category:** Questions\
**Tags:** orders-api\
**Created:** [September 29, 2021, 9:41am UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770 "2021-09-29T09:41:58Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Maciej](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Maciej](https://developer.squareup.com/forums/u/Maciej)\
**Post date:** [September 29, 2021, 9:41am UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/1 "2021-09-29T09:41:58Z")

</div>

Hi,

I’ve been investigating the issue that our customer recently had. I think it’s somehow related to the orders that have used Appointment Service.  
For example, let’s look at this [order](https://jsoneditoronline.org/#left=cloud.b2e0570784694ee58deb49bd3e5ce721):  
It has a `5bbpUZKTM8jyT0VMxJkQkMpeV` id, it has a product variation `FE4H7WQ6HOTCR4O74AI7Y6PG`, and this variation belongs to an item with `AUSSALESTAXML9G5SEBG94ZR` tax catalogue id, however, this tax id doesn’t appear in order’s applied taxes. Could you please explain why it’s not here? Is it a bug or expected behaviour?

Thanks

---

<div class="post-metadata">

**Author:** ![Maciej](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Maciej](https://developer.squareup.com/forums/u/Maciej)\
**Post date:** [September 30, 2021, 7:47am UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/2 "2021-09-30T07:47:57Z")

</div>

Hi there.

I found another customer affected by this issue. Could you please look at this [order](https://jsoneditoronline.org/#left=cloud.9de27b397a234d4bac4286663ac15059)? Describing briefly, there is an order with id `rUF4hxVDQWAuBRuPf4lhF2meV` that has product variation `6D6YYNTBYMUZU5PKZNYMVNLB` and that variation belongs to an item with `AUSSALESTAXML11ZPDVQBD20` tax catalogue, but this tax id doesn’t appear in order’s applied taxes.

Thanks in advance 🙂

---

<div class="post-metadata">

**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\
**Post date:** [September 30, 2021, 5:42pm UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/3 "2021-09-30T17:42:49Z")

</div>

👋 I spoke to the team about this and this is due to the way that the order was created and paid for with Square Appointments. Currently the `applied_taxes` won’t contain the Id for the tax. You will need to get the `tax_id` by getting the `related_objects` associated to the item. 🙂

---

<div class="post-metadata">

**Author:** ![Maciej](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Maciej](https://developer.squareup.com/forums/u/Maciej)\
**Post date:** [September 30, 2021, 5:58pm UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/4 "2021-09-30T17:58:31Z")

</div>

Thanks for the response. I appreciate it. 🙂

---

<div class="post-metadata">

**Author:** ![Maciej](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Maciej](https://developer.squareup.com/forums/u/Maciej)\
**Post date:** [October 1, 2021, 10:18am UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/5 "2021-10-01T10:18:32Z")

</div>

Hi,

Actually, there is one more thing I would like to know.  
Could you please confirm if by _“You will need to get the `tax_id` by getting the `related_objects` associated to the item.”_ you mean that we should extract an **id** from the _Appointments Service_ item’s **tax\_ids** to find out which **taxes** were used during the order creation? So, those **tax\_ids** can be matched with **taxes** on the particular **line\_item**?

 ![app-service-tax-id-retrieve-explanation](https://global.discourse-cdn.com/square/original/1X/223a3f81e7892694f5286fac67617248bca69ecb.png)  
Would you please confirm if my understanding is correct? I’ll appreciate it.

Thanks!

---

<div class="post-metadata">

**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\
**Post date:** [October 1, 2021, 3:41pm UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/6 "2021-10-01T15:41:50Z")

</div>

Yes, you are correct! 🙂

---

<div class="post-metadata">

**Author:** ![Maciej](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Maciej](https://developer.squareup.com/forums/u/Maciej)\
**Post date:** [October 11, 2021, 9:57am UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/7 "2021-10-11T09:57:16Z")

</div>

Hi again,

I have another question regarding the same customer.  
Besides Square Appointments-related orders, we found some `taxes` still don’t have `catalog_object_id` assigned. For example this [order](https://jsoneditoronline.org/#left=cloud.af4444bdb1524057bc9f1767c581b7c1) has line item with **uid** `e274a8d7-8bcd-4248-be22-db09b57ae186` that is related to the **product\_variant** with **id** `P7B3J3WLCQIGN2SE7VW5FXAC` and this variant belongs to an item with `AUSSALESTAXML9G5SEBG94ZR` tax catalog id, but order field `taxes` doesn’t contain such a relation.  
Can we match it in the same way we did for Square Appointment items, so we will know which `id` of the tax was used for the particular `line_item`?

 ![app-item-tax-id-retrieve-explanation](https://global.discourse-cdn.com/square/original/1X/7bfbe489d1842285d4c5015865b39870e3bd0920.png)  
Is the solution you gave us also applicable for this issue? If yes, how we can distinguish between real ad-hoc taxes and those created using the shown relation?

Thanks.

---

<div class="post-metadata">

**Author:** ![Maciej](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Maciej](https://developer.squareup.com/forums/u/Maciej)\
**Post date:** [October 11, 2021, 12:34pm UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/8 "2021-10-11T12:34:57Z")

</div>

Besides this customer, there is another one that has a similar issue.

Initially, we thought that it’s somehow related to how **Weebly** works (which is not supported by us). But our customer said it’s not - he doesn’t use that. So, by investigating the [order](https://jsoneditoronline.org/#left=cloud.ff251cea0b384e939e3b4f631af4ac16), we found a potential association with **catalogue tax** (described in previous posts) which we want potentially use. We already know that it works for Square Appointments, so maybe we can use that for other similar issues like this one also?

This affects all line items of order with id `6JvvCEthVgqVnBcxmTIMoKlK73RZY`.

Sorry, for linking so many tickets here, but we want to find a more general solution if possible.

---

<div class="post-metadata">

**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\
**Post date:** [October 11, 2021, 5:38pm UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/9 "2021-10-11T17:38:25Z")

</div>

👋 Yes, with the orders you provided you will match it in the same way you did for Square Appointment items, so you will know which `id` of the tax was used for the particular `line_item` . Also for Square Online store orders like `6JvvCEthVgqVnBcxmTIMoKlK73RZY ` you can use the same process to figure our the taxes.

---

<div class="post-metadata">

**Author:** ![Maciej](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Maciej](https://developer.squareup.com/forums/u/Maciej)\
**Post date:** [October 12, 2021, 6:58am UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/10 "2021-10-12T06:58:37Z")

</div>

Thanks Bryan.

I see, so we can use this process for Square Appointments and even for Square Online. But how about `59A3UWzvLuvxzgzbkMEi2JseV`. As I understand, this is not Square Online order. So, is this a coincidence that we can also apply the same process here? I’m asking because I’m looking specifically for general solutions, but I don’t see anything special regarding this particular order.

---

<div class="post-metadata">

**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\
**Post date:** [October 12, 2021, 4:15pm UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/11 "2021-10-12T16:15:11Z")

</div>

I’m not sure I fully understand the question. This order `59A3UWzvLuvxzgzbkMEi2JseV ` is from Square Appointments.

---

<div class="post-metadata">

**Author:** ![Maciej](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Maciej](https://developer.squareup.com/forums/u/Maciej)\
**Post date:** [October 13, 2021, 4:21pm UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/12 "2021-10-13T16:21:54Z")

</div>

Right, I’m very sorry I didn’t notice that it was Square Appointment service.  
Please assume there wasn’t this part of a question 😃  
Thanks.

---

<div class="post-metadata">

**Author:** ![Maciej](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Maciej](https://developer.squareup.com/forums/u/Maciej)\
**Post date:** [March 27, 2024, 9:04am UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/13 "2024-03-27T09:04:12Z")

</div>

Hi @Bryan-Square , I wasn’t sure if I should open another issue or continue on this one, but the thing that we found, based on our prior experience, might be related to the Apportioned Services topic.

Recently, we stopped using the workaround described above, as Square seems to resolve the issue and now properly return the `catalog_object_id` of taxes when the sale is related to the appointment services.

Unfortunately, after making this shift, we started notice some occurrences of missing `catalog_object_id` in some orders, potentially related to appointment services, even though, the majority of the orders returns the `catalog_object_id`.

For example, based on this order:

```auto
{
  "id": "5bbpUZKTM8jyT0VMxJkQkMpeV",
  "location_id": "LFQ21VWDKFHA2",
  "line_items": [
    {
      "uid": "baeb396d-4c4f-4a95-a5f1-a5b2b36d7bd4",
      "catalog_object_id": "FE4H7WQ6HOTCR4O74AI7Y6PG",
      "catalog_version": 1631443425453,
      "quantity": "1",
      "name": "264.14 - GS - FULL CLIP and Wash",
      "variation_name": "Regular",
      "base_price_money": {
        "amount": 9000,
        "currency": "AUD"
      },
      "gross_sales_money": {
        "amount": 9000,
        "currency": "AUD"
      },
      "total_tax_money": {
        "amount": 818,
        "currency": "AUD"
      },
      "total_discount_money": {
        "amount": 0,
        "currency": "AUD"
      },
      "total_money": {
        "amount": 9000,
        "currency": "AUD"
      },
      "variation_total_price_money": {
        "amount": 9000,
        "currency": "AUD"
      },
      "applied_taxes": [
        {
          "uid": "3521d169-f574-41f0-b7df-46db181190b1",
          "tax_uid": "c75a229a-5afe-4e09-aa47-9e41819f7c5f",
          "applied_money": {
            "amount": 818,
            "currency": "AUD"
          }
        }
      ],
      "item_type": "ITEM"
    }
  ],
  "taxes": [
    {
      "uid": "c75a229a-5afe-4e09-aa47-9e41819f7c5f",
      "name": "GST",
      "percentage": "10",
      "type": "INCLUSIVE",
      "applied_money": {
        "amount": 818,
        "currency": "AUD"
      },
      "scope": "LINE_ITEM"
    }
  ],
  "created_at": "2021-09-23T04:19:46Z",
  "updated_at": "2021-09-23T04:19:46Z",
  "state": "COMPLETED",
  "total_tax_money": {
    "amount": 818,
    "currency": "AUD"
  },
  "total_discount_money": {
    "amount": 0,
    "currency": "AUD"
  },
  "total_tip_money": {
    "amount": 0,
    "currency": "AUD"
  },
  "total_money": {
    "amount": 9000,
    "currency": "AUD"
  },
  "closed_at": "2021-09-23T04:19:46Z",
  "tenders": [
    {
      "id": "LdWNQSRu6BvRtMqjxnx2XDxouaB",
      "location_id": "LFQ21VWDKFHA2",
      "transaction_id": "5bbpUZKTM8jyT0VMxJkQkMpeV",
      "created_at": "2021-09-23T04:19:44Z",
      "amount_money": {
        "amount": 9000,
        "currency": "AUD"
      },
      "processing_fee_money": {
        "amount": 198,
        "currency": "AUD"
      },
      "customer_id": "H1B1Y5R7714SD6X08AGZTH8PKG",
      "type": "CARD",
      "card_details": {
        "status": "CAPTURED",
        "card": {
          "card_brand": "VISA",
          "last_4": "3660",
          "fingerprint": "sq-1-E4SnuqE8c1xyFJ4HOCd-Z3INRMcCblqP3zF_Ez3_uWyHOpQJ6zhMcgQEp7CUt7Fq8g"
        },
        "entry_method": "KEYED"
      },
      "tip_money": {
        "amount": 0,
        "currency": "AUD"
      }
    }
  ],
  "total_service_charge_money": {
    "amount": 0,
    "currency": "AUD"
  },
  "return_amounts": {
    "total_money": {
      "amount": 0,
      "currency": "AUD"
    },
    "tax_money": {
      "amount": 0,
      "currency": "AUD"
    },
    "discount_money": {
      "amount": 0,
      "currency": "AUD"
    },
    "tip_money": {
      "amount": 0,
      "currency": "AUD"
    },
    "service_charge_money": {
      "amount": 0,
      "currency": "AUD"
    }
  },
  "net_amounts": {
    "total_money": {
      "amount": 9000,
      "currency": "AUD"
    },
    "tax_money": {
      "amount": 818,
      "currency": "AUD"
    },
    "discount_money": {
      "amount": 0,
      "currency": "AUD"
    },
    "tip_money": {
      "amount": 0,
      "currency": "AUD"
    },
    "service_charge_money": {
      "amount": 0,
      "currency": "AUD"
    }
  },
  "customer_id": "H1B1Y5R7714SD6X08AGZTH8PKG"
}

```

We can see that the `taxes` array is missing the `catalog_object_id`, when similar orders like `YwCnODosEGgbtZe2rMDybX1eV`, created, according to the customer, in the same source, properly includes the property.

Might I know what is the key factor that decides whether the order will have the `catalog_object_id` or not? Is it something that can be fixed/adjusted by Square, or the workaround will still be required?

Thank you.

---

<div class="post-metadata">

**Author:** ![Maciej](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Maciej](https://developer.squareup.com/forums/u/Maciej)\
**Post date:** [April 9, 2024, 7:43am UTC](https://developer.squareup.com/forums/t/orders-related-to-appointment-service-dont-have-catalog-object-id-of-taxes/3770/14 "2024-04-09T07:43:41Z")

</div>

Hi @Bryan-Square , a gentle follow-up on this matter please.
