RE: Trouble importing a CSV to update inventory

Hi guys, I’m brand new to NS and trying to make an impact in my internship. We have about 1,800 different SKUs that need to have their inventories changed — so doing it by hand is going to be a big pain.

My workflow is Setup -> Import/Export -> Import CSV Records. Import type is Transactions and Record Type is Inventory Adjustment. As a proof of concept, I’m trying to change ONLY the quantity in this one particular item, i.e. I want to increment its qty in its current location by one. This is my CSV file:

Adjustment Account,Item,Location,Internal ID,Adjust Qty By,Memo
5-99999 COST OF GOODS SOLD : Inventory Adjustment,ABCDEF-12345,03-ECO-EU-Amsterdam,53806,1,Testing

I pulled the Internal ID by writing a simple Report that dumped out the quantities and locations for the stuff I’m interested in. When I try and import this file, I get an error messaging saying “Transaction type specified is incorrect”.

What am I doing wrong? How can I fix this? Just to reiterate, all I want to do is change quantities on certain SKUs. I don’t want to change price, location, or anything else. Thanks!

bitpushr Rookie Asked on November 18, 2019 in Inventory.
Add Comment
16 Answers

correct! it needs to be the internal ID is the Unique id in the url for the item

Rookie Answered on May 12, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.