nehshardware Posted June 20, 2014 Share Posted June 20, 2014 After importing the csv file, set up with the correct headings and matching them.....not all the data was imported. The cost price and sale price is missing as well as the sales tax. Any ideas? I really hate to have to go back and re-do 8,000 products to include the missing pieces. Tamara NEHSHARDWARE Link to comment Share on other sites More sharing options...
krystleramos Posted June 26, 2014 Share Posted June 26, 2014 You may have formatted the cost price/sales price incorrectly. Make sure the field includes numbers and decimals only, no currency signs. Also, make sure the sales tax descriptor name that you placed in the field is correctly set up in Inventoria. You don't have to re-do the 8K items...just make the changes in the spreadsheet for the data that didn't import (if necessary) and then change the quantity for each item to 0. It should update each item with the new data without adding additional quantity. Hope that helps! Link to comment Share on other sites More sharing options...
nehshardware Posted July 3, 2014 Author Share Posted July 3, 2014 I imported the file again before I realized that I had formulas in the cells.....so I fixed all of that and now I am importing again......keeping my fingers crossed that my problems are solved! Thank you for your reply!! Link to comment Share on other sites More sharing options...
KLuWolF Posted June 4, 2015 Share Posted June 4, 2015 When I try to match the tax code, I've set up the codes *, P, G (both, PST, GST) and in the CSV file it looks like the records with *, G or P don't match any of these 3 codes? After the import it only comes up with 'none'?! I was hoping not to lose my supplier info, the Iventoria item has a supplier data field but it doen't appear on the match data import dialog? Can it be added somehow? and maybe the custom felds too? Link to comment Share on other sites More sharing options...
KLuWolF Posted June 5, 2015 Share Posted June 5, 2015 Ok I got the tax, it was looking for a number not the text the old software exported. Still wondering about supplier data? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now