拼多多淘宝大量缓存商品数据用什么格式提供比较好？

╰+攻爆jí腚メ 2024-03-24 21:16 6阅读 0赞

众所周知，淘宝拼多多是我国主流的电商平台，其上有大量的商品数据。很多商家会通过API来访问他们的商品数据，根据API的调用次数收费。第三方数据公司提供电商数据接口API，采集实时数据。但是，在他们的服务器上有大量的缓存数据，这些数据一直被大家所忽略。这批数据量巨大的缓存数据的作用和价值却非常大。他们省掉了调用API的时间和成本，直接从服务器中调取，性价比很高。

对于拼多多和淘宝这样的大型电商平台的缓存商品数据的交付，如何顺利的交付是关键。以下是一些可能适合缓存商品数据的格式：

1.  JSON：JSON（JavaScript Object Notation）是一种轻量级的数据交换格式，它易于阅读和编写，并且能够描述简单的数据结构和复杂的数据结构。在缓存商品数据时，可以将数据转换为JSON格式，然后存储在缓存中。
2.  XML：XML（Extensible Markup Language）是一种标记语言，它可以用来描述数据的结构。XML可以用于存储和传输数据，并且具有广泛的兼容性。然而，XML比JSON更加复杂，并且解析速度较慢。它由纯文本文件组成，其中每一行代表一条记录，每个字段由逗号分隔。SQLite支持SQL语言，可以进行复杂的数据查询，并且具有较高的性能。如果您的商品数据结构较为简单，JSON和CSV可能是不错的选择。如果您的数据结构较为复杂，或者需要进行复杂的数据查询，SQLite可能更加适合。

商品缓存数据示例 [了解更多商品缓存数据][Link 1]

