采集数据处理流程
web scraper采集字段定义如下：
web-scraper-order,
web-scraper-start-url,
items,
items-href,
pro_name,
pro_new_price,
pro_old_price,
pro_size,
pro_main-src,
pro_des,
pro_detail_img-src,
pro_class,
pro_class_01,
pro_class_02,
pro_class_03
采集下来的数据
命名成1.csv
输入3.2命令 —- 转成1.xls
打开1.xls，删除第一行；替换第二行的“-” 为“_”
输入3.1命令，合并详细图数据 1.xls 生产 1_new.xls
编辑 1_new.xls的数据
–直接生成zencart 的数据 三份
ZenCart156数据上传数据字段定义如下
"v_products_model",
"v_products_type",
"v_products_image",
"v_products_name_1",
"v_products_description_1",
"v_products_url_1",
"v_specials_price",
"v_specials_date_avail",
"v_specials_expires_date",
"v_products_price",
"v_products_weight",
"v_product_is_call",
"v_products_sort_order",
"v_products_quantity_order_min",
"v_products_quantity_order_units",
"v_products_priced_by_attribute",
"v_product_is_always_free_shipping",
"v_date_avail",
"v_date_added",
"v_products_quantity",
"v_manufacturers_name",
"v_categories_name_1",
"v_tax_class_title",
"v_status",
"v_metatags_products_name_status",
"v_metatags_title_status",
"v_metatags_model_status",
"v_metatags_price_status",
"v_metatags_title_tagline_status",
"v_metatags_title_1",
"v_metatags_keywords_1",
"v_metatags_description_1"
"v_products_model",
"v_folder_name",
"v_mainimg",
"v_detailimg",
"v_videosrc",
"v_ext1",
"v_ext2",
"v_ext3"
"v_products_model",
"v_products_options_type",
"v_products_options_name_1",
"v_products_options_values_name_1"
OT数据格式字段定义如下：
Seo标题
Seo关键字
Seo描述
一级分类
二级分类
三级分类
四级分类
产品ID
产品名字
产品原始价格
产品折扣
产品售价
产品型号
产品Sku
产品自定义属性
产品状态
产品排序
产品描述
图片文件夹
主图
详细图
产品相关ID
合并数据之后1_new.xls数据定义字段如下
web_scraper_order
web_scraper_start_url
items
items_href
pro_name
pro_new_price
pro_old_price
pro_size
pro_main_src
pro_des
pro_detail_img_src
pro_class
pro_class_01
pro_class_02
pro_class_03
pro_merge_images