如何使用 PHP 按 SKU 获取方形库存？

Question

我想从 Square Catalog 获取所有产品。

这是代码：

require 'vendor/autoload.php';

use Square\SquareClient;

use Square\LocationsApi;

use Square\Exceptions\ApiException;

use Square\Http\ApiResponse;

use Square\Models\ListLocationsResponse;

use Square\Environment;

$client = new SquareClient([

    'accessToken' => '{{access_token}}',

    'environment' => Environment::SANDBOX,

]);

//Providing SKU

$object_ids = ['GFLR20L', '232GGGD'];

$body = new \Square\Models\BatchRetrieveCatalogObjectsRequest($object_ids);

$body->setIncludeRelatedObjects(true);

$api_response = $client->getCatalogApi()->batchRetrieveCatalogObjects($body);

if ($api_response->isSuccess()) {

    $result = $api_response->getResult();

} else {

    $errors = $api_response->getErrors();

}

输出：

object(Square\Models\BatchRetrieveCatalogObjectsResponse)#13 (3) 

{

  ["errors":"Square\Models\BatchRetrieveCatalogObjectsResponse":private] => NULL

  ["objects":"Square\Models\BatchRetrieveCatalogObjectsResponse":private] => NULL

  ["relatedObjects":"Square\Models\BatchRetrieveCatalogObjectsResponse":private] => NULL 

}

**> sjosey 的帖子建议：

我的 PHP 代码：

正在寻找名称为 Paper 的产品。**

$object_types = ['ITEM'];

$prefix_query = new \Square\Models\CatalogQueryPrefix('name', 'paper');

$query = new \Square\Models\CatalogQuery();

$query->setPrefixQuery($prefix_query);

> 在此存储值

$body = new \Square\Models\SearchCatalogObjectsRequest();

$body->setObjectTypes($object_types);

$body->setQuery($query);

$body->setLimit(100);

$api_response = $client->getCatalogApi()->searchCatalogObjects($body);

> 在这里获取 api 响应

if ($api_response->isSuccess()) {

    $result = $api_response->getResult();

} else {

    $errors = $api_response->getErrors();

}

> 回波结果

var_dump($result);

Answer 1

想出了解决办法。以下代码按产品 IDS 获取所有产品的列表。该数组可用于根据要求设置数据（按 SKU 或任何内容）require 'vendor/autoload.php';use Square\SquareClient;use Square\LocationsApi;use Square\Exceptions\ApiException;use Square\Http\ApiResponse;use Square\Models\ListLocationsResponse;use Square\Environment;$client = new SquareClient([    'accessToken' => '{{access_token}}',    'environment' => Environment::PRODUCTION,]);$bag = [];$cursor = null;$ctr = 1;$api_response = $client->getCatalogApi()->listCatalog($cursor, 'ITEM');if ($api_response->isSuccess()) {    $result = $api_response->getResult();} else {    $errors = $api_response->getErrors();}$g1 = $result;$g2 = json_encode($g1);$g3 = json_decode($g2);$cursor = $g3->cursor;$objects = $g3->objects;$g4 = json_encode($objects);$g5 = json_decode($g4);foreach($g5 as $g51){    $bag[$g51->id] = $g51;}while($cursor != null){$api_response2 = $client->getCatalogApi()->listCatalog($cursor, 'ITEM');if ($api_response2->isSuccess()) {    $result2 = $api_response2->getResult();} else {    $errors2 = $api_response2->getErrors();}$g6 = $result2;$g7 = json_encode($g6);$g8 = json_decode($g7);$cursor = $g8->cursor;$objects2 = $g8->objects;$g9 = json_encode($objects2);$g10 = json_decode($g9);foreach($g10 as $g101){    $bag[$g101->id] = $g101;}}var_dump(count($bag));

Answer 2

object_ids 与 SKU 不同；它们是 Square 这边生成的唯一 ID。您可能希望使用SearchCatalogObjects (POST /v2/catalog/search) 端点来按 SKU 进行搜索。使用您的 SKU 之一的查询示例如下：{  "query": {    "exact_query": {      "attribute_name": "sku",      "attribute_value": "GFLR20L"    }  }}这将获取您的目录对象 ID，但如果您对库存感兴趣，您仍然需要使用另一个端点来获取库存，例如RetrieveInventoryCount（它以catalog_object_ids 作为参数）。