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 setting "Allow exporting inventory in ingest data format" must be enabled to export your inventory data in a zip file format to be used
To update vendor costs:
- Navigate to POS > Inventory
- Click Vendor Profiles from the left-hand panel
- On the vendor profiles page, click "Export" in the upper right-hand corner
- 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
- In this sheet, you can add or edit the data in the following columns:
- Once you are through updating the vendor cost, download the sheets as a CSV file
- On the vendor profile page, click Import
- On the Import Inventory page, read the instructions and then click "Upload File Here"
- Select the CSV file from the file manager and then click the Import button
- You will then be directed to the Ingest Data Processed batch page, with the file located at the top
- 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.