Exporting Global Vendors

In this article, we will guide you through the steps on how to export global vendors in MyTime.

Things to know:

• The global database for inventory must be enabled on both 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 to activate it.
• The ability to export global vendors is controlled by the "Manage Inventory Vendors" access permission and the "Enable Global Vendors" company setting.
• Global Vendor Export Formats:
• Excel Spreadsheet – The default format for exporting the vendor list.
• ZIP File – Available through a hidden setting that must be enabled by the MyTime team. To activate this option, contact our support team at support@mytime.com.
• Do not edit the inventory manifest file included in the export; it is used internally by MyTime.
• Do not delete or rearrange any column titles in the CSV files.

Contents

• Export as Excel Spreadsheet
• Export as ZIP File

Export as Excel Spreadsheet

1. Navigate to the Inventory tab
2. In the left panel, click Vendor Profiles.
3. Once the page loads, click the Export hyperlink
4. An Excel spreadsheet will be downloaded to your device.
5. Open the spreadsheet to view the exported vendor list.
6. You can review and make adjustments to your inventory as needed.

Export as ZIP File

1. Navigate to the Inventory tab.
2. In the left panel, click Vendor Profiles.
3. Once the page loads, click Export to download a ZIP file.
4. The system will generate a ZIP file containing the following files:
   • inventory_vendors
   • inventory_vendor_skus
   • inventory_manifest

Contents of Exported Files

:

Inventory_Vendors CSV files

Inventory_Vendor_Skus CSV File

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
mytime_sku_id	The internal unique ID for the 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

Inventory_Manifest CSV File

• Example Contents:
• inventory_vendors
• inventory_vendor_skus

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

Related Articles:

• Global Vendors
• Adding Vendors Manually on the Vendor Profile Page
• Adding Vendors while Importing Products
• Assign Products to Vendors