OZON 刊登方案设计

## 方案架构

![](/media/202305/2023-05-25_141809_157572.png)

## 接口
> ```文档``` : https://docs.ozon.ru/api/seller/zh/

***基础信息***
> ```获取分类``` ：https://api-seller.ozon.ru/v2/category/tree

> ```获取分类属性``` ：https://api-seller.ozon.ru/v3/category/attribute

> ```获取分类属性选项``` ：https://api-seller.ozon.ru/v2/category/attribute/values

***刊登商品***
> ```创建商品``` ：https://api-seller.ozon.ru/v2/product/import

> ```获取结果``` ：https://api-seller.ozon.ru/v1/product/import/info

***商品信息***
> ```商品列表```：https://api-seller.ozon.ru/v2/product/list

> ```商品详情```：https://api-seller.ozon.ru/v2/product/info

> ```商品属性```：https://api-seller.ozon.ru/v3/products/info/attributes

> ```商品描述```：https://api-seller.ozon.ru/v1/product/info/description

> ```商品下架（存档）```：https://api-seller.ozon.ru/v1/product/archive

> ```商品上架（取消存档）```：https://api-seller.ozon.ru/v1/product/unarchive

***商品库存***
> ```仓库列表```：https://api-seller.ozon.ru/v1/warehouse/list

> ```更新库存```：https://api-seller.ozon.ru/v2/products/stocks

***商品价格***
> ```更新价格```：https://api-seller.ozon.ru/v1/product/import/prices

## 特别注意
> 1、刊登存在获取不到结果的情况。

> 2、基础信息中分类、分类属性可以返回中文（中文和俄文都需要拉取），但是选项没有中文返回（需要翻译），选项拉取必填，非必填先少量拉取。

> 3、更新和刊登在平台是一个接口，做同步还是做异步。

> 4、同步仓库列表。（每晚同步）

## 中台表设计

> 分类属性表
```mysql
CREATE TABLE `t_ozon_category_attr` (
  `id` bigint(20) NOT NULL,
  `category_id` bigint(20) NOT NULL COMMENT '类目编号',
  `attribute_id` bigint(20) NOT NULL COMMENT '属性编号',
  `attribute_name_init` varchar(1000) NOT NULL COMMENT '属性名称（原文）',
  `attribute_name_zh` varchar(1000) NOT NULL COMMENT '属性名称（中文）',
  `attribute_name_en` varchar(1000) NOT NULL COMMENT '属性名称（英文）',
  `is_required` tinyint(4) DEFAULT NULL COMMENT '是否必填，1：是   2：否',
  `description` varchar(2000) DEFAULT NULL COMMENT '属性描述',
  `type` varchar(255) DEFAULT NULL COMMENT '输入类型：String、multiline、Decimal、URL、Boolean、Integer',
  `is_collection` tinyint(4) DEFAULT NULL COMMENT '是否是集合，1：是   2：否',
  `group_id` bigint(20) DEFAULT NULL COMMENT '所属组',
  `group_name` varchar(255) DEFAULT NULL COMMENT '组名称',
  `dictionary_id` bigint(20) DEFAULT NULL COMMENT '字典ID',
  `is_aspect` tinyint(4) DEFAULT NULL COMMENT '是否可变种，1：是   2：否',
  `category_dependent` tinyint(4) DEFAULT NULL COMMENT '该属性对每个类别是否是不同的值，1：是   2：否',
  `status` tinyint(4) DEFAULT '1' COMMENT '1、正常；2、删除',
  `version` varchar(255) DEFAULT NULL COMMENT '版本号',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`,`attribute_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分类属性表';
```

> 分类属性选项表
```mysql
CREATE TABLE `t_ozon_category_attr_value` (
  `id` bigint(20) NOT NULL,
  `category_id` bigint(20) DEFAULT NULL COMMENT '类目编号',
  `attribute_id` bigint(20) DEFAULT NULL COMMENT '属性编号',
  `attribute_value_id` bigint(20) DEFAULT NULL COMMENT '选项ID',
  `attribute_value_init` varchar(255) DEFAULT NULL COMMENT '选项（原文）',
  `attribute_value_zh` varchar(255) DEFAULT NULL COMMENT '选项（中文）',
  `attribute_value_en` varchar(255) DEFAULT NULL COMMENT '选项（英文）',
  `info` varchar(255) DEFAULT NULL COMMENT 'info',
  `picture` varchar(255) DEFAULT NULL COMMENT '图片链接',
  `version` varchar(255) DEFAULT NULL COMMENT '版本号',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`,`attribute_id`,`attribute_value_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分类属性选项表';
```

