Managing Outlet SKUs

If you use DEAR POS in your outlets and you sell products based on weight and price, e.g. you ran a butcher shop, delicatessen, or flower shop, you can use weight-based or price-based barcodes with your products. This will allow DEAR POS to compute the prices your customers will need to pay at the register. However, before you can use these barcodes, you must have the required label printing weighing scales that can handle them. 


The DEAR POS Integration page is where you set DEAR POS to use GS1, weight-based or price-based barcodes. In addition, barcode configuration is performed under the Barcode setup tab on the DEAR POS Integration page. For more information, see Getting Started with DEAR POS.


If your product SKUs in DEAR are configured in such a way that they do not/cannot include weight or price data, you can also set up separate SKUs for these products on the outlet level. These outlet SKUs are similar to the price lookup codes in your weighing scales.


To know more about how these barcodes are used in DEAR POS, see Selling in DEAR POS.


Prerequisites


Table of Contents



Manually Creating Outlet SKUs

[back to top]


To create outlet SKUs for your products one-by-one:

  1. Navigate to the Integrations Tab and select DEAR Point of Sale.
  2. On the Integrations page, click the Outlets tab.
  3. Click Set product outlet-level SKUs for advanced barcodes.
  4. On the Outlet-Level Product SKUs window, click the button on the top left.



  5. Type in the product SKU, if known. As you type, DEAR responds by narrowing down your search until you see the applicable SKU.
  6. Select the product SKU to retrieve the product name and category as well.
  7. Enter the outlet-level SKU. This will be validated by DEAR based on the configured barcodes under the Barcode setup tab on the DEAR POS Integration page. For more information, see Barcode setup.

To add more outlet-level SKUs, repeat Steps 4-7.



Importing a List of Outlet SKUs

[back to top]


Aside from manually creating outlet SKUs, you can also import a .CSV file with a specific format in the Outlet-Level Product SKUs window. You can either create this file manually or export your outlet-level SKUs from another third-party program using the specified template file format (see Exporting Outlet SKUs). If you have multiple outlets, this procedure simplifies the creation of outlet SKUs since you can just export your outlet SKUs from one of your outlets and import it to another outlet.

IMPORTANT! DEAR will only allow importing outlet SKUs for products that are already listed in the outlet. Thus, you must list products in the outlet first before you can import the outlet SKUs for them.

  1. Navigate to the Integrations tab and select DEAR Point of Sale.
  2. On the Integrations page, click the Outlets tab.
  3. Click Set product outlet-level SKUs for advanced barcodes.
  4. On the Outlet-Level Product SKUs window, click the Import button.



  5. On the Import Outlet-Level SKUs page, download the Outlet Level SKUs template file. You can also download the template .CSV file directly from here.

IMPORTANT! Do not change the column headings in the template file. Otherwise, you may encounter problems importing the file back into DEAR.

  1. Enter your outlet-level SKUs into the template file, then import the file back to DEAR by selecting it from your computer or dragging it into the box at the bottom of the Outlet-Level Product SKUs window.
  2. If there are issues with the file, you will see them listed near the bottom. Correct the issues, then try uploading the file again.



  3. Once the file is successfully imported, you will be taken back to the Outlet-Level Product SKUs window, where a listing of the imported products will be displayed.



Exporting Outlet SKUs

[back to top]


You can export outlet SKUs to a .CSV file with a specific format in the Outlet-Level Product SKUs window. If you have multiple outlets, this procedure simplifies the creation of outlet SKUs since you can just export your outlet SKUs file from one of your outlets and import it to another outlet.

  1. Navigate to the Integrations Tab and select DEAR Point of Sale.
  2. On the DEAR POS Integrations page, click the Outlets tab.
  3. Click Set product outlet-level SKUs for advanced barcodes.
  4. On the Outlet-Level Product SKUs window, click the Export button.
  5. Select the folder on your computer where you want to save the file, then click OK.



Deleting an Outlet SKU

[back to top]


You can delete an outlet SKU if you do not want to sell it on your DEAR POS outlet anymore. 

  1. Navigate to the Integrations tab and select DEAR Point of Sale.
  2. On the DEAR POS Integrations page, click the Outlets tab.
  3. Click Set product outlet-level SKUs for advanced barcodes.
  4. On the Outlet-Level Product SKUs window, enter the outlet SKU to be deleted in the Search bar on the top right.
  5. Once you find the item, click the Delete icon to its right.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.