Aerodrome Documentation

Article content

As I'm sure you've guessed, the bulk product importer allows you to upload a csv full of products to Jet in a single operation.

There are many different columns that can be included (see definitions below), but only a handful are required. The requried columns are as follows:

  • Product Title
  • Multipack Qty
  • A product code. (GTIN, EAN, ISBN, ISBN-13, UPC and/or ASIN)
  • Brand
  • Main Image Url

Note: Inventory and price are not part of the sku upload process.

You can download an example csv here: Example Merchant Sku CSV

Col No Name Value
1 Merchant SKU An identifier from your catalog which represents the product.
2 Title The title of a given merchant sku. Maximum length: 500 characters.
3 Browse node id The unique ID that defines where the product will be found in the Jet.com browse structure. This can be found using the Jet Taxonomy Spreadsheet or by using the Cateogry and Attribute browser in Aerodrome. Currently, it is not possible to assign attribute values with the bulk importer, but will be added in a near future release.
4 Amazon item type keyword ItemType allows customers to find your products as they browse to the most specific item types.
5 Category path The category path for where this product is located in your categorization structure
For example: A laptop bag might belong in Electronics/Computers/Laptops/Accessories/Bags in your product's category
6 GTIN A GTIN product code. At least one product code or ASIN must be supplied with each product.
7 EAN A product code. At least one product code or ASIN must be supplied with each product.
8 ISBN A product code for a book. At least one product code or ASIN must be supplied with each product.
9 ISBN-13 A product code for a book using the EAN format. At least one product code or ASIN must be supplied with each product.
10 UPC A product code. At least one product code or ASIN must be supplied with each product.
11 ASIN An Amazon product code. At least one product code or ASIN must be supplied with each product.
12 Multipack Qty Number of items with the given Standard Product Code that makes up your merchant SKU (product offer).
13 Brand The brand for your merchant SKU. Maximum length: 100 characters.
14 Manufacturer The manufacturer for your merchant SKU. Maximum length: 100 characters.
15 Part Number Part number provided by the original manufacturer of the merchant SKU.
16 Description A long description for your SKU.
17 Bullet 1 A featured description. Maximum length: 50 characters.
18 Bullet 2 A featured description. Maximum length: 50 characters.
19 Bullet 3 A featured description. Maximum length: 50 characters.
20 Bullet 4 A featured description. Maximum length: 50 characters.
21 Bullet 5 A featured description. Maximum length: 50 characters.
22 Price Per Unit For Price Per Unit calculations, the number of units included in the merchant SKU. The unit of measure must be specified in order to indicate what is being measured by the unit-count.
23 Price Per Unit Type This is a label for the value entered into "Price Per Unit" The price per unit can then be constructed by dividing the selling price by the number of units and appending the text "Price Per Unit Type". For example, for a six-pack of soda, "Price Per Unit" would be set to 6, and "Price Per Unit Type" would be set to "can". This would calculate the "price per can" for the customer on Jet.
24 Shipping Weight (pounds) Weight of the merchant SKU when in its shippable configuration.
25 Package Length (inches) Length of the merchant SKU when in its shippable configuration.
26 Package Width (inches) Width of the merchant SKU when in its shippable configuration.
27 Package Height (inches) Height of the merchant SKU when in its shippable configuration.
28 Item Length (inches) Length of the merchant SKU when in its fully assembled/usable condition.
29 Item Width (inches) Width of the merchant SKU when in its fully assembled/usable condition.
30 Item Height (inches) Height of the merchant SKU when in its fully assembled/usable condition.
31 Fulfillment Time (days) The time in days between acknowledging an order and when it ships.
32 Is Prop 65? You must tell Jet if your product is subject to Proposition 65 rules and regulations. Proposition 65 requires merchants to provide California consumers with special warnings for products that contain chemicals known to cause cancer, birth defects, or other reproductive harm, if those products expose consumers to such materials above certain threshold levels. The default value for this is "false," so if you do not populate this column, we will assume your product is not subject to this rule. Please view this website for more information: oehha.gov
33 Legal Disclaimer Any legal language required to be displayed with the product.
34 CPSIA 1 Use this field to indicate if a cautionary statement relating to the choking hazards of children's toys and games applies to your product. These cautionary statements are defined in Section 24 of the Federal Hazardous Substances Act and Section 105 of the Consumer Product Safety Improvement Act of 2008. They must be displayed on the product packaging and in certain online and catalog advertisements. You are responsible for determining if a cautionary statement applies to the product. This can be verified by contacting the product manufacturer or checking the product packaging. Cautionary statements that you select will be displayed on the product detail page. If no cautionary statement applies to the product, select "no warning applicable".
Must be one of the following values:
  • no warning applicable
  • choking hazard small parts
  • choking hazard is a small ball
  • choking hazard is a marble
  • choking hazard contains a small ball
  • choking hazard contains a marble
  • choking hazard balloon

