In this article, we'll walk through the steps on how to update inventory product prices, costs, and quantities using CSV files.
Things to know:
- The ability to update a product's price, cost, and/or quantity via ingest data is governed by the 'Accessing Ingest Data' access control setting.
- The ability to update products' price, cost, and/or quantity 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.
- When making changes, be sure to use the Location ID column (Column D) to identify the correct location for each product, ensuring that updates are applied accurately.
To update product price, cost, and/or quantity:
- Navigate to POS > Inventory
- Export your inventory by clicking the Export link at the bottom right of the page
- The inventory data will be downloaded in a zip file. In that file, locate and open the inventory_stocks sheet.
- On this sheet, you will see the following:
Column Description product_name The name of the product sku_id The sku_id is your SKU's external ID that can be found on the 'Edit Product Details' modal under POS > Inventory. 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. sku_name The name assigned to the SKU location_id The unique characters assigned to the 'Store ID' field on the 'Edit Location' modal under Business Setup> Business Profile> Edit Locations > Store ID. You can add your own if this field is blank quantity The current quantity for the stock type (retail vs back bar) of each product stock_type This will indicate whether the product is stocked for back bar or retail price The price of the product cost The cost of the product vendor The vendor assigned to the product expiration_date The expiration date assigned to the shipment received for the product. This can be found on the 'Add Shipment' modal under POS > Inventory > Expand the product mytime_sku_id The unique internal MyTime ID assigned to the SKU
mytime_location_id The unique internal MyTime ID assigned to the location mytime_stock_id The unique internal MyTime ID assigned to the stock deleted This gives you the option to delete products by changing the '0's to '1's
- Once you have made changes to the product's price, cost, and/or quantity, download the sheet as a CSV file
- On the Inventory 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! 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.
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