Call for transactions for a specific item id returns all transactions for the location

Questions
1

trying to use the endpoint https://connect.squareup.com/v2/locations/{location_id}/transactions?item_id={item_id}

I think I’m using the correct Item_id. When I retrieve the information for the product, It returns the following I’m assuming the item_id in this case would be JTWDGQ6W5E5T5ZVPALVNA2VE. I’ve also tried using 3NQD4SPM75WBXCD2WZTDNVE4 with the same result.

[type] => ITEM
                    [id] => 3NQD4SPM75WBXCD2WZTDNVE4
                    [updated_at] => 2023-04-29T15:14:05.037Z
                    [created_at] => 2022-08-27T18:17:48.845Z
                    [version] => 1682781245037
                    [is_deleted] => 
                    [present_at_all_locations] => 
                    [present_at_location_ids] => Array
                        (
                            [0] => L2NZ8JD1GZZQ1
                        )

                    [item_data] => stdClass Object
                        (
                            [name] => Paint and Sip
                            [abbreviation] => Fo
                            [is_taxable] => 1
                            [visibility] => PRIVATE
                            [category_id] => GZV4ZOUB4BCKFOVPWHPFM5DQ
                            [variations] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [type] => ITEM_VARIATION
                                            [id] => JTWDGQ6W5E5T5ZVPALVNA2VE
                                            [updated_at] => 2023-04-06T19:33:39.559Z
                                            [created_at] => 2022-08-27T18:17:48.845Z
                                            [version] => 1680809619559
                                            [is_deleted] => 
                                            [present_at_all_locations] => 
                                            [present_at_location_ids] => Array
                                                (
                                                    [0] => L2NZ8JD1GZZQ1
                                                )

                                            [item_variation_data] => stdClass Object
                                                (
                                                    [item_id] => 3NQD4SPM75WBXCD2WZTDNVE4
                                                    [name] => Regular
                                                    [sku] => PC_09-04-23
                                                    [ordinal] => 0
                                                    [pricing_type] => FIXED_PRICING
                                                    [price_money] => stdClass Object
                                                        (
                                                            [amount] => 5900
                                                            [currency] => USD
                                                        )

                                                    [location_overrides] => Array
                                                        (
                                                            [0] => stdClass Object
                                                                (
                                                                    [location_id] => L064G2YRAD6TZ
                                                                    [track_inventory] => 1
                                                                )

                                                            [1] => stdClass Object
                                                                (
                                                                    [location_id] => L2NZ8JD1GZZQ1
                                                                    [track_inventory] => 1
                                                                )

                                                            [2] => stdClass Object
                                                                (
                                                                    [location_id] => L2SCBBM91JZ8Q
                                                                    [track_inventory] => 
                                                                )

                                                        )

                                                    [track_inventory] => 1
                                                    [inventory_alert_type] => NONE
                                                    [sellable] => 1
                                                    [stockable] => 1
                                                )

                                        )

                                )

                            [product_type] => REGULAR
                            [skip_modifier_screen] => 
                            [ecom_uri] => 
                            [ecom_image_uris] => Array
                                (
                                    [0] => https://602564658821610015.square.site/uploads/1/4/1/1/141112714/s124604264364047714_p57_i1_w2000.jpeg
                                )

                            [ecom_available] => 
                            [ecom_visibility] => UNAVAILABLE
                            [image_ids] => Array
                                (
                                    [0] => ICXCZVSTGUDILB55OR4HWHKQ
                                )

                            [event] => stdClass Object
                                (
                                    [uid] => V27X56NJ5FQMEWWUCQSW42OW
                                    [start_at] => 2022-09-04T22:00:00+00:00
                                    [end_at] => 2022-09-05T01:30:00+00:00
                                    [event_location_time_zone] => America/New_York
                                    [event_location_name] => Propagate Studios
                                    [event_location_types] => Array
                                        (
                                            [0] => EVENT_LOCATION_TYPE_DO_NOT_USE
                                        )

                                    [address_id] => DON7V6SQTYWWCJOIWWZQ22YH
                                    [all_day_event] => 
                                )

                        )

                )

what am i missing?

2

Is there a reason your using the deprecated Transactions API. If you want catalog objects you should be calling the Catalog API. :slightly_smiling_face:

3

I’m trying to lookup the sales information for a specific item. how many sales were made and the customer information for that sale.

I couldn’t find anywhere else to do that besides the transactions API.

4

You’ll want to use a combination of APIs to get the information. For example Orders API to get the itemized order. In the order will be the catalog_object_ids and there may be a customer_id. You can then call the Catalog API to get the item information. If there’s a customer_id you can use that to call the Customers API to get the customer information. If there’s no customer in the order object you can call GetPayment with the payment_id or the tender_id. There may be a customer in the payment object if were able to infer one. :slightly_smiling_face: