This article explains how values are mapped correctly for a proper sync to occur between Jetti and a CSV/Google Drive file.
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
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.
- Enter sku for the header name field in Jetti (or whatever you’ve entered for the column header in your spreadsheet)
- 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.