We have a location on boarded with us (Location Id - DQYS5XZBK1EVT). We noticed that there is a difference between the product list exported via the Square portal and the products returned from the List Catalog API. There were some additional products that were available in the API response which were not there in the Square Menu.
Example-
Chocolate Muffin → JU7QBVEEOWQ4VOB5ZQGBYMNF
Aguna De Fresca → J53EMVTAVCC2U54XDUGFM36V
These products are not available in the menu exported through the portal but available in the catalog API response.
{
"type": "ITEM",
"id": "JU7QBVEEOWQ4VOB5ZQGBYMNF",
"updated_at": "2023-12-07T17:34:25.056Z",
"created_at": "2022-12-18T00:07:41.069Z",
"version": 1701970465056,
"is_deleted": false,
"present_at_all_locations": true,
"item_data": {
"name": "Chocolate Muffin",
"description": "Chocolate Muffin !",
"is_taxable": true,
"variations": [
{
"type": "ITEM_VARIATION",
"id": "WH6HX2EB5KEKCF7G5Q546NZN",
"updated_at": "2023-08-17T21:33:58.817Z",
"created_at": "2022-12-18T00:07:41.069Z",
"version": 1692308038817,
"is_deleted": false,
"present_at_all_locations": true,
"item_variation_data": {
"item_id": "JU7QBVEEOWQ4VOB5ZQGBYMNF",
"name": "Regular",
"ordinal": 0,
"pricing_type": "FIXED_PRICING",
"price_money": {
"amount": 349,
"currency": "USD"
},
"location_overrides": [
{
"location_id": "DQYS5XZBK1EVT",
"track_inventory": false
}
],
"track_inventory": false,
"sellable": true,
"stockable": true,
"channels": [
"CH_A51IYVkMRGuyouDtH5gFLlUUH7mkRzGObOZ5EQlQuYC"
]
}
}
],
"product_type": "REGULAR",
"ecom_available": false,
"ecom_visibility": "UNAVAILABLE",
"pickup_fulfillment_preferences_id": "fprefs_127iznsi0zxsgcxyj1tsuzlj4",
"description_html": "<p>Chocolate Muffin ! </p>",
"description_plaintext": "Chocolate Muffin !",
"channels": [
"CH_A51IYVkMRGuyouDtH5gFLlUUH7mkRzGObOZ5EQlQuYC"
],
"is_archived": false
}
}
{
"type": "ITEM",
"id": "J53EMVTAVCC2U54XDUGFM36V",
"updated_at": "2023-12-07T17:34:25.056Z",
"created_at": "2022-03-04T21:29:58.255Z",
"version": 1701970465056,
"is_deleted": false,
"catalog_v1_ids": [
{
"catalog_v1_id": "92be992e-4114-47f4-a620-37f78b8455bd",
"location_id": "DQYS5XZBK1EVT"
}
],
"present_at_all_locations": false,
"present_at_location_ids": [
"DQYS5XZBK1EVT"
],
"item_data": {
"name": "Agua De Fresa",
"abbreviation": "Ag",
"label_color": "ff9da2a6",
"is_taxable": true,
"visibility": "PRIVATE",
"tax_ids": [
"2QYNDIQQCQWCZPHAR4R4WMLB"
],
"variations": [
{
"type": "ITEM_VARIATION",
"id": "7Z537U2HDJSGFHENMBHXFY35",
"updated_at": "2022-05-02T19:41:48.665Z",
"created_at": "2022-03-04T21:29:58.255Z",
"version": 1651520508665,
"is_deleted": false,
"catalog_v1_ids": [
{
"catalog_v1_id": "0f4761e2-52b4-442b-b97d-868e8867b2bc",
"location_id": "DQYS5XZBK1EVT"
}
],
"present_at_all_locations": false,
"present_at_location_ids": [
"DQYS5XZBK1EVT"
],
"item_variation_data": {
"item_id": "J53EMVTAVCC2U54XDUGFM36V",
"name": "Regular",
"ordinal": 0,
"pricing_type": "VARIABLE_PRICING",
"sellable": true,
"stockable": true
}
}
],
"product_type": "REGULAR",
"ecom_available": false,
"ecom_visibility": "UNINDEXED",
"categories": [
{
"id": "VIHHCQZJK776VADEMBV7I6JE",
"ordinal": 206158430208
}
],
"is_archived": false,
"reporting_category": {
"id": "VIHHCQZJK776VADEMBV7I6JE",
"ordinal": 206158430208
}
}
}
Appreciate it if you can help us figure out what are the attributes that these items have in common that we have to consider to stop syncing them.