Over the past several years, we have assisted many customers how to properly configure Finale to properly update stock quantities to their selling channels. We sometimes field calls from customers stating the most of their marketplaces or shopping carts SKUs are being updated with the correct stock quantities, but a few SKUs are not being updated by Finale.
If a Finale is updating a few SKUs, then you can immediately rule out the marketplace and/or shopping cart is not properly connected to Finale.
Below are the top reasons why a specific SKU is not updated.
1. There is NO mapping between the Finale product id and the selling channel sku
The quickest way to determine is that there is a mapping is running the highlighted report from the ‘Reports’ section.
The report name is called "Stock quantities pushed for each connection."
The mapping determines the relationship between the product id and marketplace SKU. If there is no mapping, then Finale will not update the stock level for a given marketplace.
This report will list all the product mappings by connection. If you do not see the product mapping when exporting the report, then the issue can be rectified by creating the mapping.
The mapping can be created by following the instructions below.
A) Create a 3-column product mapping file in Excel
- Product Lookup: This is your marketplace SKU. This can be the same as the Product ID
- Product ID: This is your Finale SKU
- Stores to Add: This is your integration name (Amazon, eBay, Walmart, etc.). It is case sensitive and must match EXACTLY how it appears in your integration page.
B) Copy the data from your spreadsheet and import it under Inventory>>Product Lookups
2. The mapping between the Finale product id and the selling channel SKU is incorrect
The second most common issue we see is when the store is pushing back an error when Finale is trying to update a stock level for a product. First, check your integrations page for any errors like the image below.
Update all of your Product Lookups to make sure that they match exactly what is in your store.
If this doesn't fix the error, see bullet point #4 below.
3. Multiple listings with the same SKU
Within a connection, Finale will only update the first instance if you have multiple listings with the same product id. eBay is a popular marketplace that allows for multiple listings with the same customer label (the equivalent of the product id within Finale). This issue can be easily rectified by changing the unique SKU of the sequent listings.
For example, if you have three eBay listings, each with the same custom label "Test", you would need to change the custom label of the other two to a variation, such as "Test-2" and "Test-3"
4. SKU Misconfiguration on the Marketplace or Shopping Cart
If you have confirmed the mapping is correct, and Finale is still not updating the marketplace, make sure inventory tracking is indeed turned on or enabled for the marketplace. Some marketplaces and shopping carts allow for inventory tracking to be disabled.
The settings on each respective connection may have a slightly different naming convention, but below is a screenshot of the Shopify tracking configuration. If your product has variants, you must check the inventory configuration on the variant level.
5. Special Characters in the SKU
Although not as common, we have seen customers have issues when there are special characters with the SKU within certain marketplaces and shopping carts. If the SKU has a special character (e.g. ‘&’, ‘>’, ‘#’) and is not being updated, modify the SKU to remove the special characters and remap the Finale product id.
If you follow the instructions above and are still having issues, please contact us firstname.lastname@example.org so that we can assist. We are happy to help.
6. Leading or Following Spaces in the SKU
Likely the least common cause, in certain cases the SKU on a marketplace or other connection will have space or a tab before or after the SKU. This will cause the Product Lookup within Finale to return an error because there is no exact match. Just simply edit the SKU to remove any spaces before or after and run the connection again.