Implemented Bulk Upload BIN locations via CSV
Currently you have to create BINs one by one manually, would be awesome if there was some sort of bulk uploader. We have 3000+ bins, so it makes it tough to use the feature as is.
If you have a little development background you can just hit the same endpoint as the website:
I just ran this with my Bin locations:
Where bins-json looks like:
1 person likes this
It's comments like this that is why I ended up not using DEAR.
P.S. Great you've listened to the community and added the missing functionality.
1 person likes this
Please note that suggested approach with using internal DEAR API directly without web browser if discovered will lead to your account locking and subscription suspension. This sort of hacking violates our terms and conditions.
P.S. The requested functionality to manage Bins vial CSV import/export has been rolled out.
1 person likes this
Agree this is much needed. Also categories should be able to be uploaded via CSV.
Martin - thanks but can you give me a little help with your post?
What cookie value(s) are you copying? The two which look most promising are .ASPXAUTH and .AS.NET_SessionId but I'm not having luck with either.
re-written as a single line I can't get this to create the Bin. Would you be able to help?
curl -v --header "Content-Type: application/json" -b "<my .ASPXAUTH value pasted here>" -d {"ParentID":"WW","Description":"test_bin_1","IsDefault":false,"AllowReorder":false,"FFServiceID":"","ReferenceCount":0,"UseForFixedAssetsOnly":false}
<> ; done
where "WW" is my existing Location and "test_bin_1" is my Bin to be created
+1 from me. Migrating/integrating with my 3PL system is proving tricky as the FEFO stock is held in multiple locations and doing bin entry by hand will be a real pain.
simple CSV import like elsewhere in DEAR be very helpful
Guys, this has been very interesting. I've taught myself Python over the last 4-5 days that gets data from DEAR and have a working example which I'll share once its tidied up a bit. The plan is to send data to Zoho Reports to make up for the hopeless reporting in DEAR.
I also want to get the list of finished goods which does not have an endpoint in the API explorer. Hopefully, Martins method will help me find it.
Agree! This would be make bin management MUCH easier!
"Validation failed for one or more entities. See 'EntityValidationErrors' property for more details."
Awesome...now to enter over 9100 bin locations because I can't have the fucking bin locations in the bulk inventory uploads until I've "mapped" them in the Locations & Bin.
Please be aware that having more then 2000 bins might impact system performance on your account significantly. This is the limitation we will try to resolve in the following 6 month.
Many thanks Martin! We're doing a big move in a couple of weeks implementing a new storage system so the ability to add a couple of hundred Bins will be very useful.
To make it one step easier for anyone copying this - the "TenantLocation" can be easily found through the API explorer - see attached
I like this IDEA. Implement BIN management and transfer options via API and CSV !
I'm actually no longer using Dear (a long story , though I did complete the migration we just sold before we used it in anger):
So the two value you need to pull from the website are your Cookies (Which contains the authentication and the ParentID which is a GUID.
These are the full steps I took to do this. TL;DR Inspect the request made by the web browser when adding a Bin and pull the values from that.
You're one liner isn't right as you've left half of the for loop in there. I tried this one-liner and created your Bin "test_bin1"
I just ran this on a new account and all was good:
This should get a nice 200 response of
The LocationID is the newly assigned GUID for your bin.
In doing this I did get a few 400 errors saying the request was invalid. Note that the data is a JSON model and so it contains " which if you are using " to delimit your data parameter it won't work to well. Hence you may see in the one-liner above that the data flag is using single quotes ' to bound the JSON payload.
Hope this helps.