There are 3 scenarios where this can happen:
1) Products in your store are duplicated.
Spark Shipping requires unique SKUs for products. When products share the same SKU, Spark Shipping assigns a unique ID at the end of the SKU to make it unique.
To correct this, we recommend that you remove the duplicate SKUs from your store first. Then, you request a data purge and refresh from Spark Shipping support.
2) Products in your store were deleted and re-listed.
Spark Shipping does not remove products that were deleted in your store automatically. Instead, it will see the new version of each SKU as a duplicate instance so it assigns a unique ID at the end of the SKU to make it unique.
To correct this we would recommend that you contact Spark Shipping support to request a data purge and refresh.
3) Variants in your store have the same SKU or a blank SKU.
In Spark Shipping, all products and variants are required to have a unique Product SKU.
In the case where variants do not have a unique SKU, Spark Shipping will add this extra ID after the SKU (to make it unique)
To correct this we would recommend that you update the products SKUs to make them unique in your store first. Follow that by requesting a data refresh from Spark Shipping support.
Related:
How do I add variant items?
- This has to be done on the Shopify side
- All SKUs including variants in Spark come over to your store as single SKU
Below is an article that will help you get started building variants in Shopify:
https://help.shopify.com/en/manual/products/variants/add-variants