experiment.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from util import *\n",
    "#-*- coding: utf-8 -*-\n",
    "import sys\n",
    "reload(sys)\n",
    "sys.setdefaultencoding('utf-8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = create_engine(\"mysql://wspider:wspider00!q@133.186.143.65:3306/wspider\",\n",
    "                           connect_args={'connect_timeout': 10000})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_sql_query(\"SELECT * FROM MWS_COLT_ITEM LIMIT 3\" , engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1, 2, 3])"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.ID.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "for id in data.ID.values:\n",
    "    image_df = pd.read_sql_query(\"SELECT * FROM MWS_COLT_IMAGE WHERE ITEM_ID = %s\" % id, engine)\n",
    "    print(image_df['GOODS_IMAGE'][0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>ITEM_ID</th>\n",
       "      <th>GOODS_IMAGE</th>\n",
       "      <th>FILE_PATH</th>\n",
       "      <th>OPTION</th>\n",
       "      <th>SEQ</th>\n",
       "      <th>HASH</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>REG_DT</th>\n",
       "      <th>UPT_DT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>http://image.gsshop.com/image/26/82/26824626_L...</td>\n",
       "      <td>/GSSHOP/2/0/2.jpg</td>\n",
       "      <td>67073096550953918</td>\n",
       "      <td>1</td>\n",
       "      <td>-709455420029072118</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-08-01 16:04:32</td>\n",
       "      <td>2017-08-28 15:51:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID  ITEM_ID                                        GOODS_IMAGE          FILE_PATH             OPTION  SEQ                HASH  STATUS              REG_DT              UPT_DT\n",
       "0   2        2  http://image.gsshop.com/image/26/82/26824626_L...  /GSSHOP/2/0/2.jpg  67073096550953918    1 -709455420029072118       1 2017-08-01 16:04:32 2017-08-28 15:51:00"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_sql_query(\"SELECT * FROM MWS_COLT_IMAGE WHERE ITEM_ID = %s\" % '2', engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'http://image.gsshop.com/image/26/82/26824626_L1.jpg'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_sql_query(\"SELECT * FROM MWS_COLT_IMAGE WHERE ITEM_ID = %s\" % '2', engine)['GOODS_IMAGE'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "resp = urllib.urlopen('http://image.gsshop.com/image/26/82/26824626_L1.jpg')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<addinfourl at 5113463584 whose fp = <socket._fileobject object at 0x130c8fad0>>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "resp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "image = np.asarray(bytearray(resp.read()), dtype=\"uint8\")\n",
    "image = cv2.imdecode(image, cv2.IMREAD_COLOR)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[[255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        ..., \n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255]],\n",
       "\n",
       "       [[255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        ..., \n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255]],\n",
       "\n",
       "       [[255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        ..., \n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255]],\n",
       "\n",
       "       ..., \n",
       "       [[255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        ..., \n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255]],\n",
       "\n",
       "       [[255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        ..., \n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255]],\n",
       "\n",
       "       [[255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        ..., \n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255],\n",
       "        [255, 255, 255]]], dtype=uint8)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 418,
   "metadata": {},
   "outputs": [],
   "source": [
    "# engine = create_engine(\"mysql://wspider:wspider00!q@133.186.143.65:3306/wspider\",\n",
    "#                            connect_args={'connect_timeout': 10000})\n",
    "\n",
    "engine = create_engine(\"mysql://wspidermr:wspidermr00!q@133.186.134.155:3306/lf-bigdata-real-5\",\n",
    "                           connect_args={'connect_timeout': 10000})\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 419,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_answer = pd.read_sql_query(\"SELECT * FROM MLF_GOODS_ANSWER\" , engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_answer = data_answer[['GOODS_NO', 'CATE_CODE3']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GOODS_NO</th>\n",
       "      <th>CATE_CODE3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4764804</td>\n",
       "      <td>WF1204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4764805</td>\n",
       "      <td>WF0902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4764808</td>\n",
       "      <td>WF0902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4764809</td>\n",
       "      <td>WF0699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4764810</td>\n",
       "      <td>WF0699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4764852</td>\n",
       "      <td>WF0902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>4764856</td>\n",
       "      <td>WF0902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4764857</td>\n",
       "      <td>WF0902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4764858</td>\n",
       "      <td>WF0902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4764860</td>\n",
       "      <td>WF0902</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    GOODS_NO CATE_CODE3\n",
       "0    4764804     WF1204\n",
       "1    4764805     WF0902\n",
       "2    4764808     WF0902\n",
       "3    4764809     WF0699\n",
       "4    4764810     WF0699\n",
       "..       ...        ...\n",
       "15   4764852     WF0902\n",
       "16   4764856     WF0902\n",
       "17   4764857     WF0902\n",
       "18   4764858     WF0902\n",
       "19   4764860     WF0902\n",
       "\n",
       "[20 rows x 2 columns]"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_answer.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 422,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pd.read_sql_query(\"SELECT * FROM MLF_IMAGE LIMIT 3\" , engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_image = pd.read_sql_query(\"SELECT GOODS_NO, IMAGE_URL FROM MLF_IMAGE\" , engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_image = data_image.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IMAGE_URL</th>\n",
       "      <th>GOODS_NO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://image.gsshop.com/image/26/82/26825197_L...</td>\n",
       "      <td>4764797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://image.gsshop.com/image/26/82/26824627_L...</td>\n",
       "      <td>4764800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://image.gsshop.com/image/26/82/26825223_L...</td>\n",
       "      <td>4764801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://image.gsshop.com/image/26/82/26825131_L...</td>\n",
       "      <td>4764793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://image.gsshop.com/image/25/63/25635525_L...</td>\n",
       "      <td>4764814</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           IMAGE_URL  GOODS_NO\n",
       "0  http://image.gsshop.com/image/26/82/26825197_L...   4764797\n",
       "1  http://image.gsshop.com/image/26/82/26824627_L...   4764800\n",
       "2  http://image.gsshop.com/image/26/82/26825223_L...   4764801\n",
       "3  http://image.gsshop.com/image/26/82/26825131_L...   4764793\n",
       "4  http://image.gsshop.com/image/25/63/25635525_L...   4764814"
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_image.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_answer_image = pd.merge(data_answer, data_image, how='left', left_on=['GOODS_NO'], right_on=['GOODS_NO'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_answer_image = data_answer_image.groupby(\"GOODS_NO\").first()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_answer_image['GOODS_NO'] = data_answer_image.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CATE_CODE3</th>\n",
       "      <th>IMAGE_URL</th>\n",
       "      <th>GOODS_NO</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOODS_NO</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4764804</th>\n",
       "      <td>WF1204</td>\n",
       "      <td>http://image.gsshop.com/image/26/12/26125249_L...</td>\n",
       "      <td>4764804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4764805</th>\n",
       "      <td>WF0902</td>\n",
       "      <td>http://image.gsshop.com/image/25/11/25112401_L...</td>\n",
       "      <td>4764805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4764808</th>\n",
       "      <td>WF0902</td>\n",
       "      <td>http://image.gsshop.com/image/26/12/26125243_L...</td>\n",
       "      <td>4764808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4764809</th>\n",
       "      <td>WF0699</td>\n",
       "      <td>http://image.gsshop.com/image/26/76/26766819_L...</td>\n",
       "      <td>4764809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4764810</th>\n",
       "      <td>WF0699</td>\n",
       "      <td>http://image.gsshop.com/image/25/92/25920999_L...</td>\n",
       "      <td>4764810</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         CATE_CODE3                                          IMAGE_URL  GOODS_NO\n",
       "GOODS_NO                                                                        \n",
       "4764804      WF1204  http://image.gsshop.com/image/26/12/26125249_L...   4764804\n",
       "4764805      WF0902  http://image.gsshop.com/image/25/11/25112401_L...   4764805\n",
       "4764808      WF0902  http://image.gsshop.com/image/26/12/26125243_L...   4764808\n",
       "4764809      WF0699  http://image.gsshop.com/image/26/76/26766819_L...   4764809\n",
       "4764810      WF0699  http://image.gsshop.com/image/25/92/25920999_L...   4764810"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_answer_image.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_category = pd.read_sql_query(\"SELECT * FROM MLF_CATEGORY\" , engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CATE_NO</th>\n",
       "      <th>UPPER_CATE_NO</th>\n",
       "      <th>CATE_NAME</th>\n",
       "      <th>DEPTH</th>\n",
       "      <th>CODE1</th>\n",
       "      <th>CODE2</th>\n",
       "      <th>CODE3</th>\n",
       "      <th>CODE4</th>\n",
       "      <th>CODE5</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>CATE_NAMES</th>\n",
       "      <th>LEAF</th>\n",
       "      <th>REG_DT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>미분류</td>\n",
       "      <td>1</td>\n",
       "      <td>99</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>미분류</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-08-29 11:34:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>남성의류</td>\n",
       "      <td>1</td>\n",
       "      <td>WM</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>남성의류</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-08-29 11:34:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>여성의류</td>\n",
       "      <td>1</td>\n",
       "      <td>WF</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>여성의류</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-08-29 11:34:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>유니섹스의류</td>\n",
       "      <td>1</td>\n",
       "      <td>WU</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>유니섹스의류</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-08-29 11:34:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>키즈의류</td>\n",
       "      <td>1</td>\n",
       "      <td>WK</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>키즈의류</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-08-29 11:34:48</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   CATE_NO  UPPER_CATE_NO CATE_NAME  DEPTH CODE1 CODE2 CODE3 CODE4 CODE5  STATUS CATE_NAMES  LEAF              REG_DT\n",
       "0        0              0       미분류      1    99                               1        미분류     0 2017-08-29 11:34:48\n",
       "1        1              0      남성의류      1    WM                               1       남성의류     0 2017-08-29 11:34:48\n",
       "2        2              0      여성의류      1    WF                               1       여성의류     0 2017-08-29 11:34:48\n",
       "3        3              0    유니섹스의류      1    WU                               1     유니섹스의류     0 2017-08-29 11:34:48\n",
       "4        4              0      키즈의류      1    WK                               1       키즈의류     0 2017-08-29 11:34:48"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_category.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_category = data_category[['CODE3', 'CATE_NAMES']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CODE3</th>\n",
       "      <th>CATE_NAMES</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td>미분류</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>남성의류</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td></td>\n",
       "      <td>여성의류</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td></td>\n",
       "      <td>유니섹스의류</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td></td>\n",
       "      <td>키즈의류</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  CODE3 CATE_NAMES\n",
       "0              미분류\n",
       "1             남성의류\n",
       "2             여성의류\n",
       "3           유니섹스의류\n",
       "4             키즈의류"
      ]
     },
     "execution_count": 152,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_category.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 424,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_answer_image_category = pd.merge(data_answer_image, data_category, how='left', left_on=[\"CATE_CODE3\"], right_on=[\"CODE3\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 425,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CATE_CODE3</th>\n",
       "      <th>IMAGE_URL</th>\n",
       "      <th>GOODS_NO</th>\n",
       "      <th>CODE3</th>\n",
       "      <th>CATE_NAMES</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>WF1204</td>\n",
       "      <td>http://image.gsshop.com/image/26/12/26125249_L...</td>\n",
       "      <td>4764804</td>\n",
       "      <td>WF1204</td>\n",
       "      <td>여성의류&gt;팬츠&gt;배기</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>WF0902</td>\n",
       "      <td>http://image.gsshop.com/image/25/11/25112401_L...</td>\n",
       "      <td>4764805</td>\n",
       "      <td>WF0902</td>\n",
       "      <td>여성의류&gt;티셔츠&gt;기타 티셔츠</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>WF0902</td>\n",
       "      <td>http://image.gsshop.com/image/26/12/26125243_L...</td>\n",
       "      <td>4764808</td>\n",
       "      <td>WF0902</td>\n",
       "      <td>여성의류&gt;티셔츠&gt;기타 티셔츠</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WF0699</td>\n",
       "      <td>http://image.gsshop.com/image/26/76/26766819_L...</td>\n",
       "      <td>4764809</td>\n",
       "      <td>WF0699</td>\n",
       "      <td>여성의류&gt;블라우스&gt;미분류</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>WF0699</td>\n",
       "      <td>http://image.gsshop.com/image/25/92/25920999_L...</td>\n",
       "      <td>4764810</td>\n",
       "      <td>WF0699</td>\n",
       "      <td>여성의류&gt;블라우스&gt;미분류</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  CATE_CODE3                                          IMAGE_URL  GOODS_NO   CODE3       CATE_NAMES\n",
       "0     WF1204  http://image.gsshop.com/image/26/12/26125249_L...   4764804  WF1204       여성의류>팬츠>배기\n",
       "1     WF0902  http://image.gsshop.com/image/25/11/25112401_L...   4764805  WF0902  여성의류>티셔츠>기타 티셔츠\n",
       "2     WF0902  http://image.gsshop.com/image/26/12/26125243_L...   4764808  WF0902  여성의류>티셔츠>기타 티셔츠\n",
       "3     WF0699  http://image.gsshop.com/image/26/76/26766819_L...   4764809  WF0699    여성의류>블라우스>미분류\n",
       "4     WF0699  http://image.gsshop.com/image/25/92/25920999_L...   4764810  WF0699    여성의류>블라우스>미분류"
      ]
     },
     "execution_count": 425,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_answer_image_category.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 426,
   "metadata": {},
   "outputs": [],
   "source": [
    "del data_answer_image_category['CATE_CODE3']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 353,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pickle.dump(data_answer_image_category, open(\"data/data_answer_image_category.pkl\", \"wb\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pickle.dump(data_answer_image_category, open(\"data/data_answer_image_category.pkl\", \"wb\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 427,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_answer_image_category['STATUS'] = \"waiting\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 428,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IMAGE_URL</th>\n",
       "      <th>GOODS_NO</th>\n",
       "      <th>CODE3</th>\n",
       "      <th>CATE_NAMES</th>\n",
       "      <th>STATUS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://image.gsshop.com/image/26/12/26125249_L...</td>\n",
       "      <td>4764804</td>\n",
       "      <td>WF1204</td>\n",
       "      <td>여성의류&gt;팬츠&gt;배기</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://image.gsshop.com/image/25/11/25112401_L...</td>\n",
       "      <td>4764805</td>\n",
       "      <td>WF0902</td>\n",
       "      <td>여성의류&gt;티셔츠&gt;기타 티셔츠</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://image.gsshop.com/image/26/12/26125243_L...</td>\n",
       "      <td>4764808</td>\n",
       "      <td>WF0902</td>\n",
       "      <td>여성의류&gt;티셔츠&gt;기타 티셔츠</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://image.gsshop.com/image/26/76/26766819_L...</td>\n",
       "      <td>4764809</td>\n",
       "      <td>WF0699</td>\n",
       "      <td>여성의류&gt;블라우스&gt;미분류</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://image.gsshop.com/image/25/92/25920999_L...</td>\n",
       "      <td>4764810</td>\n",
       "      <td>WF0699</td>\n",
       "      <td>여성의류&gt;블라우스&gt;미분류</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           IMAGE_URL  GOODS_NO   CODE3       CATE_NAMES   STATUS\n",
       "0  http://image.gsshop.com/image/26/12/26125249_L...   4764804  WF1204       여성의류>팬츠>배기  waiting\n",
       "1  http://image.gsshop.com/image/25/11/25112401_L...   4764805  WF0902  여성의류>티셔츠>기타 티셔츠  waiting\n",
       "2  http://image.gsshop.com/image/26/12/26125243_L...   4764808  WF0902  여성의류>티셔츠>기타 티셔츠  waiting\n",
       "3  http://image.gsshop.com/image/26/76/26766819_L...   4764809  WF0699    여성의류>블라우스>미분류  waiting\n",
       "4  http://image.gsshop.com/image/25/92/25920999_L...   4764810  WF0699    여성의류>블라우스>미분류  waiting"
      ]
     },
     "execution_count": 428,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_answer_image_category.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 429,
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp2 = pd.read_sql_query(\"SELECT * FROM MLF_GOODS_CATE\" , engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 438,
   "metadata": {},
   "outputs": [],
   "source": [
    "MLF_GOODS = pd.read_sql_query(\"SELECT GOODS_NO, GOODS_NAME, URL FROM MLF_GOODS\" , engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 432,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IMAGE_URL</th>\n",
       "      <th>GOODS_NO</th>\n",
       "      <th>CODE3</th>\n",
       "      <th>CATE_NAMES</th>\n",
       "      <th>STATUS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://image.gsshop.com/image/26/12/26125249_L...</td>\n",
       "      <td>4764804</td>\n",
       "      <td>WF1204</td>\n",
       "      <td>여성의류&gt;팬츠&gt;배기</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://image.gsshop.com/image/25/11/25112401_L...</td>\n",
       "      <td>4764805</td>\n",
       "      <td>WF0902</td>\n",
       "      <td>여성의류&gt;티셔츠&gt;기타 티셔츠</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://image.gsshop.com/image/26/12/26125243_L...</td>\n",
       "      <td>4764808</td>\n",
       "      <td>WF0902</td>\n",
       "      <td>여성의류&gt;티셔츠&gt;기타 티셔츠</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://image.gsshop.com/image/26/76/26766819_L...</td>\n",
       "      <td>4764809</td>\n",
       "      <td>WF0699</td>\n",
       "      <td>여성의류&gt;블라우스&gt;미분류</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://image.gsshop.com/image/25/92/25920999_L...</td>\n",
       "      <td>4764810</td>\n",
       "      <td>WF0699</td>\n",
       "      <td>여성의류&gt;블라우스&gt;미분류</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           IMAGE_URL  GOODS_NO   CODE3       CATE_NAMES   STATUS\n",
       "0  http://image.gsshop.com/image/26/12/26125249_L...   4764804  WF1204       여성의류>팬츠>배기  waiting\n",
       "1  http://image.gsshop.com/image/25/11/25112401_L...   4764805  WF0902  여성의류>티셔츠>기타 티셔츠  waiting\n",
       "2  http://image.gsshop.com/image/26/12/26125243_L...   4764808  WF0902  여성의류>티셔츠>기타 티셔츠  waiting\n",
       "3  http://image.gsshop.com/image/26/76/26766819_L...   4764809  WF0699    여성의류>블라우스>미분류  waiting\n",
       "4  http://image.gsshop.com/image/25/92/25920999_L...   4764810  WF0699    여성의류>블라우스>미분류  waiting"
      ]
     },
     "execution_count": 432,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_answer_image_category.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 433,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_org_cate_name = tmp2[['GOODS_NO', 'ORG_CATE_NAME']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 434,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pd.merge(data_answer_image, data_category, how='left', left_on=[\"CATE_CODE3\"], right_on=[\"CODE3\"])\n",
    "\n",
    "data_answer_image_category_org = pd.merge(data_answer_image_category, data_org_cate_name, how='left', left_on=[\"GOODS_NO\"], right_on=[\"GOODS_NO\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 440,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_answer_image_category_org_mlf = pd.merge(data_answer_image_category_org, MLF_GOODS, how='left', left_on=[\"GOODS_NO\"], right_on=[\"GOODS_NO\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 446,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IMAGE_URL</th>\n",
       "      <th>GOODS_NO</th>\n",
       "      <th>CODE3</th>\n",
       "      <th>CATE_NAMES</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>ORG_CATE_NAME</th>\n",
       "      <th>GOODS_NAME</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://image.gsshop.com/image/26/12/26125249_L...</td>\n",
       "      <td>4764804</td>\n",
       "      <td>WF1204</td>\n",
       "      <td>여성의류&gt;팬츠&gt;배기</td>\n",
       "      <td>waiting</td>\n",
       "      <td>패션의류/속옷&gt;여성의류&gt;바지/팬츠&gt;배기/통/와이드</td>\n",
       "      <td>[보니알렉스] 와이드 팬츠 3종택1</td>\n",
       "      <td>http://www.gsshop.com/prd/prd.gs?prdid=26125249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://image.gsshop.com/image/25/11/25112401_L...</td>\n",
       "      <td>4764805</td>\n",
       "      <td>WF0902</td>\n",
       "      <td>여성의류&gt;티셔츠&gt;기타 티셔츠</td>\n",
       "      <td>waiting</td>\n",
       "      <td>패션의류/속옷&gt;여성의류&gt;티셔츠&gt;라운드넥/브이넥</td>\n",
       "      <td>[리차드차이] 스카프넥 크롭티 ECTZ720C</td>\n",
       "      <td>http://www.gsshop.com/prd/prd.gs?prdid=25112401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://image.gsshop.com/image/26/12/26125243_L...</td>\n",
       "      <td>4764808</td>\n",
       "      <td>WF0902</td>\n",
       "      <td>여성의류&gt;티셔츠&gt;기타 티셔츠</td>\n",
       "      <td>waiting</td>\n",
       "      <td>패션의류/속옷&gt;여성의류&gt;티셔츠&gt;라운드넥/브이넥</td>\n",
       "      <td>리차드차이 린넨 티셔츠 3종택1</td>\n",
       "      <td>http://www.gsshop.com/prd/prd.gs?prdid=26125243</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://image.gsshop.com/image/26/76/26766819_L...</td>\n",
       "      <td>4764809</td>\n",
       "      <td>WF0699</td>\n",
       "      <td>여성의류&gt;블라우스&gt;미분류</td>\n",
       "      <td>waiting</td>\n",
       "      <td>패션의류/속옷&gt;여성의류&gt;블라우스/셔츠&gt;프린트/체크</td>\n",
       "      <td>[리차드차이]EC_마린 블라우스 2종 택1</td>\n",
       "      <td>http://www.gsshop.com/prd/prd.gs?prdid=26766819</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://image.gsshop.com/image/25/92/25920999_L...</td>\n",
       "      <td>4764810</td>\n",
       "      <td>WF0699</td>\n",
       "      <td>여성의류&gt;블라우스&gt;미분류</td>\n",
       "      <td>waiting</td>\n",
       "      <td>패션의류/속옷&gt;여성의류&gt;블라우스/셔츠&gt;기본/솔리드</td>\n",
       "      <td>로맨틱 프린트 블라우스 3종택1</td>\n",
       "      <td>http://www.gsshop.com/prd/prd.gs?prdid=25920999</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           IMAGE_URL  GOODS_NO   CODE3       CATE_NAMES   STATUS                ORG_CATE_NAME                 GOODS_NAME                                              URL\n",
       "0  http://image.gsshop.com/image/26/12/26125249_L...   4764804  WF1204       여성의류>팬츠>배기  waiting  패션의류/속옷>여성의류>바지/팬츠>배기/통/와이드        [보니알렉스] 와이드 팬츠 3종택1  http://www.gsshop.com/prd/prd.gs?prdid=26125249\n",
       "1  http://image.gsshop.com/image/25/11/25112401_L...   4764805  WF0902  여성의류>티셔츠>기타 티셔츠  waiting    패션의류/속옷>여성의류>티셔츠>라운드넥/브이넥  [리차드차이] 스카프넥 크롭티 ECTZ720C  http://www.gsshop.com/prd/prd.gs?prdid=25112401\n",
       "2  http://image.gsshop.com/image/26/12/26125243_L...   4764808  WF0902  여성의류>티셔츠>기타 티셔츠  waiting    패션의류/속옷>여성의류>티셔츠>라운드넥/브이넥          리차드차이 린넨 티셔츠 3종택1  http://www.gsshop.com/prd/prd.gs?prdid=26125243\n",
       "3  http://image.gsshop.com/image/26/76/26766819_L...   4764809  WF0699    여성의류>블라우스>미분류  waiting  패션의류/속옷>여성의류>블라우스/셔츠>프린트/체크    [리차드차이]EC_마린 블라우스 2종 택1  http://www.gsshop.com/prd/prd.gs?prdid=26766819\n",
       "4  http://image.gsshop.com/image/25/92/25920999_L...   4764810  WF0699    여성의류>블라우스>미분류  waiting  패션의류/속옷>여성의류>블라우스/셔츠>기본/솔리드          로맨틱 프린트 블라우스 3종택1  http://www.gsshop.com/prd/prd.gs?prdid=25920999"
      ]
     },
     "execution_count": 446,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_answer_image_category_org_mlf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 348,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_images():\n",
    "    \n",
    "\n",
    "    df = data_answer_image_category[data_answer_image_category.STATUS != 'done']\n",
    "    return df.head(10).T.to_dict().values()\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 445,
   "metadata": {},
   "outputs": [],
   "source": [
    "#get_images()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 347,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<generator object get_images at 0x25d173f50>"
      ]
     },
     "execution_count": 347,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp_gen"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 273,
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp = data_answer_image_category"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 287,
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp = pickle.load(open(\"data/data_answer_image_category.pkl\", \"rb\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 352,
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp['STATUS'] = 'waiting'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 299,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\xbf\\xa9\\xbc\\xba\\xc0\\xc7\\xb7\\xf9>\\xc6\\xd2\\xc3\\xf7>\\xb9\\xe8\\xb1\\xe2'"
      ]
     },
     "execution_count": 299,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp['CATE_NAMES'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 320,
   "metadata": {},
   "outputs": [],
   "source": [
    "print(a)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pymongo import MongoClient\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "client = MongoClient(\"mongodb://mongo-191809ff-1.b3d823aa.cont.dockerapp.io:32770\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "db = client.epopcon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WU0204',\n",
       "  u'GOODS_NAME': u'[\\ud589\\ud150]\\ub0a8\\uc5ec\\uacf5\\uc6a9 \\ubc99\\ucee4 \\ub2e4\\uc6b4\\uc790\\ucf13(10090-213-802-48)',\n",
       "  u'GOODS_NO': 10702464,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/41/92/60/54/4/454609241_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc601\\ud50c\\ub77c\\uc790 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\uc810\\ud37c > \\ud328\\ub529/\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=454609241',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be14')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WF0204',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\ube14\\ub799 \\ud6c4\\ub4dc \\ub2e4\\uc6b4 \\ud328\\ub529 (167838SY15)',\n",
       "  u'GOODS_NO': 10702465,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/39/28392457_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ub514\\uc790\\uc774\\ub108\\uc0f5>\\ub0a8\\uc131 \\uc758\\ub958>\\uc790\\ucf13/\\ucf54\\ud2b8/\\ud328\\ub529',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28392457',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be15')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'CODE3': u'WF0804',\n",
       "  u'GOODS_NAME': u'[\\ud074\\ub9ad\\uc564\\ud37c\\ub2c8]\\ucf00\\ub9b0 \\uaf48\\ubc30\\uae30 \\ubc18\\ud3f4\\ub77c\\ub2c8\\ud2b8/\\ud130\\ud2c0\\ub125/\\ub871\\uc2a4\\uc6e8\\ud130/\\uc2dc\\ubcf4\\ub9ac\\uc9dc',\n",
       "  u'GOODS_NO': 10702472,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/54/28549642_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud2b8\\ub80c\\ub4dc\\uc758\\ub958>\\ub2c8\\ud2b8/\\uac00\\ub514\\uac74/\\uc870\\ub07c>\\ud130\\ud2c0\\ub125/\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28549642',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be16')}]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(db.products.find().limit(3))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# db.products_test.insert_many(list(db.products.find().limit(3)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WU0204',\n",
       "  u'GOODS_NAME': u'[\\ud589\\ud150]\\ub0a8\\uc5ec\\uacf5\\uc6a9 \\ubc99\\ucee4 \\ub2e4\\uc6b4\\uc790\\ucf13(10090-213-802-48)',\n",
       "  u'GOODS_NO': 10702464,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/41/92/60/54/4/454609241_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc601\\ud50c\\ub77c\\uc790 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\uc810\\ud37c > \\ud328\\ub529/\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=454609241',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be14')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WF0204',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\ube14\\ub799 \\ud6c4\\ub4dc \\ub2e4\\uc6b4 \\ud328\\ub529 (167838SY15)',\n",
       "  u'GOODS_NO': 10702465,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/39/28392457_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ub514\\uc790\\uc774\\ub108\\uc0f5>\\ub0a8\\uc131 \\uc758\\ub958>\\uc790\\ucf13/\\ucf54\\ud2b8/\\ud328\\ub529',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28392457',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be15')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'CODE3': u'WF0804',\n",
       "  u'GOODS_NAME': u'[\\ud074\\ub9ad\\uc564\\ud37c\\ub2c8]\\ucf00\\ub9b0 \\uaf48\\ubc30\\uae30 \\ubc18\\ud3f4\\ub77c\\ub2c8\\ud2b8/\\ud130\\ud2c0\\ub125/\\ub871\\uc2a4\\uc6e8\\ud130/\\uc2dc\\ubcf4\\ub9ac\\uc9dc',\n",
       "  u'GOODS_NO': 10702472,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/54/28549642_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud2b8\\ub80c\\ub4dc\\uc758\\ub958>\\ub2c8\\ud2b8/\\uac00\\ub514\\uac74/\\uc870\\ub07c>\\ud130\\ud2c0\\ub125/\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28549642',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be16')}]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(db.products_test.find())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WU0204',\n",
       "  u'GOODS_NAME': u'[\\ud589\\ud150]\\ub0a8\\uc5ec\\uacf5\\uc6a9 \\ubc99\\ucee4 \\ub2e4\\uc6b4\\uc790\\ucf13(10090-213-802-48)',\n",
       "  u'GOODS_NO': 10702464,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/41/92/60/54/4/454609241_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc601\\ud50c\\ub77c\\uc790 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\uc810\\ud37c > \\ud328\\ub529/\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=454609241',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be14')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WF0204',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\ube14\\ub799 \\ud6c4\\ub4dc \\ub2e4\\uc6b4 \\ud328\\ub529 (167838SY15)',\n",
       "  u'GOODS_NO': 10702465,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/39/28392457_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ub514\\uc790\\uc774\\ub108\\uc0f5>\\ub0a8\\uc131 \\uc758\\ub958>\\uc790\\ucf13/\\ucf54\\ud2b8/\\ud328\\ub529',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28392457',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be15')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'CODE3': u'WF0804',\n",
       "  u'GOODS_NAME': u'[\\ud074\\ub9ad\\uc564\\ud37c\\ub2c8]\\ucf00\\ub9b0 \\uaf48\\ubc30\\uae30 \\ubc18\\ud3f4\\ub77c\\ub2c8\\ud2b8/\\ud130\\ud2c0\\ub125/\\ub871\\uc2a4\\uc6e8\\ud130/\\uc2dc\\ubcf4\\ub9ac\\uc9dc',\n",
       "  u'GOODS_NO': 10702472,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/54/28549642_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud2b8\\ub80c\\ub4dc\\uc758\\ub958>\\ub2c8\\ud2b8/\\uac00\\ub514\\uac74/\\uc870\\ub07c>\\ud130\\ud2c0\\ub125/\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28549642',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be16')}]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(db.products_test.find())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "good_nos = [10702464]\n",
    "status = '2'\n",
    "username = 'minsu'\n",
    "result = db.products_test.update_many({'GOODS_NO': {'$in': good_nos}}, {'$set': {'STATUS': status, 'USERNAME': username}})\n",
    "# products"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.UpdateResult at 0x10c752410>"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "db.products_test.update_many({}, {'$set': {'USERNAME': 'TEST'}})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{u'n': 1, u'nModified': 1, u'ok': 1.0, 'updatedExisting': True}"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result.raw_result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{u'CATE_NAMES': u'\\ub0a8\\uc131\\uc7a1\\ud654>\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EM9999',\n",
       "  u'GOODS_NAME': u'[\\ud558\\ud504\\ud074\\ub7fd/BASSO homme]\\uacac100 \\ub808\\ub4dc \\uae30\\ud558\\ud559 \\ud328\\ud134 \\ub125\\ud0c0\\uc774 (WSP3A..',\n",
       "  u'GOODS_NO': 7658408,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/26/78/26786863_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud558\\ud504\\ud074\\ub7fd>\\ub0a8\\uc131\\uc815\\uc7a5\\xb7\\uce90\\uc8fc\\uc5bc>\\ud328\\uc158\\uc18c\\ud488',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=26786863',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c1122c')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc6a9\\ud488>\\uc2a4\\ud3ec\\uce20\\uc6a9\\ud488>\\uc218\\uc601',\n",
       "  u'CODE3': u'UF0301',\n",
       "  u'GOODS_NAME': u'[\\uc544\\ub808\\ub098] \\uc5ec\\uc131 \\uc77c\\ubc18 \\uc6d0\\ud53c\\uc2a4 \\uc218\\uc601\\ubcf5 (ATBPL05) LIM',\n",
       "  u'GOODS_NO': 7658434,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/27/18/27187573_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc218\\uc601>\\uc5ec\\uc131\\ube44\\uce58\\uc218\\uc601\\ubcf5',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=27187573',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c1122d')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uc591\\ub9d0>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EF0699',\n",
       "  u'GOODS_NAME': u'[\\ub77c\\ucf54\\uc2a4\\ud14c(\\uc758\\ub958)]\\uc5ec\\uc131 \\uc194\\ub9ac\\ub4dc \\ub7ec\\ud50c \\uc591\\ub9d0 LCST RA191E-17C70V',\n",
       "  u'GOODS_NO': 7658463,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/23/07/31/18/4/418310723_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub9e8\\uc988 > \\ubc31\\ud654\\uc810 \\ub0a8\\uc131 \\uce90\\uc8fc\\uc5bc > \\ucf54\\ub514\\uc544\\uc774\\ud15c > \\ud328\\uc158\\uc18c\\ud488/\\uc591\\ub9d0',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=418310723',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c1122e')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc7a1\\ud654>\\uac00\\ubc29>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EK0199',\n",
       "  u'GOODS_NAME': u'[\\uc704\\ub4dc\\ub9c8\\ubbf8]\\ub7ec\\ube0c\\uc720 \\ubc29\\uc218 \\uc55e\\uce58\\ub9c8\\uc138\\ud2b8',\n",
       "  u'GOODS_NO': 7658490,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/12/60/18/16/4/416186012_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc720\\uc544\\ub3d9\\uad00 > \\uc720\\uc544\\ub3d9\\uc758\\ub958/\\uc7a1\\ud654 > \\uc720\\uc544\\ub3d9 \\uc2e0\\ubc1c/\\uac00\\ubc29/\\uc7a1\\ud654 > \\uc55e\\uce58\\ub9c8',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=416186012',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c1122f')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc790\\ucf13>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WF0199',\n",
       "  u'GOODS_NAME': u'[KEITH]\\ub2c8\\ucf5c\\ub77c\\uc2a4 K7SK120-37',\n",
       "  u'GOODS_NO': 11579815,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/8/0/66/63/2063660875_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc5ec\\uc131 \\ube0c\\ub79c\\ub4dc\\uc758\\ub958>\\ucee4\\ub9ac\\uc5b4\\ube0c\\ub79c\\ub4dc>\\ud0a4\\uc774\\uc2a4(KEITH)>\\uc790\\ucf13/\\ucf54\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2063660875',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11230')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ub4dc\\ub808\\uc2a4>\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'CODE3': u'WF1301',\n",
       "  u'GOODS_NAME': u'[\\ub098\\uc774\\uc2a4\\ud074\\ub78d]\\ud398\\ubbf8\\ub2cc\\ud55cA\\ub77c\\uc778\\uc6d0\\ud53c\\uc2a4(N174MSE007)',\n",
       "  u'GOODS_NO': 11154444,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/20/18/38/60/4/460381820_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc601\\uce90\\uc8fc\\uc5bc > \\uc6d0\\ud53c\\uc2a4 > \\uc815\\uc7a5\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=460381820',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11231')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ub4dc\\ub808\\uc2a4>\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'CODE3': u'WF1301',\n",
       "  u'GOODS_NAME': u'[\\ub098\\uc774\\uc2a4\\ud074\\ub78d]\\ud398\\ubbf8\\ub2cc\\ud55c\\uc6d0\\ud53c\\uc2a4(N174MSE012)',\n",
       "  u'GOODS_NO': 11154445,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/05/18/38/60/4/460381805_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc601\\uce90\\uc8fc\\uc5bc > \\uc6d0\\ud53c\\uc2a4 > \\uc815\\uc7a5\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=460381805',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11232')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ub4dc\\ub808\\uc2a4>\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'CODE3': u'WF1301',\n",
       "  u'GOODS_NAME': u'[\\ub098\\uc774\\uc2a4\\ud074\\ub78d]\\ud398\\ubbf8\\ub2cc\\ud55c\\uc154\\ub9c1\\uc6d0\\ud53c\\uc2a4(N174MSE011)',\n",
       "  u'GOODS_NO': 11154399,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/80/17/38/60/4/460381780_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc601\\uce90\\uc8fc\\uc5bc > \\uc6d0\\ud53c\\uc2a4 > \\uc815\\uc7a5\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=460381780',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11233')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ub4dc\\ub808\\uc2a4>\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'CODE3': u'WF1301',\n",
       "  u'GOODS_NAME': u'[\\ub098\\uc778] \\ube44\\ub300\\uce6d \\ub871 \\ub2c8\\ud2b8 \\uc6d0\\ud53c\\uc2a4(OP-3441)',\n",
       "  u'GOODS_NO': 11154431,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/82/28825560_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc5ec\\uc131\\uce90\\uc8fc\\uc5bc>\\uc6d0\\ud53c\\uc2a4>\\uc815\\uc7a5\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28825560',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11234')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ub4dc\\ub808\\uc2a4>\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'CODE3': u'WF1301',\n",
       "  u'GOODS_NAME': u'[\\ub098\\uc774\\uc2a4\\ud074\\ub78d]\\ud398\\ubbf8\\ub2cc\\ud55c\\uccb4\\ud06c\\uc6d0\\ud53c\\uc2a4(N174MSE013)',\n",
       "  u'GOODS_NO': 11154331,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/98/17/38/60/4/460381798_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc601\\uce90\\uc8fc\\uc5bc > \\uc6d0\\ud53c\\uc2a4 > \\uc815\\uc7a5\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=460381798',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11235')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ub4dc\\ub808\\uc2a4>\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'CODE3': u'WF1301',\n",
       "  u'GOODS_NAME': u'[\\ub098\\uc778] H\\ud54f \\ubbf8\\ub514 \\ub2c8\\ud2b8 \\uc6d0\\ud53c\\uc2a4(OP-3474)',\n",
       "  u'GOODS_NO': 11154341,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/82/28825504_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc5ec\\uc131\\uce90\\uc8fc\\uc5bc>\\uc6d0\\ud53c\\uc2a4>\\uc815\\uc7a5\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28825504',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11236')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\uc154\\uce20>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WM0699',\n",
       "  u'GOODS_NAME': u'[\\uc62c\\uc820]\\ubd80\\ub4dc\\ub7ec\\uc6b4 \\ucd09\\uac10\\uc758 \\uccb4\\ud06c\\uc154\\uce20 ZOX4WC1301',\n",
       "  u'GOODS_NO': 11154274,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/82/28821390_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\ub0a8\\uc131\\uc758\\ub958>\\uc154\\uce20/\\ub0a8\\ubc29>\\uccb4\\ud06c/\\ud328\\ud134 \\uc154\\uce20',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28821390',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11237')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WF0902',\n",
       "  u'GOODS_NAME': u'[\\ud54f\\ub380]\\ub9ac\\ubcf8\\uace8\\uc9c0\\ud2f0\\uc154\\uce20(FFBPKJW420)',\n",
       "  u'GOODS_NO': 11154283,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/40/25/45/60/4/460452540_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc601\\uce90\\uc8fc\\uc5bc > \\ud2f0\\uc154\\uce20 > \\uc194\\ub9ac\\ub4dc/\\ubb34\\uc9c0\\ud2f0\\uc154\\uce20 > \\ube0c\\uc774\\ub125/V\\ub125 > \\uae34\\ud314',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=460452540',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11238')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WF0902',\n",
       "  u'GOODS_NAME': u'[\\ub098\\uc774\\uc2a4\\ud074\\ub78d]\\ud398\\ubbf8\\ub2cc\\ud55c\\ud2f0\\uc154\\uce20(N174MSM004)',\n",
       "  u'GOODS_NO': 11154253,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/39/16/38/60/4/460381639_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc601\\uce90\\uc8fc\\uc5bc > \\ud2f0\\uc154\\uce20 > \\uc194\\ub9ac\\ub4dc/\\ubb34\\uc9c0\\ud2f0\\uc154\\uce20 > \\ub77c\\uc6b4\\ub4dc/U\\ub125 > \\uae34\\ud314',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=460381639',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11239')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ub4dc\\ub808\\uc2a4>\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'CODE3': u'WF1301',\n",
       "  u'GOODS_NAME': u'[NamuGRim]\\ub098\\ubb34\\uadf8\\ub9bc 77\\uac00\\ub2a5_\\ud5e4\\ub77c\\uc2dcOPS C17WPE30066PK',\n",
       "  u'GOODS_NO': 11154255,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/82/28822289_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc5ec\\uc131\\uce90\\uc8fc\\uc5bc>\\uc6d0\\ud53c\\uc2a4>\\uc0c8\\ud2f4/\\uc2e4\\ud06c\\uc6d0\\ud53c\\uc2a4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28822289',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c1123a')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc6a9\\ud488>\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'UU9999',\n",
       "  u'GOODS_NAME': u'[\\uba5c\\ud0a8]\\uba5c\\ud0a8\\uc2a4\\ud3ec\\uce20 \\uc2a4\\ud2b8\\ub808\\uce6d\\ubc34\\ub4dc 2\\ub2e8\\uacc4 3 COLOR 3 SIZE [520\\uc6d0\\ud560\\uc778\\ucfe0\\ud3f0]',\n",
       "  u'GOODS_NO': 8117467,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/99/69/52/68/3/368526999_2_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub2f7\\ucef4 > \\ud5ec\\uc2a4/\\uc694\\uac00/\\uc218\\uc601/\\uc2a4\\ud0a4 > \\ud5ec\\uc2a4\\uc6a9\\ud488 > \\uadfc\\ub825\\ubc34\\ub4dc > \\uc911/\\uace0\\uae09',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=368526999',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c1123b')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc7a1\\ud654>\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'CODE3': u'EM0107',\n",
       "  u'GOODS_NAME': u'[\\uc324\\uc18c\\ub098\\uc774\\ud2b8RED] ELIUN BACKPACK M_BLACK AU709002',\n",
       "  u'GOODS_NO': 4859729,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/24/14/24147899_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uac00\\ubc29/\\ud328\\uc158\\uc7a1\\ud654>\\ub0a8\\uc131\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=24147899',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c1123c')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc7a1\\ud654>\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'CODE3': u'EM0107',\n",
       "  u'GOODS_NAME': u'[\\uc324\\uc18c\\ub098\\uc774\\ud2b8Red]Turris BACKPACK L_BLACK (I8109001)',\n",
       "  u'GOODS_NO': 4859728,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/19/09/19094000_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uac00\\ubc29/\\ud328\\uc158\\uc7a1\\ud654>\\ub0a8\\uc131\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=19094000',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c1123d')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'CODE3': u'EF0107',\n",
       "  u'GOODS_NAME': u'[\\uc324\\uc18c\\ub098\\uc774\\ud2b8RED]EGERTON BACKPACK L_BLACK(AI309001)',\n",
       "  u'GOODS_NO': 4859736,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/21/90/21907608_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uac00\\ubc29/\\ud328\\uc158\\uc7a1\\ud654>\\uc5ec\\uc131\\ud578\\ub4dc\\ubc31/\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=21907608&lseq=361480',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c1123e')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc7a1\\ud654>\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'CODE3': u'EU0107',\n",
       "  u'GOODS_NAME': u'[\\uc324\\uc18c\\ub098\\uc774\\ud2b8RED]EGERTON BACKPACK M_BLACK(AI309002)',\n",
       "  u'GOODS_NO': 4859734,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/22/47/22479754_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uac00\\ubc29/\\ud328\\uc158\\uc7a1\\ud654>\\uce90\\uc8fc\\uc5bc \\ubc31\\ud329/\\uc5d0\\ucf54\\ubc31>\\ubc31\\ud329',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=22479754',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c1123f')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'CODE3': u'EF0107',\n",
       "  u'GOODS_NAME': u'[\\uc324\\uc18c\\ub098\\uc774\\ud2b8RED]EGERTON BACKPACK L_BLACK(AI309001)',\n",
       "  u'GOODS_NO': 4859736,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/21/90/21907608_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uc5ec\\ud589\\uac00\\ubc29\\xb7\\uc18c\\ud488>\\ud558\\ub4dc \\uce90\\ub9ac\\uc5b4>\\uae30\\ub0b4\\uc6a9',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=21907608&lseq=361480',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11244')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'CODE3': u'EF0107',\n",
       "  u'GOODS_NAME': u'[\\uc324\\uc18c\\ub098\\uc774\\ud2b8RED]EGERTON BACKPACK L_BLACK(AI309001)',\n",
       "  u'GOODS_NO': 4859736,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/21/90/21907608_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uac00\\ubc29/\\ud328\\uc158\\uc7a1\\ud654>\\ub0a8\\uc131\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=21907608&lseq=361480',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c11245')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'CODE3': u'EF0107',\n",
       "  u'GOODS_NAME': u'[\\uc324\\uc18c\\ub098\\uc774\\ud2b8RED]EGERTON BACKPACK L_BLACK(AI309001)',\n",
       "  u'GOODS_NO': 4859736,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/21/90/21907608_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uac00\\ubc29/\\ud328\\uc158\\uc7a1\\ud654>\\ub0a8\\uc131\\uac00\\ubc29>\\uc11c\\ub958\\uac00\\ubc29',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=21907608&lseq=361480',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac543160cd74183c2e075')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'CODE3': u'EF0107',\n",
       "  u'GOODS_NAME': u'[\\uc324\\uc18c\\ub098\\uc774\\ud2b8RED]EGERTON BACKPACK L_BLACK(AI309001)',\n",
       "  u'GOODS_NO': 4859736,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/21/90/21907608_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uac00\\ubc29/\\ud328\\uc158\\uc7a1\\ud654>\\uce90\\uc8fc\\uc5bc \\ubc31\\ud329/\\uc5d0\\ucf54\\ubc31>\\ubc31\\ud329',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=21907608&lseq=361480',\n",
       "  u'USERNAME': u'minsu',\n",
       "  u'_id': ObjectId('5a6ac543160cd74183c2e076')}]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(db.products.find({'USERNAME': 'minsu'}))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WU0204',\n",
       "  u'GOODS_NAME': u'[\\ud589\\ud150]\\ub0a8\\uc5ec\\uacf5\\uc6a9 \\ubc99\\ucee4 \\ub2e4\\uc6b4\\uc790\\ucf13(10090-213-802-48)',\n",
       "  u'GOODS_NO': 10702464,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/41/92/60/54/4/454609241_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc601\\ud50c\\ub77c\\uc790 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\uc810\\ud37c > \\ud328\\ub529/\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=454609241',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be14')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WF0204',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\ube14\\ub799 \\ud6c4\\ub4dc \\ub2e4\\uc6b4 \\ud328\\ub529 (167838SY15)',\n",
       "  u'GOODS_NO': 10702465,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/39/28392457_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ub514\\uc790\\uc774\\ub108\\uc0f5>\\ub0a8\\uc131 \\uc758\\ub958>\\uc790\\ucf13/\\ucf54\\ud2b8/\\ud328\\ub529',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28392457',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be15')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'CODE3': u'WF0804',\n",
       "  u'GOODS_NAME': u'[\\ud074\\ub9ad\\uc564\\ud37c\\ub2c8]\\ucf00\\ub9b0 \\uaf48\\ubc30\\uae30 \\ubc18\\ud3f4\\ub77c\\ub2c8\\ud2b8/\\ud130\\ud2c0\\ub125/\\ub871\\uc2a4\\uc6e8\\ud130/\\uc2dc\\ubcf4\\ub9ac\\uc9dc',\n",
       "  u'GOODS_NO': 10702472,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/54/28549642_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud2b8\\ub80c\\ub4dc\\uc758\\ub958>\\ub2c8\\ud2b8/\\uac00\\ub514\\uac74/\\uc870\\ub07c>\\ud130\\ud2c0\\ub125/\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28549642',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be16')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\uac00\\ub514\\uac74',\n",
       "  u'CODE3': u'WF0801',\n",
       "  u'GOODS_NAME': u'\\uc81c\\ud504\\ub9b0 \\ud138 \\uc548\\uac10 \\uccb4\\ud06c \\ub204\\ube54 \\uc810\\ud37c',\n",
       "  u'GOODS_NO': 10702477,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/44/28445028_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud2b8\\ub80c\\ub4dc\\uc758\\ub958>\\ub2c8\\ud2b8/\\uac00\\ub514\\uac74/\\uc870\\ub07c>\\uae30\\ubcf8\\uac00\\ub514\\uac74',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28445028&sectid=1382303&lsectid=1378781&msectid=1379357&ssectid=1382303&lseq=405302',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be17')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ud328\\ub529',\n",
       "  u'CODE3': u'WU0202',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\uc560\\uc26c \\ud558\\ud504\\ub125 \\ud328\\ub529 (257838WY13)',\n",
       "  u'GOODS_NO': 10702429,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/32/28328932_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 >\\uc790\\ucf13/\\uc810\\ud37c/\\ucf54\\ud2b8>\\ud328\\ub529/\\ub2e4\\uc6b4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28328932',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be18')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ud328\\ub529',\n",
       "  u'CODE3': u'WU0202',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\ube14\\ub799 \\ud558\\ud504\\ub125 \\ud328\\ub529 (257838WY15)',\n",
       "  u'GOODS_NO': 10702451,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/32/28328895_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 >\\uc790\\ucf13/\\uc810\\ud37c/\\ucf54\\ud2b8>\\ud328\\ub529/\\ub2e4\\uc6b4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28328895',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be19')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ud328\\ub529',\n",
       "  u'CODE3': u'WU0202',\n",
       "  u'GOODS_NAME': u'[\\uc9c0\\uc624\\ub2e4\\ub178] 377924 \\uc5ec \\uc775\\uc2a4\\ud2b8\\ub9bc \\ub2e4\\uc6b4 \\ud30c\\uce74',\n",
       "  u'GOODS_NO': 10702453,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/7/9/37/60/2060379732_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud604\\ub300\\ubc31\\ud654\\uc810>\\uc9c4\\u3163\\uc720\\ub2c8\\uc139\\uc2a4>\\uc790\\ucf13|\\uc810\\ud37c|\\ucf54\\ud2b8>\\uc810\\ud37c>\\ud328\\ub529\\uc810\\ud37c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2060379732',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be1a')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\ud2b8\\ub808\\uc774\\ub2dd',\n",
       "  u'CODE3': u'WK1205',\n",
       "  u'GOODS_NAME': u'[\\ud589\\ud150\\uc8fc\\ub2c8\\uc5b4](14140-010-871-46)\\uc8fc\\ub2c8\\uc5b4 \\ub0a8\\uc544 \\ucc54\\ud504\\uc2a4\\ud0a4\\uc810\\ud37c',\n",
       "  u'GOODS_NO': 10702459,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/3/4/10/61/2061104399_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud604\\ub300\\ubc31\\ud654\\uc810>\\uc9c4\\u3163\\uc720\\ub2c8\\uc139\\uc2a4>\\ud328\\uc158\\uc18c\\ud488|\\ud2b8\\ub808\\uc774\\ub2dd\\ubcf5>\\ud0a4\\uc988\\uc6e8\\uc5b4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2061104399',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be1b')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\ud2b8\\ub808\\uc774\\ub2dd',\n",
       "  u'CODE3': u'WK1205',\n",
       "  u'GOODS_NAME': u'[\\ud589\\ud150\\uc8fc\\ub2c8\\uc5b4](14140-110-871-46)\\uc8fc\\ub2c8\\uc5b4 \\uc5ec\\uc544 \\uc2a4\\ud0a4\\uc810\\ud37c',\n",
       "  u'GOODS_NO': 10702480,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/8/8/11/61/2061118847_0_480.JPG',\n",
       "  u'ORG_CATE_NAME': u'\\ud604\\ub300\\ubc31\\ud654\\uc810>\\uc9c4\\u3163\\uc720\\ub2c8\\uc139\\uc2a4>\\ud328\\uc158\\uc18c\\ud488|\\ud2b8\\ub808\\uc774\\ub2dd\\ubcf5>\\ud0a4\\uc988\\uc6e8\\uc5b4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2061118847',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be1c')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WM0399',\n",
       "  u'GOODS_NAME': u'[\\ud558\\ud504\\ud074\\ub7fd/ZIOZIA] ANDZ \\ubaa8\\uc9c1\\ucf54\\ud2b8 BZV4CG1182GR',\n",
       "  u'GOODS_NO': 10702496,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/01/28013326_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud558\\ud504\\ud074\\ub7fd>\\ub0a8\\uc131\\uc815\\uc7a5\\xb7\\uce90\\uc8fc\\uc5bc>\\ucf54\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28013326',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be1d')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc7a1\\ud654>\\uc2e0\\ubc1c>\\uc544\\ucfe0\\uc544\\uc288\\uc988',\n",
       "  u'CODE3': u'EU0513',\n",
       "  u'GOODS_NAME': u'[\\uc544\\ub514\\ub2e4\\uc2a4(\\uc288\\uc988)]\\uc544\\ub514\\ub2e4\\uc2a4 \\uacf5\\uc6a9 CC \\ub808\\ubcf4 3 \\uc2ac\\ub77c\\uc774\\ub4dc (\\ube14\\ub799/\\uc2a4\\uce74\\uc774\\ube14\\ub8e8) S78036 [5,140\\uc6d0\\ud560\\uc778\\ucfe0\\ud3f0]',\n",
       "  u'GOODS_NO': 7294745,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/23/38/55/89/3/389553823_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub2f7\\ucef4 > \\uc2a4\\ud3ec\\uce20\\ud328\\uc158/\\uad6c\\uae30 > \\uc2ac\\ub9ac\\ud37c/\\uc0cc\\ub4e4/\\uc544\\ucfe0\\uc544\\uc288\\uc988',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=389553823',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be1e')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WF0902',\n",
       "  u'GOODS_NAME': u'[\\ud3ec\\uc5d0\\ubc8421]Midnight Vibes \\ud2f0\\uc154\\uce20 [KB\\uad6d\\ubbfc/\\ub86f\\ub370\\uce74\\ub4dc5%\\ud560\\uc778]',\n",
       "  u'GOODS_NO': 7294751,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/30/21/52/93/3/393522130_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub2f7\\ucef4 > \\uc5ec\\uc131 \\uce90\\uc8fc\\uc5bc/\\uc815\\uc7a5 > \\ud2f0\\uc154\\uce20 > \\ud504\\ub9b0\\ud2b8/\\ud328\\ud134\\ud2f0\\uc154\\uce20 > \\uce90\\ub9ad\\ud130/\\ud328\\ud134',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=393522130',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be1f')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc7a1\\ud654>\\uac00\\ubc29>\\ubc31\\ud329',\n",
       "  u'CODE3': u'EU0107',\n",
       "  u'GOODS_NAME': u'[\\ud0a4\\ud50c\\ub9c1]\\ucf00\\uc774\\uc5d4 (CAYENNE) \\ubc31\\ud329 KHCBA33DZT_',\n",
       "  u'GOODS_NO': 7294800,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/64/20/65/97/3/397652064_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc2a4\\ud3ec\\uce20\\ud328\\uc158/\\uc288\\uc988 > \\uc2a4\\ud3ec\\uce20\\uac00\\ubc29 > \\ubc31\\ud329',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=397652064',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be20')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud32c\\uce20>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WF1299',\n",
       "  u'GOODS_NAME': u'[\\uc2dc\\uc5d0\\ub85c]\\ubd80\\ud074\\uaf43\\uc790\\uc218 \\uc55e\\ud131 \\ubcfc\\ub968 \\ubc18\\ubc14\\uc9c0(SD2PTF856)',\n",
       "  u'GOODS_NO': 7294805,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/02/01/56/89/3/389560102_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc601\\uce90\\uc8fc\\uc5bc > \\ud32c\\uce20 > \\uce58\\ub9c8/\\ud050\\ub86f\\ud32c\\uce20',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=389560102',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be21')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WF0902',\n",
       "  u'GOODS_NAME': u'[\\ud3ec\\uc5d0\\ubc8421]\\ub7ed\\ud0a4 \\ud504\\ub9b0\\ud2b8 \\uc2a4\\uc6e8\\ud2b8\\uc154\\uce20 [KB\\uad6d\\ubbfc/\\ub86f\\ub370\\uce74\\ub4dc5%\\ud560\\uc778]',\n",
       "  u'GOODS_NO': 7294809,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/48/93/35/25/3/325359348_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub2f7\\ucef4 > \\uc5ec\\uc131 \\uce90\\uc8fc\\uc5bc/\\uc815\\uc7a5 > \\ud2f0\\uc154\\uce20 > \\ud504\\ub9b0\\ud2b8/\\ud328\\ud134\\ud2f0\\uc154\\uce20 > \\uce90\\ub9ad\\ud130/\\ud328\\ud134',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=325359348',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be22')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc7a1\\ud654>\\uc7a5\\uac11>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EM1199',\n",
       "  u'GOODS_NAME': u'[\\ub974\\uae4c\\ud504]1416OV304 \\ud30c\\uc6cc\\uc2a4\\ud2b8\\ub808\\uce58 \\uc18c\\uc7ac\\ub97c \\uc801\\uc6a9\\ud55c BASIC \\ub0a8\\uc131\\uc6a9 \\ubc29\\ud55c \\uc7a5\\uac11',\n",
       "  u'GOODS_NO': 7294914,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/28/91/97/23/3/323979128_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc2a4\\ud3ec\\uce20\\ud328\\uc158/\\uc288\\uc988 > \\uc2a4\\ud3ec\\uce20\\uc7a1\\ud654/\\uc6a9\\ud488 > \\uc7a5\\uac11/\\uc591\\ub9d0',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=323979128',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be23')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ud328\\ub529',\n",
       "  u'CODE3': u'WM0202',\n",
       "  u'GOODS_NAME': u'[\\uc6b8\\uc2a4\\ud3ec\\uce20]50D TWIN RIB \\uc6f0\\ub860 \\ud328\\ub529\\ub871\\ucf54\\ud2b8 409/411',\n",
       "  u'GOODS_NO': 7294958,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/75/66/28/15/3/315286675_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub2f7\\ucef4 > \\uc2a4\\ud3ec\\uce20\\ud328\\uc158/\\uad6c\\uae30 > \\ub0a8\\uc131 \\uc2a4\\ud3ec\\uce20\\uc758\\ub958 > \\ub2e4\\uc6b4/\\ud328\\ub529\\uc7ac\\ud0b7/\\uc810\\ud37c > \\ub355\\ub2e4\\uc6b4/\\ud328\\ub529',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=315286675',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be24')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uac00\\ubc29>\\uc204\\ub354/\\ud06c\\ub85c\\uc2a4/\\uba54\\uc2e0\\uc800\\ubc31',\n",
       "  u'CODE3': u'EF0105',\n",
       "  u'GOODS_NAME': u'[\\uc9c8\\ubc14\\uc774\\uc9c8\\uc2a4\\ud29c\\uc5b4\\ud2b8]\\uc9c8\\ub9ac\\ub2e4\\ud06c\\ube0c\\ub77c\\uc6b4 \\uc2a4\\ud130\\ub4dc \\ubbf8\\ub2c8\\ud06c\\ub85c\\uc2a4 JLBA7E116W2 [3%\\uc801\\ub9bd+KB\\uad6d\\ubbfc/\\ub86f\\ub370\\uce74\\ub4dc5%\\ud560\\uc778]',\n",
       "  u'GOODS_NO': 7294966,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/14/14/42/36/3/336421414_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub2f7\\ucef4 > \\ud328\\uc158\\uc7a1\\ud654 > \\uc5ec\\uc131\\uac00\\ubc29 > \\ud06c\\ub85c\\uc2a4\\ubc31 > \\uac00\\uc8fd',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=336421414',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be25')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\ud32c\\uce20>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WK1099',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uaf34\\ub9ac\\uc5d0](\\uc5d0\\uaf34\\ub9ac\\uc5d0) \\uc18c\\ud504\\ud2f0 \\uae30\\ubaa8 \\uba74\\ud32c\\uce20_14D5202',\n",
       "  u'GOODS_NO': 7295130,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/96/70/99/93/3/393997096_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc720\\uc544\\ub3d9\\uad00 > \\uc720\\uc544\\ub3d9\\uc758\\ub958/\\uc7a1\\ud654 > \\uc5ec\\uc544 \\uc8fc\\ub2c8\\uc5b4\\uc758\\ub958 > \\ubc14\\uc9c0 > \\uba74 > \\uae34\\ubc14\\uc9c0',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=393997096',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be26')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ubc14\\ub78c\\ub9c9\\uc774',\n",
       "  u'CODE3': u'WU0203',\n",
       "  u'GOODS_NAME': u'[\\uc544\\uc774\\ub354]\\uac00\\uaca9\\uc778\\ud558[14SS] PHARAOH (\\ud30c\\ub77c\\uc624) \\ub0a8\\ub140 \\uc790\\ucf13 DMP14107_DWP1410',\n",
       "  u'GOODS_NO': 7295147,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/93/33/96/60/3/360963393_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\ub4f1\\uc0b0/\\uace8\\ud504/\\uc218\\uc601 > \\ub0a8\\uc131\\ub4f1\\uc0b0\\ubcf5 > \\ubc14\\ub78c\\ub9c9\\uc774\\uc7ac\\ud0b7/\\uc810\\ud37c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=360963393',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be27')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uc2e0\\ubc1c>\\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'CODE3': u'EF0502',\n",
       "  u'GOODS_NAME': u'203962 Crocs Torino Lace-up M \\ud06c\\ub85d\\uc2a4 \\ud1a0\\ub9ac\\ub178 \\ub808\\uc774\\uc2a4\\uc5c5 \\ub9e8',\n",
       "  u'GOODS_NO': 4855369,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/24/32/24320428_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc2a4\\ud3ec\\uce20\\uc288\\uc988>\\uce90\\uc8fc\\uc5bc\\ud654/\\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=24320428',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be28')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc6a9\\ud488>\\uc2a4\\ud3ec\\uce20\\uc6a9\\ud488>\\uc2a4\\ud3ec\\uce20\\uc288\\uc988',\n",
       "  u'CODE3': u'UF0308',\n",
       "  u'GOODS_NAME': u'203995 Swiftwater Wave W \\uc2a4\\uc704\\ud504\\ud2b8 \\uc6cc\\ud130 \\uc6e8\\uc774\\ube0c \\uc6b0\\uba3c',\n",
       "  u'GOODS_NO': 4855375,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/24/66/24667583_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc2a4\\ud3ec\\uce20\\uc288\\uc988>\\uae30\\ud0c0\\uc2a4\\ud3ec\\uce20\\ud654',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=24667583',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be29')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc6a9\\ud488>\\uc0dd\\ud65c\\uc6a9\\ud488>\\uae30\\uc800\\uadc0',\n",
       "  u'CODE3': u'UK0107',\n",
       "  u'GOODS_NAME': u'\\u2605GS\\ud2b9\\uac00\\u2605 \\uc720\\ud321 2017\\ub144 \\uc816\\ubcd1\\uc18c\\ub3c5\\uae30',\n",
       "  u'GOODS_NO': 4855331,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/18/54/18541529_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ucd9c\\uc0b0/\\uc720\\uc544\\ub3d9>\\uae30\\uc800\\uadc0/\\ubb3c\\ud2f0\\uc288/\\uc218\\uc720/\\uc774\\uc720>\\uc218\\uc720\\uc6a9\\ud488>\\uc816\\ubcd1\\uc18c\\ub3c5\\uae30/\\uac74\\uc870\\ub300',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=18541529&lseq=403259-1378778&lab=df',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be2a')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc6a9\\ud488>\\uc0dd\\ud65c\\uc6a9\\ud488>\\uae30\\uc800\\uadc0',\n",
       "  u'CODE3': u'UK0107',\n",
       "  u'GOODS_NAME': u'\\u2605GS\\ud2b9\\uac00\\u2605 \\uc720\\ud321 2017\\ub144 \\uc816\\ubcd1\\uc18c\\ub3c5\\uae30',\n",
       "  u'GOODS_NO': 4855331,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/18/54/18541529_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ucd9c\\uc0b0/\\uc720\\uc544\\ub3d9>\\uae30\\uc800\\uadc0/\\ubb3c\\ud2f0\\uc288/\\uc218\\uc720/\\uc774\\uc720>\\uc218\\uc720\\uc6a9\\ud488>\\uc816\\ubcd1/\\uc816\\uaf2d\\uc9c0',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=18541529&lseq=403259-1378778&lab=df',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be2b')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uc548\\uacbd>\\uc120\\uae00\\ub77c\\uc2a4',\n",
       "  u'CODE3': u'EF1001',\n",
       "  u'GOODS_NAME': u'[\\ud3ec\\uc5d0\\ubc8421]\\ubbf8\\ub7ec \\ub77c\\uc6b4\\ub4dc \\uc120\\uae00\\ub77c\\uc2a4 [KB\\uad6d\\ubbfc/\\ub86f\\ub370\\uce74\\ub4dc5%\\ud560\\uc778]',\n",
       "  u'GOODS_NO': 4855217,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/62/02/28/63/3/363280262_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub2f7\\ucef4 > \\uc5ec\\uc131 \\uce90\\uc8fc\\uc5bc/\\uc815\\uc7a5 > \\ucf54\\ub514\\uc544\\uc774\\ud15c > \\uc120\\uae00\\ub77c\\uc2a4/\\uc548\\uacbd',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=363280262',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be2c')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc6a9\\ud488>\\uc0dd\\ud65c\\uc6a9\\ud488>\\uae30\\uc800\\uadc0',\n",
       "  u'CODE3': u'UK0107',\n",
       "  u'GOODS_NAME': u'\\uc5d8\\ube48\\uc988 \\ud074\\ub798\\uc2dd \\uc774\\uc720\\uc2dd \\uc8fd2\\ub2e8\\uacc4(\\ub9cc7\\uac1c\\uc6d4~10\\uac1c\\uc6d4)',\n",
       "  u'GOODS_NO': 4855228,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/21/46/21462268_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ucd9c\\uc0b0/\\uc720\\uc544\\ub3d9>\\uae30\\uc800\\uadc0/\\ubb3c\\ud2f0\\uc288/\\uc218\\uc720/\\uc774\\uc720>\\uc774\\uc720\\uc2dd/\\uc601\\uc720\\uc544\\uac04\\uc2dd>\\uc774\\uc720\\uc2dd',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=21462268',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be2d')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc6a9\\ud488>\\uc2a4\\ud3ec\\uce20\\uc6a9\\ud488>\\uc2a4\\ud3ec\\uce20\\uc288\\uc988',\n",
       "  u'CODE3': u'UF0308',\n",
       "  u'GOODS_NAME': u'203991 Crocs Kelli Sandal W \\ud06c\\ub85d\\uc2a4 \\ucf08\\ub9ac \\uc0cc\\ub4e4 \\uc6b0\\uba3c',\n",
       "  u'GOODS_NO': 4855365,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/24/35/24354907_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc2a4\\ud3ec\\uce20\\uc288\\uc988>\\uae30\\ud0c0\\uc2a4\\ud3ec\\uce20\\ud654',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=24354907',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be2e')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uc2e0\\ubc1c>\\ud50c\\ub7ab',\n",
       "  u'CODE3': u'EF0517',\n",
       "  u'GOODS_NAME': u'203954 Crocs Kelli Flat W \\ucf08\\ub9ac \\ud50c\\ub7ab \\uc6b0\\uba3c',\n",
       "  u'GOODS_NO': 4855366,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/24/69/24696595_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc2a4\\ud3ec\\uce20\\uc288\\uc988>\\ud50c\\ub7ab\\uc288\\uc988',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=24696595',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be2f')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc6a9\\ud488>\\uc0dd\\ud65c\\uc6a9\\ud488>\\uc2a4\\ud0a8\\ucf00\\uc5b4',\n",
       "  u'CODE3': u'UK0101',\n",
       "  u'GOODS_NAME': u'\\uc544\\ube44\\ub178\\ubca0\\uc774\\ube44 \\ub85c\\uc158 354ml\\uff0b\\uc6cc\\uc2dc\\uc564\\uc0f4\\ud478 354ml',\n",
       "  u'GOODS_NO': 4855354,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/14/72/14727263_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ucd9c\\uc0b0/\\uc720\\uc544\\ub3d9>\\uc2a4\\ud0a8\\ucf00\\uc5b4/\\uc6cc\\uc2dc>\\uc720\\uc544 \\ub85c\\uc158/\\ud06c\\ub9bc/\\uc624\\uc77c>\\uc720\\uc544 \\ub85c\\uc158',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=14727263',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be30')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc6a9\\ud488>\\uc0dd\\ud65c\\uc6a9\\ud488>\\uae30\\uc800\\uadc0',\n",
       "  u'CODE3': u'UK0107',\n",
       "  u'GOODS_NAME': u'\\uc544\\ube44\\ub178\\ubca0\\uc774\\ube44 \\ub85c\\uc158 227g\\uff0b\\uc6cc\\uc2dc\\uc564\\uc0f4\\ud478 354ml [\\uc99d\\uc815]',\n",
       "  u'GOODS_NO': 4855355,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/15/52/15520959_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ucd9c\\uc0b0/\\uc720\\uc544\\ub3d9>\\uc2a4\\ud0a8\\ucf00\\uc5b4/\\uc6cc\\uc2dc>\\uc720\\uc544 \\ub85c\\uc158/\\ud06c\\ub9bc/\\uc624\\uc77c>\\uc720\\uc544 \\uae30\\uc800\\uadc0\\ud06c\\ub9bc',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=15520959',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be31')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\uc790\\ucf13>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WM0199',\n",
       "  u'GOODS_NAME': u'[KAPPA] \\uce74\\ud30c \\ub0a8\\uc131 \\ud2b8\\ub808\\uc774\\ub2dd \\uc790\\ucf13 KHFT351MNBLK',\n",
       "  u'GOODS_NO': 9902401,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/3/6/92/59/2059926369_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc2a4\\ud3ec\\uce20\\uc758\\ub958\\u2502\\uc2e0\\ubc1c\\u2502\\uac00\\ubc29>\\uc2a4\\ud3ec\\uce20\\ud328\\uc158 \\ube0c\\ub79c\\ub4dc>\\uce74\\ud30c(Kappa)>\\uc7ac\\ud0b7/\\uc810\\ud37c',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2059926369',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be32')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\uc790\\ucf13>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WM0199',\n",
       "  u'GOODS_NAME': u'[KAPPA] \\uce74\\ud30c \\ub0a8\\uc131 \\ud2b8\\ub808\\uc774\\ub2dd \\uc790\\ucf13 KHFT401MNBLK',\n",
       "  u'GOODS_NO': 9902398,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/4/6/92/59/2059926407_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc2a4\\ud3ec\\uce20\\uc758\\ub958\\u2502\\uc2e0\\ubc1c\\u2502\\uac00\\ubc29>\\uc2a4\\ud3ec\\uce20\\ud328\\uc158 \\ube0c\\ub79c\\ub4dc>\\uce74\\ud30c(Kappa)>\\uc7ac\\ud0b7/\\uc810\\ud37c',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2059926407',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be33')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud32c\\uce20>\\uc9c4',\n",
       "  u'CODE3': u'WF1202',\n",
       "  u'GOODS_NAME': u'[\\ub274\\ubc1c\\ub780\\uc2a4](NBML81A702) \\uc5ec\\uc131 WOMEN \\uc5d0\\uc13c\\uc15c \\uc57d\\uae30\\ubaa8 \\ud2b8\\ub808\\uc774\\ub2dd \\ud32c\\uce20 (SLIM FIT)',\n",
       "  u'GOODS_NO': 11666006,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/9/7/82/63/2063827952_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud604\\ub300\\ubc31\\ud654\\uc810>\\uc2a4\\ud3ec\\uce20\\u3163\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc2a4\\ud3ec\\uce20\\uc758\\ub958>\\uba74/\\uccad\\ubc14\\uc9c0',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2063827952',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be34')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\uc154\\uce20>\\uc2a4\\ud2b8\\ub77c\\uc774\\ud504\\uc154\\uce20',\n",
       "  u'CODE3': u'WM0602',\n",
       "  u'GOODS_NAME': u'[\\uc62c\\uc820] \\uc2a4\\ud2f0\\uce58 \\ud3ec\\uc778\\ud2b8 \\uc778\\ub514\\uace0 \\uc154\\uce20(ZAV3WC1108)',\n",
       "  u'GOODS_NO': 6791339,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/27/08/27084762_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ub0a8\\uc131\\uc758\\ub958>\\uc154\\uce20/\\ub0a8\\ubc29>\\uccb4\\ud06c/\\uc2a4\\ud2b8\\ub77c\\uc774\\ud504\\uc154\\uce20',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=27084762&sectid=1380562&lsectid=1378788&msectid=1378930&ssectid=1380562&lseq=405302',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be35')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\uc790\\ucf13>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WM0199',\n",
       "  u'GOODS_NAME': u'[KAPPA] \\uce74\\ud30c \\ub0a8\\uc131 \\ud2b8\\ub808\\uc774\\ub2dd \\uc790\\ucf13 KHFT481MOCMG',\n",
       "  u'GOODS_NO': 9902407,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/5/6/92/59/2059926569_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc2a4\\ud3ec\\uce20\\uc758\\ub958\\u2502\\uc2e0\\ubc1c\\u2502\\uac00\\ubc29>\\uc2a4\\ud3ec\\uce20\\ud328\\uc158 \\ube0c\\ub79c\\ub4dc>\\uce74\\ud30c(Kappa)>\\uc7ac\\ud0b7/\\uc810\\ud37c',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2059926569',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be36')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc7a1\\ud654>\\ubaa8\\uc790>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EK1399',\n",
       "  u'GOODS_NAME': u'[FILA] \\uc544\\ub3d9 \\ubc29\\uc6b8 \\ub2c8\\ud2b8 \\ubaa8\\uc790 (FILAM_K4KCW755X_NV_)',\n",
       "  u'GOODS_NO': 9902406,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/6/2/01/60/2060012661_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc720\\uc544\\ub3d9 \\uc758\\ub958|\\uc7a1\\ud654>\\ud328\\uc158\\uc544\\uc774\\ud15c\\u3163\\uc7a1\\ud654>\\ubaa8\\uc790',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2060012661&sectId=1176269',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be37')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc7a1\\ud654>\\uc2e0\\ubc1c>\\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'CODE3': u'EU0502',\n",
       "  u'GOODS_NAME': u'\\ub3d4\\ubc14 \\ub9ac\\ubc84\\uc2a4 (DOMBA REBIRTH (GREY)) [M-5015]',\n",
       "  u'GOODS_NO': 5059225,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/24/28/24287203_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uc288\\uc988/\\uc2a4\\ub2c8\\ucee4\\uc988>\\uc2a4\\ub2c8\\ucee4\\uc988/\\uc6b4\\ub3d9\\ud654>\\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=24287203',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be38')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc6a9\\ud488>\\uc2a4\\ud3ec\\uce20\\uc6a9\\ud488>\\uc218\\uc601',\n",
       "  u'CODE3': u'UF0301',\n",
       "  u'GOODS_NAME': u'[\\ubc30\\ub7f4] \\ub9d0\\ub9ac\\ubd80 \\uc6cc\\ud130 \\ub808\\uae45\\uc2a4 \\ube14\\ub799/\\ud654\\uc774\\ud2b8 (BW4MLGB005BWFR)',\n",
       "  u'GOODS_NO': 5059222,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/25/95/25957596_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc2a4\\ud3ec\\uce20/\\ub808\\uc800>\\uc218\\uc601\\xb7\\uad6c\\uae30 \\uc6a9\\ud488>\\uc218\\uc601\\ubcf5>\\uc5ec\\uc131\\ube44\\uce58\\uc6e8\\uc5b4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=25957596',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be39')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc6a9\\ud488>\\uc0dd\\ud65c\\uc6a9\\ud488>\\uae30\\uc800\\uadc0',\n",
       "  u'CODE3': u'UK0107',\n",
       "  u'GOODS_NAME': u'[\\uc5d8\\ub9ac\\ud380\\ud2b8\\uc774\\uc5b4\\uc2a4] \\uc0ac\\uacc4\\uc808 \\ubaa9\\ucfe0\\uc158(\\uc0c9\\uc0c1\\uc120\\ud0dd)\\u2605\\uc720\\ubaa8\\ucc28/\\uce74\\uc2dc\\ud2b8\\ud638\\ud658',\n",
       "  u'GOODS_NO': 5059160,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/15/80/15807942_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ucd9c\\uc0b0/\\uc720\\uc544\\ub3d9>\\uae30\\uc800\\uadc0/\\ubb3c\\ud2f0\\uc288/\\uc218\\uc720/\\uc774\\uc720>\\uc218\\uc720\\uc6a9\\ud488>\\uc218\\uc720\\ucfe0\\uc158/\\uc218\\uc720\\uac00\\ub9ac\\uac1c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=15807942&lseq=361480',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be3a')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc6a9\\ud488>\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'UU9999',\n",
       "  u'GOODS_NAME': u'\\uc2a4\\uce7c\\ub81b\\uc5d0\\ub514\\uc158 4.5L',\n",
       "  u'GOODS_NO': 5059156,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/25/76/25767543_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc0dd\\ud65c/\\uc8fc\\ubc29>\\uc8fc\\ubc29 \\uc6a9\\ud488\\xb7\\uc2dd\\uae30>\\ub0c4\\ube44/\\uc555\\ub825\\uc1a5>\\ud3b8\\uc218\\ub0c4\\ube44',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=25767543',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be3b')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\uae30\\ud0c0 \\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4',\n",
       "  u'CODE3': u'WM1209',\n",
       "  u'GOODS_NAME': u'[\\ub098\\uc774\\ud0a4] \\ub2e4\\uc6b4\\uc26c\\ud504\\ud2b8 7 (GS) 869969_400',\n",
       "  u'GOODS_NO': 5059216,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/24/81/24810087_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc2a4\\ud3ec\\uce20/\\ub808\\uc800>\\uc2a4\\ud3ec\\uce20 \\uc758\\ub958\\xb7\\uc2e0\\ubc1c\\xb7\\uac00\\ubc29>\\ub0a8\\uc131 \\uc2a4\\ud3ec\\uce20\\ud654>\\uc2a4\\ub2c8\\ucee4\\uc988/\\uce94\\ubc84\\uc2a4\\ud654',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=24810087',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be3c')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc6a9\\ud488>\\uc0dd\\ud65c\\uc6a9\\ud488>\\uae30\\uc800\\uadc0',\n",
       "  u'CODE3': u'UK0107',\n",
       "  u'GOODS_NAME': u'[\\uc5d8\\ub9ac\\ud380\\ud2b8\\uc774\\uc5b4\\uc2a4] \\uc0ac\\uacc4\\uc808 \\ubaa9\\ucfe0\\uc158(\\uc0c9\\uc0c1\\uc120\\ud0dd)\\u2605\\uc720\\ubaa8\\ucc28/\\uce74\\uc2dc\\ud2b8\\ud638\\ud658',\n",
       "  u'GOODS_NO': 5059160,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/15/80/15807942_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ucd9c\\uc0b0/\\uc720\\uc544\\ub3d9>\\uc784\\uc2e0\\xb7\\ucd9c\\uc0b0 \\uc6a9\\ud488>\\ucd9c\\uc0b0/\\uc2e0\\uc0dd\\uc544\\uc6a9\\ud488>\\uc9f1\\uad6c\\ubca0\\uac1c/\\uc881\\uc300\\ubca0\\uac8c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=15807942&lseq=361480',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be3d')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uc2e0\\ubc1c>\\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'CODE3': u'EF0502',\n",
       "  u'GOODS_NAME': u'\\ubca0\\uc5b4\\ud30c\\uc6b0(BEARPAW) PEGGY (womens) 3\\uc885 \\ud0dd1',\n",
       "  u'GOODS_NO': 5059137,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/22/07/22074070_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uc288\\uc988/\\uc2a4\\ub2c8\\ucee4\\uc988>\\uc5ec\\uc131\\ud654>\\uc2ac\\ub9bd\\uc628/\\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=22074070',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be3e')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ubc14\\ub78c\\ub9c9\\uc774',\n",
       "  u'CODE3': u'WM0203',\n",
       "  u'GOODS_NAME': u'\\ub77c\\ud478\\ub9c8 \\ub0a8\\uc131 \\ub2e4\\ud06c\\ube14\\ub8e8 \\ud03c\\ud305 \\ucd08\\uacbd\\ub7c9 \\uc810\\ud37c LMJ06D900DL',\n",
       "  u'GOODS_NO': 5059128,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/22/17/22177212_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc2a4\\ud3ec\\uce20/\\ub808\\uc800>\\ub4f1\\uc0b0/\\uc544\\uc6c3\\ub3c4\\uc5b4 \\uc758\\ub958\\xb7\\uc6a9\\ud488>\\ub0a8\\uc131\\ub4f1\\uc0b0\\uc758\\ub958>\\uc790\\ucf13/\\uc810\\ud37c/\\ubc14\\ub78c\\ub9c9\\uc774',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=22177212',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be3f')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uc2dc\\uacc4>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EF0999',\n",
       "  u'GOODS_NAME': u'\\ub85c\\uc988\\ubabd \\uc5ec\\uc131\\uc6a9 \\uac00\\uc8fd\\uc2dc\\uacc4 RS#08-05BR',\n",
       "  u'GOODS_NO': 5059151,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/24/27/24273170_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uc96c\\uc5bc\\ub9ac/\\uc2dc\\uacc4>\\uc2dc\\uacc4>\\ube0c\\ub79c\\ub4dc\\uc2dc\\uacc4',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=24273170',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be40')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uc2dc\\uacc4>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EF0999',\n",
       "  u'GOODS_NAME': u'\\uc5e0\\ud3ec\\ub9ac\\uc624 \\uc544\\ub974\\ub9c8\\ub2c8 \\uc5ec\\uc131\\uc2dc\\uacc4 AR1961 \\ud30c\\uc2ac\\ucf54\\ub9ac\\uc544 \\uc9c1\\uc601',\n",
       "  u'GOODS_NO': 5059148,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/26/04/26046776_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc7a1\\ud654/\\uc288\\uc988/\\ubcf4\\uc11d>\\uc96c\\uc5bc\\ub9ac/\\uc2dc\\uacc4>\\uc2dc\\uacc4>\\ud504\\ub9ac\\ubbf8\\uc5c4\\uc2dc\\uacc4',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=26046776',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be41')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\ucf54\\ud2b8>\\ub871\\ucf54\\ud2b8',\n",
       "  u'CODE3': u'WK0303',\n",
       "  u'GOODS_NAME': u'[\\ub2e5\\uc2a4 \\ud0a4\\uc988]\\ud6fc\\uc774\\ud06c \\uc774\\uc911\\uc5ec\\ubc08 \\ubaa8\\uc9c1\\ucf54\\ud2b8(DNW13CC04M-BK)',\n",
       "  u'GOODS_NO': 11077437,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/48/51/43/59/4/459435148_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc720\\uc544\\ub3d9\\uad00 > \\ub86f\\ub370\\ubc31\\ud654\\uc810 \\uc720\\uc544\\ub3d9/\\uc6a9\\ud488 > \\ub0a8\\uc544 \\uc544\\ub3d9\\uc758\\ub958 > \\ucf54\\ud2b8/\\ud2b8\\ub80c\\uce58\\ucf54\\ud2b8 > \\ub871\\ucf54\\ud2b8',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=459435148',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be42')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WU0299',\n",
       "  u'GOODS_NAME': u'[FOREST CAMP]Real Racoon Down Parka /\\ub9ac\\uc5bc \\ub77c\\ucfe4 \\ub2e4\\uc6b4 \\uc810\\ud37c[FCSW4488-Red]',\n",
       "  u'GOODS_NO': 7619495,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/7/2/70/27/2027702770_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc720\\ub2c8\\uc139\\uc2a4|\\uce90\\uc8fc\\uc5bc>\\uc774\\uc9c0\\uce90\\uc96c\\uc5bc\\ube0c\\ub79c\\ub4dc>\\ud3ec\\ub808\\uc2a4\\ud2b8\\ucea0\\ud504>\\uc810\\ud37c',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2027702770&sectId=1926682',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be43')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc7a1\\ud654>\\uc2e0\\ubc1c>\\ubd80\\uce20',\n",
       "  u'CODE3': u'EK0505',\n",
       "  u'GOODS_NAME': u'[\\ucf00\\uc774\\uc2a4\\uc704\\uc2a4]\\uace0\\uae09\\uc2a4\\ub7ec\\uc6b4 \\ub514\\uc790\\uc778\\uc774 \\ub3cb\\ubcf4\\uc774\\ub294 \\uaca8\\uc6b8 \\uc544\\ub3d9\\ubd80\\uce20 4117KS451',\n",
       "  u'GOODS_NO': 11042159,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/28/02/73/58/4/458730228_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc2a4\\ud3ec\\uce20\\ud328\\uc158/\\uc288\\uc988 > \\uc544\\ub3d9\\uc2a4\\ud3ec\\uce20\\uc288\\uc988 > \\ubc29\\ud55c\\ud654/\\ud328\\ub529\\ubd80\\uce20 > \\ubc29\\ud55c\\ud654/\\ud328\\ub529\\ubd80\\uce20',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=458730228',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be44')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc7a1\\ud654>\\ubaa8\\uc790>\\ud5e4\\uc5b4\\ubc34\\ub4dc',\n",
       "  u'CODE3': u'EK1302',\n",
       "  u'GOODS_NAME': u'[\\ubc0d\\ud06c\\ubba4](DG)\\ub2c8\\ud2b8\\uc655\\uad00\\ud5e4\\uc5b4\\ubc34\\ub4dc(37A11-870-02)',\n",
       "  u'GOODS_NO': 8007918,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/86/27/61/19/4/419612786_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc720\\uc544\\ub3d9\\uad00 > \\ub86f\\ub370\\ubc31\\ud654\\uc810 \\uc720\\uc544\\ub3d9/\\uc6a9\\ud488 > \\uc2e0\\ubc1c/\\uac00\\ubc29/\\uc7a1\\ud654 > \\ud5e4\\uc5b4 \\uc561\\uc138\\uc11c\\ub9ac > \\ud5e4\\uc5b4\\ubc34\\ub4dc',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=419612786',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be45')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WM0802',\n",
       "  u'GOODS_NAME': u'[\\ub2e5\\uc2a4\\uace8\\ud504]\\ub2e5\\uc2a4\\uace8\\ud504 \\ub0a8\\uc131 \\ub808\\ub4dc \\uccb4\\ud06c \\uc6b8\\ud63c\\ubc29 \\uae34\\ud314\\uc154\\uce20 OUTS6DG12RD [17,250\\uc6d0\\ud560\\uc778\\ucfe0\\ud3f0]',\n",
       "  u'GOODS_NO': 8007907,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/41/69/68/16/4/416686941_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub2f7\\ucef4 > \\uace8\\ud504\\uc758\\ub958/\\uc6a9\\ud488 > \\ub0a8\\uc131\\uace8\\ud504\\uc758\\ub958 > \\ud2f0\\uc154\\uce20 > \\uae34\\ud314\\ud2f0\\uc154\\uce20',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=416686941',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be46')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uac00\\ubc29>\\uc204\\ub354/\\ud06c\\ub85c\\uc2a4/\\uba54\\uc2e0\\uc800\\ubc31',\n",
       "  u'CODE3': u'EF0105',\n",
       "  u'GOODS_NAME': u'[\\ub808\\uc2a4\\ud3ec\\uc0c9]\\ub9c8\\uce74\\ub871 \\uc2a4\\ubab0 \\uce90\\ub9ac\\uc62c \\uc204\\ub354\\ubc31 [9811.D564]',\n",
       "  u'GOODS_NO': 11534763,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/74/97/12/69/4/469129774_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\ud328\\uc158\\uc7a1\\ud654 > \\uc5ec\\uc131\\uac00\\ubc29 > \\uc204\\ub354\\ubc31',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=469129774',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be47')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WF0902',\n",
       "  u'GOODS_NAME': u'[\\ub098\\uc778(NAIN)]\\ud50c\\ub7ec\\ud53c \\uc2ac\\ub9bc \\ud2f0(T-3245)',\n",
       "  u'GOODS_NO': 8007899,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/50/20/65/16/4/416652050_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc601\\uce90\\uc8fc\\uc5bc > \\ud2f0\\uc154\\uce20 > \\uc194\\ub9ac\\ub4dc/\\ubb34\\uc9c0\\ud2f0\\uc154\\uce20 > \\ub77c\\uc6b4\\ub4dc/U\\ub125 > \\uae34\\ud314',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=416652050',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be48')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uc591\\ub9d0>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EF0699',\n",
       "  u'GOODS_NAME': u'[\\ub2e5\\uc2a4(\\uc591\\ub9d0)]\\uc591\\ub9d0 \\uc778\\uae30\\uc120\\ubb3c 3\\uc871\\uc138\\ud2b8 \\uade0\\uc77c\\uac00 11\\uc885 \\u4e2d\\ud0dd1 \\u2605\\uc1fc\\ud551\\ubc31+\\uc120\\ubb3c\\ud3ec\\uc7a5\\u2605',\n",
       "  u'GOODS_NO': 8007897,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/37/04/67/16/4/416670437_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc2dc\\uacc4/\\uc8fc\\uc5bc\\ub9ac/\\uc2dc\\uc98cACC > \\uc2a4\\ud0c0\\ud0b9/\\uc591\\ub9d0 > \\uc591\\ub9d0',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=416670437',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be49')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WF0902',\n",
       "  u'GOODS_NAME': u'[\\ud5e4\\uc9c0\\uc2a4\\uace8\\ud504]\\ud5e4\\uc9c0\\uc2a4\\uace8\\ud504 \\uc5ec\\uc131 \\uc624\\ub80c\\uc9c0 \\uc2a4\\ud2b8\\ub77c\\uc774\\ud504 \\uc2a4\\ud2b8\\ub808\\uce58 \\uae34\\ud314\\uce74\\ub77c\\ud2f0\\uc154\\uce20 HWTS7C513O2 [15,420\\uc6d0\\ud560\\uc778\\ucfe0\\ud3f0]',\n",
       "  u'GOODS_NO': 8007906,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/61/63/69/16/4/416696361_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub2f7\\ucef4 > \\uace8\\ud504\\uc758\\ub958/\\uc6a9\\ud488 > \\uc5ec\\uc131\\uace8\\ud504\\uc758\\ub958 > \\ud2f0\\uc154\\uce20 > \\uae34\\ud314\\ud2f0\\uc154\\uce20',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=416696361',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be4a')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WF0902',\n",
       "  u'GOODS_NAME': u'[\\ub098\\uc778(NAIN)]\\ubcf4\\ud2b8\\ub125 \\ub8e8\\uc988 \\ud2f0(T-3238)',\n",
       "  u'GOODS_NO': 8007901,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/24/20/65/16/4/416652024_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc601\\uce90\\uc8fc\\uc5bc > \\ud2f0\\uc154\\uce20 > \\uc194\\ub9ac\\ub4dc/\\ubb34\\uc9c0\\ud2f0\\uc154\\uce20 > \\ub77c\\uc6b4\\ub4dc/U\\ub125 > \\uae34\\ud314',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=416652024',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be4b')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc7a1\\ud654>\\uc2e0\\ubc1c>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EF0599',\n",
       "  u'GOODS_NAME': u'[\\uc2a4\\ud2f0\\uc720]S/S \\ubca0\\uc2a4\\ud2b8 \\ub77c\\uc778 \\ubc18\\uc9dd\\uc774 \\uae00\\ub9ac\\ud130 \\uc18c\\uc7ac \\ud3ec\\uc778\\ud2b8 \\ud328\\uc158 \\uc2ac\\ub9bd\\uc628 71220BK,71221SV',\n",
       "  u'GOODS_NO': 8007809,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/10/18/37/65/3/365371810_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc288\\uc988 > \\uc5ec\\uc131\\ud654',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=365371810',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be4c')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WM0899',\n",
       "  u'GOODS_NAME': u'[\\uc5e0\\ud3f4\\ud584]\\ub0a8\\uc131\\uc6a9 \\uc2f1\\uae00 \\uae30\\ubcf8 \\ud2f0\\uc154\\uce20 EPW5TR1220',\n",
       "  u'GOODS_NO': 8007804,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/96/14/98/18/4/418981496_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\ud2f0\\uc154\\uce20 > \\uc194\\ub9ac\\ub4dc/\\ubb34\\uc9c0\\ud2f0\\uc154\\uce20 > \\ub77c\\uc6b4\\ub4dc/U\\ub125 > \\uae34\\ud314',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=418981496',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be4d')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WF0999',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988]\\uc5ec\\uc131 \\uc544\\uc774\\ubcf4\\ub9ac \\uc2a4\\ud2b8\\ub77c\\uc774\\ud504 \\uc640\\uc774\\ub4dc \\uc2ac\\ub9ac\\ube0c \\ud2f0\\uc154\\uce20 (357641W830)',\n",
       "  u'GOODS_NO': 8007881,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/19/62/99/16/4/416996219_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\ud2f0\\uc154\\uce20 > \\uc2a4\\ud2b8\\ub77c\\uc774\\ud504\\ud2f0\\uc154\\uce20 > \\uae34\\ud314',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=416996219',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be4e')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\ud32c\\uce20>\\uc2a4\\ud0a4\\ub2c8',\n",
       "  u'CODE3': u'WM1003',\n",
       "  u'GOODS_NAME': u'[\\uac8c\\uc2a4(\\uc9c4)]\\ub0a8\\uc131 \\ube14\\ub799\\ube14\\ub799 \\uc2a4\\ud0a4\\ub2c8(MH3D9130)',\n",
       "  u'GOODS_NO': 8007812,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/79/31/42/19/4/419423179_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\ub370\\ub2d8 > \\uc2a4\\ud0a4\\ub2c8\\uc9c4',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=419423179',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be4f')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\uc154\\uce20>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WM0699',\n",
       "  u'GOODS_NAME': u'[\\ub2e5\\uc2a4(\\uc154\\uce20)]17\\ub144 FW \\uae34\\uc18c\\ub9e4 \\uae30\\ubcf8\\ud54f \\uae30\\ubaa8\\ube0c\\ub77c\\uc6b4\\uccb4\\ud06c DKDW1CSL113-W1',\n",
       "  u'GOODS_NO': 11042105,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/54/36/77/58/4/458773654_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub9e8\\uc988 > \\ubc31\\ud654\\uc810 \\ub0a8\\uc131 \\uc815\\uc7a5/\\uc154\\uce20 > \\ub4dc\\ub808\\uc2a4\\uc154\\uce20 > \\uccb4\\ud06c\\uc154\\uce20 > \\uae30\\ubcf8\\ud54f',\n",
       "  u'STATUS': u'progress',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=458773654',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be50')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WK0802',\n",
       "  u'GOODS_NAME': u'[\\uc720\\ub77c\\ube44] \\ubaa8\\ud06c \\ud558\\uc774\\ub125 \\ud2f0\\uc154\\uce20(74TS772)',\n",
       "  u'GOODS_NO': 11042137,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/76/28764225_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ucd9c\\uc0b0/\\uc720\\uc544\\ub3d9>\\uc720\\uc544\\ub3d9\\xb7\\uc8fc\\ub2c8\\uc5b4 \\uc758\\ub958>\\uc544\\ub3d9\\uc758\\ub958>\\ud2f0\\uc154\\uce20/\\ub0a8\\ubc29',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28764225',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be51')},\n",
       " {u'CATE_NAMES': u'\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'999999',\n",
       "  u'GOODS_NAME': u'[\\uace8\\ub4e0\\uad6c\\uc2a4] \\uc288\\ud37c\\uc2a4\\ud0c0 \\ub85c\\uc6b0 \\uc2a4\\ud30c\\ud074 \\uace8\\ub4dc GCOMS590 E37 \\ub0a8\\uc790 \\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'GOODS_NO': 7619298,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/3/9/23/57/2057239376_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uba85\\ud488|\\ud574\\uc678\\uc1fc\\ud551>NEW ARRIVALS>2017 ARRIVALS',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2057239376',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be52')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc6a9\\ud488>\\uc0dd\\ud65c\\uc6a9\\ud488>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'UU0499',\n",
       "  u'GOODS_NAME': u'[\\ud2f0\\ud050\\ube0c]RFID \\ud574\\ud0b9\\ubc29\\uc9c0 \\uc548\\uc804\\ubcf5\\ub300',\n",
       "  u'GOODS_NO': 7976574,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/83/09/26/24/4/424260983_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ub2f7\\ucef4 > \\ud328\\uc158\\uc7a1\\ud654 > \\ud2b8\\ub798\\ube14\\ub9c8\\ucf13 > \\uc5ec\\ud589 \\ud3b8\\uc758\\uc6a9\\ud488 > \\uae30\\ud0c0 \\uc18c\\ud488',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=424260983',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be53')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WF0204',\n",
       "  u'GOODS_NAME': u'[\\ube48\\ud3f4\\uc544\\uc6c3\\ub3c4\\uc5b4]\\ub808\\ub4dc \\uacf5\\uc6a9 \\ub3c4\\ube0c \\ub2e4\\uc6b4',\n",
       "  u'GOODS_NO': 11534765,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/11/04/13/62/4/462130411_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ub86f\\ub370\\ubc31\\ud654\\uc810 > \\ub4f1\\uc0b0/\\uace8\\ud504/\\uc218\\uc601 > \\uc5ec\\uc131\\ub4f1\\uc0b0\\ubcf5 > \\ub2e4\\uc6b4/\\ud328\\ub529\\uc7ac\\ud0b7/\\uc810\\ud37c > \\ub355\\ub2e4\\uc6b4/\\ud328\\ub529',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=462130411',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be54')},\n",
       " {u'CATE_NAMES': u'\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'999999',\n",
       "  u'GOODS_NAME': u'[\\uace8\\ub4e0\\uad6c\\uc2a4] \\uc288\\ud37c\\uc2a4\\ud0c0 \\ub85c\\uc6b0 G31MS590 C71 \\ub0a8\\uc790 \\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'GOODS_NO': 7619299,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/2/9/23/57/2057239230_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uba85\\ud488|\\ud574\\uc678\\uc1fc\\ud551>NEW ARRIVALS>2017 ARRIVALS',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2057239230',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be55')},\n",
       " {u'CATE_NAMES': u'\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'999999',\n",
       "  u'GOODS_NAME': u'[\\uace8\\ub4e0\\uad6c\\uc2a4] \\uc288\\ud37c\\uc2a4\\ud0c0 \\ub85c\\uc6b0 \\uc2a4\\ud30c\\ud074 \\uc2e4\\ubc84 GCOMS590 E36 \\ub0a8\\uc790 \\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'GOODS_NO': 7619291,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/3/9/23/57/2057239340_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uba85\\ud488|\\ud574\\uc678\\uc1fc\\ud551>NEW ARRIVALS>2017 ARRIVALS',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2057239340',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be56')},\n",
       " {u'CATE_NAMES': u'\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'999999',\n",
       "  u'GOODS_NAME': u'[\\uace8\\ub4e0\\uad6c\\uc2a4] \\uc288\\ud37c\\uc2a4\\ud0c0 \\ub85c\\uc6b0 \\uace8\\ub4dc\\ud0ed G31MS590 C73 \\ub0a8\\uc790 \\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'GOODS_NO': 7619292,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/3/9/23/57/2057239335_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uba85\\ud488|\\ud574\\uc678\\uc1fc\\ud551>NEW ARRIVALS>2017 ARRIVALS',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2057239335',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be57')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\uac00\\ub514\\uac74',\n",
       "  u'CODE3': u'WF0801',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\uc2a4\\uce74\\uc774 \\ube14\\ub8e8 \\uace8\\uc9c0 \\ub2c8\\ud2b8 \\ud480\\uc624\\ubc84 (128151BZ9Q)',\n",
       "  u'GOODS_NO': 11531664,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/1/4/38/63/2063384182_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud604\\ub300\\ubc31\\ud654\\uc810>\\uc601\\uce90\\uc8fc\\uc5bc>\\ub2c8\\ud2b8|\\uac00\\ub514\\uac74|\\ubca0\\uc2a4\\ud2b8>\\ub2c8\\ud2b8|\\uc2a4\\uc6e8\\ud130>\\ub77c\\uc6b4\\ub4dc\\ub125\\ub2c8\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2063384182',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be58')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ud328\\ub529',\n",
       "  u'CODE3': u'WF0202',\n",
       "  u'GOODS_NAME': u'\\ub274\\ubc1c\\ub780\\uc2a4 \\uc5ec\\uc131 \\uae30\\ubaa8 \\ub77c\\uae00\\ub780 \\ud6c4\\ub4dc(NBMD347612_ORANGE)_\\uc624\\ub80c\\uc9c0',\n",
       "  u'GOODS_NO': 11531648,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/29/06/29063456_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\uc7ac\\ud0b7/\\uc810\\ud37c>\\ud328\\ub529/\\ub2e4\\uc6b4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=29063456',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be59')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\uac00\\ub514\\uac74',\n",
       "  u'CODE3': u'WF0801',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\ud551\\ud06c \\uccb4\\ud06c \\ube0c\\uc774\\ub125 \\ub2c8\\ud2b8 \\uce74\\ub514\\uac74 (12815AB11X)',\n",
       "  u'GOODS_NO': 11531622,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/1/4/38/63/2063384152_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud604\\ub300\\ubc31\\ud654\\uc810>\\uc601\\uce90\\uc8fc\\uc5bc>\\ub2c8\\ud2b8|\\uac00\\ub514\\uac74|\\ubca0\\uc2a4\\ud2b8>\\uac00\\ub514\\uac74|\\ubca0\\uc2a4\\ud2b8>\\ube0c\\uc774\\ub125\\uac00\\ub514\\uac74',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2063384152',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be5a')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WU0799',\n",
       "  u'GOODS_NAME': u'[FOREST CAMP]Lambswool Sweater/\\uc591\\ub450\\uc870\\uc9c1 \\uc2a4\\uc6e8\\ud130/\\ucf00\\uc774\\ube14/\\uaf48\\ubca0\\uae30/\\ub2c8\\ud2b8\\u223c4XL[FCSW3414-Ivory]best quality ',\n",
       "  u'GOODS_NO': 7619423,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/4/0/43/27/2027430458_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc720\\ub2c8\\uc139\\uc2a4|\\uce90\\uc8fc\\uc5bc>\\uc774\\uc9c0\\uce90\\uc96c\\uc5bc\\ube0c\\ub79c\\ub4dc>\\ud3ec\\ub808\\uc2a4\\ud2b8\\ucea0\\ud504>\\ub2c8\\ud2b8/\\uc2a4\\uc6e8\\ud130',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2027430458',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be5b')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\uac00\\ub514\\uac74',\n",
       "  u'CODE3': u'WF0801',\n",
       "  u'GOODS_NAME': u'[\\ud30c\\ud504\\ub9ac\\uce74] (N74VTH04) \\ud558\\uc774\\ub125 \\ud0c0\\uc784 \\ub2c8\\ud2b8\\ubca0\\uc2a4\\ud2b8',\n",
       "  u'GOODS_NO': 11531577,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/3/8/39/63/2063398309_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud604\\ub300\\ubc31\\ud654\\uc810>\\uc601\\uce90\\uc8fc\\uc5bc>\\ub2c8\\ud2b8|\\uac00\\ub514\\uac74|\\ubca0\\uc2a4\\ud2b8>\\uac00\\ub514\\uac74|\\ubca0\\uc2a4\\ud2b8>\\ub2c8\\ud2b8\\ubca0\\uc2a4\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2063398309',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be5c')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ub871\\ucf54\\ud2b8',\n",
       "  u'CODE3': u'WF0303',\n",
       "  u'GOODS_NAME': u'\\uba38\\uc2a4\\ud2b8\\ube44 \\uc6b8\\ube14\\ub80c\\ub514\\ub4dc \\ucf54\\ud2b8_LMLWCCA501P',\n",
       "  u'GOODS_NO': 11531572,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/29/06/29063659_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ud558\\ud504\\xb7\\ub871 \\ucf54\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=29063659',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be5d')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc154\\uce20>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WU0699',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] [GD \\ucc29\\uc6a9] \\ub124\\uc774\\ube44 \\ud50c\\ub77c\\uc6cc \\ud30c\\uc790\\ub9c8 \\uc154\\uce20 _ G-Dragon GD \\uc9c0\\ub4dc\\ub798\\uace4 \\ucf5c\\ub77c\\ubcf4 (217465W51M)',\n",
       "  u'GOODS_NO': 11531570,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/6/4/25/52/2052254696_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc720\\ub2c8\\uc139\\uc2a4|\\uce90\\uc8fc\\uc5bc>\\uc778\\uae30\\ube0c\\ub79c\\ub4dc \\ub9e4\\uc7a5>\\uc5d0\\uc787\\uc138\\ucee8\\uc988(8seconds)>\\uc154\\uce20/\\ub0a8\\ubc29',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2052254696',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be5e')},\n",
       " {u'CATE_NAMES': u'\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'999999',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988]\\uc5ec\\uc131 \\ub124\\uc774\\ube44 \\uc194\\ub9ac\\ub4dc \\uace8\\uc9c0 \\uc0ad\\uc2a4 (2981KTTY2R)',\n",
       "  u'GOODS_NO': 11531565,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/48/53/77/68/4/468775348_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc601\\ud50c\\ub77c\\uc790 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\ucf54\\ub514\\uc544\\uc774\\ud15c > \\uae30\\ud0c0',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=468775348',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be5f')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ub871\\ucf54\\ud2b8',\n",
       "  u'CODE3': u'WF0303',\n",
       "  u'GOODS_NAME': u'\\uba38\\uc2a4\\ud2b8\\ube44 \\uacbd\\ub7c9 \\uad6c\\uc2a4\\ub2e4\\uc6b4 \\ubca0\\uc2a4\\ud2b8_LWLWCVW503P',\n",
       "  u'GOODS_NO': 11531557,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/29/06/29063662_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ud558\\ud504\\xb7\\ub871 \\ucf54\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=29063662',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be60')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc7a1\\ud654>\\uc2e0\\ubc1c>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EM0599',\n",
       "  u'GOODS_NAME': u'[\\uc54c\\ub809\\uc0b0\\ub354\\ub9e5\\ud038] \\uc624\\ubc84\\uc194 476225 WHQY2 9059 \\ub0a8\\uc790 \\uc2a4\\ub2c8\\ucee4\\uc988',\n",
       "  u'GOODS_NO': 7619433,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/3/1/17/57/2057171370_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc218\\uc785\\uba85\\ud488>\\uc218\\uc785\\uba85\\ud488 \\ube0c\\ub79c\\ub4dc\\uc804\\uccb4\\ubcf4\\uae30>Alexander McQueen>\\uc288\\uc988',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2057171370',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be61')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc7a1\\ud654>\\ubaa8\\uc790>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'EU1399',\n",
       "  u'GOODS_NAME': u'[\\ub274\\uc5d0\\ub77c]\\uacf5\\uc6a9 \\ub274\\uc5d0\\ub77c MLB \\ud37c\\ud3ec\\ub808\\uc774\\ud2f0\\ub4dc \\ub274\\uc695 \\uc591\\ud0a4\\uc2a4 \\ube14\\ub799 \\uba54\\uc2dc \\ubcfc\\ucea1 11452685',\n",
       "  u'GOODS_NO': 7188493,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/15/01/58/73/3/373580115_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc601\\ud50c\\ub77c\\uc790 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\ucf54\\ub514\\uc544\\uc774\\ud15c > \\ubaa8\\uc790 > \\uc57c\\uad6c\\ubaa8\\uc790',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=373580115',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be62')},\n",
       " {u'CATE_NAMES': u'\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'999999',\n",
       "  u'GOODS_NAME': u'\\ub274\\ubc1c\\ub780\\uc2a4\\ud0a4\\uc988 530/574 \\uc678 \\ubca8\\ud06c\\ub85c \\uc544\\ub3d9\\ud654 6\\uc885 \\ud0dd\\uc77c',\n",
       "  u'GOODS_NO': 10935123,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/6/2/68/61/2061682630_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc2a4\\ud3ec\\uce20\\uc758\\ub958\\u2502\\uc2e0\\ubc1c\\u2502\\uac00\\ubc29>\\uc2a4\\ud3ec\\uce20\\ud328\\uc158 \\ube0c\\ub79c\\ub4dc>\\ub274\\ubc1c\\ub780\\uc2a4>\\uce90\\uc96c\\uc5bc/\\uae30\\ud0c0',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2061682630',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be63')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\uc218\\uc601',\n",
       "  u'CODE3': u'WK1203',\n",
       "  u'GOODS_NAME': u'[\\uc544\\ub808\\ub098] \\uc5ec\\uc544\\ub3d9 \\ucea0\\ud551 2PCS \\uc218\\uc601\\ubcf5 (ATSGI63) NVY',\n",
       "  u'GOODS_NO': 10935124,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/71/28715371_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc218\\uc601>\\uc544\\ub3d9\\uc218\\uc601\\ubcf5',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28715371',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be64')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\uc218\\uc601',\n",
       "  u'CODE3': u'WK1203',\n",
       "  u'GOODS_NAME': u'[\\uc544\\ub808\\ub098] \\ub0a8\\uc544\\ub3d9 \\ucea0\\ud551 3PCS \\uc218\\uc601\\ubcf5 AUSBS61BLU',\n",
       "  u'GOODS_NO': 10935108,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/71/28715363_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc218\\uc601>\\uc544\\ub3d9\\uc218\\uc601\\ubcf5',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28715363',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be65')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\uc218\\uc601',\n",
       "  u'CODE3': u'WK1203',\n",
       "  u'GOODS_NAME': u'[\\uc5d8\\ud2b8\\ub798\\ube14]\\uc2a4\\ud50c\\ub798\\uc2dc\\uc5b4\\ubc14\\uc6c3 \\uc6dc\\uc778\\uc6d0 \\ube14\\ub8e8\\ube14\\ub7ec\\uc12cKT',\n",
       "  u'GOODS_NO': 10935115,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/71/28718085_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc218\\uc601>\\uc544\\ub3d9\\uc218\\uc601\\ubcf5',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28718085',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be66')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc6a9\\ud488>\\uc2a4\\ud3ec\\uce20\\uc6a9\\ud488>\\uc218\\uc601',\n",
       "  u'CODE3': u'UU0301',\n",
       "  u'GOODS_NAME': u'[\\uc544\\ub808\\ub098] \\uc2e4\\ub9ac\\ucf58 \\uc218\\ubaa8 \\uc218\\uc601\\uc6a9\\ud488 AQAAC01WHB',\n",
       "  u'GOODS_NO': 10935118,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/71/28714511_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc218\\uc601>\\uc218\\uc601\\uc6a9\\ud488',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28714511&sectid=1406042&lsectid=1403694&msectid=1405678&ssectid=1406042&lseq=405303',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be67')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\uc218\\uc601',\n",
       "  u'CODE3': u'WK1203',\n",
       "  u'GOODS_NAME': u'[\\uc5d8\\ud2b8\\ub798\\ube14]\\uc2a4\\ud50c\\ub798\\uc2dc\\uc5b4\\ubc14\\uc6c3 UV\\ucf64\\ube44 \\ud551\\ud06cKT',\n",
       "  u'GOODS_NO': 10935119,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/71/28718101_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc218\\uc601>\\uc544\\ub3d9\\uc218\\uc601\\ubcf5',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28718101',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be68')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc6a9\\ud488>\\uc2a4\\ud3ec\\uce20\\uc6a9\\ud488>\\uc218\\uc601',\n",
       "  u'CODE3': u'UU0301',\n",
       "  u'GOODS_NAME': u'[\\uc544\\ub808\\ub098] \\uc204\\ub354\\ubc31 \\uc218\\uc601\\uc6a9\\ud488 ATSAB90GRN',\n",
       "  u'GOODS_NO': 10935085,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/71/28714502_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc218\\uc601>\\uc218\\uc601\\uc6a9\\ud488',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28714502',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be69')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\uc218\\uc601',\n",
       "  u'CODE3': u'WK1203',\n",
       "  u'GOODS_NAME': u'[\\uc544\\ub808\\ub098] \\ub0a8\\uc544\\ub3d9 \\ucea0\\ud551 3PCS \\uc218\\uc601\\ubcf5 AUSBS63BLK',\n",
       "  u'GOODS_NO': 10935090,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/71/28715353_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc218\\uc601>\\uc544\\ub3d9\\uc218\\uc601\\ubcf5',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28715353',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be6a')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc6a9\\ud488>\\uc2a4\\ud3ec\\uce20\\uc6a9\\ud488>\\uc218\\uc601',\n",
       "  u'CODE3': u'UU0301',\n",
       "  u'GOODS_NAME': u'[\\uc544\\ub808\\ub098] \\uc218\\uacbd \\ud558\\ub4dc\\ucf00\\uc774\\uc2a4 ARAAJ01YEL',\n",
       "  u'GOODS_NO': 10935099,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/71/28714498_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc218\\uc601>\\uc218\\uc601\\uc6a9\\ud488',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28714498',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be6b')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\uc218\\uc601',\n",
       "  u'CODE3': u'WK1203',\n",
       "  u'GOODS_NAME': u'[\\uc544\\ub808\\ub098] \\ub0a8\\uc544\\ub3d9 \\ucea0\\ud551 3PCS \\uc218\\uc601\\ubcf5 AUSBS63NVY',\n",
       "  u'GOODS_NO': 10935100,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/71/28715357_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ubc31\\ud654\\uc810>\\ubc31\\ud654\\uc810 \\uc2a4\\ud3ec\\uce20/\\uc544\\uc6c3\\ub3c4\\uc5b4>\\uc218\\uc601>\\uc544\\ub3d9\\uc218\\uc601\\ubcf5',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28715357',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be6c')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ube14\\ub77c\\uc6b0\\uc2a4>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WF0699',\n",
       "  u'GOODS_NAME': u'[\\ud558\\ud504\\ud074\\ub7fd/CLOVIS]\\ud074\\ub77c\\ube44\\uc2a4 \\uc6d0\\ud3ec\\ucf13\\ube14\\ub77c\\uc6b0\\uc2a4(CVYW43805M_LB)',\n",
       "  u'GOODS_NO': 9150541,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/26/77/26778495_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\ube14\\ub77c\\uc6b0\\uc2a4/\\uc154\\uce20>\\uae30\\ubcf8/\\uc194\\ub9ac\\ub4dc',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=26778495',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be6d')},\n",
       " {u'CATE_NAMES': u'\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'999999',\n",
       "  u'GOODS_NAME': u'[\\ud50c\\ub77c\\uc2a4\\ud2f1\\uc544\\uc77c\\ub79c\\ub4dc] \\ub808\\uc9c1\\uae30 \\uae30\\ubcf8 \\ud32c\\uce20 PF1WP2...',\n",
       "  u'GOODS_NO': 9150531,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/23/88/23884749_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud328\\uc158\\uc544\\uc6b8\\ub81b>\\ub9c8\\ub9ac\\uc624\\uc544\\uc6b8\\ub81b>\\uc5ec\\uc131 \\uc601\\uce90\\uc8fc\\uc5bc',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=23884749',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be6e')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ub871\\ucf54\\ud2b8',\n",
       "  u'CODE3': u'WF0303',\n",
       "  u'GOODS_NAME': u'[\\uc774\\uc0ac\\ubca0\\uc774] \\ud3ed\\uc2a4 \\ud37c \\ubaa9\\ub3c4\\ub9ac \\ud558\\ud504\\ucf54\\ud2b8 (VPHAY2649)',\n",
       "  u'GOODS_NO': 9150497,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/27/22/27227509_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ud558\\ud504\\xb7\\ub871 \\ucf54\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=27227509',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be6f')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WU0802',\n",
       "  u'GOODS_NAME': u'[\\uc624\\uac00\\uac8c/\\uc544\\uba54\\ub9ac\\uce78 \\uc2a4\\ud1a0\\ub9ac]\\ub0a8\\uc5ec\\uc0ac\\uc774\\uc988/\\ucee4\\ud50c\\uae34\\ud314/\\ucee4\\ud50c\\ud2f0/\\ucee4\\ud50c\\ub8e9..',\n",
       "  u'GOODS_NO': 9150471,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/12/96/12967188_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\ub77c\\uc6b4\\ub4dc\\ub125/\\ube0c\\uc774\\ub125',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=12967188',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be70')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WF0902',\n",
       "  u'GOODS_NAME': u'[\\ub7a9(LAP)] LA \\uae30\\ubaa8 \\ud2f0\\uc154\\uce20 AF4CT980',\n",
       "  u'GOODS_NO': 9150844,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/27/51/27517522_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\ub77c\\uc6b4\\ub4dc\\ub125/\\ube0c\\uc774\\ub125',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=27517522&sectid=1380131&lsectid=1378773&msectid=1379348&ssectid=1380131&lseq=405302',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be71')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\uae30\\ud0c0 \\ud2f0\\uc154\\uce20',\n",
       "  u'CODE3': u'WF0902',\n",
       "  u'GOODS_NAME': u'[\\ubca0\\uc2a4\\ub760\\ubca8\\ub9ac] \\ub808\\uc774\\uc2a4 \\ud328\\uce58 \\ube0c\\ub808\\uc774\\ub4dc \\uc5d0\\uc9c0 \\ud2f0\\uc154\\uce20 (BLIBY2813)',\n",
       "  u'GOODS_NO': 9150778,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/27/15/27155590_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\ud2f0\\uc154\\uce20>\\ub77c\\uc6b4\\ub4dc\\ub125/\\ube0c\\uc774\\ub125',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=27155590',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be72')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc790\\ucf13>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WF0199',\n",
       "  u'GOODS_NAME': u'[\\ube44\\ud0a4] \\ubc30\\uc0c9 \\ud504\\ub9b0\\ud305 \\ud558\\uc774\\ub125 \\ubaa8\\uc9c1 \\ud558\\ud504\\ucf54\\ud2b8 (TPHBY2606)',\n",
       "  u'GOODS_NO': 9150624,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/27/22/27227484_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\uc7ac\\ud0b7/\\uc810\\ud37c>\\ud14c\\uc77c\\ub7ec\\ub4dc/\\uae30\\ubcf8',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=27227484',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be73')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ub871\\ucf54\\ud2b8',\n",
       "  u'CODE3': u'WF0303',\n",
       "  u'GOODS_NAME': u'JNZ combine \\uce90\\uc2dc\\ub77c\\uc774\\ud06c \\uc6b8\\ucf54\\ud2b8 \\ubc84\\uac74\\ub514',\n",
       "  u'GOODS_NO': 9150574,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/27/48/27483475_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ud558\\ud504\\xb7\\ub871 \\ucf54\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=27483475',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be74')},\n",
       " {u'CATE_NAMES': u'\\ubbf8\\ubd84\\ub958>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'999999',\n",
       "  u'GOODS_NAME': u'[\\ud06c\\ub85c\\ucee4\\ub2e4\\uc77c\\ub808\\uc774\\ub514] \\ud328\\ub529 CL6WPD204_MY...',\n",
       "  u'GOODS_NO': 9150884,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/23/78/23787808_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud328\\uc158\\uc544\\uc6b8\\ub81b>\\ub9c8\\ub9ac\\uc624\\uc544\\uc6b8\\ub81b>\\uc5ec\\uc131 \\uc601\\uce90\\uc8fc\\uc5bc',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=23787808',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be75')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ub871\\ucf54\\ud2b8',\n",
       "  u'CODE3': u'WF0303',\n",
       "  u'GOODS_NAME': u'[\\uc774\\uc0ac\\ubca0\\uc774] \\ud1a0\\ub07c \\ud37c \\uc54c\\ud30c\\uce74 \\ud558\\ud504\\ucf54\\ud2b8 (VPHAZ2642)',\n",
       "  u'GOODS_NO': 9150846,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/27/22/27227504_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc5ec\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ud558\\ud504\\xb7\\ub871 \\ucf54\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=27227504',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be76')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ud328\\ub529',\n",
       "  u'CODE3': u'WU0202',\n",
       "  u'GOODS_NAME': u'[\\uc950\\uc54c\\uc5d0\\uc787][\\uc2a4\\ud14c\\ub808\\uc624\\ubc14\\uc774\\ub110\\uc988] \\ub0a8\\uc5ec\\uacf5\\uc6a9 MA-1 \\ud56d\\uacf5\\ud328\\ub529\\uc810\\ud37c / SVJP7D001-BK',\n",
       "  u'GOODS_NO': 8933912,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/91/95/26/34/4/434269591_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc601\\ud50c\\ub77c\\uc790 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\uc810\\ud37c > \\ud328\\ub529/\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=434269591',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be77')}]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(db.products.find().limit(100))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 365,
   "metadata": {},
   "outputs": [],
   "source": [
    "a = tmp.T.to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 442,
   "metadata": {},
   "outputs": [],
   "source": [
    "records = json.loads(data_answer_image_category_org_mlf.T.to_json()).values()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 444,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WF0204',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\ube14\\ub799 \\ud6c4\\ub4dc \\ub2e4\\uc6b4 \\ud328\\ub529 (167838SY15)',\n",
       "  u'GOODS_NO': 10702465,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/39/28392457_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ub514\\uc790\\uc774\\ub108\\uc0f5>\\ub0a8\\uc131 \\uc758\\ub958>\\uc790\\ucf13/\\ucf54\\ud2b8/\\ud328\\ub529',\n",
       "  u'STATUS': u'waiting',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28392457'},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'CODE3': u'WF0804',\n",
       "  u'GOODS_NAME': u'[\\ud074\\ub9ad\\uc564\\ud37c\\ub2c8]\\ucf00\\ub9b0 \\uaf48\\ubc30\\uae30 \\ubc18\\ud3f4\\ub77c\\ub2c8\\ud2b8/\\ud130\\ud2c0\\ub125/\\ub871\\uc2a4\\uc6e8\\ud130/\\uc2dc\\ubcf4\\ub9ac\\uc9dc',\n",
       "  u'GOODS_NO': 10702472,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/54/28549642_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud2b8\\ub80c\\ub4dc\\uc758\\ub958>\\ub2c8\\ud2b8/\\uac00\\ub514\\uac74/\\uc870\\ub07c>\\ud130\\ud2c0\\ub125/\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'STATUS': u'waiting',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28549642'}]"
      ]
     },
     "execution_count": 444,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "records[1:3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 462,
   "metadata": {},
   "outputs": [],
   "source": [
    "products = db.products"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 463,
   "metadata": {},
   "outputs": [],
   "source": [
    "products.drop()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 464,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "u'GOODS_NO_1'"
      ]
     },
     "execution_count": 464,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "products.insert_many(records)\n",
    "products.create_index('GOODS_NO')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 469,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "20"
      ]
     },
     "execution_count": 469,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(list(products.find({'STATUS':'progress'})))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 408,
   "metadata": {},
   "outputs": [],
   "source": [
    "retrived_lst = get_products_lst()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 453,
   "metadata": {},
   "outputs": [],
   "source": [
    "#retrived_lst"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 410,
   "metadata": {},
   "outputs": [],
   "source": [
    "GOODS_NOs = [item['GOODS_NO'] for item in retrived_lst]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 411,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[4856655,\n",
       " 4856677,\n",
       " 4856555,\n",
       " 4856620,\n",
       " 4856465,\n",
       " 4856535,\n",
       " 4856643,\n",
       " 4856653,\n",
       " 4856629,\n",
       " 4856630,\n",
       " 9955515,\n",
       " 9955509,\n",
       " 6849178,\n",
       " 9955525,\n",
       " 9955520,\n",
       " 5076652,\n",
       " 5076585,\n",
       " 5076548,\n",
       " 5076520,\n",
       " 5076582]"
      ]
     },
     "execution_count": 411,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "GOODS_NOs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 416,
   "metadata": {},
   "outputs": [],
   "source": [
    "update_status('done', GOODS_NOs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 407,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_products_lst(n=20):\n",
    "    retrived_lst = list(products.find({'STATUS': 'waiting'}).limit(n))\n",
    "    return retrived_lst\n",
    "def update_status(status, good_nos):\n",
    "    products.update_many({'GOODS_NO': {'$in': good_nos}}, {'$set': {'STATUS': status}})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 452,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 452,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(products.find({'STATUS': '-1\"}))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pymongo import MongoClient"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "client = MongoClient(\"mongodb://mongo-191809ff-1.b3d823aa.cont.dockerapp.io:32770\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[u'admin', u'coinone', u'config', u'epopcon', u'local']"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "client.database_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "db_epopcon = client.epopcon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "lst = list(db_epopcon.products.find().limit(10))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WU0204',\n",
       "  u'GOODS_NAME': u'[\\ud589\\ud150]\\ub0a8\\uc5ec\\uacf5\\uc6a9 \\ubc99\\ucee4 \\ub2e4\\uc6b4\\uc790\\ucf13(10090-213-802-48)',\n",
       "  u'GOODS_NO': 10702464,\n",
       "  u'IMAGE_URL': u'http://image.lotte.com/goods/41/92/60/54/4/454609241_1_500.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\uc601\\ud50c\\ub77c\\uc790 > \\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 > \\uc810\\ud37c > \\ud328\\ub529/\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.lotte.com/goods/viewGoodsDetail.lotte?goods_no=454609241',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be14')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ub2e4\\uc6b4\\uc810\\ud37c',\n",
       "  u'CODE3': u'WF0204',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\ube14\\ub799 \\ud6c4\\ub4dc \\ub2e4\\uc6b4 \\ud328\\ub529 (167838SY15)',\n",
       "  u'GOODS_NO': 10702465,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/39/28392457_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ub514\\uc790\\uc774\\ub108\\uc0f5>\\ub0a8\\uc131 \\uc758\\ub958>\\uc790\\ucf13/\\ucf54\\ud2b8/\\ud328\\ub529',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28392457',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be15')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'CODE3': u'WF0804',\n",
       "  u'GOODS_NAME': u'[\\ud074\\ub9ad\\uc564\\ud37c\\ub2c8]\\ucf00\\ub9b0 \\uaf48\\ubc30\\uae30 \\ubc18\\ud3f4\\ub77c\\ub2c8\\ud2b8/\\ud130\\ud2c0\\ub125/\\ub871\\uc2a4\\uc6e8\\ud130/\\uc2dc\\ubcf4\\ub9ac\\uc9dc',\n",
       "  u'GOODS_NO': 10702472,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/54/28549642_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud2b8\\ub80c\\ub4dc\\uc758\\ub958>\\ub2c8\\ud2b8/\\uac00\\ub514\\uac74/\\uc870\\ub07c>\\ud130\\ud2c0\\ub125/\\ud3f4\\ub77c\\ub2c8\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28549642',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be16')},\n",
       " {u'CATE_NAMES': u'\\uc5ec\\uc131\\uc758\\ub958>\\uc2a4\\uc6e8\\ud130>\\uac00\\ub514\\uac74',\n",
       "  u'CODE3': u'WF0801',\n",
       "  u'GOODS_NAME': u'\\uc81c\\ud504\\ub9b0 \\ud138 \\uc548\\uac10 \\uccb4\\ud06c \\ub204\\ube54 \\uc810\\ud37c',\n",
       "  u'GOODS_NO': 10702477,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/44/28445028_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud2b8\\ub80c\\ub4dc\\uc758\\ub958>\\ub2c8\\ud2b8/\\uac00\\ub514\\uac74/\\uc870\\ub07c>\\uae30\\ubcf8\\uac00\\ub514\\uac74',\n",
       "  u'STATUS': u'-1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28445028&sectid=1382303&lsectid=1378781&msectid=1379357&ssectid=1382303&lseq=405302',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be17')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ud328\\ub529',\n",
       "  u'CODE3': u'WU0202',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\uc560\\uc26c \\ud558\\ud504\\ub125 \\ud328\\ub529 (257838WY13)',\n",
       "  u'GOODS_NO': 10702429,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/32/28328932_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 >\\uc790\\ucf13/\\uc810\\ud37c/\\ucf54\\ud2b8>\\ud328\\ub529/\\ub2e4\\uc6b4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28328932',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be18')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ud328\\ub529',\n",
       "  u'CODE3': u'WU0202',\n",
       "  u'GOODS_NAME': u'[\\uc5d0\\uc787\\uc138\\ucee8\\uc988] \\ube14\\ub799 \\ud558\\ud504\\ub125 \\ud328\\ub529 (257838WY15)',\n",
       "  u'GOODS_NO': 10702451,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/32/28328895_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\uc9c4/\\uc720\\ub2c8\\uc139\\uc2a4 >\\uc790\\ucf13/\\uc810\\ud37c/\\ucf54\\ud2b8>\\ud328\\ub529/\\ub2e4\\uc6b4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28328895',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be19')},\n",
       " {u'CATE_NAMES': u'\\uc720\\ub2c8\\uc139\\uc2a4\\uc758\\ub958>\\uc810\\ud37c/\\uc544\\uc6b0\\ud130>\\ud328\\ub529',\n",
       "  u'CODE3': u'WU0202',\n",
       "  u'GOODS_NAME': u'[\\uc9c0\\uc624\\ub2e4\\ub178] 377924 \\uc5ec \\uc775\\uc2a4\\ud2b8\\ub9bc \\ub2e4\\uc6b4 \\ud30c\\uce74',\n",
       "  u'GOODS_NO': 10702453,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/7/9/37/60/2060379732_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud604\\ub300\\ubc31\\ud654\\uc810>\\uc9c4\\u3163\\uc720\\ub2c8\\uc139\\uc2a4>\\uc790\\ucf13|\\uc810\\ud37c|\\ucf54\\ud2b8>\\uc810\\ud37c>\\ud328\\ub529\\uc810\\ud37c',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2060379732',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be1a')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\ud2b8\\ub808\\uc774\\ub2dd',\n",
       "  u'CODE3': u'WK1205',\n",
       "  u'GOODS_NAME': u'[\\ud589\\ud150\\uc8fc\\ub2c8\\uc5b4](14140-010-871-46)\\uc8fc\\ub2c8\\uc5b4 \\ub0a8\\uc544 \\ucc54\\ud504\\uc2a4\\ud0a4\\uc810\\ud37c',\n",
       "  u'GOODS_NO': 10702459,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/3/4/10/61/2061104399_0_480.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud604\\ub300\\ubc31\\ud654\\uc810>\\uc9c4\\u3163\\uc720\\ub2c8\\uc139\\uc2a4>\\ud328\\uc158\\uc18c\\ud488|\\ud2b8\\ub808\\uc774\\ub2dd\\ubcf5>\\ud0a4\\uc988\\uc6e8\\uc5b4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2061104399',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be1b')},\n",
       " {u'CATE_NAMES': u'\\ud0a4\\uc988\\uc758\\ub958>\\uc2a4\\ud3ec\\uce20\\uc6e8\\uc5b4>\\ud2b8\\ub808\\uc774\\ub2dd',\n",
       "  u'CODE3': u'WK1205',\n",
       "  u'GOODS_NAME': u'[\\ud589\\ud150\\uc8fc\\ub2c8\\uc5b4](14140-110-871-46)\\uc8fc\\ub2c8\\uc5b4 \\uc5ec\\uc544 \\uc2a4\\ud0a4\\uc810\\ud37c',\n",
       "  u'GOODS_NO': 10702480,\n",
       "  u'IMAGE_URL': u'http://image.hyundaihmall.com/static/8/8/11/61/2061118847_0_480.JPG',\n",
       "  u'ORG_CATE_NAME': u'\\ud604\\ub300\\ubc31\\ud654\\uc810>\\uc9c4\\u3163\\uc720\\ub2c8\\uc139\\uc2a4>\\ud328\\uc158\\uc18c\\ud488|\\ud2b8\\ub808\\uc774\\ub2dd\\ubcf5>\\ud0a4\\uc988\\uc6e8\\uc5b4',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.hyundaihmall.com/front/pda/itemPtc.do?slitmCd=2061118847',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be1c')},\n",
       " {u'CATE_NAMES': u'\\ub0a8\\uc131\\uc758\\ub958>\\ucf54\\ud2b8>\\ubbf8\\ubd84\\ub958',\n",
       "  u'CODE3': u'WM0399',\n",
       "  u'GOODS_NAME': u'[\\ud558\\ud504\\ud074\\ub7fd/ZIOZIA] ANDZ \\ubaa8\\uc9c1\\ucf54\\ud2b8 BZV4CG1182GR',\n",
       "  u'GOODS_NO': 10702496,\n",
       "  u'IMAGE_URL': u'http://image.gsshop.com/image/28/01/28013326_L1.jpg',\n",
       "  u'ORG_CATE_NAME': u'\\ud328\\uc158\\uc758\\ub958/\\uc18d\\uc637>\\ud558\\ud504\\ud074\\ub7fd>\\ub0a8\\uc131\\uc815\\uc7a5\\xb7\\uce90\\uc8fc\\uc5bc>\\ucf54\\ud2b8',\n",
       "  u'STATUS': u'1',\n",
       "  u'URL': u'http://www.gsshop.com/prd/prd.gs?prdid=28013326',\n",
       "  u'USERNAME': u'',\n",
       "  u'_id': ObjectId('5a6ac541160cd74183c0be1d')}]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lst"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(lst)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CATE_NAMES</th>\n",
       "      <th>CODE3</th>\n",
       "      <th>GOODS_NAME</th>\n",
       "      <th>GOODS_NO</th>\n",
       "      <th>IMAGE_URL</th>\n",
       "      <th>ORG_CATE_NAME</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>URL</th>\n",
       "      <th>_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>유니섹스의류&gt;점퍼/아우터&gt;다운점퍼</td>\n",
       "      <td>WU0204</td>\n",
       "      <td>[행텐]남여공용 벙커 다운자켓(10090-213-802-48)</td>\n",
       "      <td>10702464</td>\n",
       "      <td>http://image.lotte.com/goods/41/92/60/54/4/454...</td>\n",
       "      <td>영플라자 &gt; 진/유니섹스 &gt; 점퍼 &gt; 패딩/다운점퍼</td>\n",
       "      <td>1</td>\n",
       "      <td>http://www.lotte.com/goods/viewGoodsDetail.lot...</td>\n",
       "      <td>5a6ac541160cd74183c0be14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>여성의류&gt;점퍼/아우터&gt;다운점퍼</td>\n",
       "      <td>WF0204</td>\n",
       "      <td>[에잇세컨즈] 블랙 후드 다운 패딩 (167838SY15)</td>\n",
       "      <td>10702465</td>\n",
       "      <td>http://image.gsshop.com/image/28/39/28392457_L...</td>\n",
       "      <td>패션의류/속옷&gt;디자이너샵&gt;남성 의류&gt;자켓/코트/패딩</td>\n",
       "      <td>1</td>\n",
       "      <td>http://www.gsshop.com/prd/prd.gs?prdid=28392457</td>\n",
       "      <td>5a6ac541160cd74183c0be15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>여성의류&gt;스웨터&gt;폴라니트</td>\n",
       "      <td>WF0804</td>\n",
       "      <td>[클릭앤퍼니]케린 꽈배기 반폴라니트/터틀넥/롱스웨터/시보리짜</td>\n",
       "      <td>10702472</td>\n",
       "      <td>http://image.gsshop.com/image/28/54/28549642_L...</td>\n",
       "      <td>패션의류/속옷&gt;트렌드의류&gt;니트/가디건/조끼&gt;터틀넥/폴라니트</td>\n",
       "      <td>1</td>\n",
       "      <td>http://www.gsshop.com/prd/prd.gs?prdid=28549642</td>\n",
       "      <td>5a6ac541160cd74183c0be16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>여성의류&gt;스웨터&gt;가디건</td>\n",
       "      <td>WF0801</td>\n",
       "      <td>제프린 털 안감 체크 누빔 점퍼</td>\n",
       "      <td>10702477</td>\n",
       "      <td>http://image.gsshop.com/image/28/44/28445028_L...</td>\n",
       "      <td>패션의류/속옷&gt;트렌드의류&gt;니트/가디건/조끼&gt;기본가디건</td>\n",
       "      <td>-1</td>\n",
       "      <td>http://www.gsshop.com/prd/prd.gs?prdid=2844502...</td>\n",
       "      <td>5a6ac541160cd74183c0be17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>유니섹스의류&gt;점퍼/아우터&gt;패딩</td>\n",
       "      <td>WU0202</td>\n",
       "      <td>[에잇세컨즈] 애쉬 하프넥 패딩 (257838WY13)</td>\n",
       "      <td>10702429</td>\n",
       "      <td>http://image.gsshop.com/image/28/32/28328932_L...</td>\n",
       "      <td>패션의류/속옷&gt;진/유니섹스 &gt;자켓/점퍼/코트&gt;패딩/다운</td>\n",
       "      <td>1</td>\n",
       "      <td>http://www.gsshop.com/prd/prd.gs?prdid=28328932</td>\n",
       "      <td>5a6ac541160cd74183c0be18</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           CATE_NAMES   CODE3                          GOODS_NAME  GOODS_NO                                          IMAGE_URL                     ORG_CATE_NAME STATUS                                                URL                       _id\n",
       "0  유니섹스의류>점퍼/아우터>다운점퍼  WU0204  [행텐]남여공용 벙커 다운자켓(10090-213-802-48)  10702464  http://image.lotte.com/goods/41/92/60/54/4/454...      영플라자 > 진/유니섹스 > 점퍼 > 패딩/다운점퍼      1  http://www.lotte.com/goods/viewGoodsDetail.lot...  5a6ac541160cd74183c0be14\n",
       "1    여성의류>점퍼/아우터>다운점퍼  WF0204    [에잇세컨즈] 블랙 후드 다운 패딩 (167838SY15)  10702465  http://image.gsshop.com/image/28/39/28392457_L...      패션의류/속옷>디자이너샵>남성 의류>자켓/코트/패딩      1    http://www.gsshop.com/prd/prd.gs?prdid=28392457  5a6ac541160cd74183c0be15\n",
       "2       여성의류>스웨터>폴라니트  WF0804   [클릭앤퍼니]케린 꽈배기 반폴라니트/터틀넥/롱스웨터/시보리짜  10702472  http://image.gsshop.com/image/28/54/28549642_L...  패션의류/속옷>트렌드의류>니트/가디건/조끼>터틀넥/폴라니트      1    http://www.gsshop.com/prd/prd.gs?prdid=28549642  5a6ac541160cd74183c0be16\n",
       "3        여성의류>스웨터>가디건  WF0801                   제프린 털 안감 체크 누빔 점퍼  10702477  http://image.gsshop.com/image/28/44/28445028_L...     패션의류/속옷>트렌드의류>니트/가디건/조끼>기본가디건     -1  http://www.gsshop.com/prd/prd.gs?prdid=2844502...  5a6ac541160cd74183c0be17\n",
       "4    유니섹스의류>점퍼/아우터>패딩  WU0202      [에잇세컨즈] 애쉬 하프넥 패딩 (257838WY13)  10702429  http://image.gsshop.com/image/28/32/28328932_L...    패션의류/속옷>진/유니섹스 >자켓/점퍼/코트>패딩/다운      1    http://www.gsshop.com/prd/prd.gs?prdid=28328932  5a6ac541160cd74183c0be18"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = create_engine(\"mysql://wspidermr:wspidermr00!q@133.186.134.155:3306/lf-bigdata-real-5\",\n",
    "                           connect_args={'connect_timeout': 10000})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sqlalchemy import MetaData, Table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sqlalchemy.sql import table, column, select, update, insert\n",
    "from sqlalchemy.orm import sessionmaker\n",
    "# define meta information\n",
    "metadata = MetaData(bind=engine)\n",
    "mytable = Table('MLF_CATEGORY_LABELED', metadata, autoload=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "Session = sessionmaker(bind=engine)\n",
    "session = Session()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "u'1'"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "lst[0]['STATUS']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# i = insert(mytable)\n",
    "# i = i.values({'GOODS_NO': lst[1]['GOODS_NO'], 'STATUS': lst[1]['STATUS']})\n",
    "# session.execute(i)ask_price1,ask_price2,ask_qty1,ask_qty2,bid_price1,bid_price2,bid_qty1,bid_qty2,currency,errorCode,first,high,last,low,result,timestamp,volume,yesterday_first,yesterday_high,yesterday_last,yesterday_low,yesterday_volume\n",
    "# 72590,72600,49.1511,175.5696,72400,72360,29.0972,9.3200,qtum,0,72120,77360,72400,70430,success,1514819737,1048538.0962,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72400,72360,29.0972,9.3200,qtum,0,72120,77360,72400,70430,success,1514819738,1048538.0962,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72410,72400,66.7342,29.0972,qtum,0,72120,77360,72400,70430,success,1514819739,1048538.0962,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72410,72400,66.7342,29.0972,qtum,0,72120,77360,72400,70430,success,1514819740,1048538.0962,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72410,72400,66.7342,29.0972,qtum,0,72120,77360,72400,70430,success,1514819741,1048538.0962,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72410,72400,66.7342,29.0972,qtum,0,72120,77360,72400,70430,success,1514819742,1048538.0962,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72410,72400,66.7342,29.0972,qtum,0,72120,77360,72400,70430,success,1514819743,1048538.0962,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72410,72400,66.7342,29.0972,qtum,0,72120,77360,72400,70430,success,1514819744,1048538.0962,72560,77360,73120,70430,1052842.0381\n",
    "# 72500,72590,1.0000,49.1511,72410,72400,66.7342,29.0972,qtum,0,72090,77360,72400,70430,success,1514819745,1048533.8725,72560,77360,73120,70430,1052842.0381\n",
    "# 72500,72590,1.0000,49.1511,72410,72400,66.7342,29.0972,qtum,0,72090,77360,72400,70430,success,1514819746,1048533.8725,72560,77360,73120,70430,1052842.0381\n",
    "# 72500,72590,1.0000,49.1511,72410,72400,66.7342,29.0972,qtum,0,72090,77360,72400,70430,success,1514819747,1048533.8725,72560,77360,73120,70430,1052842.0381\n",
    "# 72500,72590,1.0000,49.1511,72410,72400,66.7342,29.0972,qtum,0,72090,77360,72400,70430,success,1514819748,1048533.8725,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72410,72400,66.7342,29.0972,qtum,0,72090,77360,72500,70430,success,1514819749,1048534.8725,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72300,72280,72.3600,10.2000,qtum,0,72090,77360,72300,70430,success,1514819750,1048716.8977,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72300,72280,68.9600,10.2000,qtum,0,72090,77360,72300,70430,success,1514819751,1048720.2977,72560,77360,73120,70430,1052842.0381\n",
    "# 72590,72600,49.1511,175.5696,72300,72280,68.9600,10.2000,qtum,0,72090,77360,72300,70430,success,1514819752,1048720.2977,72560,77360,73120,70430,1052842.0381\n",
    "# 72580,72590,66.7342,152.6771,72300,72280,68.9600,10.2000,qtum,0,72090,77360,72300,70430,success,1514819753,1048720.2977,72560,77360,73120,70430,1052842.0381\n",
    "# 72400,72580,1.0000,66.7342,72310,72300,14.8000,68.9600,qtum,0,72090,77360,72300,70430,success,1514819754,1048720.2977,72560,77360,73120,70430,1052842.0381\n",
    "# 72400,72580,1.0000,66.7342,72310,72300,14.8000,83.7600,qtum,0,72090,77360,72300,70430,success,1514819755,1048720.2977,72560,77360,73120,70430,1052842.0381\n",
    "# 72400,72580,1.0000,66.7342,72310,72300,14.8000,83.7600,qtum,0,72090,77360,72300,70430,success,1514819756,1048720.2977,72560,77360,73120,70430,1052842.0381\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>GOODS_NO</th>\n",
       "      <th>STATUS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10702464</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10702465</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10702472</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10702477</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10702429</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364128</th>\n",
       "      <td>10047367</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364129</th>\n",
       "      <td>10047370</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364130</th>\n",
       "      <td>10047371</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364131</th>\n",
       "      <td>10047404</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364132</th>\n",
       "      <td>10047409</td>\n",
       "      <td>waiting</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>364133 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        GOODS_NO   STATUS\n",
       "0       10702464        1\n",
       "1       10702465        1\n",
       "2       10702472        1\n",
       "3       10702477       -1\n",
       "4       10702429        1\n",
       "...          ...      ...\n",
       "364128  10047367  waiting\n",
       "364129  10047370  waiting\n",
       "364130  10047371  waiting\n",
       "364131  10047404  waiting\n",
       "364132  10047409  waiting\n",
       "\n",
       "[364133 rows x 2 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[['GOODS_NO', 'STATUS']].to_sql(con=engine, name='MLF_CATEGORY_LABELED', if_exists='replace', flavor='mysql')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df.STATUS != 'waiting', ['GOODS_NO', 'STATUS']].to_sql(con=engine, name='MLF_CATEGORY_LABELED2', if_exists='replace', flavor='mysql')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2762"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "db_epopcon.products.find({'USERNAME': 'Sam'}).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}