> 刊登表
```mysql
CREATE TABLE `mps_ozon_task` (
  `id` bigint NOT NULL COMMENT '主键',
  `app_id` bigint DEFAULT NULL COMMENT 'appid',
  `shop_id` bigint DEFAULT NULL COMMENT '店铺id',
  `product_attrs` mediumtext CHARACTER SET utf8 COLLATE utf8_bin COMMENT '商品属性组',
  `bar_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '商品条码',
  `category_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '类目id',
  `color_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '营销图片',
  `complex_attributes` mediumtext CHARACTER SET utf8 COLLATE utf8_bin COMMENT '具有嵌套属性的特征组。',
  `currency_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '价格显示的货币。',
  `package_depth` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '包装厚度。',
  `dimension_unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '尺寸测量单位',
  `geo_names` text COMMENT '地理限制。',
  `package_height` int DEFAULT NULL COMMENT '包装高度',
  `image_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '图片列表',
  `main_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '商品主图',
  `service_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '服务类型。 以大写形式传递其中的一个值:IS_CODE_SERVICE,IS_NO_CODE_SERVICE。',
  `images_vr` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '360图像组',
  `product_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '商品名称',
  `seller_sku` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'offer_id卖方系统中的商品ID — 货号。至50字符。',
  `old_price` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '折扣前的价格（将在产品卡上划掉）。 以卢布表示。分数分隔 符号 — 点, 在点之后最多两个字符。',
  `pdf_list` text COMMENT 'PDF-文件清单。',
  `premium_price` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '订阅客户的价格',
  `product_price` varchar(20) DEFAULT NULL COMMENT '商品价格，包括折扣，显示在商品卡上。',
  `product_vat` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '商品增值税税率:',
  `product_weight` int DEFAULT NULL COMMENT '含包装的商品重量。 限值为1000公斤或其他换算值 计量单位。\r\n',
  `weight_unit` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '测重单位：g — 克,kg — 公斤,lb — 磅。',
  `product_width` int DEFAULT NULL COMMENT '    \r\ninteger <int32>\r\n包装宽度。',
  `product_id` bigint DEFAULT NULL COMMENT '刊登成功回写商品id',
  `flag` tinyint(1) DEFAULT NULL COMMENT '刊登状态，1：待刊登(定时刊登未执行)   2：刊登中  6：刊登失败 7：部分失败  9：刊登成功',
  `is_timing` tinyint(1) DEFAULT NULL COMMENT '是否定时刊登 1是 2否',
  `result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '刊登结果',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `relate_task_id` bigint DEFAULT NULL COMMENT '用该字段判断是否是同一个商品',
  PRIMARY KEY (`id`),
  KEY `idx_product_id` (`product_id`),
  KEY `idx_shop_id_flag` (`shop_id`,`flag`) USING BTREE,
  KEY `idx_update_time` (`update_time`,`flag`) USING BTREE,
  KEY `idx_create_time` (`create_time`,`flag`) USING BTREE,
  KEY `idx_sku` (`seller_sku`) USING BTREE,
  KEY `idx_relate_task` (`relate_task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='ozon刊登任务表';
