Accessories
Bottoms
Headwear
Tops
Outerwear
Footwear
To delete existing options - set the value of "process_type" column to "delete"
To add new product options add the record without value for "id"
When create category
1 - Cells with begining # chatacter will not affect for update or add
2 - Main category/sub category|Another category tree main category/sub category
If category name does not exist it will create the category then add the product into the category product table
id | sku | record_type | product_name | gender | price | map | msrp | discount | modal | description | features | status | brand | spsc_code | unit_of_measure | manufacturer | type | default_image | images | product_id | upc | size1 | size2 | color | quantity | sort_order | process_type | category | sub_category | categories |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
brand_modal | product | P name | Male or Female or Unisex | 18.50 | 69R66 | description | features | 1 or 0 | Flying Cross | 53101600 | EA or PA or ... | Flying Cross | main | FlyingCross/69R66.jpg | FlyingCross/69R66-1.jpg|FlyingCross/69R66-2.jpg | Size or Waist or ... | Width or Inseam or Length or ... | 100 | Outerwear | Jacket | Accessories/Bags|Made in USA/Bags | |||||||||
brand_modal_size1_width... | 18.50 | 1 or 0 | 4534535556 | Small | Regular | Red | 100 | 1 |
First format (Recommond) - upc column is required and product option values and product values update. Feed header (upc,msrp / upc,map/ upc,price/ upc,map,msrp/ upc,price,map,msrp/ ...)
upc | price | map | msrp |
---|---|---|---|
6734585453 | 15.20 |
Second format - Brand and Modal columns are required, only product values update not poduct options. Feed header (brand,modal,msrp /brand,modal,map, brand,modal,msrp,map/ ....
brand | modal | upc | price | map | msrp |
---|---|---|---|---|---|
Horace small | HS1221 | 15.20 |