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!