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:
- Navigate to POS > Inventory
- On the left panel, click Vendor Profiles
- Once the page loads, click 'Export' to download the zip file
- 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
- inventory_vendors: This sheet contains vendor profile details.
- Once you’ve updated both CSV sheets, download them as CSV files
- Go back to Vendor Profiles
- Click 'Import'
- On the Import Inventory page, review the instructions and click 'Upload File Here'
- Select your CSV file and click 'Import'
- You’ll be redirected to the Processed Batches page
- 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
Feedback sent
We appreciate your effort and will try to fix the article