Importing products to ShipMonk is fairly straight forward. All you need is a little Excel knowledge and you'll save a bunch of time when it comes to creating products in ShipMonk's inventory system.
At present, our "Import Products" section allows you to import products to the following (required fields will be labeled "REQUIRED" in parenthesis):
- SKU (REQUIRED)
- Product Name (REQUIRED)
- Barcode (REQUIRED)
- Replacement Value (REQUIRED)
- Customs Declaration Value (REQUIRED)
- Country of Origin (REQUIRED)
- Type of Packaging (REQUIRED)
- HS Code
- Product Weight (lbs)
- Length (in.)
- Width (in.)
- Height (in.)
- Blacklisted from orders
Step 1. Hover over "Inventory" and and click "Import Products". You'll see a hyperlink in the description below "Data Input" to view a template. Click that hyperlink which will take you to a Google Sheet page. You'll see an example spreadsheet with the header in yellow and the fields in green. Copy the header and either in a new Google Sheet or on Microsoft Excel, paste the header into a new sheet (as demonstrated by the GIF below). We'll need it in a bit.
Step 2. On the new spreadsheet you created, fill out all the prompts for all the new products you plan on importing. Be sure to include all REQUIRED information (highlighted in yellow). Then, save your spreadsheet as a CSV file.
*OPTIONAL STEP* Blacklisting Multiple SKUs
If you're blacklisting multiple SKUs from orders, add a new field after "Barcode" and name it "Blacklisted from orders".
- Type a "1" in the field for each SKU for you're blacklisting
- Type a "0" in the field for each SKU you're NOT blacklisting
Step 3. Go back to the "Import Products" section and click on "Upload CSV". Find your saved product spreadsheet and upload it.
Step 4. Click on "First row is a header" so the system does not consider the header when extrapolating your data. Then choose the correct header for each column (make sure this is accurate). The system will organize your data into columns, which will then enable you to select the header for each column (SKU, product name, weight, dimensions, customs declaration value, etc). After selecting the correct headers, click "Next".
Step 5. After Step 4 you'll be taken to a window where you can review your data. If you're satisfied and there's no mistakes, click on "Import New Items" which will complete the import.
*NOTE* Be aware of the "Status" column on the far right. Each product in that list is considered a "New item" so the system recognizes that the SKUs in that list aren't in the system. If any of your SKUs were already in the system it would say "Existing item".