Is it possible to import inventory items from Excel sheet i.e. complete excel sheet. I’ve inventory maintained in excel sheet and want the same to import to Manager.
1 Like
When you click New Inventory Item button under Inventory Items tab, there is a Import... button in top-right corner which will allow you to import inventory items in bulk.
Experiment with this feature on dummy file first to make sure this feature works as expected before you import into your main file. And before you import into main file, do the backup first so you have reference point in case you want to revert import.
2 Likes
Got it. and imported successfully.
Thanks
Hello sir,
just downloaded the software,work great.The only problem i can import inventory from excel as i can’t see the import button
I have a database of 8000 products.
Please help,
Try using Batch Create
1 Like
Hello,
Thank you very much for your reply.Do u think i need to upgrade the version? i cant find any button to upgrade?
Why - having just downloaded your version should be fairly current - the batch create is here
To upgrade Desktop edition, click Desktop edition
im trying batch also does not work
Hello,
i cant find the import buttun…Anybody can help me please.Ive tried batch ,it doesnt work.
Please please
Did you read the Guide
1 Like
Hello got it,
But it wont update qty.
Thanks
You need to provide more information about what you mean and what the problem is. Inventory is quite complex, and “it won’t update qty” doesn’t help anyone help you.
Hello,
While i make batch import mean Qty on hand (opening Stock) doesnt update automatically
When batch importing starting balances, there is a column called HasStartingBalance. Make sure this column has value set to True.
Hi
I am having no luck at all importing my inventory into Manager
I dont have a import button so I tried the batch import with a small sample (50 items)
After pasting them in the step 3 and clicking NEXT nothing happens, nothing got added at all and no error messages. Please help
Johanne
What version of Manager are you using?
After you paste in your data and click the Next button, you should see a preview like this:
Do you see that, but with 50 items instead of the 1 in my example?
If you do, click Batch Create and the items should be created.
Otherwise, if you need more help could you provide a sample file (with 1-2 items) that you’re trying to import?
Sorry I just realised that I was trying to use batch update and not create. I have gotten them imported now but realised that my cost price is wrong on all of them (my fault) I did the total (cost x number on hand) instead of the individual.
I am fixing that now in the spreadsheet do I use the batch update now to fix my error?
Thanks
Johanne
- Click Batch Update
- Copy the text that you see on that page
- Paste it into spreadsheet
- Then, modify the data to match what it should be.
- Copy from spreadsheet and paste back into Manager
- Click Next
- Review the list of changes. It should only show the columns modified that you tried to modify in the spreadsheet.
- Click Batch Update if you’re happy.
Note: Do not use your original spreadsheet. Create a new spreadsheet (or new tab on existing spreadsheet) and use the data copied from Manager screen if you’re doing a Batch Update.
5 posts were split to a new topic: How to add supplier information to inventory items