Updating Vendor Cost using 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. 

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
   • In this sheet, you can add or edit the data in the following columns:
     • vendor_sku_id - The vendor_sku_id can be found on your vendor product UI. 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            
     • vendor_id
     • sku_id
     • cost
     • min_order_quantity
5. Once you are through updating the vendor cost, download the sheets as a CSV file
6. On the vendor profile page, click Import
7. On the Import Inventory page, read the instructions and then click "Upload File Here"
8. Select the CSV file from the file manager and then click the Import button
9. You will then be directed to the Ingest Data Processed batch page, with the file located at the top
10. 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.