Cannot have 'no warning applicable' and another reason submitted together
35 CPSIA 2 See CPSIA 1
36 CPSIA 3 See CPSIA 1
37 CPSIA 4 See CPSIA 1
38 CPSIA 5 See CPSIA 1
39 CPSIA 6 See CPSIA 1
40 CPSIA 7 See CPSIA 1
41 Country of Origin The country that the item was manufactured in. Maximum length: 50 characters.
42 Safety Warning If applicable, use to supply any associated warnings for your product. Maximum length: 2000 characters
43 MSRP The manufacturer's suggested retail price or list price for the product
44 MAP Price Minimum Advertised Price (MAP) for the product. This price is used as the display or reference price when price policy value 102 is used via the MAP Implementation field. See MAP Implementation for policy values.
45 MAP Implementation Price policy rule that determines allowed item pricing and Jet member savings shown to the consumer. Please note that this field name is misleading as it is used for all price policies and not just a MAP policy. These settings only apply to what the consumer is shown and have no impact on what a retailer is paid for an item.
Must be one of the following values:
  • "101" – No restrictions on displayed product pricing or Jet member savings on the product. This setting is the normal setting used for most products.
  • "102" – Jet member savings for the product are never advertised and are only visible to logged in Jet members after they specifically request to reveal savings. This value can be used when complying with a manufacturer's Minimum Advertised Price (MAP) policy. The API map_price field must also be used when using this setting as it is needed to display a price for advertising and initial presentation to the consumer.
  • "103" – Jet member savings never applied to product and product orders never awarded to retailer if Jet item price is below item price sent by retailer. This value can be used when complying with a manufacturer's Unilateral Minimum Retail Price Policy. This policy setting will restrict the ability to win an order for a product if the retailer item price sent is above Jet's item price shown to the consumer.
46 Tax Code Jet's standard code for the tax properties of a given product.
Must be one of the following values:
  • Toilet Paper
  • Thermometers
  • Sweatbands
  • SPF Suncare Products
  • Sparkling Water
  • Smoking Cessation
  • Shoe Insoles
  • Safety Clothing
  • Pet Foods
  • Paper Products
  • OTC Pet Meds
  • OTC Medication
  • Oral Care Products
  • Non-Motorized Boats
  • Non Taxable Product
  • Mobility Equipment
  • Medicated Personal Care Items
  • Infant Clothing
  • Helmets
  • Handkerchiefs
  • Generic Taxable Product
  • General Grocery Items
  • General Clothing
  • Fluoride Toothpaste
  • Feminine Hygiene Products
  • Durable Medical Equipment
  • Drinks under 50 Percent Juice
  • Disposable Wipes
  • Disposable Infant Diapers
  • Dietary Supplements
  • Diabetic Supplies
  • Costumes
  • Contraceptives
  • Contact Lens Solution
  • Carbonated Soft Drinks
  • Car Seats
  • Candy with Flour
  • Candy
  • Breast Pumps
  • Braces and Supports
  • Bottled Water Plain
  • Beverages with 51 to 99 Percent Juice
  • Bathing Suits
  • Bandages and First Aid Kits
  • Baby Supplies
  • Athletic Clothing
  • Adult Diapers
47 Exclude from Fee Adjustments Set to true to prevent Jet from automatically applying any fee adjustment rules to the product. Please be aware that this may decrease the number of orders that you win for this listing.
48 Main Image URL URL location where Jet.com can access the image. The images should be 40,000 pixels or larger, There is no limit to image size.
  • the only unsupported image file formats are multi-layer png and gif.
  • all images' areas must be at least 40000 pixels (ie 200x200)
  • one side must be at least 200 pixels; the other side must be at least 100 pixels.
49 Swatch Image URL A url for a thumbnail image
50 Alternate Image URL 1 URL location where Jet can access an additional image. See image notes under "Main Image URL"
51 Alternate Image URL 2 URL location where Jet can access an additional image. See image notes under "Main Image URL"
52 Alternate Image URL 3 URL location where Jet can access an additional image. See image notes under "Main Image URL"
53 Alternate Image URL 4 URL location where Jet can access an additional image. See image notes under "Main Image URL"
54 Alternate Image URL 5 URL location where Jet can access an additional image. See image notes under "Main Image URL"
55 Alternate Image URL 6 URL location where Jet can access an additional image. See image notes under "Main Image URL"
56 Alternate Image URL 7 URL location where Jet can access an additional image. See image notes under "Main Image URL"
57 Alternate Image URL 8 URL location where Jet can access an additional image. See image notes under "Main Image URL"