Product / Supplier association

Product / Supplier association

Product / Supplier association

This article explains why it is important to associate your products to one or several suppliers and how to do so. 

1. What is a product/supplier association

Associate a product to a given supplier tells Connect this product can be provided by the supplier. A product can be associated to several suppliers, this mean you can buy the same product from a different supplier.

Associate a product and supplier(s) provide several advantages :
  1. Automatically fill the supplier SKU and buying price when you create a new Purchase Order
  2. Apply filter by supplier in most of the screens
  3. Compare supplier prices from the supply needs screen, to optimize the purchase costs
For each product / supplier association, you can define :
  1. Supplier SKU: this is the SKU of your supplier, it is used in the purchase order PDF sent to your supplier. If this information is filled out you will gain time making your purchase order.
  2. Buying price : this is the buying price using the supplier currency.
  3. Primary : select a supplier as primary (favorite - mainly used for the drop shipping extension)
Once suppliers are created, you can associate them to products.

2. Association grid

Associations between products and suppliers can be set from the Product / Supplier association grid, available from menu


Purchasing >> Product / Supplier Association
 
Here is a view of the Product / Supplier association grid :



In the Product / Supplier association grid, you’ll find 1 row per product per supplier.


That means if you have 10 products created in your system and 6 suppliers created in ERP, that the grid will contains 60 rows (10 products x 6 suppliers = 60 “association rows”).

Let’s take above picture as example. As we can see, 2 suppliers are set in the system : “Supplier A” and “Supplier B”.

  1. If we look at the red framed part, we can see the association row between product “24-MB01” and supplier “Supplier A”. As we can see, the Associated column contains Yes, meaning product “24-MB01” is already associated to “Supplier A”. That’s why we are able to define a Supplier SKU, Buying price or even a MOQ for this association.      
  1. If we look at the green framed part, we can see the association row between product SKU “24-MB01” and supplier “Supplier B”. As we can see, the Associated column contains No, meaning product “24-MB01” is not yet associated to “Supplier B”. That’s why Supplier SKU, Buying price or even MOQ cannot yet be set for this association.

You can so easily filter already made associations filtering the “Associated” column on “Yes”.  This will display all already made product(s) / supplier(s) association(s).

  1. To create a new association between a product and a supplier, apply filter(s) in the grid to find required product / supplier association row(s), then check required row(s) from the first column and select mass action “Associate to supplier”. Then, simply click on the Submit button that just appeared to create association(s).
  1. To remove an existing association, apply filter(s) in the grid to find required product / supplier association row(s), then check required row(s) from the first column and select mass action “Remove”.Then, simply click on the Submit button that just appeared to remove association(s).

An “advanced” association pop-up is available for each product / supplier association, clicking on the pencil icon (available from the “Action” column.  From this pop-up you can define additional  informations for select association, such as Supply delay and Shipping delay values.

You can export grid data using the Export button located at the top-left corner.

3. Import file

This option is available from menu Supplier > Product / supplier association > "import" button in the bottom right corner.

Import file button is used to import product/supplier association information using a csv file. It can be comma separated or semi-colon separated.
Short-codes are listed in the same screen, create a csv file using the short-codes and choose the "Choose File" button and import the product/supplier association data.



FILE HEADER
sku
supplier
sp_sku
sp_price
sp_primary
sp_stock
sp_can_dropship
sp_moq
sp_pack_qty
sp_shipping_delay
sp_supply_delay
FORMAT
TEXT (Product Sku)
TEXT (Supplier code)
TEXT (Supplier Sku)
NUMBER (Wholesale price)
1 : (Primary supplier for this product)
NUMBER (Supplier stock)
1 : (Dropship available for this product)
NUMBER (Minimum order quantity)
NUMBER
NUMBER (DAY)
NUMBER (DAY)
EXAMPLE
Sku1
Supplier1
Reference12
55
1
220
My best supplier
1

5
10



Mandatory

3.1 Import with the wizard

You can find the wizard in the wizard section under the name "Product/Supplier association"
The wizard is a simplified version of the manual import.
You only need to select the .csv file you want to import into MyFulfillment and then map each column with the attribute in Connect.





4. Product / Supplier Association in product view

You can also associate particular product to different suppliers from Products >> click on the required SKU >> choose supplier tab



In this screen, you will be able to choose the supplier from the drop-down and assign supplier sku, buying price and click on save. The product / supplier association data will be shown on the grid.

 



    • Related Articles

    • Supplier offers

      Overview The Supplier offers integration is designed to allow you to import supplier product stock level into a specific warehouse and other information like the buying price, supplier SKU, minimun quantity, and if supplier is the primary supplier. ...

    • Add product to PO

      Add product: You can add products in the PO using the “Add products” tab : check the products you want to add, fill the quantity (or keep empty for 1) and click on the save button. You can add quantity for the selected products that should be added ...

    • What are the ways to associate the supplier in prestashop to MyFullfillment.?

      There are 2 ways to associate the supplier in prestashop to MyFullfillment. By product/supplier association, you can associate the supplier to the products. By creating the PO, with the suppliers and products. This will associate the products to the ...

    • Supplier details

      Supplier details 1. Suppliers management The suppliers grid is available from the grid available in menu : Purchasing >> Suppliers 2.1 Add a new supplier From this grid, you will find a "Add a new supplier" button located at the bottom right corner. ...

    • Data Import and Data Export

      Data import Navigate to Menu Wizard >> Scroll down to Data Import  You will find various import types of import as below: 1) Supplier import 2) Stock and location import 3) Product / supplier association import 4) Purchase order update Supplier ...