Importing Vendors & SKUs on the Vendor Profile Page

Modified on Mon, 2 Jun at 9:31 AM

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 blobid2.png
  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.
      ColumnDescription
      vendor_idExternal ID you assign to the vendor
      mytime_vendor_idThe 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.  
      ColumnDescription
      vendor_sku_idThe 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_idThe unique internal MyTime ID assigned to the vendor SKU
      vendor_idThe external ID assigned to the vendor 
      mytime_vendor_idThe 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.
      costThe cost for the product that was added on the vendor product interface. 
      min_order_quantityThe minimum order quantity for the product. If no value is entered, it defaults to 0. 
      discontinuedTied 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

Congratulations! You've successfully updated your vendor and SKU data using Ingest Data. To verify the changes, navigate back to the Vendor Profiles page in your inventory.



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

 

Related Articles:

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article