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.

Re: Inventory import

Add 1 item.
Export it
study the exported file format.
Prepare the rest of the items in that format.
Now import the rest.