Fulfillment CSV Formatting
Format
You CSV file should be formatted with the appropriate headers (see below).
Each line (row) in your file should reference a single SKU for an order. So an order with five different items would be five lines with everything except the product_sku, product_qty, and product_name duplicated.
The following example outlines the minimum required fields for order submissions:
order id, ship_name, ship_address_1, ship_city, ship_state, ship_zipcode, ship_country, product_sku, product_qty, product_name
1111, Jon Hamm, 321 Broadway, New York, NY, 10001, US, bluehat, 1, Fancy Blue Hat
1111, Jon Hamm, 321 Broadway, New York, NY, 10001, US, greenjacketlarge, 2, Shiny Green Jacket (Large)
2222, Miley Cyrus, 321 Main Street, Hollywood, CA, 90068, US, greenjacketsmall 2, Shiny Green Jacket (Small)
2222, Taylor Swift, 454 Music Ave, Nashville, TN, 37212, US, yellowhat, 1, Fancy Yellow Hat
2222, Taylor Swift, 454 Music Ave, Nashville, TN, 37212, US purplesocks, 2, Purple SocksColumns
- The order of your columns (headers) is not important, they can be in any order you’d prefer, as long as required columns are present and have the expected data.
- Feel free to leave out the non-required columns, if they’re not there, we won’t use them.
- You can also add as many extra columns as you’d like, we won’t even bother them if they’re there.
| Column | Required | Description |
|---|---|---|
| order id | yes | Numeric order ID *note the lack of underscore for this specific clumn name |
| ship_name | yes | Shipping label name |
| ship_attn | no | Shipping label attention |
| ship_email | no | Customer email address – NOTE: required if we are sending email tracking notifications |
| ship_phone | no | Customer phone |
| ship_address_1 | yes | Customer street address |
| *ship_address_2 * | no | Apt, Suite, etc. |
| ship_city | yes | Customer city |
| ship_state | yes | USPS format tate/province code |
| ship_zipcode | yes | USPS format zip / postal code |
| ship_country | yes | Two letter USPS format country designation |
| ship_method | no | Shipping method if preselected, see codes below Leave out or leave blank to select cheapest method available |
| product_sku | yes | Unique product SKU, see note below |
| product_qty | yes | number of this item to ship |
| product_name | yes | Human readable name of product |
product_sku
Product SKUs should be unique alphanumerica codes 4-128 characters long. Each product option should be referenced by a different SKU. It doesn’t matter to us how you designate this, it could be all numbers, all letters, or a combination of both – as long as every product variant has a unique code.
It could make visual sense like this:
- albumcd
- albumvinyl
- album8track
Or it could be all numbers:
- 0001
- 0002
- 0003
It cound even be nonsense, like this:
- toastisnicewithbutter
- thisvinylrecordisround
- dlskhgfldgodfgpdkv
Again, we don’t really care what it is as long as they each represent a specific unique product variant in your project.
Example:
You have a thsirt available in both blue and red, and in sizes S,M, and L. You’re SKUs should look something like this:
- shirtbluesmall
- shirtbluemedium
- shirtbluelarge
- shirtblacksmall
- shirtblackmedium
- shirtblacklarge
Shipping Methods
| Shipping Methods | Description |
|---|---|
| USPS | – |
| USPS-PRIORITY | – |
| USPS-INT | – |
| USPS-INT-PRIORI | – |
| UPS-GROUND-RES | – |
| UPS-2DAY-AIR | – |
| UPS-3DAY-AIR | – |
| UPS-STAND | – |
| UPS-WWE | – |
| FEDEX-GRD | – |
| FEDEX-EXS | – |
| FEDEX-HD | – |
| FEDEX-SPP | – |
| USPS | – |