In the article, we will walk through the steps to update your inventory product name, brand and category using ingest data.
- Navigate to POS > Inventory
- Export your inventory and locate the following 3 spreadsheets or create new spreadsheets and rename them to:
- inventory_products - This sheet should include:
- product_id - This is the external ID that can be located on your product UI
- name
- brand
- category
- vendor
- product_id - This is the external ID that can be located on your product UI
- inventory_manifest - This sheet should include:
- inventory_products.csv
- type - products
- batch_manifest - This sheet should include the folder with the CSV sheets to be uploaded and the type (Please note that including the batch manifest is optional)
- inventory_products - This sheet should include:
- Download the Excel sheets as a CSV file
- Go to your download folder and create a new folder called "inventory"
- Cut and paste the inventory_products.csv and the inventory_manifest.csv sheets into the "inventory" folder
- 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
- When the Archive Name and Parameter dialog box appears, change the archive format to "zip" and rename the archive to inventory_(date).zip
- Click OK
- Login to your MyTime account
- Click the arrow beside your name in the top right corner to see the Ingest Data option
- The page will be redirected to the Processed Batches page > Click the Upload File button
- 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
- The file will appear below once it has successfully begun to ingest
- Once the file has begun to ingest successfully, the file will appear below
- 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 name, brand and category using Ingest Data. You can navigate to POS > Inventory to view the changes.
For more information contact us at support@mytime.com.