Updating Product Price, Cost and Quantity via CSV File

In this article, we'll walk through the steps on how to update inventory product prices, costs, and quantities using CSV files. 

To update product price, cost, and/or quantity:

1. Navigate to POS > Inventory
2. Export your inventory by clicking the Export link at the bottom right of the page
3. The inventory data will be downloaded in a zip file. In that file, locate and open the inventory_stocks sheet:
   • In this sheet you can add or edit the data in the following columns:
     • sku_id - The sku_id is your SKU external ID that can be found on your 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.
     • location_id - You can locate your location_id by navigating to Business Setup> Business Profile> Edit Locations > Store ID. You can add your own if this field is blank 
     • price
     • cost
     • quantity
4. Once you have made changes to the product's price, cost, and/or quantity, download the sheet as a CSV file
5. On the Inventory page, click Import
6. On the Import Inventory page, read the instructions and then click "Upload File Here"
7. Select the CSV file from the file manager and then click the Import button
8. You will then be directed to the Ingest Data Processed batch page, with the file located at the top
9. 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! You have successfully changed your product prices, cost, or quantity using Ingest Data. You can navigate to POS > Inventory to view the changes. 

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