How to export data to Taobao Assistant CSV using PHP

This article mainly introduces how to use PHP to export data to Taobao Assistant CSV. It has certain reference value. Now I share it with you. Friends in need can refer to it.

Among them, ECSHOP data transfer When I came to Taobao, the ecshop assistant developed by 51ecshop originally had this function. Later, I planned to implement it directly on the web page myself, so I tested it. It took me a while and I shared it in the hope that it would be helpful to everyone and save time.

First picture


Implementation principle

Read the data first, and write the corresponding rows of the CSV with the corresponding data segments segment, and then save it as CSV. It was tested and passed in the latest version of Taobao Assistant

Implementation code

function totaobao() 
    { 

        //加载所选商品 
        $map['goods_id'] = array('in',$this->returnid()); 
        $result = $this->showgoods($map); 
        //写入CSV并保存数据     
        $header =iconv('UTF-8','GB2312',"宝贝名称,宝贝类目,店铺类目,新旧程度,省,城市,出售方式,宝贝价格,加价幅度,宝贝数量,有效期,运费承担,平邮,EMS,快递,付款方式,支付宝,发票,保修,自动重发,放入仓库,橱窗推荐,开始时间,心情故事,宝贝描述,宝贝图片,宝贝属性,团购价,最小团购件数,邮费模版ID,会员打折,修改时间,上传状态,图片状态,返点比例,新图片,视频,销售属性组合,用户输入ID串,用户输入名-值对,商家编码,销售属性别名,代充类型,宝贝编号");     

        header("Content-type:text/csv"); 
        header("Content-Disposition:attachment;filename=ybkgoods.csv"); 
        header('Cache-Control:must-revalidate,post-check=0,pre-check=0'); 
        header('Expires:0'); 
        header('Pragma:public'); 
        echo "$header\n"; 

        //输出数据体 
        foreach($result as $value) 
        { 
//过滤描述字段 
            $desc = csvdatafilter("www.yibaikuan.com",$value['goods_desc']); 
//截取图片文件名 
            $img = msubstr($value['goods_thumb'],24,25); 
            //转义 

            $body =iconv('UTF-8','GB2312',$value['goods_name'].",,,0,浙江,金华,b,".$value['shop_price'].",0,".$value['goods_number'].",14,1,20,20,10,,,0,0,1,0,1,,,".$desc.",,,,,0,0,,100,,0,".$img.":0:0:|;,,,,,,,0,"); 
            echo "$body\n"; 

        }          
    }

A few points to note
1. Encoding issues
2. HTML code filtering problem in product description
3. Pay attention to the path of the picture
Conclusion:
The principles of csv generated for Taobao, Paipai, and Youah Assistant are almost the same. If you need it, you can go test.

The above is the entire content of this article. I hope it will be helpful to everyone's study. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

PHP implements WeChat public platform enterprise account verification interface

Use PHP to crawl Tmall and Taobao Product data

The above is the detailed content of How to export data to Taobao Assistant CSV using PHP. For more information, please follow other related articles on the PHP Chinese website!