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.
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 have enabled “Find Product by SKU” feature, then “Excel Transactions” wont attempt to create Products automatically even when “Auto Create List Entities” feature is enabled in Import Settings.