ShipWorks allows you to easily import your product catalog. This article will guide you through how to import your product information using the sample file attached to this article.
!! HINT !! - Product details associated to items in the Product Catalog, by default, do not show up on printed Packing Slips or Invoices. However, your ShipWorks invoice or packing slip template can be modified to use the information associated to products stored in the Product Catalog. Please see this article to learn how.
First Things First
Before you begin, please be sure that:
1. You have ShipWorks version 6.0 or later installed. You can check your version of ShipWorks by clicking on the Help tab and then the About ShipWorks button. For assistance with upgrading your version of ShipWorks, please see this article.
2. Your product catalog is in the proper format to be imported into ShipWorks. (Instructions below)
Switching to the Product Catalog
To import products you must first be in the Product Catalog in ShipWorks. Here's how:
1. Click on the Application menu. Then, select Shipping View and select Products.
Downloading the Product Import Sample File
Next, download the sample file. Using the sample file will ensure that your product catalog is in the proper format to be imported into ShipWorks. To download the file:
Note: The same sample file is attached to the bottom of this article.
1. In the Product Catalog, click on the Import button.
2. Click on the sample products file link.
3. Navigate to the location on your computer where you would like to save the file. Then, click the Save button.
The file will be saved to the location you specify as a .CSV (comma delimited file).
Configuring the Sample File
Configure your product file so that it matches the format of the Sample file you downloaded in the previous steps.
It is important that:
- The column headings in the Sample file remain unaltered.
- Begin entering your products into ROW 3 of the ProductImport_Sample.csv file.
- Product information is entered into the appropriate columns and in the correct format using the information below.
- Fields marked with * are required.
If there is a product in your import file with the same SKU as a product already in your ShipWorks database the imported product file will over-write the values for that product in ShipWorks. It is important to note that blank values for a SKU in your import file will update the product in ShipWorks to be blank as well.
|* SKU||Unique identifier for the product, for example: 45-678-9 or 56789|
Used for alias SKU numbers. An alias is an additional SKU assigned to a product. For example, if you have separate SKUs for the same product being sold on multiple stores or if you have unique Amazon or eBay SKUs for the product.
Note: If any of your Alias SKUs contain a pipe character ( | ) it will need to be escaped using a ( \ ). For example, if your SKU is SKU|1 you would it enter into the alias field as SKU\|1. This tells ShipWorks that the | is actually part of the SKU.
|Bundled SKUs||For items containing multiple SKUs that are sold together, enter each SKU and quantity in the following format: SKU : QTY | SKU : QTY.
For example, if the bundle contains one of SKU1, two of SKU2 and three of SKU3 it would be entered as:
SKU1 : 1 | SKU2 : 2 | SKU3 : 3
Bundled SKUs must either already exist in ShipWorks or must be listed separately in the product import file being created.
Note: If any of your Alias SKUs contain a pipe ( | ) or a colon ( : ) it will need to be escaped using a ( \ ). For example, if your SKU is SKU|1 or SKU:1 you would enter into the field as SKU\|1 or SKU\:1 in the Budled SKU field. This tells ShipWorks that the pipe or colon is actually part of the SKU.
|* Name||The name or description of the product. For example: Large Red T-shirt|
|UPC||The Universal Product Code (UPC) of the product.|
|ASIN||The Amazon Standard Identification Number (ASIN) of the product.|
|ISBN||The International Standard Book Number (ISBN) of the product.|
|Weight||The weight of the product entered in fractional pounds. For example: If the product weight is 1 pound and 4 ounces it would be entered as 1.25.
Enter only the numerical value. Do not include the unit of measure such as 'pounds' or 'lbs'.
|Length||The length entered in inches.|
|Width||The width entered in inches.|
|Height||The height entered in inches.|
|Image URL||If your product has an image associated with it, you can enter the path or the URL to the image here. Examples may look like:
For an image located on your PC: C:/Pictures/Image1.jpg
For an image on a network drive: \\NetworkDrive\image.png
For an image located on the internet: https://www.yourwebsite.com/windows-tile-310x150.png
|Warehouse-Bin Location||Your warehouse location for the product.|
|Declared Value||The declared value of the product when shipping internationally. Unit is US Dollar.|
|Country of Origin||The country in which the product was manufactured. Used when shipping internationally. Enter the two character country code .
For example: United States = US, Germany = DE, etc.
|Harmonized Code||Standard WCO tariff code for international shipments.|
|Active||Indicates if the product is Active (available for use by the ShipWorks software) or Inactive (is in the ShipWorks product catalog, but is not used by ShipWorks).
To mark an item as Active, any of the following values can be used: Active, Yes, True, or 1
To mark a product as Inactive, simply leave the field blank or enter Inactive.
Importing the Product File
Now that you have the import file saved with your product information, you can import the file into ShipWorks.
1. Click on the Import button.
2. Click on the Import button located at the bottom of the Import Product screen.
3. Navigate to and select your import file. Then, click the Open button.
The file will be imported and you will be notified of the number of products imported, how many of the products were new, and how many products were already in ShipWorks.
4. Click the Close button. The products will now be displayed in ShipWorks.
Click here for a list of all of the articles related to the Product Catalog.