Welcome to the Help Center

Adding Products via Inventory Spreadsheet

In this article, we will walk through how to add a new product to your inventory via the MyTime spreadsheet. 

Things to know:

  • For imports, products are matched by name + category + SKU name. They must be
    entered in order for the data in that row to be recorded. These columns are labeled
    matcher and will be used to map, or match, the product on your sheet to the product that
    you already have in MyTime. If you change any of these fields of an existing product, it will create a new product. 
  • Radio buttons at the bottom of the page:
    • If Update existing inventory is selected, then existing SKUs will not be deleted if they are not on the import sheet
    • If Overwrite and replace inventory is selected, only existing SKUs for products with multiple SKUs will be updated/removed. Existing SKUs that are not on the import sheet will be removed from inventory. For each product name on the import sheet, you must include the quantity of each SKU Name/SKU Number associated with that Product Name, or else that SKU will be deleted from inventory.      

  17610465-7d18041a411593f1a7fe2991346b48df.png

    • If you edit details such as brand, SKU #, barcode, description, etc, and the "Overwrite and replace inventory" option is selected when importing - the edits will reflect at all locations.

To access the inventory spreadsheet:

  1. Navigate to POS > Inventory 10431471-dbde8702d1b15dedca9a51e0582af81a.png
  2. Select the Import link at the bottom right of the page 10431605-30834ef00cde3b783dac0e2016a25a07.png
  3. The screen below will appear, select Download spreadsheet  10431633-a3ac7d16641a5bb03a8e48f80a71efa5.png
  4. The first tab of the excel document (labeled INSTRUCTIONS) explains how to enter your inventory.
  5. Use the second tab (labeled SKU) to enter your inventory information.
    • Product Name - This field is required and is a matcher. Enter the product name that this
      SKU corresponds to.
    • Product Brand - Brand of the product
    • Product Category - This field is required and is a matcher. Category associated with
      the product; you can add multiple categories, just separate using a comma.
    • Product Vendor - Vendor responsible for supplying the product.
    • Product Description - Text description of the product, often provided by the
      manufacturer
    • Sell Product to Clients? - ("Y" or "N") Should this product be sold to customers via the
      POS? Taxes will be applied.
    • Commission Eligible? - ("Y" or "N") Can this product be applied to retail commissions?
    • Discontinued? - ("Y" or "N") Can this product be ordered?
    • SKU Name - This field is required and is a matcher. The full name of the SKU
    • SKU Number - The unique stock-keeping unit associated with the specific version of a
      product
    • Vendor SKU Number - The Product Number the vendor assigned to the SKU, if
      different than the Manufacturer’s SKU number
    • Min - The quantity at which you want to be alerted to re-order on MyTime
    • Barcode - The number appearing directly below the barcode image on the SKU. You
      can add multiple barcodes, just separate using a comma.
    • Max - The quantity of each SKU you want to maintain; used to calculate the reorder
      amount
    • Price - This field is required. The price paid by the client for the SKU
    • Cost Basis - This field is required. The price paid to the vendor for the SKU
    • Expiration Date - The expiration date of SKUs (leave blank if this does not apply)
    • Current Retail Stock - The current retail stock at the time the report was exported
      from MyTime
    • Current Back Bar Stock - The current back bar stock at the time the report was
      exported from MyTime
    • New Batch Date Added - The date the new batch was added to your inventory.
    • New Retail Batch Quantity - The quantity of retail SKUs that you are stocking as part
      of a new batch or shipment (you must use this if the cost or expiration date differs from
      previous batches). Note if this column is used, the Current Stock column will be ignored.
    • New Back Bar Batch Quantity - The quantity of back bar SKUs that you are stocking
      as part of a new batch or shipment (you must use this if the cost or expiration date
      differs from previous batches). Note if this column is used, the Current Stock column will
      be ignored.
    • New Cost Basis - The cost of SKUs in the new batch
    • New Expiration Date - The expiration date of SKUs in the new batch (leave blank if this
      does not apply)
    • Retail Enabled - Indicates the SKU can be a retail item
    • Back Bar Enabled - Indicates the SKU can be a back bar item.
  6. When you are finished entering your inventory information into the MyTime Inventory Spreadsheet, make sure to save the excel file
  7. Next, return to the Import section of the Inventory page, select the location then the Upload button 17610731-32306b492734dbe6b8f426669a5ffa96.png
  8. When your file is uploaded, select Import 17610788-80dc44ecd33ade91442b4fc86c6d73f6.png
  9. Your products are now added and will appear in your Inventory section of MyTime

If you have any questions about adding products to Inventory, contact our Support Team at support@mytime.com.  

Related Article

Adding Products Manually to Inventory

Powered by Zendesk