Topic: Inventory import
Is there no way to import quantities as part of the Import CSV process?
I looked at the import_items.php file and mimicked the file layout in the section referring to the import items.
Here's the commented layout I used:
type, item_code, stock_id, description, category, units, qty, mb_flag, currency, price
However, when i go to import it I'm getting a SQL every time. I've double and triple checked it and the import columns are exactly the way they read above in the csv.
At first it belly ached about a problem with the 0_dimension table and I found a reference that suggested there was a typing error in one line (needed the double == for the compare). I changed that and didn't get the error, but it did absolutely nothing but take me right back to the items import page.
I'm a bit stumped as to how you're supposed to load skus with qtys and I can't even begin to entertain this if I have to write something to update them in sql.
Ideas?
Thanks,
C.