Skip to main content

Using the Mortar products export

The Mortar products export gives you a spreadsheet of your Oversell risk and Needs review products, so you can track and share linking fixes.

Overview

This spreadsheet can help organize the review of unlinked products and track your progress in fixing them, even splitting the workload between team members. To help you quickly review and edit each product, this report includes hyperlinks to the products on Shopify and your POS.

Sample Mortar Products export

Selecting the product title on the spreadsheet will open the related Shopify product in your web browser. To find the matching product in your POS, use the Search in POS action on the product's row on the Mortar Products page.

Setting your priorities

To help you prioritize which unlinked product to focus on first, Mortar organizes the report to focus on high-risk Oversell risk products. These products need your help to make a 1-to-1 link with a product in your POS. The report has a sheet for each tab on the Products page. The first sheet lists your linked products. It is named Linked while your account is onboarding and Syncing once your account is live. Work through these two sheets:

  • Oversell risk - Unlinked variants with available inventory on Shopify. These products are your highest risk for problems.

  • Needs review - Unlinked variants without inventory on Shopify. These are not a risk online and may be out-of-date products.

✔ Tip: Fix your Oversell risk sheet first!

Why products are unlinked

The Problem column (I) identifies the "why" you need to focus on for each product. This column can help sort and focus on products with similar causes. There are five types of problems you may need to address:

  • No match found - Mortar cannot find any product with a matching SKU or Barcode in your POS.

  • No data to match - A SKU or Barcode was not present on Shopify, so it is impossible to link.

  • Non-unique in POS - Multiple products in your POS have the same SKU or Barcode.

  • Non-unique in Shopify - Multiple products in Shopify have the same SKU or Barcode.

  • Conflicting matches - Multiple IDs on an existing product have resulted in more than one unique match to a product or multiple products.

Using the Mortar products export

Focus on making your Shopify SKUs or barcodes unique and match a unique ID found in your POS.

Step-by-step

  1. Choose a product from the Oversell risk or Needs review sheet

  2. Select the product title to open the product on Shopify

  3. Review the Problem (column I) and apply the appropriate fix:

    1. No data to match - Fixing "No data" products

    2. Non-unique in POS or Non-unique in Shopify - Fixing "Non-unique" products

    3. Conflicting matches - Fixing "Conflicting matches"

  4. Check off or delete the corrected product from the product linking export

  5. Repeat these steps at least for your Oversell risk products

Once you have fixed your Oversell risk products, you can work on the Needs review list or return to Mortar to finalize the linking process by selecting Finalize.

Learn more: Save Linking

General Tips

  • Sort - By default, the export is sorted alphabetically by title. However, if working on common issues is faster for you, it may be helpful to sort your products by other attributes like "Problem" (column I).

  • For non-unique products, when you have duplicate SKUs or Barcodes, it can be helpful to sort your list by these columns to see the identical IDs together and then sequentially fix each product.

  • Share - For large lists of products, it is often easier to divide and conquer. You can assign specific product rows to team members and distribute the workload to several people.

  • Track - Keep track of which products have already been fixed by marking each completed product in an additional column. If you are using a shared workspace like Google Sheets, your team can collectively see progress.


Additional Links

Did this answer your question?