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.
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.
Next, copy the spreadsheet data and paste data under:
Import >>Product lookups to batch create & update product lookups