Associate Suppliers with Product SKUs

Available to Existing Inventory Management Subscribers

This feature is only available to existing Inventory Management subscribers. Non-Inventory Management subscribers can learn more about using the ShippingEasy Product Catalog.

We are not currently opening Inventory Management to new users or developing new features or functionality for our Inventory solution. This means that at this time we cannot address the issues you have with the current system.

If you need an inventory solution that lets you add your third-party fulfillment provider to your account, our sister company ShipStation may be a better solution for you.

ShippingEasy's Inventory Management solution makes it easy to generate Purchase Orders when you associate a Supplier with individual SKUs. By mapping your Products to Suppliers, you are able to add more details to Products, including the Supplier SKU and Unit Cost. This data can be populated to Purchase Orders, to streamline restocking.

Products and Suppliers can be paired in a couple of ways - either by adding the Supplier to the Product entry or by adding the Product to the Supplier entry.

Add a Supplier to a Product

  1. Locate the product you wish to associate with one of your Suppliers on the PRODUCTS page. Then click on the blue Product name.

    PROD_product_description.PNG
  2. Toggle to the Suppliers tab on the Product details page.

    PROD_DET_SuppliersTab.png
  3. Use the Supplier search to look up your saved Supplier by name or ID.

    Note

    Only existing Suppliers can be added to Products. Learn how to save a Supplier.

  4. Click the Supplier you wish to add and it will populate the list below.

    PRODET_supplier_name.PNG

    The changes will save automatically.

    Tip

    If you make a mistake, you can remove the Supplier by clicking the "X" button to the right of the Supplier entry.

Add a Product to a Supplier

  1. Locate the Supplier you wish to associate with one or more Products. Then click on the blue Supplier name.

    Box highlights supplier's name in blue under Name column
  2. Scroll down to the "Products" section. Use the Product Search to locate Products by name or SKU.

    PROD_product_section_search.PNG
  3. Click the Products you wish to add and they will populate the list below.

    SUPPLIER_products_auto_populate.png
  4. The changes will save automatically.

    Tip

    If you make a mistake, you can remove the Product by clicking the "X" button to the right of the Product entry.

Add multiple Products to a Supplier via CSV

Uploading a CSV file is a quick way to add multiple products to suppliers in ShippingEasy. If you want to associate suppliers with current products already listed in ShippingEasy, you can export your products list before re-uploading.

Once you have a product list, create a CSV file with at least two columns to add suppliers: SKU and Suppliers.

Follow these steps to associate suppliers in a CSV:

  1. In the SKU column, include all of the product SKUs that you want to assign suppliers to.

    csv_columns_sku.PNG
  2. In the Suppliers column, include each supplier that you would like to add to the product. All suppliers that you will be assigned via the upload must be added to your Suppliers list in your ShippingEasy account before starting the upload. Learn more about adding Suppliers.

    Note

    In the Suppliers column, always list all suppliers that should be assigned to the product as this column is set with each upload.

    suppliers_column_csv.png
  3. The format for the Suppliers column on the CSV file is:

    Supplier Name: Supplier SKU: Unit Cost

    Supplier SKU is the stock keeping unit assigned by your supplier to identify the product(s) when re-ordering.

    Unit Cost is the per-unit cost of a product for a specified supplier.

    1. If there are multiple suppliers assigned to a product, separate them with a vertical bar separator.

      Multiple Suppliers per SKU example:

      Supplier Name: Supplier SKU: Unit Cost | Supplier Name: Supplier SKU: Unit Cost

    2. If you do not have a Supplier SKU or Unit Cost, that segment still needs to be included in the upload.

      No Supplier SKU example:

      Supplier Name:: Unit Cost

      No Unit Cost example:

      Supplier Name: Supplier SKU:

  4. Once the CSV file is ready, you'll save it and upload it via the "Upload Products" action on your PRODUCTS page.

    Attachments

Comments

Add a Comment

Please sign in to leave a comment.

    Tags:
  • #pendo
  • inventory products suppliers
  • answerbot_article_public
  • assign
  • suppliers uploads
  • inventory suppliers
  • inventory suppliers edit
  • inventory suppliers new