Updating Vendor Cost via CSV Files (Ingest Data)

Updating vendor costs via CSV files provides a streamlined approach to managing and updating vendor costs across products. This method is ideal for businesses that manage large inventories or frequently update vendor costs, helping maintain accurate pricing and cost records. The guide will walk you through preparing your CSV file and the steps needed to complete the upload. 

Things to know:

• The ability to update a vendor's cost is governed by the 'Accessing Ingest Data' access control setting.
  
• The ability to update vendor cost via CSV files is controlled by a hidden setting that only the MyTime team can enable. To enable the hidden setting, please contact our support team at support@mytime.com.

To update vendor costs:

1.  Navigate to POS > Inventory
2. Click Vendor Profiles from the left-hand panel 
3. On the vendor profiles page, click "Export" in the upper right-hand corner
4. The vendor data will be downloaded in a zip file. In that file, locate and open the inventory_vendor_skus sheet
5. On this sheet, you will see: 
   

   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
   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

     
6. Once you are through updating the vendor cost, download the sheets as a CSV file
7. On the vendor profile page, click Import
8. On the Import Inventory page, read the instructions and then click "Upload File Here"
9. Select the CSV file from the file manager and then click the Import button
10. You will then be directed to the Ingest Data Processed batch page, with the file located at the top
11. Refresh the page until it is completed. When completed, the file will be assigned an end time and the status will be changed to Finished

Congratulations on successfully updating your vendor cost with Ingest Data. To see the changes, please visit the vendor profile.

For more information, contact us at support@mytime.com or (385) 233-6964.