Red color background indicates required fields.
record_type column should be "product" for product data rows.
First row contains product information. Product options data should be inserted in subsequent rows.
To delete existing options, set the value of process_type column to "delete".
To add new product options, leave the id column blank.
Cells beginning with the # character will not affect updates or additions.
When creating categories:
Main category/sub category | Another category tree main category/sub category
If the category name does not exist, it will be created, and the product will be added to 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 |
Red color background indicates required fields.
First Format (Recommended) - upc
column is required, and both product option values and product values will be updated. 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 will be updated (not product options). Feed header: brand,modal,msrp
/ brand,modal,map
/ brand,modal,msrp,map
/ ...
brand | modal | upc | price | map | msrp |
---|---|---|---|---|---|
Horace Small | HS1221 | 15.20 |