Importing Vendors & SKUs on the Vendor Profile Page

Vendor profiles in MyTime are essential for creating purchase orders. To include a product in a purchase order, it must first be assigned to a vendor. This article explains how to import new vendors and vendor SKUs into your inventory using CSV files via Ingest Data.

Things to know: 

• The ability to import vendors is governed by the "Manage Inventory Vendors" access control setting.
• You can edit external IDs for vendors and vendor SKUs, but only if the hidden setting is enabled by the MyTime support team. To activate it, please contact our support team at support@mytime.com. 
• Do not edit the inventory manifest file included in the export; it’s used internally by MyTime.
• Do not delete or rearrange any of the column titles on the CSV files.
• When you export vendors, only active (non-deleted) vendors are included.
• You can use this import process to reassign products to a new vendor.
• When importing the inventory_vendor_skus sheet, the importer follows this order for matching records:
  • If both vendor_sku_id and mytime_vendor_sku_id are provided, the system attempts to match first by vendor_sku_id, then by mytime_vendor_sku_id.
  • Similarly, if both vendor_id and mytime_vendor_id are provided, it tries vendor_id first, then mytime_vendor_id.

To get started:

1. Navigate to POS > Inventory
2.  On the left panel, click Vendor Profiles
3. Once the page loads, click 'Export' to download the zip file 
4. Extract the file, you’ll find two CSV sheets:
   
   • inventory_vendors: This sheet contains vendor profile details.
     

     Column	Description
     vendor_id	External ID you assign to the vendor
     mytime_vendor_id	The unique internal MyTime ID assigned to the vendor
     name	The name of the vendor
     phone_number	The vendor's phone number. This field is optional
     fax_number	The vendor's fax number. This field is optional
     email	The vendor's email address. This field is optional
     street_address	The vendor's physical address. This field is optional
     street_address_2
     city
     state
     country
     zip
     deleted	This gives you the option to delete products by changing the '0's to '1's

     
   • inventory_vendor_skus: This sheet maps products (SKUs) to vendors.  

     Column	Description
     vendor_sku_id	The vendor_sku_id can be found on your vendor product interface. The visibility of this field is controlled by a hidden setting that can only be activated by the MyTime team. To enable the hidden setting, please contact our Support Team at support@mytime.com
     mytime_vendor_sku_id	The unique internal MyTime ID assigned to the vendor SKU
     vendor_id	The external ID assigned to the vendor
     mytime_vendor_id	The unique internal MyTime ID assigned to the vendor
     sku_name	The name assigned to the SKU
     sku_id	The unique ID assigned to the specific SKU
     sku_number	The manufacturer SKU number listed on the 'Edit Product' modal
     vendor_code	This is the product number that the specific vendor assigned to this SKU. This information is added as the vendor SKU on the vendor product interface.
     cost	The cost for the product that was added on the vendor product interface.
     min_order_quantity	The minimum order quantity for the product. If no value is entered, it defaults to 0.
     discontinued	Tied to the "Active" toggle in the 'Edit Product Details' modal under POS > Inventory. If the toggle is set to Yes, the product is considered active, and the column will display a FALSE. If set to No, the product is considered discontinued, and the column will display a TRUE.
     deleted	This gives you the option to delete products by changing the '0's to '1's

     
5. Once you’ve updated both CSV sheets, download them as CSV files
   
6. Go back to Vendor Profiles
7. Click 'Import'
   
8. On the Import Inventory page, review the instructions and click 'Upload File Here'
   
9. Select your CSV file and click 'Import'
   
10. You’ll be redirected to the Processed Batches page
    
11. Refresh the page until the status changes to Finished

If you have any questions about adding vendors and products to vendors, contact our Support Team at support@mytime.com. 

Related Articles:

• Adding Vendors while Importing Products
• Adding Vendors using the Shipment Button on the Inventory Page
• Adding Vendors Manually on the Vendor Profile Page