Product List import From Excel Spreadsheet
I wanted to change all my products (which are all services and non-inventory) to be under more specific sales accounts that I just made. So, I exported all the products to update in excel, and then reimported them with their new sales accounts implemented. Afterwards, I noticed that every item was properly updated when I looked them up under the "Products/Services" tab. The problem is that none of the historical transactions with these items have changed accounts. I'd really like to be able to see all my past sales under these new accounts so that I can analyze the revenue centers of my company with greater detail.
What did I do wrong? Is there any way to update my historical data?
