I am using the trial version of Totals as I need a new invoicing program to replace Quicksales for ipad.(which I love) however they do not have a mac app at this time and I am getting to busy to keep working on an ipad.
My question is I like editing my items in CSV formate in excel as I bring in pricing from another spreadsheet which calculates price changes. However ever once I am done editing the prices and import them back in they do not edit the current items with the same names and categories (as prices are all that have changed.) Totals creates all new items but doesn't duplicate the category folders.
As I have quite a few items and the prices change monthly it is more efficient to edit items bulk in excel then manually in Totals. Is there a way I can do this?
the import function creates always new items. I have just filed a feature request to check for SKUs in csv and update existing items if they exist by SKU. In the current version you can write a little AppleScript, if you are familiar with it, which parses the csv file, searches by SKU (or by name whatever) and updates the item accordingly.
we had to wait to synchronize the Mac App Store version and website version before adding new features. The latest update includes only essential bug fixes and mountain lion compatibility. So unfortunately this is not in the latest version, 2.1.3, implemented.