"item": {
    		"num_iid": "652874751412",
    		"title": "北欧轻奢布艺沙发 小户型简约现代客厅ins风网红款三双人订制沙发",
    		"desc_short": "",
    		"price": "480.00",
    		"total_price": 0,
    		"suggestive_price": 0,
    		"orginal_price": "480.00",
    		"nick": "惜情yqq1127",
    		"num": "200",
    		"min_num": 0,
    		"detail_url": "https://item.taobao.com/item.htm?id=652874751412",
    		"pic_url": "//img.alicdn.com/imgextra/i4/2568161054/O1CN01aYBriY1Jem9UDtt9e_!!2568161054.jpg",
    		"brand": "#0 工厂",
    		"brandId": "1435187098",
    		"rootCatId": "50008164",
    		"cid": "50020632",
    		"crumbs": [],
    		"created_time": "",
    		"modified_time": "",
    		"delist_time": "",
    		"desc": "<img size=\"27893\">https://img.alicdn.com/imgextra/i3/2568161054/O1CN01LFmSOU1Jem9QOjMPb_!!2568161054.jpg</img><img size=\"132455\">https://img.alicdn.com/imgextra/i3/2568161054/O1CN014vyOOT1Jem9DpHz3Y_!!2568161054.jpg</img><img size=\"2455\">https://img.alicdn.com/imgextra/i1/2568161054/O1CN01B3PpsA1Jem9N8V7uf_!!2568161054.jpg</img><img size=\"117664\">https://img.alicdn.com/imgextra/i2/2568161054/O1CN015JbyeY1Jem9MZshUt_!!2568161054.jpg</img><img size=\"16674\">https://img.alicdn.com/imgextra/i1/2568161054/O1CN01HXSoxx1Jem9RvgzHN_!!2568161054.jpg</img><img size=\"96260\">https://img.alicdn.com/imgextra/i3/2568161054/O1CN01IEultA1Jem9MdEx8R_!!2568161054.jpg</img><img size=\"13573\">https://img.alicdn.com/imgextra/i3/2568161054/O1CN0176K98O1Jem9QOjE69_!!2568161054.jpg</img><img size=\"110974\">https://img.alicdn.com/imgextra/i4/2568161054/O1CN013Pxp1O1Jem9RvgeTv_!!2568161054.jpg</img><img size=\"104198\">https://img.alicdn.com/imgextra/i1/2568161054/O1CN01SfyZ8M1Jem9QOi1Gx_!!2568161054.jpg</img><img size=\"576580\">https://img.alicdn.com/imgextra/i4/2568161054/O1CN01bb1POa1Jem9Sdgve2_!!2568161054.jpg</img><img size=\"676617\">https://img.alicdn.com/imgextra/i3/2568161054/O1CN018Eo9dV1Jem9KV0y79_!!2568161054.jpg</img><img size=\"9125\">https://img.alicdn.com/imgextra/i1/2568161054/O1CN01vuEofr1Jem9Nzy9xY_!!2568161054.jpg</img><img size=\"107197\">https://img.alicdn.com/imgextra/i4/2568161054/O1CN01qw9sAi1Jem8wkNKpy_!!2568161054.jpg</img><img size=\"198877\">https://img.alicdn.com/imgextra/i1/2568161054/O1CN01HeFhFw1Jem8rLnjBY_!!2568161054.jpg</img><img size=\"71423\">https://img.alicdn.com/imgextra/i2/2568161054/O1CN01SNgjoi1Jem9QOil15_!!2568161054.jpg</img><img size=\"37628\">https://img.alicdn.com/imgextra/i2/2568161054/O1CN01RXf3RA1Jem9DpHVwj_!!2568161054.jpg</img><img size=\"170889\">https://img.alicdn.com/imgextra/i4/2568161054/O1CN01gZmZjt1Jem9ISThgm_!!2568161054.jpg</img><img size=\"6378\">https://img.alicdn.com/imgextra/i2/2568161054/O1CN01YL0FHM1Jem9PQTjX9_!!2568161054.jpg</img><img size=\"212074\">https://img.alicdn.com/imgextra/i4/2568161054/O1CN01UhsEhZ1Jem8yvJIhZ_!!2568161054.jpg</img><img src=\"https://www.o0b.cn/i.php?t.png&rid=gw-1.64e8138a83326&p=1778786367&k=i_key&t=1692930956\" style=\"display:none\" />",
    		"desc_img": [],
    		"item_imgs": [
    			{
    				"url": "//img.alicdn.com/imgextra/i4/2568161054/O1CN01aYBriY1Jem9UDtt9e_!!2568161054.jpg"
    			},
    			{
    				"url": "//img.alicdn.com/imgextra/i3/2568161054/O1CN01kjOfNb1Jem9DmWn8Y_!!2568161054.jpg"
    			},
    			{
    				"url": "//img.alicdn.com/imgextra/i1/2568161054/O1CN01HoB9ha1Jem9DmWn8r_!!2568161054.jpg"
    			},
    			{
    				"url": "//img.alicdn.com/imgextra/i4/2568161054/O1CN011PjP2P1Jem9MXEUFT_!!2568161054.jpg"
    			},
    			{
    				"url": "//img.alicdn.com/imgextra/i3/2568161054/O1CN01KUfBFL1Jem9KTTMn1_!!2568161054.jpg"
    			}
    		],
    		"item_weight": "",
    		"item_size": "",
    		"location": "江苏南通",
    		"post_fee": "",
    		"express_fee": null,
    		"ems_fee": "",
    		"shipping_to": "",
    		"has_discount": "false",
    		"video": {
    			"url": null
    		},
    		"is_virtual": "",
    		"sample_id": "",
    		"is_promotion": "false",
    		"props_name": "31480:14306495906:几人坐:脚踏90*60*48cm;31480:14306495907:几人坐:双人165*95*67cm;31480:14306495908:几人坐:三人210*95*67cm;31480:14306495909:几人坐:单人100*95*67cm;31480:21480914361:几人坐:四人位240*95*67cm;31480:21480914362:几人坐:大四人320*95*76cm;31480:1387571900:几人坐:3米贵妃沙发;31480:32527954:几人坐:定制尺寸;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
    		"prop_imgs": {
    			"prop_img": [
    				{
    					"properties": "1627207:28321",
    					"url": "//img.alicdn.com/imgextra/i1/2568161054/O1CN017GTZ4h1Jem9Qra1ap_!!2568161054.jpg"
    				}
    			]
    		},
    		"property_alias": "",
    		"props": [
    			{
    				"name": "品牌",
    				"value": "#0 工厂"
    			},
    			{
    				"name": "型号",
    				"value": "520"
    			},
    			{
    				"name": "材质",
    				"value": "木"
    			},
    			{
    				"name": "木质材质",
    				"value": "松木"
    			},
    			{
    				"name": "面料",
    				"value": "绒布"
    			},
    			{
    				"name": "风格",
    				"value": "北欧"
    			},
    			{
    				"name": "几人坐",
    				"value": "脚踏90*60*48cm,双人165*95*67cm,三人210*95*67cm,单人100*95*67cm,四人位240*95*67cm,大四人320*95*76cm,3米贵妃沙发,定制尺寸"
    			},
    			{
    				"name": "颜色分类",
    				"value": "乳白色"
    			},
    			{
    				"name": "填充物",
    				"value": "海绵"
    			},
    			{
    				"name": "结构工艺",
    				"value": "木质工艺"
    			},
    			{
    				"name": "是否可定制",
    				"value": "是"
    			},
    			{
    				"name": "沙发组合形式",
    				"value": "U形"
    			},
    			{
    				"name": "是否可拆洗",
    				"value": "是"
    			},
    			{
    				"name": "适用对象",
    				"value": "成年人"
    			},
    			{
    				"name": "是否带储物空间",
    				"value": "否"
    			},
    			{
    				"name": "产地",
    				"value": "上海"
    			},
    			{
    				"name": "地市",
    				"value": "上海市"
    			},
    			{
    				"name": "区县",
    				"value": "奉贤区"
    			},
    			{
    				"name": "是否组装",
    				"value": "否"
    			},
    			{
    				"name": "出租车是否可运输",
    				"value": "否"
    			},
    			{
    				"name": "填充物硬度",
    				"value": "软"
    			},
    			{
    				"name": "款式定位",
    				"value": "经济型"
    			}
    		],
    		"total_sold": "613",
    		"skus": {
    			"sku": [
    				{
    					"price": "480",
    					"total_price": 0,
    					"orginal_price": "480",
    					"properties": "31480:14306495906;1627207:28321",
    					"properties_name": "31480:14306495906:几人坐:脚踏90*60*48cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
    					"quantity": "200",
    					"sku_id": "4881047531343"
    				},
    				{
    					"price": "1688",
    					"total_price": 0,
    					"orginal_price": "1688",
    					"properties": "31480:14306495907;1627207:28321",
    					"properties_name": "31480:14306495907:几人坐:双人165*95*67cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
    					"quantity": "135",
    					"sku_id": "4881047531344"
    				},
    				{
    					"price": "2088",
    					"total_price": 0,
    					"orginal_price": "2088",
    					"properties": "31480:14306495908;1627207:28321",
    					"properties_name": "31480:14306495908:几人坐:三人210*95*67cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
    					"quantity": "200",
    					"sku_id": "4881047531345"
    				},
    				{
    					"price": "968",
    					"total_price": 0,
    					"orginal_price": "968",
    					"properties": "31480:14306495909;1627207:28321",
    					"properties_name": "31480:14306495909:几人坐:单人100*95*67cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
    					"quantity": "200",
    					"sku_id": "4881047531346"
    				},
    				{
    					"price": "2388",
    					"total_price": 0,
    					"orginal_price": "2388",
    					"properties": "31480:21480914361;1627207:28321",
    					"properties_name": "31480:21480914361:几人坐:四人位240*95*67cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
    					"quantity": "200",
    					"sku_id": "5039985183001"
    				},
    				{
    					"price": "3188",
    					"total_price": 0,
    					"orginal_price": "3188",
    					"properties": "31480:21480914362;1627207:28321",
    					"properties_name": "31480:21480914362:几人坐:大四人320*95*76cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
    					"quantity": "200",
    					"sku_id": "5039985183002"
    				},
    				{
    					"price": "3400",
    					"total_price": 0,
    					"orginal_price": "3400",
    					"properties": "31480:1387571900;1627207:28321",
    					"properties_name": "31480:1387571900:几人坐:3米贵妃沙发;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
    					"quantity": "200",
    					"sku_id": "5039984824000"
    				},
    				{
    					"price": "3000",
    					"total_price": 0,
    					"orginal_price": "3000",
    					"properties": "31480:32527954;1627207:28321",
    					"properties_name": "31480:32527954:几人坐:定制尺寸;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
    					"quantity": "200",
    					"sku_id": "5039985183003"
    				}
    			]
    		},
    		"seller_id": "2568161054",
    		"sales": 14,
    		"shop_id": "567158267",
    		"props_list": {
    			"31480:14306495906": "几人坐:脚踏90*60*48cm",
    			"31480:14306495907": "几人坐:双人165*95*67cm",
    			"31480:14306495908": "几人坐:三人210*95*67cm",
    			"31480:14306495909": "几人坐:单人100*95*67cm",
    			"31480:21480914361": "几人坐:四人位240*95*67cm",
    			"31480:21480914362": "几人坐:大四人320*95*76cm",
    			"31480:1387571900": "几人坐:3米贵妃沙发",
    			"31480:32527954": "几人坐:定制尺寸",
    			"1627207:28321": "颜色分类:乳白色 尺寸颜色可定制"
    		},
    		"seller_info": {
    			"nick": "惜情yqq1127",
    			"item_score": "4.9 ",
    			"score_p": "4.9 ",
    			"delivery_score": "4.9 ",
    			"shop_type": "C",
    			"user_num_id": "2568161054",
    			"sid": "567158267",
    			"title": "现代布艺沙发",
    			"zhuy": "https://shop567158267.taobao.com/",
    			"shop_name": "现代布艺沙发"
    		},
    		"tmall": false,
    		"error": "",
    		"warning": "",
    		"url_log": [],
    		"fav_count": "7970",
    		"fans_count": "680",
    		"freight": "平邮: 快递包邮",
    		"props_imgs": {
    			"prop_img": [
    				{
    					"properties": "1627207:28321",
    					"url": "//img.alicdn.com/imgextra/i1/2568161054/O1CN017GTZ4h1Jem9Qra1ap_!!2568161054.jpg"
    				}
    			]
    		},
    		"_ddf": "xdl",
    		"promo_type": null,
    		"props_img": {
    			"1627207:28321": "//img.alicdn.com/imgextra/i1/2568161054/O1CN017GTZ4h1Jem9Qra1ap_!!2568161054.jpg"
    		},
    		"format_check": "ok",
    		"shop_item": [],
    		"relate_items": []
    	},

[Link 1]: https://o0b.cn/jennif