Jet.com requires all product listings to be managed outside of Jet, and then uploaded to Jet when any updates are made. This means new products and changes to product records must happen within ShipStation. To add new products or make changes to products in bulk, you can use ShipStation's Product CSV import process.
ShipStation's integration with Jet will then send the product information over to Jet to ensure the information across both platforms is consistent.
Importing Products into ShipStation via CSV
Importing products into ShipStation requires ShipStation's pre-formatted CSV template. Once you've connected a Jet.com store, the pre-formatted CSV contains custom fields specifically for Jet products. Do not edit or remove any of the column headers in the CSV. For fields you do not need, simply leave the cells blank.
To download the product CSV template, go to the Products tab, click Import, then select Download Sample CSV file.
In the downloaded template, enter your product information into the appropriate fields. The Jet specific fields are after the ParentSKU field in the CSV:
Description, JetBrand, JetPrice, JetMultiPackQuantity, JetCategory, and JetInventoryOverride.
These fields correspond to the fields available in the Jet tab of your product details window.
A word about Jet Categories
When bulk importing the Jet Category into ShipStation, you must enter the numerical Node ID that corresponds to the Jet Listing Category into the CSV. Click here to download a complete list (in xlsx format) of available numerical Node Ids and the Jet Listing Category mapping.
You can use either an L0, L1, or L2 node ID in the JetCategory field. See following example using the first line of categories from the downloaded spreadsheet:
- Enter an ID of 1000000 into the JetCategory field. ShipStation will import the product using the Books & Other Media category, which is how Jet will add it to your catalog.
Enter an ID of 1000001 into the JetCategory field. Jet would map the product to their Books & Other Media category, with a sub-category of Books - Arts & Entertainment.
Enter an ID of 1000002 into the JetCategory. Jet would map the product to their Books & Other Media category, with a sub-category of Books - Arts & Entertainment with a specific tertiary category of Architecture.
Jet recommends getting as specific as possible with the category mapping (by using at least an L1 Node ID).
Once your CSV is completely filled in, save it.
Then, go back to the ShipStation import window and click Select File.
Choose your new CSV, select to identify products by SKU and Update product information if the products already exist.
Click Start Import.
The upload may take a few minutes depending on how many products there are. You can close this window and ShipStation will work on this upload in the background.
You’ll see a success message once your product import is finished!
Once your product records are imported into ShipStation, go to Settings > Selling Channel > Store Setup and click Edit next to your Jet store.
Go to the Jet tab and click Trigger Manual Sync. This will ensure your new products and changes have been uploaded to your Jet account.
Finally, be sure to set your products' stock levels. You can do this by individual SKU, or in bulk:
ShipStation automatically updates your product stock levels to Jet once every 12 hours.