Learn how to synchronize starting with Totals version 2.2
Please post in English only. Thank you!
editing items in csv & importing them back in
  • Dear Support team,

    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?
  • Hi,

    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.

    Kind regards,
    Ferhat
  • Thank you for your prompt response. I look forward to hopefully seeing this feature in the near future.

    -huper
  • Was this feature added in the latest update do you know?

    I noticed it mentioned CVC import but will it update my current items instead of just loading them as new ones?
  • Hi,

    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.

    Kind regards,
    Ferhat
  • Hi Ferhat,

    Do you know was this implemented in the 2.1.4 update?
    Is there a list of the updates made for this new version?

    Thanks

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Login with Facebook Sign In with Google Sign In with OpenID Sign In with Twitter

In this Discussion

Tagged