User Interface and Navigation - need help importing my inventory

Print Page | Close Window

need help importing my inventory

Printed From: Almyta Systems
Category: SBS and AID Software packages
Forum Name: User Interface and Navigation
Forum Discription: Interface principals, mouse and keyboard navigation, shortcuts, menus
URL: http://www.almyta.com/forum/forum_posts.asp?TID=229
Printed Date: 19 Apr 2019 at 7:46am
Software Version: Web Wiz Forums 10 - http://www.webwizforums.com

Topic: need help importing my inventory

Posted By: goodwinmw
Subject: need help importing my inventory
Date Posted: 21 Jul 2012 at 12:44am

hi . Watched the video and did everything it said. Once mapped I check my master inventory list and it is missing data that I put in the spreadsheet. below I have a pic of the spreadsheet setup iam using and what data loaded in the AID master inventory list. Its missing a lot of item even though they are in the spreadsheet. Please advise how I setup my CVS file with my inventory.

here is my spreadsheet setup:
http://imgs.inkfrog.com/pix/craftebay/spreadsheet.JPG

here is what got mapped to AId:
http://imgs.inkfrog.com/pix/craftebay/aidmasterlst.JPG

Any help would be appreciated. Hopefully the pics will help.

Replies:

Posted By: BillD
Date Posted: 22 Jul 2012 at 6:37pm

Starting with Unit Cost, in your spreadsheet, it is formatted as text '$1.72. Text evaluated to 0. Remove the quote ('), remove $ sign. Leave only number 1.72. Re-import the same file. Map only Item ID and Unit cost.

For the Category, you need to add manually or import the categories first (DARICE must exist on the categories screen) then you can re-import Item ID and Category.

This should fix the problem.