# 淘寶導入
淘寶導入
文件路徑:shop/controllers/Seller/Goods/TBImportCtl.php;
###### 導入csv文件
商品分類:
```
<pre class="calibre14">```
<span class="token"><</span>select name<span class="token">=</span><span class="token4">"sgcate_id[]"</span> class<span class="token">=</span><span class="token4">"sgcategory"</span><span class="token">></span>
<span class="token"><</span>option value<span class="token">=</span><span class="token4">"0"</span><span class="token">></span><span class="token"><</span><span class="token">?</span><span class="token">=</span><span class="token3">__</span><span class="token1">(</span><span class="token4">'請選擇'</span><span class="token1">)</span><span class="token">?</span><span class="token">></span><span class="token1">.</span><span class="token1">.</span><span class="token1">.</span><span class="token"><</span><span class="token">/</span>option<span class="token">></span>
<span class="token"><</span><span class="token">?</span>php <span class="token2">if</span> <span class="token1">(</span><span class="token">!</span><span class="token3">empty</span><span class="token1">(</span>$shop_goods_cat_rows<span class="token1">)</span><span class="token1">)</span><span class="token1">{</span> <span class="token">?</span><span class="token">></span>
<span class="token"><</span><span class="token">?</span>php foreach <span class="token1">(</span>$shop_goods_cat_rows as $shop_goods_cat_id <span class="token">=</span><span class="token">></span> $shop_goods_cat_data<span class="token1">)</span> <span class="token1">{</span> <span class="token">?</span><span class="token">></span>
<span class="token"><</span>option data<span class="token">-</span>parent_id<span class="token">=</span><span class="token4">"<?= $shop_goods_cat_data['parent_id'] ?>"</span> value<span class="token">=</span><span class="token4">"<?= $shop_goods_cat_id ?>"</span><span class="token">></span><span class="token"><</span><span class="token">?</span><span class="token">=</span> $shop_goods_cat_data<span class="token1">[</span><span class="token4">'shop_goods_cat_name'</span><span class="token1">]</span> <span class="token">?</span><span class="token">></span><span class="token"><</span><span class="token">/</span>option<span class="token">></span>
<span class="token"><</span><span class="token">?</span>php <span class="token1">}</span> <span class="token">?</span><span class="token">></span>
<span class="token"><</span><span class="token">?</span>php <span class="token1">}</span> <span class="token2">else</span> <span class="token1">{</span> <span class="token">?</span><span class="token">></span>
<span class="token"><</span>option value<span class="token">=</span><span class="token4">"-1"</span><span class="token">></span><span class="token"><</span><span class="token">?</span><span class="token">=</span><span class="token3">__</span><span class="token1">(</span><span class="token4">'暫無分類'</span><span class="token1">)</span><span class="token">?</span><span class="token">></span><span class="token1">.</span><span class="token1">.</span><span class="token1">.</span><span class="token"><</span><span class="token">/</span>option<span class="token">></span>
<span class="token"><</span><span class="token">?</span>php <span class="token1">}</span> <span class="token">?</span><span class="token">></span>
<span class="token"><</span><span class="token">/</span>select<span class="token">></span>
$<span class="token1">.</span><span class="token3">get</span><span class="token1">(</span>SITE_URL <span class="token">+</span> <span class="token4">'?ctl=Seller_Goods_Cat&met=cat&typ=json'</span><span class="token1">,</span> <span class="token1">{</span>cat_id<span class="token1">:</span> cat_id<span class="token1">}</span><span class="token1">,</span> <span class="token2">function</span><span class="token1">(</span>data<span class="token1">)</span><span class="token1">{</span>
<span class="token2">if</span> <span class="token1">(</span>data<span class="token1">.</span>status <span class="token">==</span> <span class="token6">200</span><span class="token1">)</span> <span class="token1">{</span>
<span class="token5">//沒有數據</span>
<span class="token2">if</span><span class="token1">(</span>data<span class="token1">.</span>data<span class="token1">.</span>length <span class="token">===</span> <span class="token6">0</span><span class="token1">)</span><span class="token1">{</span>
<span class="token2">return</span> <span class="token6">false</span><span class="token1">;</span>
<span class="token1">}</span>
var option_rows <span class="token">=</span> <span class="token1">[</span><span class="token1">]</span><span class="token1">,</span> cat_data <span class="token">=</span> data<span class="token1">.</span>data<span class="token1">;</span>
<span class="token2">if</span> <span class="token1">(</span>change<span class="token1">)</span> <span class="token1">{</span>
option_rows<span class="token1">.</span><span class="token3">push</span><span class="token1">(</span><span class="token4">"<option value='0'>請選擇</option>"</span><span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span>
<span class="token2">for</span> <span class="token1">(</span>var i <span class="token">=</span> <span class="token6">0</span><span class="token1">;</span> i <span class="token"><</span> cat_data<span class="token1">.</span>length<span class="token1">;</span> i<span class="token">++</span><span class="token1">)</span> <span class="token1">{</span>
option_rows<span class="token1">.</span><span class="token3">push</span><span class="token1">(</span><span class="token4">"<option value="</span> <span class="token">+</span> cat_data<span class="token1">[</span>i<span class="token1">]</span><span class="token1">.</span>cat_id <span class="token">+</span> <span class="token4">">"</span> <span class="token">+</span> cat_data<span class="token1">[</span>i<span class="token1">]</span><span class="token1">.</span>cat_name <span class="token">+</span> <span class="token4">"</option>"</span><span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span>
<span class="token2">if</span> <span class="token1">(</span>change<span class="token1">)</span><span class="token1">{</span>
<span class="token5">//first create select</span>
<span class="token2">if</span> <span class="token1">(</span>option_rows<span class="token1">.</span>length <span class="token">></span> <span class="token6">0</span><span class="token1">)</span> <span class="token1">{</span>
<span class="token5">//default first goods_cat</span>
$<span class="token1">(</span><span class="token4">"#gc_id"</span><span class="token1">)</span><span class="token1">.</span><span class="token3">val</span><span class="token1">(</span>cat_data<span class="token1">[</span><span class="token6">0</span><span class="token1">]</span><span class="token1">.</span>cat_id<span class="token1">)</span><span class="token1">,</span> $<span class="token1">(</span><span class="token4">"#cat_name"</span><span class="token1">)</span><span class="token1">.</span><span class="token3">val</span><span class="token1">(</span>cat_data<span class="token1">[</span><span class="token6">0</span><span class="token1">]</span><span class="token1">.</span>cat_name<span class="token1">)</span><span class="token1">;</span>
var next_deep <span class="token">=</span> deep <span class="token">+</span> <span class="token6">1</span><span class="token1">;</span>
$<span class="token1">(</span><span class="token4">"span[nctype=gc"</span> <span class="token">+</span> next_deep <span class="token">+</span> <span class="token4">"]"</span><span class="token1">)</span><span class="token1">.</span><span class="token3">append</span><span class="token1">(</span><span class="token4">"<select data-deep="</span> <span class="token">+</span> next_deep <span class="token">+</span> <span class="token4">">"</span> <span class="token">+</span> option_rows<span class="token1">.</span><span class="token3">join</span><span class="token1">(</span><span class="token4">""</span><span class="token1">)</span> <span class="token">+</span> <span class="token4">"</select>"</span><span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span>
<span class="token1">}</span> <span class="token2">else</span> <span class="token1">{</span>
$select<span class="token1">.</span><span class="token3">append</span><span class="token1">(</span>option_rows<span class="token1">.</span><span class="token3">join</span><span class="token1">(</span><span class="token4">""</span><span class="token1">)</span><span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span>
<span class="token1">}</span> <span class="token2">else</span> <span class="token1">{</span>
Public<span class="token1">.</span>tips<span class="token1">.</span><span class="token3">error</span><span class="token1">(</span>data<span class="token1">.</span>msg<span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span>
<span class="token1">}</span><span class="token1">)</span>
```
```
所在地:
```
<pre class="calibre14">```
<span class="token2">function</span> <span class="token3">getDistrictList</span><span class="token1">(</span>province_id<span class="token1">,</span> change<span class="token1">)</span> <span class="token1">{</span>
change <span class="token">&&</span> $<span class="token1">(</span><span class="token4">"#city_id"</span><span class="token1">)</span><span class="token1">.</span><span class="token3">remove</span><span class="token1">(</span><span class="token1">)</span><span class="token1">;</span>
<span class="token2">if</span> <span class="token1">(</span>$<span class="token1">.</span><span class="token3">inArray</span><span class="token1">(</span>province_id<span class="token1">,</span> <span class="token1">[</span><span class="token6">1</span><span class="token1">,</span> <span class="token6">2</span><span class="token1">,</span> <span class="token6">9</span><span class="token1">,</span> <span class="token6">22</span><span class="token1">]</span><span class="token1">)</span> <span class="token">!=</span> <span class="token">-</span><span class="token6">1</span><span class="token1">)</span> <span class="token2">return</span><span class="token1">;</span>
$<span class="token1">.</span><span class="token3">get</span><span class="token1">(</span>SITE_URL <span class="token">+</span> <span class="token4">'?ctl=Base_District&met=district&pid=0&typ=json'</span><span class="token1">,</span> <span class="token1">{</span>pid<span class="token1">:</span> province_id<span class="token1">}</span><span class="token1">,</span> <span class="token2">function</span> <span class="token1">(</span>data<span class="token1">)</span> <span class="token1">{</span>
<span class="token2">if</span> <span class="token1">(</span>data<span class="token1">.</span>status <span class="token">==</span> <span class="token6">200</span><span class="token1">)</span> <span class="token1">{</span>
var district_data <span class="token">=</span> data<span class="token1">.</span>data<span class="token1">.</span>items<span class="token1">,</span> district_row <span class="token">=</span> <span class="token1">[</span><span class="token1">]</span><span class="token1">;</span>
<span class="token2">for</span> <span class="token1">(</span> var i<span class="token">=</span><span class="token6">0</span><span class="token1">;</span> i<span class="token"><</span>district_data<span class="token1">.</span>length<span class="token1">;</span> i<span class="token">++</span> <span class="token1">)</span> <span class="token1">{</span>
district_row<span class="token1">.</span><span class="token3">push</span><span class="token1">(</span><span class="token4">"<option value="</span> <span class="token">+</span> district_data<span class="token1">[</span>i<span class="token1">]</span><span class="token1">.</span>district_id <span class="token">+</span> <span class="token4">">"</span> <span class="token">+</span> district_data<span class="token1">[</span>i<span class="token1">]</span><span class="token1">.</span>district_name <span class="token">+</span> <span class="token4">"</option>"</span><span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span>
district_row <span class="token">=</span> district_row<span class="token1">.</span><span class="token3">join</span><span class="token1">(</span><span class="token4">""</span><span class="token1">)</span><span class="token1">;</span>
<span class="token2">if</span> <span class="token1">(</span>change<span class="token1">)</span> <span class="token1">{</span>
$<span class="token1">(</span><span class="token4">'#province_id'</span><span class="token1">)</span><span class="token1">.</span><span class="token3">after</span><span class="token1">(</span><span class="token4">"<select id='city_id'>"</span> <span class="token">+</span> district_row <span class="token">+</span> <span class="token4">"</select>"</span><span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span> <span class="token2">else</span> <span class="token1">{</span>
$<span class="token1">(</span><span class="token4">'#province_id'</span><span class="token1">)</span><span class="token1">.</span><span class="token3">append</span><span class="token1">(</span>district_row<span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span>
<span class="token1">}</span> <span class="token2">else</span> <span class="token1">{</span>
Public<span class="token1">.</span>tips<span class="token1">.</span><span class="token3">error</span><span class="token1">(</span>data<span class="token1">.</span>msg<span class="token1">)</span>
<span class="token1">}</span>
<span class="token1">}</span><span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span>
```
```
新增分類:
```
<pre class="calibre14">```
$<span class="token1">(</span><span class="token4">'#add_sgcategory'</span><span class="token1">)</span><span class="token1">.</span><span class="token3">on</span><span class="token1">(</span><span class="token4">'click'</span><span class="token1">,</span> <span class="token2">function</span> <span class="token1">(</span><span class="token1">)</span> <span class="token1">{</span>
$<span class="token1">(</span><span class="token4">".sgcategory:last"</span><span class="token1">)</span><span class="token1">.</span><span class="token3">after</span><span class="token1">(</span>$<span class="token1">(</span><span class="token4">".sgcategory:last"</span><span class="token1">)</span><span class="token1">.</span><span class="token3">clone</span><span class="token1">(</span><span class="token6">true</span><span class="token1">)</span><span class="token1">.</span><span class="token3">val</span><span class="token1">(</span><span class="token6">0</span><span class="token1">)</span><span class="token1">)</span><span class="token1">;</span>
<span class="token1">}</span><span class="token1">)</span><span class="token1">;</span>
```
```
文件上傳:
上傳路徑:shop/controllers/UploadCtl.php;
方法名:uploadGoodsExcel();
##### 上傳商品圖片
實例化
```
<pre class="calibre14">```
uploader <span class="token">=</span> WebUploader<span class="token1">.</span><span class="token3">create</span><span class="token1">(</span><span class="token1">{</span>
pick<span class="token1">:</span> <span class="token1">{</span>
id<span class="token1">:</span> <span class="token4">'#filePicker'</span><span class="token1">,</span>
label<span class="token1">:</span> <span class="token4">'點擊選擇圖片'</span>
<span class="token1">}</span><span class="token1">,</span>
formData<span class="token1">:</span> <span class="token1">{</span>
uid<span class="token1">:</span> <span class="token6">123</span>
<span class="token1">}</span><span class="token1">,</span>
dnd<span class="token1">:</span> <span class="token4">'#dndArea'</span><span class="token1">,</span>
paste<span class="token1">:</span> <span class="token4">'#uploader'</span><span class="token1">,</span>
chunked<span class="token1">:</span> <span class="token6">false</span><span class="token1">,</span>
chunkSize<span class="token1">:</span> <span class="token6">512</span> <span class="token">*</span> <span class="token6">1024</span><span class="token1">,</span>
accept<span class="token1">:</span> <span class="token1">{</span>
title<span class="token1">:</span> <span class="token4">'taobaoImage'</span><span class="token1">,</span>
extensions<span class="token1">:</span> <span class="token4">"tbi,jpg"</span>
<span class="token1">}</span><span class="token1">,</span>
swf<span class="token1">:</span> BASE_URL <span class="token">+</span> <span class="token4">'/shop/static/common/js/Uploader.swf'</span><span class="token1">,</span>
server<span class="token1">:</span> SITE_URL <span class="token">+</span> <span class="token4">"?ctl=Upload&action=uploadTaoBaoImage&typ=json"</span><span class="token1">,</span>
fileVal<span class="token1">:</span> <span class="token4">'upfile'</span><span class="token1">,</span>
<span class="token5">// 禁掉全局的拖拽功能。這樣不會出現圖片拖進頁面的時候,把圖片打開。</span>
disableGlobalDnd<span class="token1">:</span> <span class="token6">true</span><span class="token1">,</span>
fileNumLimit<span class="token1">:</span> <span class="token6">300</span><span class="token1">,</span>
fileSizeLimit<span class="token1">:</span> <span class="token6">200</span> <span class="token">*</span> <span class="token6">1024</span> <span class="token">*</span> <span class="token6">1024</span><span class="token1">,</span> <span class="token5">// 200 M</span>
fileSingleSizeLimit<span class="token1">:</span> <span class="token6">50</span> <span class="token">*</span> <span class="token6">1024</span> <span class="token">*</span> <span class="token6">1024</span> <span class="token5">// 50 M</span>
<span class="token1">}</span><span class="token1">)</span><span class="token1">;</span>
```
```
上傳路徑:shop/controllers/UploadCtl.php;
方法名:uploadTaoBaoImage()
```
<pre class="calibre15">```
<span class="token5">// 生成上傳實例對象并完成上傳 </span>
$up <span class="token">=</span> <span class="token2">new</span> <span class="token3">Yf_Uploader</span><span class="token1">(</span>$field_name<span class="token1">,</span> $config<span class="token1">,</span> <span class="token4">"upload"</span><span class="token1">)</span><span class="token1">;</span>
<span class="token5">//修改goods_common表</span>
$goodsCommonModel<span class="token">-</span><span class="token">></span><span class="token3">editCommon</span><span class="token1">(</span>$common_id<span class="token1">,</span> <span class="token3">array</span><span class="token1">(</span><span class="token4">"common_image"</span> <span class="token">=</span><span class="token">></span> $image_url<span class="token1">)</span><span class="token1">)</span><span class="token1">;</span>
<span class="token5">//修改goods_image</span>
$goodsImagesModel<span class="token">-</span><span class="token">></span><span class="token3">editImages</span><span class="token1">(</span> $images_id<span class="token1">,</span> <span class="token3">array</span><span class="token1">(</span><span class="token4">"images_image"</span> <span class="token">=</span><span class="token">></span> $image_url<span class="token1">)</span> <span class="token1">)</span><span class="token1">;</span>
<span class="token5">//修改goods_base</span>
$goodsBaseModel<span class="token">-</span><span class="token">></span><span class="token3">editBase</span><span class="token1">(</span>$goods_id<span class="token1">,</span> $update_goods_data<span class="token1">,</span> <span class="token6">false</span><span class="token1">)</span><span class="token1">;</span>
```
```
- 序言
- 系統要求
- 版本更新日志
- 遠豐商城技術對接說明
- 開發指導
- 框架內容
- 基礎
- 開發規范
- 目錄結構
- 架構
- 架構總覽
- 數據庫
- 數據庫連接
- 基本使用
- 緩存
- 配置
- 路由
- 數據字典
- ucenter
- shop
- paycenter
- ucenter_admin
- shop_admin
- paycenter_admin
- 通訊內容
- 商家中心
- 頂部導航欄
- 店鋪信息欄
- 店鋪及商品提示欄
- 交易提示欄
- 銷售情況統計欄
- 單品銷量排行欄
- 店鋪運營推廣欄
- 平臺聯系方式欄
- 訂單物流
- 商品
- 商品列表
- 商品詳情
- 商品發布與編輯
- 分銷商品
- 關聯版式
- 商品規格
- 圖片空間
- 淘寶導入
- 訂單流程
- 交易訂單
- 訂單退款/退貨
- 促銷
- 團購管理
- 加價購
- 限時折扣
- 滿即送
- 代金券管理
- 分銷
- 店鋪
- 店鋪設置
- 自銷產品供應商
- 實體店鋪
- 品牌申請
- 店鋪信息
- 消費者保障服務
- 門店賬號
- 分銷商--產品供應商
- 分銷明細
- 批發市場
- 售后服務
- 咨詢管理
- 投訴管理
- 退款管理
- 退貨管理
- 云方案架構
- 負載集群
- 云存儲
- 接口
- Api接口說明
- 品牌
- 商品規格
- 商品類型
- 商品分類
- 商品
- 訂單
- 商品/店鋪收藏
- 足跡
- 退款及退貨
- 商家店鋪
- 會員
- 入駐協議
- 訂單接口
- 商品接口
- 訂單物流接口
- 商家中心接口
- 促銷接口
- 快遞鳥物流接口
- 代金券接口
- 首頁版塊
- 團購
- 平臺紅包
- 限時折扣接口
- 拼團接口
- wap首頁模板
- 雜項
- 遠程上傳圖片
- JS
- 銀聯支付
- 多語言
- 商品評分
- 圖片加載
- 買家申請退款退貨
- 商家退款退貨
- 平臺退款退貨
- 添加發票
- 提交訂單
- 確認訂單
- 運費銷售區域
- 獲取會員地址
- 充值
- 導出XLS
- 商城系統集成
- 多語言實現
- 三級分銷推廣鏈接發展推廣員
- app.ini.php
- 去分銷
- 版本更新
- 物流支持
- 運營人員建議
- 業務邏輯
- 統計結算
- 客服消息
- 賬號
- 三級分銷
- IM
- 配置
- 平臺帳號
- 活動數據表說明