```
## Java 接口文档

## 金企鹅  店铺商品列表不同可见性返回数据
> visibility=```VISIBLE```
```
{
    "result": {
        "items": [
            {
                "product_id": 348414699,
                "offer_id": "CJ-ZB-TG-HB-HS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348418354,
                "offer_id": "JD-JMQ-THG-X8-02",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348422415,
                "offer_id": "JD-JMQ-THG-X8-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348424732,
                "offer_id": "CJ-ZB-TG-HB-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348427915,
                "offer_id": "CJ-ZB-TG-HB-HS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348429950,
                "offer_id": "CJ-ZB-TG-HB-LS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348433649,
                "offer_id": "JD-JMQ-THG-X5-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351431186,
                "offer_id": "CJ-ZB-TG-MDS-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351438052,
                "offer_id": "CJ-ZB-TG-MDS-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351443905,
                "offer_id": "CJ-ZB-TG-KA-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351453496,
                "offer_id": "CJ-ZB-TG-KA-HS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            }
        ],
        "total": 11,
        "last_id": "WzM1MTQ1MzQ5NiwzNTE0NTM0OTZd"
    }
}
```

> visibility=```INVISIBLE```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```EMPTY_STOCK```
```
{
    "result": {
        "items": [
            {
                "product_id": 348422415,
                "offer_id": "JD-JMQ-THG-X8-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            }
        ],
        "total": 1,
        "last_id": "WzM0ODQyMjQxNSwzNDg0MjI0MTVd"
    }
}
```

> visibility=```NOT_MODERATED```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```MODERATED```
```
{
    "result": {
        "items": [
            {
                "product_id": 348414699,
                "offer_id": "CJ-ZB-TG-HB-HS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348418354,
                "offer_id": "JD-JMQ-THG-X8-02",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348422415,
                "offer_id": "JD-JMQ-THG-X8-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348424732,
                "offer_id": "CJ-ZB-TG-HB-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348427915,
                "offer_id": "CJ-ZB-TG-HB-HS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348429950,
                "offer_id": "CJ-ZB-TG-HB-LS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348433649,
                "offer_id": "JD-JMQ-THG-X5-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351431186,
                "offer_id": "CJ-ZB-TG-MDS-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351438052,
                "offer_id": "CJ-ZB-TG-MDS-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351443905,
                "offer_id": "CJ-ZB-TG-KA-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351453496,
                "offer_id": "CJ-ZB-TG-KA-HS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            }
        ],
        "total": 11,
        "last_id": "WzM1MTQ1MzQ5NiwzNTE0NTM0OTZd"
    }
}
```

> visibility=```DISABLED```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```STATE_FAILED```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```READY_TO_SUPPLY```
```
{
    "result": {
        "items": [
            {
                "product_id": 348414699,
                "offer_id": "CJ-ZB-TG-HB-HS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348418354,
                "offer_id": "JD-JMQ-THG-X8-02",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348422415,
                "offer_id": "JD-JMQ-THG-X8-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348424732,
                "offer_id": "CJ-ZB-TG-HB-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348427915,
                "offer_id": "CJ-ZB-TG-HB-HS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348429950,
                "offer_id": "CJ-ZB-TG-HB-LS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348433649,
                "offer_id": "JD-JMQ-THG-X5-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351431186,
                "offer_id": "CJ-ZB-TG-MDS-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351438052,
                "offer_id": "CJ-ZB-TG-MDS-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351443905,
                "offer_id": "CJ-ZB-TG-KA-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351453496,
                "offer_id": "CJ-ZB-TG-KA-HS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            }
        ],
        "total": 11,
        "last_id": "WzM1MTQ1MzQ5NiwzNTE0NTM0OTZd"
    }
}
```

> visibility=```VALIDATION_STATE_PENDING```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```VALIDATION_STATE_FAIL```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```VALIDATION_STATE_SUCCESS```
```
{
    "result": {
        "items": [
            {
                "product_id": 348414699,
                "offer_id": "CJ-ZB-TG-HB-HS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348418354,
                "offer_id": "JD-JMQ-THG-X8-02",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348422415,
                "offer_id": "JD-JMQ-THG-X8-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348424732,
                "offer_id": "CJ-ZB-TG-HB-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348427915,
                "offer_id": "CJ-ZB-TG-HB-HS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348429950,
                "offer_id": "CJ-ZB-TG-HB-LS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348433649,
                "offer_id": "JD-JMQ-THG-X5-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351431186,
                "offer_id": "CJ-ZB-TG-MDS-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351438052,
                "offer_id": "CJ-ZB-TG-MDS-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351443905,
                "offer_id": "CJ-ZB-TG-KA-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351453496,
                "offer_id": "CJ-ZB-TG-KA-HS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            }
        ],
        "total": 11,
        "last_id": "WzM1MTQ1MzQ5NiwzNTE0NTM0OTZd"
    }
}
```

> visibility=```TO_SUPPLY```
```
{
    "result": {
        "items": [
            {
                "product_id": 348422415,
                "offer_id": "JD-JMQ-THG-X8-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            }
        ],
        "total": 1,
        "last_id": "WzM0ODQyMjQxNSwzNDg0MjI0MTVd"
    }
}
```

> visibility=```IN_SALE```
```
{
    "result": {
        "items": [
            {
                "product_id": 348414699,
                "offer_id": "CJ-ZB-TG-HB-HS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348418354,
                "offer_id": "JD-JMQ-THG-X8-02",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348424732,
                "offer_id": "CJ-ZB-TG-HB-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348427915,
                "offer_id": "CJ-ZB-TG-HB-HS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348429950,
                "offer_id": "CJ-ZB-TG-HB-LS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348433649,
                "offer_id": "JD-JMQ-THG-X5-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351431186,
                "offer_id": "CJ-ZB-TG-MDS-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351438052,
                "offer_id": "CJ-ZB-TG-MDS-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351443905,
                "offer_id": "CJ-ZB-TG-KA-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351453496,
                "offer_id": "CJ-ZB-TG-KA-HS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            }
        ],
        "total": 10,
        "last_id": "WzM1MTQ1MzQ5NiwzNTE0NTM0OTZd"
    }
}
```

> visibility=```BANNED```
```
{
    "result": {
        "items": [
            {
                "product_id": 348414699,
                "offer_id": "CJ-ZB-TG-HB-HS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348418354,
                "offer_id": "JD-JMQ-THG-X8-02",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348422415,
                "offer_id": "JD-JMQ-THG-X8-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348424732,
                "offer_id": "CJ-ZB-TG-HB-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348427915,
                "offer_id": "CJ-ZB-TG-HB-HS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348429950,
                "offer_id": "CJ-ZB-TG-HB-LS-XL",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 348433649,
                "offer_id": "JD-JMQ-THG-X5-01",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351431186,
                "offer_id": "CJ-ZB-TG-MDS-LS-L",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351438052,
                "offer_id": "CJ-ZB-TG-MDS-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351443905,
                "offer_id": "CJ-ZB-TG-KA-LS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            },
            {
                "product_id": 351453496,
                "offer_id": "CJ-ZB-TG-KA-HS-M",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            }
        ],
        "total": 11,
        "last_id": "WzM1MTQ1MzQ5NiwzNTE0NTM0OTZd"
    }
}
```

> visibility=```OVERPRICED```
```
{
    "result": {
        "items": [
            {
                "product_id": 348418354,
                "offer_id": "JD-JMQ-THG-X8-02",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            }
        ],
        "total": 1,
        "last_id": "WzM0ODQxODM1NCwzNDg0MTgzNTRd"
    }
}
```

> visibility=```CRITICALLY_OVERPRICED```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```EMPTY_BARCODE```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```QUARANTINE```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```ARCHIVED```
```
{
    "result": {
        "items": [
            {
                "product_id": 217523203,
                "offer_id": "cute001",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 217553417,
                "offer_id": "JDMY002",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 217580282,
                "offer_id": "cute003",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 217588170,
                "offer_id": "cute004",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 220888421,
                "offer_id": "cute019",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 220890718,
                "offer_id": "cute005",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 220896109,
                "offer_id": "cute006",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 220896975,
                "offer_id": "cute007",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 220899672,
                "offer_id": "cute008",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 225717356,
                "offer_id": "cute010",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226263280,
                "offer_id": "cute009",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226268308,
                "offer_id": "cute018",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226273451,
                "offer_id": "cute020",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226280043,
                "offer_id": "cute011",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226285372,
                "offer_id": "cute012",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226289211,
                "offer_id": "cute014",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226292222,
                "offer_id": "cute013",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226310300,
                "offer_id": "cute015",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226321841,
                "offer_id": "cute016",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226356189,
                "offer_id": "cute017",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226361521,
                "offer_id": "cute003.1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226365806,
                "offer_id": "cute005.1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226373597,
                "offer_id": "cute006.1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226377323,
                "offer_id": "cute007.1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226382867,
                "offer_id": "cute011.1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226386831,
                "offer_id": "012.1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226392925,
                "offer_id": "cute004.11",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 226398010,
                "offer_id": "cute019.11",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 257777707,
                "offer_id": "Самолет СУ-35",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 257793569,
                "offer_id": "Лампа",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 258635437,
                "offer_id": "чай-4",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 268894884,
                "offer_id": "ЖХ-1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 268895315,
                "offer_id": "ЖЧ-1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 268895652,
                "offer_id": "РЧ-1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 268896621,
                "offer_id": "ЗЧ-1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 268906104,
                "offer_id": "ТДТ-1",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 269151985,
                "offer_id": "Чай набор",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 295134362,
                "offer_id": "CR-GM-01-B",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            },
            {
                "product_id": 326943615,
                "offer_id": "qz-btbxq",
                "is_fbo_visible": false,
                "is_fbs_visible": false,
                "archived": true,
                "is_discounted": false
            }
        ],
        "total": 39,
        "last_id": "WzMyNjk0MzYxNSwzMjY5NDM2MTVd"
    }
}
```

> visibility=```OVERPRICED_WITH_STOCK```
```
{
    "result": {
        "items": [
            {
                "product_id": 348418354,
                "offer_id": "JD-JMQ-THG-X8-02",
                "is_fbo_visible": true,
                "is_fbs_visible": true,
                "archived": false,
                "is_discounted": false
            }
        ],
        "total": 1,
        "last_id": "WzM0ODQxODM1NCwzNDg0MTgzNTRd"
    }
}
```

> visibility=```PARTIAL_APPROVED```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```IMAGE_ABSENT```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

> visibility=```MODERATION_BLOCK```
```
{
    "result": {
        "items": [],
        "total": 0,
        "last_id": ""
    }
}
```

## 接口文档
创建商品：http://192.168.2.73:30860/doc.html#/1.0/%E5%95%86%E5%93%81/createProductUsingPOST

更新商品：http://192.168.2.73:30860/doc.html#/1.0/ozon%E5%9C%A8%E7%BA%BF%E5%95%86%E5%93%81%E5%85%A5%E5%8F%A3/updateProductUsingPOST

同步店铺商品：http://192.168.2.73:30860/doc.html#/1.0/%E5%95%86%E5%93%81/syncShopProductUsingPOST

同步商品：http://192.168.2.73:30860/doc.html#/1.0/%E5%95%86%E5%93%81/syncProductUsingPOST

获取库存：
http://192.168.2.60:30435/mdc-open-api-information-service/doc.html#/1.0/ozon%20%E5%9F%BA%E7%A1%80%E4%BF%A1%E6%81%AF/getWarehouseUsingPOST

同步分类（尽量不要调，量太大了）：
http://192.168.2.60:30435/mdc-open-api-information-service/doc.html#/1.0/ozon%20%E5%9F%BA%E7%A1%80%E4%BF%A1%E6%81%AF/syncCategoryUsingPOST_1

同步分类属性：
http://192.168.2.60:30435/mdc-open-api-information-service/doc.html#/1.0/ozon%20%E5%9F%BA%E7%A1%80%E4%BF%A1%E6%81%AF/syncCategoryAttributeUsingPOST

同步分类属性选项值：
http://192.168.2.60:30435/mdc-open-api-information-service/doc.html#/1.0/ozon%20%E5%9F%BA%E7%A1%80%E4%BF%A1%E6%81%AF/syncCategoryAttributeValueUsingPOST

更新商品价格：
http://192.168.2.60:30435/mdc-open-api-product-service/doc.html#/1.0/Ozon%E5%95%86%E5%93%81/updateProductPriceUsingPOST_5

更新商品库存：
http://192.168.2.60:30435/mdc-open-api-product-service/doc.html#/1.0/Ozon%E5%95%86%E5%93%81/updateProductStockUsingPOST_4

商品下架：
http://192.168.2.60:30435/mdc-open-api-product-service/doc.html#/1.0/Ozon%E5%95%86%E5%93%81/productOfflineUsingPOST_2

商品上架：
http://192.168.2.60:30435/mdc-open-api-product-service/doc.html#/1.0/Ozon%E5%95%86%E5%93%81/productOnlineUsingPOST_2

## 翻译失败
```java
        translateGeneralRequest.setFormatType("text");
        translateGeneralRequest.setSourceLanguage("auto");
        translateGeneralRequest.setTargetLanguage("zh");
        translateGeneralRequest.setSourceText("Lesotho");
```
> {"code":10005,"message":"translate from source to target not support","requestId":"07B8F0DE-7C69-535D-9A6A-1F17595D282D"}

## 刊登失败，因为价格问题
```json
{
	"errors": [{
		"attribute_id": 0,
		"attribute_name": "",
		"code": "price_out_of_range",
		"description": "Цена не попала в допустимые границы для категории товара.",
		"field": "69.00;130.42;24585.56",
		"level": "error",
		"message": "Укажите цену от 130.42 до 24585.56 — установили такие пороги для этой категории товара",
		"state": "new"
	}],
	"offer_id": "060902",
	"product_id": 0,
	"status": "failed"
}
```

## es
```
内网:192.168.2.20:5601
user:elastic
pass:C7tn1bSt773PY5sPzQ1
index_name:
  公:ozon_online_public
  私:ozon_online_private
```