Importing Products

One of these is the product import feature in the POS Manager. Below you'll find out how to import products using our Excel template.

• Download the template
• Edit the template
• Import products

Downloading the Template

1. Log in to the POS Manager.
2. Go to Inventory > Products > Import.
3. To import new products, download the template.

Editing the Template

You can now edit the spreadsheet. We recommend editing the file with Microsoft Excel or OpenOffice. Please note that Numbers formats data differently, and exporting from Numbers to Excel can lead to errors during import into our system.

The Following Fields Are Required:

Name

Maximum 256 characters. The product name appears on the invoice.

Tax Rate in %

Enter the tax rate as a plain number without the % symbol (e.g. "19"). If you use the Shore POS outside of Germany, you can adjust your tax rates under Settings > Business > VAT.

Attributes (for Variations Only)

These are intended for products with variations. Variations are products that exist in different sizes, colors, etc.

For the Shore POS to combine multiple rows into a single product with variations, the "Name" column must contain the same product name, with attributes listed in columns "N" through "AG." You can use a maximum of three attributes per variation.

The Following Attributes Can Be Assigned:

These Fields Are Optional and Not Required:

• Item number
• Description
• Gross price
• Quantity
• EAN
• Purchase price
• Safety stock
• Reorder point
• Brand
• Supplier
• Category

Importing Products

Once you've filled in and saved your import template, you can upload it.
Follow these steps:

1. Open the POS Manager.
2. Go to Products > Product List > Import.
3. During import, you can choose between two options:
   1. Add products: Adds new products to your existing inventory.
   2. Replace all products: Removes and replaces all current products (including images) with your new import.
4. Click Select File and choose the Excel file on your computer.
5. Click Import Now to start the import.

You can check the import history below to see whether the import was successful.

A successful import is marked with a green "Done" label. If the import didn't work, a red "Failed" label appears. Hovering over the status shows more details.

Deleting Products

To delete a product, click the desired product in the product list in the POS Manager and select "Delete item" under "Actions."

Error Message When Deleting Products

The most common cause of error messages when deleting products is an outdated browser cache or an out-of-date browser version.

Quick refresh without fully clearing the cache:

• Windows: Ctrl + Shift + R
• Mac: Cmd + Shift + R

Optional: Fully clear the browser cache

• Windows: Ctrl + Shift + Delete
• Mac: Cmd + Shift + Delete

Then select "Cache" and clear it. Restart your browser afterward and try again.

Solution A: Clear the browser cache

Clear the browser cache as described above, then try deleting the products again.

Solution B: Delete multiple products via export

1. Go to manager.shore.com → Reports → Download → XLS Reports and download the Product_export file.
2. Edit the file, removing or changing the desired products, then save it.
3. Go to manager.shore.com → Inventory → Products → Import and select "Replace all."

Undoing an Overwrite of the Product List

An import can only be undone if no products have been modified after the upload (e.g. through sales, manual individual edits, or other changes). If products have already been changed after the import, undoing the import is no longer possible.

Steps to Restore Product Data

Step 1: Review product data

1. Open the product statistics report (previous month or current period).
2. Use the following columns from it:

• Columns B–E
• Column I

Step 2: Prepare the data

1. Before re-importing, always save a current product export as a backup first, e.g. under the file name Backup_Products_Date.xlsx.
2. Copy the data from columns B–E and I from the report.
3. Paste the copied data into the corresponding columns of the product upload list (Excel).
4. Use the corrected upload list for the new import.

Upload Variants

Variant 1: Add new products only (recommended)

• The safest method.
• Existing products remain unchanged.
• Only new products are added.

Variant 2: Replace all products

• Here too, always save a current product export as a backup first, e.g. under the file name Backup_Products_Date.xlsx.
• Then import the corrected, complete upload list.
• Use this variant only if the upload list is complete and correct.
• Existing product data will be replaced by the imported data.

Deleting Products with Images

Currently, there's no way to bulk-delete products that have images without also removing the associated images.

Images are currently only stored as a temporary cache in the cloud, not as standalone image files that can be downloaded or managed separately. This behavior also occurs after a complete recreation or re-import of the XLS file.

Workaround: Please delete products individually.

Caution: Deleting individual variations also removes their associated images. For products with variations, open the main product first, then delete the individual variations.

If bulk selection doesn't work at all, please check the following:

• Clear your browser cache or use a private/incognito window.
• Make sure you have at least Windows 10 with all current security updates installed.
• On Apple devices, check that the current macOS version is installed.