Updating Product Name, Brand or Category via CSV Files (Ingest Data)

In this article, we will walk through the steps to update your inventory product name, brand, and category using CSV files.

Things to know:

• The ability to update a product's name, brand, and/or category via ingest data is governed by the 'Accessing Ingest Data' access control setting.
  
• The ability to update products' names, brands, and/or categories via CSV file 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.
• Each product can be assigned to only one brand and one category. Importing multiple brands or categories for a single product is not supported.

To update a product's name, brand, and category:

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_products sheet. 
4. On this sheet, you will see the following: 

   Column	Description
   product_id	The external ID assigned to the product on the 'Edit Product Details' modal under POS > Inventory
   name	The name of the product
   brand	The product brand assigned to the product
   category	The product category assigned to the product
   description	The description added to the 'Edit Product Details' under POS > Inventory
   visible_to_clients	Corresponds to the "Sell To Clients (And Apply Taxes)" checkbox found in the 'Edit Product Details' modal under POS > Inventory. If the box is checked, this column will display a 1. If the box is unchecked, it will display a 0.
   commissionable	Corresponds to the "Commission Eligible" checkbox in the 'Edit Product Details' modal under POS > Inventory. If the box is checked, this column will display a 1. If the box is unchecked, it will display a 0.
   discontinued	Tied to the "Active" toggle in the 'Edit Product Details' modal under POS > Inventory. If the toggle is set to Yes, the product is considered active, and the column will display a 1. If set to No, the product is considered discontinued, and the column will display a 0.
   discontinued_reason	Displays the reason provided for discontinuing the product.
   alternative_product_IDs	Any external alternative ID to use to identify the product
   product_photo	The link to any photo attached to the product
   deleted	This gives you the option to delete products by changing the '0's to '1's
   mytime_product_id	The unique internal MyTime ID assigned to the product

   
5. Once you have made changes to the product's name, brand, and/or category, download the sheets as a CSV file
6. On the Inventory page, click Import
7. On the Import Inventory page, read the instructions and then click "Upload File Here"
8. Select the CSV file from the file manager and then click the Import button
9. You will then be directed to the Ingest Data Processed batch page, with the file located at the top
10. 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's name, brand, or category using Ingest Data. You can navigate to POS > Inventory to view the changes.

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