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.
Learn more: How Mortar links Shopify products to your POS
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
Choose a product from the Oversell risk or Needs review sheet
Select the product title to open the product on Shopify
Review the Problem (column I) and apply the appropriate fix:
No match found - Fixing "No match" products
No data to match - Fixing "No data" products
Non-unique in POS or Non-unique in Shopify - Fixing "Non-unique" products
Conflicting matches - Fixing "Conflicting matches"
Check off or delete the corrected product from the product linking export
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.
