Mapping Values Correctly - CSV/Google Drive

This article explains how values are mapped correctly for a proper sync to occur between Jetti and a CSV/Google Drive file.

Last updated March 9th, 2020

VIDEO TUTORIAL: How to share data from a Google Sheet

When importing inventory feeds from a CSV or Google drive, it is important to check that the values are mapped correctly. This way you will avoid any extra work of creating custom mappings, and can easily import inventory feeds to your Jetti account.

Mapping Values Correctly

When uploading inventory feeds via CSV or Google Drive, you need three main headers in the document: Name, qty, and sku.

Important: Write the headers as shown here. For example, qty needs to be written that way, with all letters being lower case. If you write quantity or Qty, it won't work.

Tip: You can use this sample file to model yours after. You can also find the sample under the Inventory Feed settings > Mappings

Custom Mapping

What happens if you or your vendors have written the headers in a different format? In this case you can create a custom mapping under the mappings tab. Just map the header names with the Sku and Inventory quantity.

  1. Enter sku for the header name field in Jetti (or whatever you’ve entered for the column header in your spreadsheet)
  2. Select sku from the dropdown and click Add inventory feed field.

You'll then need to repeat for any other columns. You only need to map the columns for which you want to sync data. There are sometimes additional fields such as separator that appear for the different field types, you can leave this blank.


What happens if my vendor doesn't have a SKU?

In this case, you can use the Ean / barcode or other identified. It should be unique to that variant and not at the product level (e.g. if a prouct has multiple variants).

Last updated March 18th, 2020

Back to Dropship