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: 23 Feb 2019 at 7:24pm
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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 10 - http://www.webwizforums.com
Copyright ©2001-2011 Web Wiz Ltd. - http://www.webwiz.co.uk