Manage Vendor SKUs

Overview

When you assign Vendor SKUs and Prices to your products, Sellercloud can automatically apply the correct vendor, vendor SKU, and price upon Purchase Order (PO) creation. This helps you accurately track product costs, link products to the right vendors, and reduce manual data entry and errors in your Purchase Order Workflow.

In this article, you will learn how Vendor SKUs and Prices work and how to assign them to your products in Sellercloud.

Set Up Vendor Products

Sellercloud allows you to add multiple vendor item details to a single product, each with its own Vendor SKU and Vendor Price. You can also configure one specific vendor as the Default Vendor. This is particularly useful when you often buy from the same supplier or have a preferred vendor among several options.

Key Terms

• Vendor: Each product in Sellercloud can have multiple Vendors, but only one Default Vendor. This vendor is selected automatically when creating Purchase Orders (POs).
• Vendor SKU: The identifier a vendor uses for a product. Each vendor can have a unique Vendor SKU for the same product. When a product is added to a PO, the Vendor SKU auto-fills based on the selected vendor.
• Vendor Price: The cost the vendor charges for a product. Vendor Prices are automatically applied based on the selected vendor when generating POs. In addition, when a product is added to a PO, the Price entered is automatically saved as the new Vendor Price for the selected vendor.

Assign a Default Vendor

To assign a default vendor to a product:

1. Go to the Product Details Page.
2. Click Edit.
3. In the Purchasing panel, select the Default Vendor and enter the Vendor SKU.
   
4. Click Save.

Assign Vendors Individually

To assign vendor item details individually:

1. Go to the Product Details Page.
2. Click Toolbox and select Purchasing.
3. Click Edit.
4. In the Vendor Prices panel, click the Add vendor price icon.
   
5. Select the Vendor and enter the Vendor SKU and Vendor Price.
   
6. Optionally, you can also enter:
   1. Case price – The total price charged by the vendor for one case of the product.
   2. Qty/Case – The number of individual units contained in one case.
   3. Qty – The number of units available in the vendor’s warehouse(s).
   4. Available – Indicates if the product is available from the vendor.
   5. Notes – Internal notes regarding this vendor’s offer for the product.
7. Click Add and then repeat these steps to add more.
8. Click Save.

Assign Vendors In Bulk

To assign vendor item details in bulk:

1. Go to Purchasing > Tools > Import Purchase Info.
2. Select Import Vendor Price.
3. Click the Download Template icon and select a format. The file gets downloaded to your device.
4. Edit the file and enter the vendor details under the following headers:
   1. ProductID (required) – The product’s SKU.
   2. Vendor (required) – The name of the vendor. If the vendor does not exist, it will be created, unless you check Do Not Create Vendor If Doesn’t Exist on step 6.
   3. VendorSKU – The SKU assigned by the vendor to the product.
   4. VendorPrice – The cost per unit that the vendor charges for the product.
   5. VendorQty – The number of units available in the vendor’s warehouse(s).
   6. IsDefaultVendorForProduct – True or False, indicates if this is the product’s Default Vendor.
   7. PricePerCase – The total price charged by the vendor for one case of the product.
   8. QtyPerCase – The number of individual units contained in one case.
   9. IsAvailable – True or False, indicates if the product is available from the vendor.
   10. VendorPricesNotes – Internal notes regarding this vendor’s offer for the product
   11. _ACTION_ – Enter _DELETE_ to remove existing Vendor SKU information from Sellercloud.
5. Save your file, then back in Sellercloud, click File and select it.
6. Optionally, you can also select:
   1. Company – The company in your Sellercloud account to which this vendor pricing applies.
   2. Profile – A saved Import Mapping.
   3. Schedule Job Date – Schedule the import to run at a specific future date/time.
   4. Do Not Create Vendor If Doesn’t Exist – Skip entries for vendors not already set up in Sellercloud, instead of creating new vendor records automatically.
7. Click Import. A Queued Job is created, and you will receive a Notification upon completion.
   

Manage Vendor Products

After adding your vendors’ associated SKU, price, and other details, you can use these options by going to the Product Details Page > Purchasing tab > Vendor Prices panel:

• Export – Export all of the product’s vendor SKU and price information to a spreadsheet.
• View History – View historical records of associated POs.
• Edit – Update a vendor’s SKU and price details.
• Delete – Delete a vendor’s SKU and price details.

Related Client Settings

The following related Client Settings are available:

• Allow To Edit Vendor SKU On PO Detail Page – Allow the Vendor SKU on the Purchase Order Details Page to be updated.
• Print PO To PDF: Always Print ProductID Instead Of Vendor SKU – When creating a PDF document of the PO, use the product’s standard Sellercloud SKU instead of the Vendor SKU.
• Do Not Update If PO Date Is Less Than Last Vendor Price Date – Prevent older POs with dates earlier than the last date on which you entered the Vendor Price from automatically changing the Vendor Price at the moment they’re created.