Needless to say, Keeping exact name of products in your files is not possible. There are lots of opportunity where it can go wrong.
But it is easy to maintain the ID or SKU of a product in files. If you are maintaining your transactions based on SKU details, “Excel Transactions” can help you to import all your transactions.
There is no need to make any changes to your files. You just need to tune your Import settings.
Watch below video to understand the overall process of Import
If you are new to Excel Transactions, please refer the below links
How to enable Settings to import using SKU?
Import settings can be accessed by Settings Menu or by clicking “Settings” button in Upload Review Screen.
Under Advanced Tab, you need to enable “Find Product by SKU” feature.
If you enabled “Find Product by SKU” feature, then “Excel Transactions” wont attempt to create Products automatically even “Auto Create List Entities” feature in Import Settings.