Sections:

I. Introduction

II. Instructions

III. FAQ






I. Introduction


If you need to make updates to multiple products at once, you can use the "Import Products" section and upload a CSV to make those updates. 


At present, our "Import Products" section allows you to make make updates 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 (REQUIRED)
  • Product Weight (lbs)
    • CANNOT be updated for products who's weight and dims are locked
  • Length (in.)
    • CANNOT be updated for products who's weight and dims are locked
  • Width (in.)
    • CANNOT be updated for products who's weight and dims are locked
  • Height (in.)
    • CANNOT be updated for products who's weight and dims are locked
  • Blacklisted from orders


*YOU CANNOT MAKE MASS UPDATES TO PRODUCTS THAT ARE INSERTS OR USE CUSTOM PACKAGING. SEE FAQ FOR MORE INFO*






II. Instructions


Step 1. You'll need to download a CSV with the products that you want to make updates to. You can export a product catalog as a CSV straight through ShipMonk's inventory interface. 


To do this, on the header click "Inventory". On the left side of the page you'll see checkboxes next to each product. If you want to make mass updates to ALL of your products, you can click the checkbox on the header which will select all of the products automatically. Otherwise, click a checkbox for each individual product until you've selected each product you're making updates to. Lastly, if you have a very large catalog you can use the search bar on the top right-hand corner to search for individual products (by SKU, product name, etc). 


*IMPORTANT* if you use the search bar to find individual products, please after selecting them, clear the search field and allow all of the products to show up again. If you do not do this, the CSV will not export with all of the other products you selected. It will only export from the search results. Look at the GIF below for reference.





Step 2. 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 3. Open up the CSV file with your products that you downloaded from Step 1. We'll need to do some quick clean up before we proceed to Step 4. Remember when repeating these steps in future CSV files to delete the same content that we'll be deleting in this step.


Delete the following headers and cells (highlighted in yellow in GIF):

  • Inventory on Hand
  • Available Inventory
  • Allocated Inventory
  • Expected Inventory
  • Packaging Type Identifier
  • Created 
  • Modified
  • Stockout days


Once you delete all the unneeded information, we're left with only the information we need.





Step 4. Copy over all the information from your product spreadsheet into the formatted spreadsheet we had you create in Step 2


*NOTE* You MUST include absolutely all available information about the products you're updating in the spreadsheet. If you leave any fields blank, the system will interpret it that you want to delete already existent information about your products.  






*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


Once again It is important that you include a "1" or "0" even for products you don't want to make changes to. A blank response will be interpreted as a "0" by default and unmark any SKUs that were already blacklisted.






Step 5. On the new spreadsheet, make your updates and save your final spreadsheet as a CSV.


For this tutorial example, we'll be making updates to the following:

  • Replacement Value
    • There's a missing replacement value missing for SKU #3
  • Customs Declaration Value
    • Updating this value to $50 (customs declaration value is always the retail value of the product) for each SKU
  • Country of Origin
    • Updating to US for each SKU
  • HS Code
    • Adding HS Codes to each SKU
  • Barcode
    • Adding barcode values to each SKU
  • Type of Packaging 
    • The system interprets packing types as numerical values. We need to update "Poly Mailer" to "1" for each SKU 


*IMPORTANT* Please use the chart below to convert your packaging type into a numeric value (ex. Bubble Mailer you'd type "2" under Type of Packaging for each SKU)

 

Type of Packaging
PolyMailer    
1
Bubble Mailer
2
Box (Corrugated Box)    
3
Fragile *SUBJECT TO ADDITIONAL CHARGES*

4
Slab a Label (the product doesn't need any other packaging to ship)
5



Before




After




Step 6. In your ShipMonk account, hover your cursor over inventory and click "Import Product". Click "Upload CSV" and upload the final CSV file with all of the updates. 





Step 7. In the Data Input box, the first thing you'll need to do is click "First Row is a header". This lets the system know not to consider the header in the final results. Then, there are a series of drop-down menus above each header. Match the drop-down selections to the headers so the system can properly interpret your data. Then click "Next". 


*NOTE* for "Barcode" select "UPC" from the dropdown menu





Step 8. This is the final window where you can review your data. Notice how on the rightmost column under "Status" you could see that the system recognizes your SKUs as existing items. The last thing to do now is click "Import and Update Existing Items". Doing this will process all your updates for each product.





You're Done! Please read the FAQ below for some things to consider.





III. FAQ



1. The packaging types do not include Custom Packaging. Can I make bulk-edit updates to SKUs that use custom packaging?


At present, you CANNOT make updates using this tool for SKUs that use custom packaging. Please know this before attempting to make updates. 



2. Can I make bulk-edit updates to SKUs that are inserts?


At present, you CANNOT make updates using this tool for SKUs that are inserts of any kind. Please know this before attempting to make updates. 



3. There's product information of the options available (SKU, Product name, HS Code, Barcode, etc...) that I don't want to updates, do I still have to include it in my spreadsheet? 


YES!.. You MUST include absolutely all available information about the products you're updates in the spreadsheet. If you leave any fields blank, the system will interpret it that you want to delete already existing information.