Importing Global Vendors

This article will guide you through the steps to import a global vendor.

Things to know:

• The global database for inventory must be enabled on the parent and child accounts. This is controlled by a hidden setting that can only be enabled by the MyTime team. Please contact our support team at support@mytime.com. 
• The ability to import global vendors is controlled by the "Manage Inventory Vendors" access permission and the "Enable Global Vendors" company setting.
  
• Inventory Manifest file should not be edited. This file is used internally by MyTime
• Inventory Vendor CSV file should be completed first, followed by the Inventory Vendors SKU CSV file
• Do not delete or rearrange any of the columns on the spreadsheet

To import a vendor:

1. Navigate to Inventory

2. Select Vendor Profiles on the left panel

3. Once the page loads, click on the 'Export' link to download the zip file

4. Open the zip file and update the necessary information in the CSV files

An explanation of how to add or modify each row is below

INVENTORY VENDORS CSV FILE

Adding New Vendors

• vendor_id - This field is required. This is the external ID of the vendor.
• mytime_vendor_id - The internal MyTime ID of the vendor. This field is provided and
  used only by MyTime for existing vendors. Please ignore.
• name - This field is required. Enter the name of the vendor
• phone_number - This field is optional. The phone number of the vendor
• fax_number - This field is optional. The fax number of the vendor
• email - This field is optional. The email address of the vendor
• street_address - This field is optional. The street address of the vendor
• street_address_2 - This field is optional. The second street address line of the vendor
• city - This field is optional. The city of the vendor’s address
• state - This field is optional. The state of the vendor's address
• country - This field is optional. Two-letter country code e.g. US
• zip - This field is optional. The zip code of the vendor's address
• deleted - This field is optional. Indicates if the vendor was deleted. If left blank, it defaults to 0.
  • Enter 1, if a vendor should be deleted (soft delete)
  • Enter 0, if a vendor should not be deleted
  • If a row for an existing vendor is deleted, then no change will be made to that vendor in MyTime

INVENTORY VENDORS SKU CSV FILE

Adding New Vendor SKUs

• vendor_sku_id - This field is required. This is the external ID of the vendor SKU.
• mytime_vendor_sku_id - This is the internal MyTime ID of the vendor SKU. It can be
  used to update a vendor SKU already in the system. This field is provided and used only
  by MyTime. If both mytime_vendor_sku_id and vendor_sku_id are provided, the
  importer first matches by vendor_sku_id. If it can't find anything, then it matches by
  mytime_vendor_sku_id.
• vendor_id - This field is required. This is the external ID of the vendor. If both
  mytime_vendor_id and vendor_id are provided, the importer first matches by vendor_id.
  If it can't find anything, then it matches by mytime_vendor_id.
• mytime_vendor_id - This is the internal MyTime ID of the vendor. It can be used to
  update a vendor already in the system. This field is provided and used only by MyTime.
  If both mytime_vendor_id and vendor_id are provided, the importer first matches by
  vendor_id. If it can't find anything, then it matches by mytime_vendor_id.
• sku_name - This field is required. The full name of the SKU.
• vendor_code - This field is optional. This is the product number this specific vendor
  assigned to the SKU if different from the manufacturer SKU number.
• cost - This field is required. How much does it cost your business to buy this product
  from the vendor?
• min_order_quantity - This field is optional. The minimum order quantity the SKU must
  be ordered in when replenishing stock. If no value is entered, it defaults to 0.
• discontinued - This field is optional. Is the product available for Purchase Order?
  (TRUE or FALSE)
• deleted - This field is optional. Indicates if the vendor SKU was removed from the
  vendor.
  • If the vendor SKU should be deleted - 1
  • If the vendor SKU should not be deleted - 0

5. Once the files are updated, zip the files (3 in total - inventory manifest, inventory vendor, and inventory vendor SKU)

6. On the All Vendors page, click on 'Import'

7. The screen below will appear, select ‘Upload File Here’

8. Select the Upload button

Your vendors are now added and will appear in your Vendor Profile section of MyTime.

For more information, contact us at support@mytime.com.    

Related Articles:

Exporting Global Inventory

Adding Vendors Manually on the Vendor Profile Page

Adding Vendors while Importing Products

Assign Products to Vendors