How do I add (or remove) a store to a product lookup?

The tutorial below is how to add stores to product lookups.  A "Store" is how Finale is configured to push stock levels back to the corresponding marketplace.  This is necessary because Finale allows you to configure the stock updates on a SKU by SKU basis.  Think of a Store as a "flag" that tells Finale to update the quantity of that SKU to that integration.   Without it, Finale will not update the stock levels for that SKU.

To remove stores, the steps are the same, however, for the bulk updates, you would use the column title "Stores to Remove" instead of "Stores to Add".

*Note: An active integration is required first before the store option is available. The Store is derived from the integration name (or location name for multi-location integrations).

Manually Add a Store

The first is on the product detail page. The product lookups section near the bottom of the page will have a new column showing the stores connected to each product lookup. Add stores to a product lookup using the "Edit stores for lookup" item in the Actions menu for each row in the table.  This will tell Finale that we are updating that SKU with quantity to the chosen marketplace.

If the product lookup (marketplace SKU) is not showing here at all, you'll need to create it first.  You can do this manually by following these steps, or you can create them in bulk when you add the stores (see below).

Bulk Add Stores to Product Lookups

The second is using the import to batch create & update product lookups feature. This can be found on in the quick links section of your home screen named "Import & Export".  Then choose "Import to batch create & update product lookups (aka scan lookups)".

One of the columns available to be imported is Stores. The stores columns is simply the name of the store associated with each product lookup being imported. If a single product lookup should be associated with multiple stores, then list the name of each store in the column separated by commas.  The mapping can be created by following the instructions below.

First, create a 3-column product mapping file in Excel using the following column headers:

• Column 1: Product ID
• Column 2: Product Lookup (which is the marketplace sku). If the sku and the Finale product id are same identified, then column 1 and column 2 will be the same.
• Column 3: Stores to Add (which would be the connection name e.g ‘Amazon’).  If you'd like to bulk REMOVE stores, then use the header "Stores to remove".

The product lookup import template can be downloaded here.

Next, copy the spreadsheet data and paste data under:

Import / Export >> Import to batch create & update product lookups