Welcome to the Help Center

Updating Product Price using Ingest Data

In this article, we'll go over how to update inventory product prices using ingest data. 

Things to know: 

  • Your sku_id can be found on the product UI, if you enable the hidden setting to have all the skus to become the SKU #.  This hidden setting can only be activated by the MyTime team. To enable the hidden setting, please contact our Support Team at support@mytime.com.
  • You can create your location_id by navigating to Business Setup> Business Profile> Edit locations > Store ID                                          

Update Product Price

  1. Export your inventory and locate the following 3 spreadsheets or create and rename them to:
    • inventory_stocks- This sheet should include:
      • sku_id
      • location_id
      • price
      • cost
    • inventory_manifest- This sheet should include:
      • inventory_stocks.csv
      • type - stocks                                                mceclip0.png
    • batch_manifest - This sheet should include the folder's name with the CSV sheets to be uploaded and the type (Please note that including the batch manifest is optional)mceclip4.png
  2. Download the excel sheets as a CSV file
  3. Go to your download folder and create a new folder called "inventory"
  4. Cut and paste the inventory_stocks.csv sheets into the "inventory" folder
  5. Create your zip file:
    • From your download folder, highlight the "inventory" folder and the batch manifest sheet or right-click on the folder only
    • Right-click one of the files and click "Add to Archive" or "Compress" depending on your device    zip_file.png
    • When the Archive Name and Parameter dialog box appears, change the archive format to "zip" and rename the archive to inventory_(date).zipmceclip5.png
    • Click OK
  6. Login to your MyTime account 
  7. Click the arrow beside your name in the top right corner to see the Ingest Data option           ingest_data_1.png
  8. The page will be redirected to the Processed Batches page > Click the Upload File button                                                 ingest_data.png
  9. Choose the zip file that you have saved on your computer then click Open - You will not see your file's name anywhere, and it will not import until you click the Import File button  
  10. The file will appear below once it has successfully begun to ingest ingest_data_3.png
  11. Once the file has begun to ingest successfully, the file will appear belowingest_data_4.png
  12. Once completed, the file will be assigned an end time and the status will be changed to Finished

Congrats you have successfully changed your product prices using Ingest Data. You can navigate to POS > Inventory to view the changes. 

 

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

 

Powered by Zendesk