Associate Suppliers with Product SKUs | How To

This feature is available to existing Inventory Management subscribers. Learn more about using the ShippingEasy Product Catalog.

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.

How to: Add a Supplier to a Product

  1. Go to PRODUCTS then the PRODUCT CATALOG.
  2. On the PRODUCTS page, locate the product you wish to associate with one of your Suppliers. Then click on the blue Product name.

  3. On the Product details page, toggle to the Suppliers tab.
    suppliers_tab.PNG
  4. Use the Supplier search to look up your saved Supplier by name or ID.
  5. Click the Supplier you wish to add and it will populate the list below.
    supplier_name.PNG
    Only existing Suppliers can be added to Products. Learn how to save a Supplier.
  6. The changes will save automatically.
    If you make a mistake, you can remove the Supplier by clicking the "X" button to the right of the Supplier entry.

How to: Add a Product to a Supplier

  1. Go to the PRODUCTS then the SUPPLIERS page from the drop-down menu.
  2. On the SUPPLIERS page, locate the Supplier you wish to associate with one or more Products. Then click on the blue Supplier name.

  3. On the Supplier details page, scroll down to the "Products" section.
  4. Use the Product Search to locate Products by name or SKU.
  5. Click the Products you wish to add and they will populate the list below.


    Only existing Products can be added to Suppliers. Learn how to save a Product.
  6. The changes will save automatically.
    If you make a mistake, you can remove the Product by clicking the "X" button to the right of the Product entry.

How to: 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. Learn more.

Once you have a product list, create a CSV file with at least the 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.
    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.


    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

    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. Learn more.

Comments

0

Can I do this with the csv upload of product details?

Comment actions Permalink
0

Hello Arnold - Presently, it's not possible to map Suppliers with Product SKUs via a CSV file. You can find a complete list of fields supported for Product uploads in this guide:

If this option would make a significant impact on your workflow, may I suggest that you post in our Feature Request forums? Our Product Team monitors these daily in order to prioritize future development.

Comment actions Permalink

Add a Comment

Please sign in to leave a comment.

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