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!