Overview

Vendor SKU Catalog is a comprehensive list of SKUs supplied by a vendor. It includes detailed information about each product that the vendor offers. 


Purpose of Vendor SKU Catalog:

  • It simplifies mapping SKUs to vendors and keeps procurement information updated.

  • It gives you visibility to check purchase price, Lead time, purchase unit factor, return or non-returnable vendor.

Navigation: Master > SKU Management > Vendor SKU Catalog





Create/Edit Vendor SKU Catalog:

Click the button “Add New” under Vendor SKU Catalog. 

The system displays a form to enter the following information -




Fields 

Description

SKU Code

The unique SKU code of the product as defined in SKU Master.

SKU Description

A detailed description of the product from SKU Master.

Vendor Code

A unique code that identifies the vendor within the Vin WMS.

Vendor Name

The name of the vendor.

Vendor SKU Code

The SKU code used by the vendor for the product.

PO Additional Charge Type

Type of additional charges that may apply to the purchase order, such as shipping, handling, etc.

Base UOM

The standard unit of measure for the product. Example: “Each”

Cost

The cost of the product if procured from this vendor.

Lead Time(in days)

The number of days it takes for the vendor to deliver the product after raising a PO.

Max Order Qty

The maximum quantity of the product that can be ordered in one PO.

Min Order Qty

The minimum quantity of the product that can be ordered in one PO.

Purchase Unit Factor

The factor in multiples of which a PO can be raised for this SKU.

Is Active

Check the checkbox if the Vendor SKU is currently active and available for purchase.

Return

Check the checkbox if the product is returnable.

Is Primary

Check the checkbox if the vendor is the primary source for this SKU.

Update All Variants

Indicates if changes to this SKU should be applied to all variants of the Style.



Now click on the Save button to store the data in the system.


User Defined Fields:



User Defined Fields (UDFs) capture additional details of a Vendor SKU’s which are not captured in other fields in the system. There are a total five such fields user can use. 


Edit Catalog for any Vendor:

Users can easily edit an existing catalog from the system to keep the Vendor’s item updated.


  • Use a search filter to select an existing Vendor that needs to be edited.

  • Now, click on the “Pencil” button from “Actions” as shown in the above image.

  • A Pop-up form will display, fill the modified details to update the existing records.


Fields based on which the SKU can be searched:

  1. SKU Code: Search by using the SKU code of the product.

  2. Vendor SKU Code: Search particular products based on vendor SKU code. 

  3. Vendor Code: Search the product based on vendor code.

  4. Is Primary: Select Yes to filter primary vendor item else select No from the dropdown.

  5. Is Active: Select Active/Inactive option from the dropdown to filter Active/Inactive vendor SKU.

  6. Lead Time(In Days): Enter the days in number to filter vendor items that could deliver in specific time. 

  7. SKU Cost: Enter the specific item cost based on which you want to filter the vendor item.

  8. Return: Select Yes to filter vendor products that can be returnable from the list.

  9. Purchase Unit Factor: You could apply the filter based on purchase unit factor.



Action Button - 




Action Button

Description

Search

Clicking on the search button without entering any filter criterion will populate the list of all the Vendor SKU catalogs created in the system based on default filter setting.

Reset

Reset button will refresh the filter fields to default settings, i.e. to an initial state to start fresh search.

Export

Users can download/export all the data present on the Vendor SKU Catalog screen at any point of time.

Add New

To add a new Vendor SKU Catalog event to the database.


Create a vendor SKU catalog in bulk:

Users can import the Bulk Vendor SKU from the Vendor SKU catalog Import section by using the XLS  template given in the import section. 


Note: Max 1000 rows can be imported in an attempt of Import.


NAVIGATION: Masters > SKU Management > Vendor SKU Catalog Import


Click the “Import” option  under Vendor SKU Catalog.



The import section will let the user import the Vendor SKU’s Bulk via XLS.


The Vendor SKU catalog Import Section will have following options:


Import Type: Select the type to import the XLS for Vendor SKU.


Choose any one option from the dropdown:


  • General Import


Download Template: Default XLS template can be downloaded from here.


XLS template will have below fields that is required to create vendor SKU Catalog in bulk.




Fill the data for respective vendor SKU with mandatory fields and save the file.


Upload Template: From here the XLS will be uploaded.


Once XLS file is uploaded, click on the import button as highlighted below:



Vendor SKU catalog Import further lets you track status of all uploaded XLS via SKU code, Vendor SKU code, Vendor, Status, Error Description and Uploaded Date.


Vendor SKU Loc Catalog Overview:

Additionally, there is another functionality to map product SKUs to vendors based on specific location. This feature allows users to make a purchase order for the product at a specific location.


Purpose of Vendor SKU Loc Catalog:

  • Mapping of vendors to SKU based on location helps to manage vendor catalog at the designated location.

  • Users can view the SKU list offered by the vendor for selling based on the locations, and have a separate primary vendor for each location.

  • Lead time option also allows vendors to have flexibility to maintain different delivery times for each location. 


Navigation: Master > SKU Management > Vendor SKU Loc Catalog





Note- 


The functionality for adding/editing/importing the SKU Vendor Location catalog will work similarly to the SKU Vendor catalog. This means -


Add Vendor SKU loc Catalog - Users can add new mapping of vendor SKU with product SKU at location level using the same method they add in Vendor SKU Catalog.


Edit Vendor SKU Loc Catalog -  Users can edit mapping of vendor SKU with product SKU at location level in the same way they add in Vendor SKU Catalog.


Import Vendor SKU Loc Catalog -  Users can add/edit mapping of vendor SKU with product SKU in bulk at location level with the same process they add in Vendor SKU Catalog.