Product Bulk Upload Automatch Fields
Posted by Steve Naqvi on 19 January 2010 06:05 PM

The bulk uploader will try to automatch the fields in the CSV file with all of the available field options in the bulk loader, if the first line used in the CSV file has any values like the values listed below in it.
When creating automatch CSV files, please use the automatch values for the first line in the CSV file. Any blank or mistyped values will be skiped. You can still manually associate the fields in the CSV file with the corresponding bulk uploader fields though.

Automatch Value => Description
-------------------------------------------
"skip" => Skip
"product_id" => Product ID
"title" => Name
"price" => Price
"category" => Category Keys
"manufacturer" => Manufacturer ID
"meta" => Meta Keywords
"meta_title" => Meta Title
"priority" => Sorting Priority
"call_for_price" => Call For Price
"is_taxable" => Is Taxable
"tax_rate" => Tax Rate
"price2" => Sale Price
"price_level_1" => Price Level 1
"price_level_2" => Price Level 2
"price_level_3" => Price Level 3
"shipping_price_1" => Shipping Price - Product Level
"free_shipping" => Free Shipping
"weight" => Unit Weight
"inter_pack" => Inter Pack
"case_pack" => Case Pack
"min_order" => Min Order
"max_order" => Max Order
"is_visible" => Available
"digital_product" => Is Digital Product
"digital_product_file" => Digital Product File
"inventory_control" => Track Inventory
"stock" => Stock
"stock_warning" => Stock Warning
"inventory_rule" => Inventory Rule
"overview" => Overview
"description" => Description
"is_hotdeal" => Is a Hotdeal
"is_home" => Is on Homepage
"tax_class_id" => Tax Class ID Number
"image_url" => Image URL
"attribute_name_1" => Attribute Name 1
"attribute_caption_1" => Attribute Caption 1
"attribute_options_1" => Attribute Options 1
"attribute_name_2" => Attribute Name 2
"attribute_caption_2" => Attribute Caption 2
"attribute_options_2" => Attribute Options 2
"attribute_name_3" => Attribute Name 3
"attribute_caption_3" => Attribute Caption 3
"attribute_options_3" => Attribute Options 3

From version > 3.9.8.0
"attribute_priority_1" => Attribute Priority 1
"attribute_priority_2" => Attribute Priority 2
"attribute_priority_3" => Attribute Priority 3
"attribute_type_1" => Attribute Type 1
"attribute_type_2" => Attribute Type 2
"attribute_type_3" => Attribute Type 3

From version > 6.14.6.3

"is_condition_new" => Product Condition (1=new 0=used)
"item_condition" => Product Condition Details (ID)
"ptype" => Product Type (ID)

(102 vote(s))
Helpful
Not helpful