Follow

How to: Associate Suppliers with Product SKUs

Created:   |   Updated:

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're 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 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. Navigate to the INVENTORY tab, then select the PRODUCTS page from drop down menu.
    inventory_products_dropdown.png
  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.
  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.

    NOTE: only existing Suppliers can be added to Products. Learn how to save a Supplier.
  6. 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.

How to: Add a Product to a Supplier

  1. Navigate to the INVENTORY tab, then select the SUPPLIERS page from drop down menu.
    inventory_suppliers_dropdown.png
  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.


    NOTE: only existing Products can be added to Suppliers. Learn how to save a Product.
  6. 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.

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'd like to add to the product. All suppliers that you will be assigning via the upload must be added to your Suppliers list in the your ShippingEasy account before starting the upload. Learn more.
    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

    If there are multiple suppliers assigned to a product, separate them with a tube.

    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.

If you have problems that require extra assistance, feel free to reach out to our team.

Anyone can post questions in the comments, to the left, and the ShippingEasy Customer Success team will gladly assist.


ShippingEasy accounts on a paid plan will find additional resources in the upper left corner in app.

1-512 | Email | Chat

Fully registered accounts may email, call, or chat with our team.
Trial accounts may email or call.

Comments

Please sign in to leave a comment.




Community    browse  

COMMUNITY FORUMS
FEATURE REQUESTS

Questions & Answers

Issues & Bugs

Productivity

Partners

Shipping

Inventory

Marketing